|
||||
|
|
OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
Thread Tools
![]() |
![]() |
#1 |
Minors (Triple A)
Join Date: Aug 2012
Posts: 299
|
PCL with Negro Leaguers
I bought the game a few days ago (OOTP11—the most recent version my system supports) hoping the following would be possible:
A league where the PCL exists alongside the Majors but declares itself a major and integrates 20 years before the "eastern" majors do. I've downloaded Cooleyvol and ctorg's PCL database and Spritze's "no asians" database. Are these all I need? Do they work together? I am a complete novice, I've never even played OOTP—but from what I've been reading it seems like what I'm trying to do is possible. The directions that come with the PCL database seem clear enough, so I don't think I'll have a problem getting that part of it to work, it's the addition of the Negro Leaguers that I'm unclear on. Since Spritze's db contains PCL players, is the PCL database even necessary? Or does it contain something that the Spritze db does not? Thanks in advance for your help. |
![]() |
![]() |
![]() |
#2 |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
Spritze's db has MLB and PCL players in it. If you only want the PCL and Negro players, you'll need to merge the two db together into one. Remember, 1958 starts the fictional player portion of your league (as far as PCLers goes).
Sprite's 'no asians' db does not give you ONLY Negro Leaguers. I 'think' you'll have to manually pull them out and place them in the PCL db. Last edited by Cooleyvol; 08-15-2012 at 02:02 PM. |
![]() |
![]() |
![]() |
#3 |
Minors (Triple A)
Join Date: Aug 2012
Posts: 299
|
Thanks, Cooleyvol.
Actually, I need for there to be MLB players, PCL Players, AND Negro Leaguers; I want the PCL to consist of players from all three sources, while the NL and AL will be made up of just MLB and PCL players, plus fictional players to pad out the rosters (if necessary). With that configuration, do I still need your database, or will Spritze's suffice? Does yours contain anything that his is missing? |
![]() |
![]() |
![]() |
#4 |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
I have no clue how you're going to basically use three different databases for one league, basically.
|
![]() |
![]() |
![]() |
#5 |
Minors (Triple A)
Join Date: Aug 2012
Posts: 299
|
I have far less of a clue about any of this than you do. Like I said, complete novice, haven't even played the game yet.
What three databases are you referring to? I mentioned two—your PCL db and Spritze's non-asian db. My question was, is there anything in your PCL db that isn't included in Spritze's? Spritze's database has PCL, MLB and Negro League players—that's ONE database, right? Isn't that all I need? Or am I missing something? |
![]() |
![]() |
![]() |
#6 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
OOTP does not differentiate PCL or Negro League players from AL and NL players. Only NL and AL teams are recognized. So OOTP does the mixmaster thing on the full component of players. Maybe OOTP17 will have more than 2 historical league designations but 13 don't.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#7 |
Minors (Triple A)
Join Date: Aug 2012
Posts: 299
|
I'm not sure I need it to do that anyway. It would be nice if it put all the PCL players on their proper PCL teams but if it can't, I can do that manually; I'll be moving players from one team to another anyway.
What I still don't know is what, if anything, I need from the Cooleyvol/ctorg PCL database if your database already includes all the PCL players. |
![]() |
![]() |
![]() |
#8 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
Everything in their db is in the OOTP 13 Spritze HS database.
BUT It's got all the Asians as well. Very few are good enough to play in the bigs though. Only the top 1 or 2 percent make the majors usually. The No Asians db doesn't have PCL players as it was from before they were added. I plan on updating the Spritze OOTP13 HS database this weekend, maybe I should make a new No Asians one at the same time.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#9 |
Minors (Triple A)
Join Date: Aug 2012
Posts: 299
|
I should have specified—the db I was looking at was this one:
Spritze DB for OOTP 11 - Real Debut, Real Team, No Asians It definitely has PCL players and Negro Leaguers in it, I just wasn't sure if it had all the PCL players. I have some other questions but I think I'll just start tinkering around with what I have and see what happens, hopefully that will give me a better understanding about how all this stuff works. Then I'll pop back in and hound you guys some more. Thanks a lot for your help, and for your work on these databases. It is very much appreciated. |
![]() |
![]() |
![]() |
#10 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
OOTP11 databases are not compatible with OOTP12/OOTP13.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#11 |
Minors (Triple A)
Join Date: Aug 2012
Posts: 299
|
That's okay, 12 & 13 aren't supported by my antiquated OS, so I'm running OOTP 11 (see original post).
|
![]() |
![]() |
![]() |
#12 |
Minors (Triple A)
Join Date: Aug 2012
Posts: 299
|
And the barrage of annoying questions begins...
Referring to the aforementioned OOTP 11 Spritze files: 1) Where did the Negro League stats in the database come from? 2) Why is there a Batting.csv and a Batting2.csv? What is the difference between them? 3) I'm able to edit the .csv files easily enough, but the game doesn't recognize the changes. I'm guessing this means I need to edit the historical_database.odb file as well. Can I do that in a text program or do I need something else? |
![]() |
![]() |
![]() |
#13 | |
Minors (Triple A)
Join Date: Aug 2012
Posts: 299
|
Quote:
|
|
![]() |
![]() |
![]() |
#14 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
I do.
1) They are compiled from 4 or 5 or 6 different sources depending on the player. Every source seems to have different set of compiled stats so I made a program that sorts them all out and gives a consenus opinion. The consensus is what is used. 2) In the Spritze db there is no difference between them. 3) ODB files cannot be edited. The various csv's are non-functional if the ODB file is present. To activate them delete the ODB file.
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
#15 |
Minors (Triple A)
Join Date: Aug 2012
Posts: 299
|
Thank you, that is helpful.
One more question (for now): Any idea what "AO" and "GO" are? (They are the last two values in the pitching files, but I don't know what they mean.) |
![]() |
![]() |
![]() |
#16 |
OOTP Historical Czar
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
|
Air Outs and Ground Outs
__________________
It's madness, madness, I tell you! For the love of God, don't do it! |
![]() |
![]() |
![]() |
Bookmarks |
|
|