Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 25 > 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, 06:28 PM   #1
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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
Old 04-10-2010, 04:16 PM   #2
szathkey
Minors (Double A)
 
szathkey's Avatar
 
Join Date: Jun 2008
Posts: 145
I cannot even convey how excited this makes me...
szathkey is offline   Reply With Quote
Old 04-12-2010, 05:34 AM   #3
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,965
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, 05:48 AM   #4
hfield007
All Star Starter
 
hfield007's Avatar
 
Join Date: Jul 2009
Posts: 1,644
Too excited for this, HURRY HURRY HURRY! =]
hfield007 is offline   Reply With Quote
Old 04-12-2010, 10:43 PM   #5
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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
Old 04-12-2010, 11:15 PM   #6
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,965
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, 11:36 AM   #7
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,965
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, 09:04 PM   #8
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
I use all the levels and fill with fictional players.
Spritze is offline   Reply With Quote
Old 04-14-2010, 12:28 AM   #9
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,965
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, 03:15 AM   #10
Rainers
Minors (Single A)
 
Rainers's Avatar
 
Join Date: Apr 2002
Location: Renton, WA
Posts: 87
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, 09:08 AM   #11
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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
Old 04-15-2010, 12:25 PM   #12
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,965
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, 12:35 PM   #13
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
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, 02:16 PM   #14
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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, 02:23 PM   #15
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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
Old 04-15-2010, 02:55 PM   #16
kagnew35
All Star Starter
 
kagnew35's Avatar
 
Join Date: Dec 2005
Location: Las Vegas, Nev
Posts: 1,965
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, 03:21 PM   #17
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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, 09:31 PM   #18
bubba22plus
All Star Reserve
 
bubba22plus's Avatar
 
Join Date: Sep 2008
Location: Equestria
Posts: 808
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, 10:02 PM   #19
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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, 01:57 PM   #20
ejbucs
Minors (Single A)
 
Join Date: Sep 2003
Posts: 77
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 08:15 AM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

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 © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments