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

Coming soon: Collection Missions

  

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-30-2009, 11:56 AM   #1
vesuvius
Minors (Double A)
 
vesuvius's Avatar
 
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
Thanks: 2
Thanked 2x in 1 post
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)
  • A. Select Path to Database -> C:\Lahman_Random\master.csv (or the directory you extracted it to)
  • B. Season Year should be set to : 2000
  • C. In the next section, use : Real Stats / Remaining Years of Career / 3 Year / 3 Year (pitcher stamina can be either 3 year or career, your choice)
5. Click on Next Step (the Database will load)

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)
  • A. Uncheck the top 3 of the 4 options (I leave auto adjust financials enabled)
9. Click on Next Step (to advance to Step 5 of 6)

10. Click on Next Step (to advance to Step 6 of 6)
  • A. Enter your manager info
  • B. Select your Game Name
  • C. Select Commish Mode if you want it.
11. Click on Advanced Mode (NOT next step!)
  • A. Click on Game Options (top left)
  • B. Disable coaching and/or scouting if you wish.
  • C. Set the ratings scales you prefer (I use 1 to 10)
12. Click back on Create Game (top left)
  • A. Select Major League 2000 near the bottom of the left menu so you can edit the league
  • B. Click on Rules (top middle towards right)
  • C. Set the Ammy Draft to March 1st (gives more players on teams in year 1)
  • D. Set Draft reveal date to 10 days prior
13. Click on Options (top middle towards right)
  • A. Check Hold Draft (inaugural Fantasy Draft)
  • B. *** UNCHECK *** automatically adjust league totals modifiers after each season for historical accuracy
  • C. *** UNCHECK *** auto adjust date if matching XML schedule found
