Home | Webstore
Latest News: OOTP Update 20.5.52 - OOTP 20 Available - FHM 5 Available

MLB All-Star Game Special: Save 50% on OOTP 20!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 06-03-2006, 06:15 PM   #1
rwmorey
Minors (Double A)
 
Join Date: Dec 2001
Posts: 175
Thanks: 0
Thanked 4x in 2 posts
Ootp 2006 Db Format?

Hi..

What is the file format of the OOTP Data files? I would love to try my hand at making some utilities but figure this is an important first piece of the puzzle.

Rich
rwmorey is offline   Reply With Quote
Old 06-05-2006, 09:20 AM   #2
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
Markus.dat files.

Without looking, I remember he said it was a binary save, which means you ain't gonna figure it out.
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 06-05-2006, 10:31 AM   #3
DaveHorn
All Star Starter
 
DaveHorn's Avatar
 
Join Date: Aug 2003
Posts: 1,146
Thanks: 2
Thanked 1x in 1 post
You don't need to figure it out, that is the point of the SQL Dump features of OOTP 2006.
__________________
Dave
HFTC Commish
DaveHorn is offline   Reply With Quote
Old 06-05-2006, 10:39 AM   #4
Comedian2004
Hall Of Famer
 
Comedian2004's Avatar
 
Join Date: Nov 2004
Location: In a house in Saint Cloud, Florida.
Posts: 7,085
Thanks: 0
Thanked 79x in 45 posts
Quote:
Originally Posted by DaveHorn
You don't need to figure it out, that is the point of the SQL Dump features of OOTP 2006.
Yeah, I know, but SQL dump don't write back to the dat files..
__________________
Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF![/COLOR][/FONT]
Comedian2004 is offline   Reply With Quote
Old 06-05-2006, 08:03 PM   #5
rwmorey
Minors (Double A)
 
Join Date: Dec 2001
Posts: 175
Thanks: 0
Thanked 4x in 2 posts
Yeah.. I'd like to be able to view mostly, but maybe edit, the data directly.
rwmorey is offline   Reply With Quote
Old 06-23-2006, 09:54 PM   #6
fearofmimes
Minors (Rookie Ball)
 
Join Date: Dec 2002
Location: Minneapolis, MN
Posts: 31
Thanks: 0
Thanked 0x in 0 posts
Reverse engineering the database file structures

It's a pretty simple database format at the binary level, but there is a new twist that wasn't present in the database for previous versions: variable-length fields for strings. I've been analyzing the data files to try to find a way to parse them effectively and I have a pretty good handle on the general contours of the files (I'm working updating some code I wrote previously to manage schedules). Right now I'm working to resolve a final issue with Teams.dat where it appears that there is an additional variable-text field somewhere in addition to the city, abbreviation, nickname, and logo fields.

I suspect that others have been doing the same thing, so it might make sense to describe our results so the database format can be documented by the community.

Correction: There are only 4 variable-length fields in Teams.dat (the table I used to calculate field characteristics was wrong) and the code is working.

Last edited by fearofmimes; 06-24-2006 at 04:05 AM.
fearofmimes is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:48 AM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments