|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
Thread Tools |
![]() |
#1 |
Minors (Double A)
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
|
All-Time Random Debut Database & Setup instructions for OOTP10
I created this for my single player experience and figured I'd make it available to anyone interested. Many folks don't even know it is possible, and it is a fun alternate universe.
Edit/Note - Have not tested it, but these instructions should work for OOTP9 as well. What this is : An alternate universe containing every player to ever play in the major leagues, with their debut years mixed up/randomized between 1990 and 2065. Thus you can have Babe Ruth playing against Barry Bonds, etc. (in theory, depending on when they randomly show up in the game). It is designed for use with a historical game beginning in 2000 (that gives a solid set of players for the 30 MLB teams in the year 2000). As the players are spread out until 2065, that gives many years with which to play the game. Created using Sandman's randomdebut utility. The setup instructions below are very important, especially the league totals modifiers. Without them, the statistics can get very crazy and unrealistic. Of note : This uses an old version of the Lahman database, as I could not get the utility to work with the newest database included in OOTP10. Since this requires a modified Lahman database to get working, I've included a link to that modified database (and not just a quick start file) along with easy step by step instructions to set up a league using it. There is no harm in using this, as the modified database will be stored by you in a separate, unique location, and only used for this particular league. *** Set up Instructions *** (I'd print this out and check off each step as you do it. Doesn't take very long, despite the lengthy instructions) ALSO - these instructions assume you have the league creation wizard running 1. Download the modified randomdebut database (6 meg) to be used with your new game here : http://www.thecblonline.com/lahmanzip/RandomLahman.zip 2. Extract the RandomLahman.zip file to a directory on your hard drive (C:\Lahman_Random\). It has to stay there for as long as you use the league (the league will pull rookies from it), and should only be used for this particular league (unless you want a 2nd league using this alternate universe). 3. Start OOTP10 and Create a New Custom Game -> Historical League 4. On the League Setup screen, (leave things default unless I state to change them)
6. Click on Next Step again (to get past the teams screen) 7. Select your minor league preferences (I use AAA, AA, A) 8. Click on Next Step (to advance to Step 4 of 6)
10. Click on Next Step (to advance to Step 6 of 6)
16. Pick the team you want to manage (if you haven't) immediately if you want to get in on the initial draft. 17. If you are in commish mode :
![]()
__________________
Join the CBL Rewind, a great historical OOTP 15 league! http://thecblonline.com/cblr/cblr.php Commish : wedgeeric@aol.com Join the Computer Baseball League, one of the longest running OOTP leagues in history (OOTP5)! http://www.thecblonline.com/cbl.php Last edited by vesuvius; 06-30-2009 at 02:19 PM. |
![]() |
![]() |
![]() |
#2 |
All Star Starter
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,965
|
Thanks for the set, lot of work. Set up my league and in 1st year ammy draft, seem to have all fictional players. What did I do wrong?
__________________
![]() http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room |
![]() |
![]() |
![]() |
#3 |
Minors (Double A)
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
|
Make sure you chose a historical league, and pointed it to the proper newly downloaded database. It should be easy to tell - when you click on next step after pointing it to the database, it should take a little bit to import the players.
Something in steps 1-4 was probably wrong. You can AIM me at wedgeeric if you have further questions.
__________________
Join the CBL Rewind, a great historical OOTP 15 league! http://thecblonline.com/cblr/cblr.php Commish : wedgeeric@aol.com Join the Computer Baseball League, one of the longest running OOTP leagues in history (OOTP5)! http://www.thecblonline.com/cbl.php |
![]() |
![]() |
![]() |
#4 |
All Star Starter
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,965
|
Rather than aim, try my live chat, more comfortable, see my sig
Hit the musical note icon below room to call me.
__________________
![]() http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room Last edited by kagnew35; 06-30-2009 at 01:34 PM. |
![]() |
![]() |
![]() |
#5 |
All Star Starter
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,965
|
I just got fired!!!!!!!!!!!!!!! In last place in 1st year, 1st time ever been tossed!!!!
But is working well, got Glavine in 1st year ammy draft, to go with Smolts, Santana, Newcombe
__________________
![]() http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room |
![]() |
![]() |
![]() |
#6 |
Minors (Double A)
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
|
Great
![]()
__________________
Join the CBL Rewind, a great historical OOTP 15 league! http://thecblonline.com/cblr/cblr.php Commish : wedgeeric@aol.com Join the Computer Baseball League, one of the longest running OOTP leagues in history (OOTP5)! http://www.thecblonline.com/cbl.php |
![]() |
![]() |
![]() |
#7 |
Hall Of Famer
Join Date: Jul 2006
Posts: 3,529
|
I wish the start date could be 2009 so we can use Real Minor League people and Teams but good file.
__________________
Grrrrrrrrrrrrrrrrrrrrrrrrrrrrrr!!!! |
![]() |
![]() |
![]() |
#8 |
Major Leagues
Join Date: Oct 2003
Location: NorthCarolina
Posts: 333
|
Great Mod! Played my first season and loved it. I really enjoy not knowing who is going to show up in the draft. Thanks for releasing the file!
__________________
Regards:John Nellis |
![]() |
![]() |
![]() |
#9 |
Major Leagues
Join Date: Feb 2005
Posts: 404
|
Thanks for the great set. I've already got a fictional league going that I'm really immersed in, but this is a fun alternative when I need a break from that. I'm thinking of trying it with only 16 teams to concentrate the talent more. If I were to do that, should the league total modifiers stay the same? I may just try it tonight and see what happens.
|
![]() |
![]() |
![]() |
#10 | |
Minors (Double A)
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
|
Quote:
Best bet is to run the 1st season a bunch of times playing with the modifiers until they generate reasonable statistics, and use those going forward. Good luck!
__________________
Join the CBL Rewind, a great historical OOTP 15 league! http://thecblonline.com/cblr/cblr.php Commish : wedgeeric@aol.com Join the Computer Baseball League, one of the longest running OOTP leagues in history (OOTP5)! http://www.thecblonline.com/cbl.php |
|
![]() |
![]() |
![]() |
#11 |
All Star Reserve
Join Date: Oct 2007
Posts: 728
|
Does the random debut database just change the birth years and debut dates for players in the Master.csv file?
|
![]() |
![]() |
![]() |
#12 |
Minors (Double A)
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
|
I didn't create it, so I can't answer it exactly, but - it definitely does significantly more than that. Each individual season's year in the fielding, fieldingOF, batting, and pitching csv files has to have their dates modified to correspond with the new debut year, etc.
__________________
Join the CBL Rewind, a great historical OOTP 15 league! http://thecblonline.com/cblr/cblr.php Commish : wedgeeric@aol.com Join the Computer Baseball League, one of the longest running OOTP leagues in history (OOTP5)! http://www.thecblonline.com/cbl.php |
![]() |
![]() |
![]() |
#13 |
Minors (Double A)
Join Date: Jul 2003
Posts: 103
|
This is a really awesome alternative file that I'm going to have some fun with. Thanks.
@jwinbigler - If you come up with good accurate league total modifiers for 16 teams, please post them. I'd like to do the same thing. |
![]() |
![]() |
![]() |
#14 |
Hall Of Famer
Join Date: Dec 2005
Location: Kansas
Posts: 2,375
|
This is a lot of fun - I abandoned my previous project to dive into this - got Honus Wagner and Hughie Jennings with my first two picks - I'll be a bit punch and judy in year one, although Glenn Davis and Ellis Valentine will make sure the other team doesn't play 8 infielders.
Got the Big Hurt with my first pick in the first year player draft, so at least some power is on the way. I'm puzzled about one thing. The players each show a 3 year OOTP history that precedes the inaugural draft. When I look at their "real" stats, I see this OOTP history directly mirrors reality. Here's my question - if I change the ages on a few of the geezers so I can have them in the league longer, how will this affect the player's career arch? Will he A) continue at the point where he entered my game, basically adding years to his career but at his diminished skill set, or, B) will he revert back to his skill set at the younger age? Will he essentially repeat his noted performance all over again? |
![]() |
![]() |
![]() |
#15 |
Hall Of Famer
Join Date: Dec 2005
Location: Kansas
Posts: 2,375
|
Dola, I would have laid odds the answer was B), but after playing the first season, it looks more like A). The half dozen guys whose ages I moved from mid-30's to mid-20's all played like they were at the end of their careers. Bummer.
|
![]() |
![]() |
![]() |
#16 |
Hall Of Famer
Join Date: Dec 2005
Location: Kansas
Posts: 2,375
|
Uh oh
Found my first duplicate last night. Happened to see the box score of another team and noticed that a pitcher named "Jim Poole" took the loss.
I have a middle reliever named Jim Poole. I compared "real" stats of the two and they are definitely the same pitcher. Guessing if it happened with one player in year one, chances are there are or will be others. |
![]() |
![]() |
![]() |
#17 |
Major Leagues
Join Date: Aug 2003
Posts: 369
|
I have a question on this setup. Is it possible to edit this setup to play less teams? I'd like to use this idea but with 12-16 teams. If so where do i start?
__________________
AIM: hydecubs FCB- Washington D.C. Freedom FOD- Washington D.C. Freedom HRBL- Hartford Riverhawks |
![]() |
![]() |
![]() |
#18 |
Minors (Double A)
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
|
Best bet would be to follow the instructions, and before the draft, edit the league set up down to the # of teams you want.
From that point you'd want to figure out new League Totals modifiers however. Best way to do this is run a test season, and at the end of the season, click the automatically adjust league totals modifiers checkbox in league setup - that will give you new modifiers that you should use as a base for year 1 (i.e. restart the league setup process in a new league, and substitute those modifers for the ones I provided).
__________________
Join the CBL Rewind, a great historical OOTP 15 league! http://thecblonline.com/cblr/cblr.php Commish : wedgeeric@aol.com Join the Computer Baseball League, one of the longest running OOTP leagues in history (OOTP5)! http://www.thecblonline.com/cbl.php |
![]() |
![]() |
![]() |
#19 | |
Major Leagues
Join Date: Aug 2003
Posts: 369
|
Quote:
Awesome, thanks for the quick reply.
__________________
AIM: hydecubs FCB- Washington D.C. Freedom FOD- Washington D.C. Freedom HRBL- Hartford Riverhawks |
|
![]() |
![]() |
![]() |
#20 |
All Star Starter
Join Date: Jun 2009
Location: jackson Hole, Wy
Posts: 1,187
|
Where do I put the Lahman file. It said to put it on your hard drive. But where? I might be missing some detail but if you can help me out I would appreciate it. Thanks.
|
![]() |
![]() |
![]() |
Bookmarks |
|
|