|
|||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
| LinkBack | Thread Tools | Display Modes |
|
|
#1 (permalink) |
|
Hall Of Famer
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 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. |
|
|
|
| 15 thanks for this post: | actionjackson (04-19-2010), AESP_pres (04-18-2010), BigBen (05-08-2010), bubba22plus (04-19-2010), edm (05-04-2010), Elysian Fields (05-09-2010), kagnew35 (04-12-2010), kbensel (07-20-2011), longhorns (04-14-2010), MrEndshiftresign (04-19-2010), mused2B (04-15-2010), NYY #23 (04-13-2010), pbar25 (09-18-2010), szathkey (04-10-2010), tcblcommish (02-20-2011) |
|
|
#3 (permalink) |
|
All Star Starter
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 Boardhttp://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room |
|
|
|
|
|
#5 (permalink) |
|
Hall Of Famer
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 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. |
|
|
|
| Thank you for this post: | mused2B (04-15-2010) |
|
|
#6 (permalink) |
|
All Star Starter
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 Boardhttp://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room |
|
|
|
|
|
#7 (permalink) |
|
All Star Starter
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 Boardhttp://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room |
|
|
|
|
|
#9 (permalink) |
|
All Star Starter
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 Boardhttp://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room |
|
|
|
|
|
#11 (permalink) |
|
Hall Of Famer
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 posts
|
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.
|
|
|
|
| Thank you for this post: | Rainers (04-15-2010) |
|
|
#12 (permalink) |
|
All Star Starter
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 Boardhttp://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room |
|
|
|
|
|
#15 (permalink) | |
|
Hall Of Famer
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 posts
|
Quote:
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. |
|
|
|
|
| 2 thanks for this post: | actionjackson (04-16-2010), szathkey (04-15-2010) |
|
|
#16 (permalink) |
|
All Star Starter
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 Boardhttp://www.soxxcountry.com/ site with FaceGen Central and Duffys Tavern Live OOTP Chat Room |
|
|
|
|
|
#17 (permalink) |
|
Hall Of Famer
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 posts
|
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.
|
|
|
|
|
|
#18 (permalink) |
|
All Star Reserve
Join Date: Sep 2008
Location: Equestria
Posts: 794
Thanks: 43
Thanked 51x in 46 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.
__________________
"Keikaku Doori..." |
|
|
|
|
|
#19 (permalink) |
|
Hall Of Famer
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 2,946
Thanks: 16
Thanked 344x in 242 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.
|
|
|
|
|
|
#20 (permalink) |
|
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.
__________________
Baseball Maelstrom Sr - Anaheim Angels Baseball Maelstrom Jr - Pittsburgh Pirates |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|