Home | Webstore
Latest News: OOTP 13 THIRD Update Available: Version 13.3.9! - OOTP 13 Released! Download Now! - iOOTP 2012 Available NOW on the AppStore - Title Bout Championship Boxing 2.5 released!

Download OOTP 13 Now! | Download iOOTP 2012 from the AppStore

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

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

Reply
 
LinkBack Thread Tools Display Modes
Old 12-29-2011, 12:20 PM   #1 (permalink)
Minors (Single A)
 
Join Date: Aug 2011
Posts: 90
Thanks: 0
Thanked 7x in 7 posts
Adjusting database

Question the database guys can help me with

I like to play historical with adjusted stats (ie all players playing as if it were ball in the 2005-2010 range)
There is the neutralized database for player stats- but it still is going to play to the that year ie 1913 or 1944

I can change the modifiers on a season, but that again can take time and of course you never really know if you have the correct modifier

Thus i thought the best way overall is to modify the lehman database. Yes longer short term, but if it works right, then i can play and play with no further refinements

If i can make it work well i would give it padresfan so he can post it

The question is. to modify the lehman database
ie say i am going to modify George Sisler,

Do i just need to open the batting (or pitching stats as required) and then make changes to the numerical values of his stats?
Do i have to change anything else on any of the other sheets?

I am not adding any players, as is, just adjusting stats to modern ball

Thanks
sprague is offline   Reply With Quote
Old 12-29-2011, 12:42 PM   #2 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 posts
A super more much easier way is to simply change the era_stats.txt file in the database folder so every year has the totals you want from 2005-2010.

If this takes you more than 60 seconds you aren't trying very hard.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 12-29-2011, 01:15 PM   #3 (permalink)
Minors (Single A)
 
Join Date: Aug 2011
Posts: 90
Thanks: 0
Thanked 7x in 7 posts
Quote:
Originally Posted by Spritze View Post
A super more much easier way is to simply change the era_stats.txt file in the database folder so every year has the totals you want from 2005-2010.

If this takes you more than 60 seconds you aren't trying very hard.
OK found the file

question though, say i want thngs to play for example to 2005.
And i want to change those over to 1901
Now in 1905 there were 30 teams they played a 162 game sched
In 1901 was 16 teams playing...140 i think, anyway that is not important

When replacing the era modifiers...
could i just copy and past 2005 into the space where 1901 was (with the year 1901 still there of course
Or will i have to modify the 2005 numbers into the league size\game size of each year, to match the team\game size?

Thanks again
sprague is offline   Reply With Quote
Old 12-30-2011, 05:49 PM   #4 (permalink)
Hall Of Famer
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 posts
Just copy.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
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

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



All times are GMT -4. The time now is 02:37 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
Copyright © 2009 Out of the Park Developments