|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
Thread Tools
![]() |
![]() |
#1 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
Spritze DB's for OOTP 11,12,13
Just posted a new version of The Spritze HS database for OOTP13. Added the full minor league record of about 400 players who topped out in the PCL 1903-1957. Only 2600 more to go!
The 400 I've done so far has proved to my satisfaction that the PCL really was a third major league with its own set of minor league affiliates. Very few of these players ever appeared east of the Mississippi. Most played Texas and west of there. File is in the usual place. PM me if anyone needs a link, username or password.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#2 |
Minors (Single A)
Join Date: Mar 2002
Location: New Jersey, USA
Posts: 88
|
Db ootp 13
I would like the link to above DB and download instructions.
Thank You Richard (Silverbullet)
__________________
Any day is a good day for Baseball. |
![]() |
![]() |
![]() |
#3 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
You must send me a PM for the linkage.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#4 |
Bat Boy
Join Date: Aug 2012
Posts: 2
|
Just registered for the board, but I don't appear to have the ability to send a PM yet. Would love to get The Spritze HS database for OOTP13.
|
![]() |
![]() |
![]() |
#5 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
The raw minor league record portion of the Spritze databases are available to anyone who wishes to use the data. Microsoft Access is required.
It is in the usual place.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#6 |
Minors (Double A)
Join Date: Aug 2012
Posts: 115
|
This is well done. Great work Spritze.
|
![]() |
![]() |
![]() |
#7 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
Kudo's to me!
![]()
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#8 |
All Star Reserve
Join Date: Mar 2003
Location: Michigan
Posts: 571
|
Give your self a pat on the back too.........
(I have not been able to get to the "secret" site to get the latest and greatest.... it's telling me "The server at zzz.xxxxxxxxxxx.com is taking too long to respond".)
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel Last edited by plannine; 09-15-2012 at 07:18 PM. |
![]() |
![]() |
![]() |
#9 | |
Bat Boy
Join Date: Sep 2012
Posts: 1
|
Quote:
just became a member and dont have have pm.. now using ootp 13.5 for mac.. any help re updated DB? |
|
![]() |
![]() |
![]() |
#10 |
Minors (Single A)
Join Date: Aug 2012
Posts: 65
|
Looking to start an online historical league and could use the database as well, but alas no PM function for us rookies. Any help could be greatly appreciated.
|
![]() |
![]() |
![]() |
#11 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
I sended both you non-PMers a PM so you'd see that you do have a PM as PM's come with signing on via OOTP board usery namingness.
Now you could both be missing bm's but that'll be way to personal to mention here. I'm not mentioning Chocolatey Ex-Lax no matter how hard you try and make me.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#12 |
Bat Boy
Join Date: Sep 2012
Posts: 15
|
Just tried out the new database everything is great but I'm noticing a problem with mine. When I go to the Yankees Roster Lou Gehrig is being displayed as Bronx County "" Lou. I'm not sure if this a glitch on my end but I really want to be able to fix this. any ideas?
|
![]() |
![]() |
![]() |
#13 | |
Bat Boy
Join Date: Oct 2012
Posts: 3
|
Quote:
|
|
![]() |
![]() |
![]() |
#14 | |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
Quote:
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
|
![]() |
![]() |
![]() |
#15 |
Minors (Single A)
Join Date: Aug 2012
Posts: 65
|
First off, I love the detail that goes into this, it really helps with the immersion factor.
That being said, two quick things that I can't wrap my head around. My intention of using the database was to start an online league in 1986. I imported the complete history, and what it does is imports the minor league history as well....but the minor league stats count towards the MLB leaderboards. For instance, Hank Aaron has 774 career HRs, Pete Rose had 4400+ hits etc. Is there something I can do to make the leaderboards accurate? Secondly, with the drafts, every player comes in at roughly 18 years old, that's fine, I understand that, however they are nearly finished products. Is there anyway, to automatically nerf their ratings so they spend at least a couple years in the minor leagues, or would I have to do it all by hand? I don't want a league full of studly 18-19 year olds as that would kill any sort of prospect or minor league system. I apologize if your database wasn't meant to be used this way, or if I'm missing something so obvious, but I thought I had a pretty good grasp of this game. Thanks for any help you can provide. |
![]() |
![]() |
![]() |
#16 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
The db is de-studded 1871-1900 and 1940-1974. The 1980's have not been done yet. It takes about 1 hour to enter each players minor league stats and fill in the missing info so I only get 1 or 2 players done in a day.
OOTP imports the minor league stat equivalences as major league stats just because that is how OOTP works. That is why I have to make MLE's rather than just use the raw minor league stats. To de-stud the unfinished years it works best to recalc on a single year rather than the more normal three generally speaking. But it depends a lot on how young a player studded out IRL. Ken Griffey Jr. will stud no matter what you do.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#17 |
Minors (Single A)
Join Date: May 2003
Posts: 59
|
Hello, for anyone out there with experience using this DB, this is the first time I've tried the SpritzeHS DB which looks awesome, I just have a couple quick q's to help me set it up right:
1. Does it make a difference if I start a league and import basing current ratings off of "real stats" v. "neutralized stats"? I tried importing using "real stats" and noticed that it made some of the minor-league lifers into stars. 2. I'm having trouble getting defensive ratings to import properly, with most players rated 0 or 1 overall at their positions. I've tried importing using "Entire Career" and "3-Year Period" for defensive stats. Thanks in advance to anyone who can help. ![]() PS The year I'm importing is 1933 Last edited by bronco6710; 10-10-2012 at 04:34 AM. |
![]() |
![]() |
![]() |
#18 | |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
Quote:
This is a challenge that sometimes crops up. Use Real Stats and the latest version and all should be well. Older versions of the db do not work with OOTP13 and the newest version of the db doesn't work with older OOTP versions because the file format OOTP uses changes with each version.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
|
![]() |
![]() |
![]() |
#19 |
All Star Reserve
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
|
Would love to get access to this DB. I'll PM you. Thanks!
__________________
DanGarion GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League PCJBL! |
![]() |
![]() |
![]() |
#20 |
Bat Boy
Join Date: Sep 2012
Posts: 6
|
I would like to get access, too, but am not yet able to send a PM. Any help?
|
![]() |
![]() |
![]() |
Bookmarks |
|
|