Home | Webstore
Latest News: OOTP 18.6 Update Available - OOTP 18 Available - FHM 3 Available - MLB Manager 2017 Available Now

Out of the Park Baseball 18 - Available Now!

  

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

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

Reply
 
Thread Tools
Old 04-09-2010, 05:28 PM   #1
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,697
Thanks: 99
Thanked 2,269x in 1,336 posts
Spritze DB's for OOTP11

Since gamers keep asking what the heck a modded db is here is very short answer. There are about 92,000 player seasons in the standard Lahman db and about 410,000 in the Spritze db. Therefore you get a much fuller roster of players and seasons that will appear in OOTP.

Since I have been really enjoying reading about the new draft stuff in OOTP11 the first db will be a historical high-school db. By that I mean all the real-life players in the db will be draftable at age 18 (or sooner if they are high school drop-outs?). Some you won't be able to sign and they will mosey off to college, some will enter your minor league system. This gives historical gamers a chance to sign a Lou Gehrig direct from High School instead of from the college ranks as happened IRL.

This means drafting will be a semi-required non-optional option that must be used with this db, you will just have to see if you can do a better job of putting together an organization than the AI can. If you decide not to enable the draft all the players will become free agents instead and then you can scout and bid on them as was done back in the pre-draft era.

I am presently unbugging this db as I get time. Once unbugged I'll make it available shortly after the game is released.

The stats included will be the Real and Neutralized files for Major Leaguers and Major League Equivalences for negro leaguers, minor leaguers and foreign players.
Spritze is offline   Reply With Quote
20 thanks for this post:
actionjackson (04-19-2010), AESP_pres (04-18-2010), BigBen (05-08-2010), bubba22plus (04-19-2010), choiwt701 (08-12-2015), Darviathar (12-15-2012), edm (05-04-2010), Elysian Fields (05-09-2010), imhoff2 (07-26-2016), kagnew35 (04-12-2010), kbensel (07-20-2011), Killemall1057 (06-09-2012), longhorns (04-14-2010), MrEndshiftresign (04-19-2010), mused2B (04-15-2010), NYY #23 (04-13-2010), Oyaji (08-27-2012), pbar25 (09-18-2010), szathkey (04-10-2010), tcblcommish (02-20-2011)
Old 04-10-2010, 03:16 PM   #2
szathkey
Minors (Single A)
 
szathkey's Avatar
 
Join Date: Jun 2008
Posts: 90
Thanks: 20
Thanked 0x in 0 posts
I cannot even convey how excited this makes me...
szathkey is offline   Reply With Quote
Old 04-12-2010, 04:34 AM   #3
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
Sounds like the best of all DB's. great work. spritze
__________________
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 04-12-2010, 04:48 AM   #4
hfield007
All Star Starter
 
hfield007's Avatar
 
Join Date: Jul 2009
Posts: 1,353
Thanks: 635
Thanked 724x in 385 posts
Too excited for this, HURRY HURRY HURRY! =]
hfield007 is offline   Reply With Quote
Old 04-12-2010, 09:43 PM   #5
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,697
Thanks: 99
Thanked 2,269x in 1,336 posts
It seems to be working fine in testing therefore I'll be releaseing two versions, one with asian players (Japanese and Korean Professional Leagues) as well as the North American players and one without them. First up is the one with everybody in the pool.

The file is compiled into a historical db file like OOTP uses instead of Lahman files. That means you can start in any year you choose and also import history if you wish to.

Message me your e-mail address and I'll tell you where to get it. Eventually it will be on the Padres Fan's site. I'll send him an e-mail today that it is available.
Spritze is offline   Reply With Quote
Thank you for this post:
mused2B (04-15-2010)
Old 04-12-2010, 10:15 PM   #6
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
db

PM sent, ty , ty, ty
__________________
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 04-13-2010, 10:36 AM   #7
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
spritze, how do you suggest we set up our leagues, in regards to minors, and feeders. I started a 1935 lg and have 117 minor leaguers on my red sox roster. So looks like 4 levels of minors is needed, how many feeders do you suggest?
__________________
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 04-13-2010, 08:04 PM   #8
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,697
Thanks: 99
Thanked 2,269x in 1,336 posts
I use all the levels and fill with fictional players.
Spritze is offline   Reply With Quote
Old 04-13-2010, 11:28 PM   #9
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
Why use any fictional players and what about using feeders? Won't the young players be run thru them?
__________________
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 04-15-2010, 02:15 AM   #10
Rainers
Minors (Single A)
 
Rainers's Avatar
 
Join Date: Apr 2002
Location: Renton, WA
Posts: 85
Thanks: 39
Thanked 23x in 15 posts
Spritze,

Can you eventually do a separate KBO and Nippon db for those of us that have both leagues in our universe?

Rainers
Rainers is offline   Reply With Quote
Old 04-15-2010, 08:08 AM   #11
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,697
Thanks: 99
Thanked 2,269x in 1,336 posts
Quote:
Originally Posted by Rainers View Post
Spritze,

Can you eventually do a separate KBO and Nippon db for those of us that have both leagues in our universe?

Rainers
Those are part of the plan that I have just recently finished planning. So pretty soon. Since I planned ahead that means I don't have to do anything at all right now. That's a pretty good plan, that planning ahead plan.
Spritze is offline   Reply With Quote
Thank you for this post:
Rainers (04-15-2010)
Old 04-15-2010, 11:25 AM   #12
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
Spritze, when will the MLB only db be ready, and how do feeder leagues work, will they be filled from your db? How many do you suggest?
__________________
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 04-15-2010, 11:35 AM   #13
Cooleyvol
Hall Of Famer
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,120
Thanks: 59
Thanked 573x in 339 posts
Does this require us to draft historical players straight from HS? What if we want them as with your most recent db?
Cooleyvol is offline   Reply With Quote
Old 04-15-2010, 01:16 PM   #14
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,697
Thanks: 99
Thanked 2,269x in 1,336 posts
Quote:
Originally Posted by kagnew35 View Post
Spritze, when will the MLB only db be ready, and how do feeder leagues work, will they be filled from your db? How many do you suggest?
MLB only and Japan and Korea db's are done, I'm just too busy at work to get them compiled. Best guess is Sunday.
Spritze is offline   Reply With Quote
Old 04-15-2010, 01:23 PM   #15
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,697
Thanks: 99
Thanked 2,269x in 1,336 posts
Quote:
Originally Posted by Cooleyvol View Post
Does this require us to draft historical players straight from HS? What if we want them as with your most recent db?
The standard Spritze db is also done but not compiled. Sunday as well?

The new Spritze High School db does create everyone upon their high school graduation. That is what makes it different than the regular Spritze db.

Sounds like I'll be a busy bee on Sunday. I'll be working at work all day Saturday, well, maybe not working but at least getting paid. I like the getting paid part more than the working part but quite often they seem to be attached at the hip.
Spritze is offline   Reply With Quote
2 thanks for this post:
actionjackson (04-16-2010), szathkey (04-15-2010)
Old 04-15-2010, 01:55 PM   #16
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
ok, thanks, impatiently waiting. Will you have a read me on the best way to set up leagues with feeders. How will the db work with them?
__________________
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 04-15-2010, 02:21 PM   #17
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,697
Thanks: 99
Thanked 2,269x in 1,336 posts
Quote:
Originally Posted by kagnew35 View Post
ok, thanks, impatiently waiting. Will you have a read me on the best way to set up leagues with feeders. How will the db work with them?
I do not use feeders personally so I do not know. I sign players as best I can to minor league contracts after they graduate high school.
Spritze is offline   Reply With Quote
Old 04-15-2010, 08:31 PM   #18
bubba22plus
All Star Reserve
 
bubba22plus's Avatar
 
Join Date: Sep 2008
Location: Equestria
Posts: 808
Thanks: 45
Thanked 55x in 50 posts
Can you tell me what id Eiji Sawamura is, and what years he comes in at?

It seems to have changed from the 10.4 database, because i entered SawamEi95 and 1936 as the base year and i got a failed import message.
__________________
OOTP Resident Brony
bubba22plus is offline   Reply With Quote
Old 04-15-2010, 09:02 PM   #19
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 5,697
Thanks: 99
Thanked 2,269x in 1,336 posts
Some things were changed during the merge with Gambo's db. This might be 1 of them. There is a master.zip file at the ftp site to answer the very question you posit. Go git'er.
Spritze is offline   Reply With Quote
Old 04-16-2010, 12:57 PM   #20
ejbucs
Minors (Single A)
 
Join Date: Sep 2003
Posts: 78
Thanks: 0
Thanked 0x in 0 posts
How does it select the players for the initial season? I got some interesting results for an 1901 season load.
ejbucs 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 10:01 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 - 2017, vBulletin Solutions, Inc.
Copyright © 2015 Out of the Park Developments