Latest News: OOTP PATCH 9.1.6 released! - OOTP 9 RELEASED! - Title Bout Championship Boxing 2.5 released! - OOTP 2007 receives Editors Choice Award from PC Gamer - Inside the Park Baseball Patch 1.03 released, DEMO now available

Click here to download Out of the Park Baseball 9!

Go Back   OOTP Developments Forums > OUT OF THE PARK BASEBALL 9 > OOTP 9 - Mods > Database Tools
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

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

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 01-21-2008, 11:03 PM   #1 (permalink)
Minors (Rookie Ball)
 
Join Date: Feb 2006
Posts: 19
How do you do it?

How do you folks make all these nice utilities? Is there some program you use?

I'm only asking, because I've got some ideas for some of my own, but I have no clue how to go about it.
OOTPinSTL is offline   Reply With Quote
Old 01-22-2008, 04:23 AM   #2 (permalink)
Moderator*
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Buckingham, England
Posts: 3,139
I can't speak for everyone here because everyone has their own way of doing things.

I use Visual Basic to write my stuff, and I wrote a dll that allows me to read and write directly to the .dat files. I know that some people access the csv's to do their utilities (Comedian2004 for example)
__________________
Tony M
Technical Support Moderator


Tony M is online now   Reply With Quote
Old 01-23-2008, 10:45 PM   #3 (permalink)
Major Leagues
 
Khaos's Avatar
 
Join Date: Dec 2001
Location: Canfield, OH
Posts: 469
Quote:
Originally Posted by redsoxford View Post
I can't speak for everyone here because everyone has their own way of doing things.

I use Visual Basic to write my stuff, and I wrote a dll that allows me to read and write directly to the .dat files. I know that some people access the csv's to do their utilities (Comedian2004 for example)
So OOTP7 is done in .net?

I ask since you are using OOP to access the dat files.

I'm old. My first programming class was Fortran (Wat FIV compiler) then Pascal. I liked Assembler the best. I'm weird that way.

I wasn't cut out for programming though. I went the network-infrastructure-sysadmin route.

Now I manage all open source and admin a linux-apache-tomcat-jboss environment with all the apps done in java. I also built a CVS and Luntbuild server for the developers to use.

I'd love to learn a little more about your dll some time. I wouldn't mind dabbling again. I have VB somewhere in my office that I can install again.
__________________
*squish*
Khaos is offline   Reply With Quote
Old 01-24-2008, 04:36 AM   #4 (permalink)
Moderator*
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Buckingham, England
Posts: 3,139
Quote:
Originally Posted by Khaos View Post
So OOTP7 is done in .net?

I ask since you are using OOP to access the dat files.
I don't know what brand of C or C+ or C++ that OOTP is written in but I guess that's its language as it require the C runtime libraries to work.

My code is completely separate to that of Markus. I took hex-dumps of the dat's and then used the csv files to pinpoint areas of data and then went through the game flipping options and saving and re-dumping to work out what had changed and went from there.

It was then a case of putting it all together and seeing how the structure held.
__________________
Tony M
Technical Support Moderator


Tony M is online now   Reply With Quote
Old 01-24-2008, 08:25 AM   #5 (permalink)
Hall Of Famer
 
The Wolf's Avatar
 
Join Date: Jun 2006
Location: Baying at the moon
Posts: 3,311
Quote:
Originally Posted by Khaos View Post
I'm old. My first programming class was Fortran (Wat FIV compiler) then Pascal.
WATFIV? The original one-pass programming language? Whoa, you aren't kidding about being old, WATFIV is from the early early early days of computing.
__________________
__________________

Barrack Hussein Obama - endorsed by North Korea, Fidel Castro, Hamas, and the Communist Party
The Wolf is offline   Reply With Quote
Old 01-24-2008, 09:40 AM   #6 (permalink)
Major Leagues
 
Join Date: Mar 2007
Posts: 404
Speaking of .DAT files...does anybody know if there is anything in any of the DAT files that shows the year that a player retired? That piece of information has got to be somewhere!
__________________
GM of the OBL - Cincinnati Reds (578-654, .469)
1938 NL West Champs
1938 National League Champs

GM of the SSBL - Atlanta Braves (360-254, .586)
2022, 2024-2025 NL East Champs
2024 National League Champs

GM of the BJHL - Avery Island Hot Peppers (169-155, .522)
falkonisback is offline   Reply With Quote
Old 01-24-2008, 10:00 AM   #7 (permalink)
Moderator*
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Buckingham, England
Posts: 3,139
Quote:
Originally Posted by falkonisback View Post
Speaking of .DAT files...does anybody know if there is anything in any of the DAT files that shows the year that a player retired? That piece of information has got to be somewhere!
Yep, in the player_nnnn.txt file...
__________________
Tony M
Technical Support Moderator


Tony M is online now   Reply With Quote
Old 01-24-2008, 10:15 AM   #8 (permalink)
Hall Of Famer
 
Join Date: Mar 2002
Location: Gainesville, FL USA
Posts: 3,308
Quote:
Originally Posted by redsoxford View Post
I don't know what brand of C or C+ or C++ that OOTP is written in but I guess that's its language as it require the C runtime libraries to work.
I'm pretty sure its in an ANSI version of C++ linked to OS specific libraries since OOTP runs on both a Mac and PC. Anything .net would be horridly slow as it would be the equivalent of writing OOTP in java.
__________________
If not perfection, when is good enough, good enough?

jarmenia is offline   Reply With Quote
Old 01-24-2008, 04:24 PM   #9 (permalink)
Major Leagues
 
Join Date: Mar 2007
Posts: 404
Quote:
Originally Posted by redsoxford View Post
Yep, in the player_nnnn.txt file...
I messed around in Access for a little while and wrote a couple of functions that does exactly that..finds the line that says the player retired and parses the date out of it. I think this will work just fine..Thanks for everyone's help!!
__________________
GM of the OBL - Cincinnati Reds (578-654, .469)
1938 NL West Champs
1938 National League Champs

GM of the SSBL - Atlanta Braves (360-254, .586)
2022, 2024-2025 NL East Champs
2024 National League Champs

GM of the BJHL - Avery Island Hot Peppers (169-155, .522)
falkonisback is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 01:04 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 Out of the Park Developments