14. Click on Strategy and Equivalencies (This is VERY important)
  • A. Change the league totals Modifiers to the following (the rest should be 1.000 when you start) : (If you don't do this, your stats will be majorly WACK)
  • ====================
    • Hits = .950
    • Doubles = 1.120
    • Triples = .840
    • HR = 2.220
    • BB = 1.150
    • HBP = 1.100
    • Strikeouts = 1.750
  • ====================
    • Sac Flies = 1.050 (down a little ways from the previous item)
    • Sac Bunts = .900
    • SB Attempts = .760
    • SB Success = 1.035
  • ====================
  • B. Make sure auto adjust league totals is still not checked...you don't want these modifiers to ever change after setting them.
15. Click on Start Game (lower left)!

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 :
  • A. You might want to check out the players in the draft, and sort them by age. Some guys import older to give the league a "full feeling" with enough players and age ranges. If there are any superstars who come in as geezers, take this chance to edit them to a younger age.
  • B. Go into Global Setup -> Player and Picture Options, and change the talent change randomness from 100 to something lower. 100 will destroy a bunch of guys development. I prefer something around 20.
18. Have fun!

__________________
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.
vesuvius is offline   Reply With Quote
2 thanks for this post:
bigMatt (08-31-2010), Tom the Fish (08-04-2009)
Old 06-30-2009, 01:14 PM   #2
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,967
Thanks: 184
Thanked 58x in 14 posts
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?
__________________
Elder Statesman of the Board

http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room
kagnew35 is offline   Reply With Quote
Old 06-30-2009, 01:26 PM   #3
vesuvius
Minors (Double A)
 
vesuvius's Avatar
 
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
Thanks: 2
Thanked 2x in 1 post
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
vesuvius is offline   Reply With Quote
Old 06-30-2009, 01:32 PM   #4
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,967
Thanks: 184
Thanked 58x in 14 posts
Rather than aim, try my live chat, more comfortable, see my sig

Hit the musical note icon below room to call me.
__________________
Elder Statesman of the Board

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.
kagnew35 is offline   Reply With Quote
Old 06-30-2009, 03:24 PM   #5
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,967
Thanks: 184
Thanked 58x in 14 posts
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
__________________
Elder Statesman of the Board

http://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room
kagnew35 is offline   Reply With Quote
Old 06-30-2009, 03:34 PM   #6
vesuvius
Minors (Double A)
 
vesuvius's Avatar
 
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
Thanks: 2
Thanked 2x in 1 post
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
vesuvius is offline   Reply With Quote
Old 07-05-2009, 08:04 PM   #7
mgom27
Hall Of Famer
 
mgom27's Avatar
 
Join Date: Jul 2006
Posts: 3,178
Thanks: 1,941
Thanked 288x in 219 posts
I wish the start date could be 2009 so we can use Real Minor League people and Teams but good file.
__________________
Grrrrrrrrrrrrrrrrrrrrrrrrrrrrrr!!!!
mgom27 is offline   Reply With Quote
Old 07-06-2009, 06:50 PM   #8
JoeRockHead
Major Leagues
 
JoeRockHead's Avatar
 
Join Date: Oct 2003
Location: NorthCarolina
Posts: 333
Thanks: 3
Thanked 5x in 5 posts
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
JoeRockHead is offline   Reply With Quote
Old 07-06-2009, 09:22 PM   #9
jwinbigler
Major Leagues
 
jwinbigler's Avatar
 
Join Date: Feb 2005
Posts: 381
Thanks: 12
Thanked 151x in 109 posts
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.
jwinbigler is offline   Reply With Quote
Old 07-08-2009, 05:57 PM   #10
vesuvius
Minors (Double A)
 
vesuvius's Avatar
 
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
Thanks: 2
Thanked 2x in 1 post
Quote:
Originally Posted by jwinbigler View Post
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.
You would want to fine tune the league totals modifiers if you did that.

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
vesuvius is offline   Reply With Quote
Old 07-16-2009, 10:49 AM   #11
ShaneCarson
All Star Reserve
 
ShaneCarson's Avatar
 
Join Date: Oct 2007
Posts: 726
Thanks: 127
Thanked 247x in 130 posts
Does the random debut database just change the birth years and debut dates for players in the Master.csv file?
ShaneCarson is offline   Reply With Quote
Old 07-16-2009, 11:52 AM   #12
vesuvius
Minors (Double A)
 
vesuvius's Avatar
 
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
Thanks: 2
Thanked 2x in 1 post
Quote:
Originally Posted by ShaneCarson View Post
Does the random debut database just change the birth years and debut dates for players in the Master.csv file?
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
vesuvius is offline   Reply With Quote
Old 07-16-2009, 05:33 PM   #13
BillyMadison
Minors (Double A)
 
Join Date: Jul 2003
Location: New York
Posts: 102
Thanks: 0
Thanked 0x in 0 posts
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.
BillyMadison is offline   Reply With Quote
Old 07-17-2009, 10:07 PM   #14
bigMatt
Hall Of Famer
 
bigMatt's Avatar
 
Join Date: Dec 2005
Location: Kansas
Posts: 2,372
Thanks: 17
Thanked 81x in 74 posts
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?
bigMatt is offline   Reply With Quote
Old 07-18-2009, 11:54 AM   #15
bigMatt
Hall Of Famer
 
bigMatt's Avatar
 
Join Date: Dec 2005
Location: Kansas
Posts: 2,372
Thanks: 17
Thanked 81x in 74 posts
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.
bigMatt is offline   Reply With Quote
Old 07-19-2009, 11:23 AM   #16
bigMatt
Hall Of Famer
 
bigMatt's Avatar
 
Join Date: Dec 2005
Location: Kansas
Posts: 2,372
Thanks: 17
Thanked 81x in 74 posts
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.
bigMatt is offline   Reply With Quote
Old 08-03-2009, 12:56 PM   #17
hyde4us11
Major Leagues
 
hyde4us11's Avatar
 
Join Date: Aug 2003
Posts: 348
Thanks: 16
Thanked 21x in 11 posts
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
hyde4us11 is offline   Reply With Quote
Old 08-03-2009, 01:02 PM   #18
vesuvius
Minors (Double A)
 
vesuvius's Avatar
 
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
Thanks: 2
Thanked 2x in 1 post
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
vesuvius is offline   Reply With Quote
Old 08-03-2009, 01:03 PM   #19
hyde4us11
Major Leagues
 
hyde4us11's Avatar
 
Join Date: Aug 2003
Posts: 348
Thanks: 16
Thanked 21x in 11 posts
Quote:
Originally Posted by vesuvius View Post
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).

Awesome, thanks for the quick reply.
__________________
AIM: hydecubs

FCB- Washington D.C. Freedom
FOD- Washington D.C. Freedom
HRBL- Hartford Riverhawks
hyde4us11 is offline   Reply With Quote
Old 08-03-2009, 09:24 PM   #20
Athletics17
All Star Starter
 
Athletics17's Avatar
 
Join Date: Jun 2009
Location: jackson Hole, Wy
Posts: 1,184
Thanks: 192
Thanked 298x in 233 posts
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.
Athletics17 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 01:32 PM.

 

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