Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 08-15-2012, 01:18 PM   #1
Furious
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.
Furious is offline   Reply With Quote
Old 08-15-2012, 02:00 PM   #2
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
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.
Cooleyvol is offline   Reply With Quote
Old 08-15-2012, 04:36 PM   #3
Furious
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?
Furious is offline   Reply With Quote
Old 08-15-2012, 04:57 PM   #4
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
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.
Cooleyvol is offline   Reply With Quote
Old 08-15-2012, 07:26 PM   #5
Furious
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?
Furious is offline   Reply With Quote
Old 08-15-2012, 07:33 PM   #6
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by Furious View Post
Or am I missing something?
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!
Spritze is offline   Reply With Quote
Old 08-15-2012, 08:15 PM   #7
Furious
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.
Furious is offline   Reply With Quote
Old 08-16-2012, 02:44 AM   #8
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
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!
Spritze is offline   Reply With Quote
Old 08-16-2012, 10:49 AM   #9
Furious
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.
Furious is offline   Reply With Quote
Old 08-16-2012, 11:59 AM   #10
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
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!
Spritze is offline   Reply With Quote
Old 08-16-2012, 08:15 PM   #11
Furious
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).
Furious is offline   Reply With Quote
Old 08-18-2012, 11:07 AM   #12
Furious
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?
Furious is offline   Reply With Quote
Old 08-26-2012, 09:56 PM   #13
Furious
Minors (Triple A)
 
Join Date: Aug 2012
Posts: 299
Quote:
Originally Posted by Furious View Post
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?
Anyone else know the answers to any of these questions?
Furious is offline   Reply With Quote
Old 08-27-2012, 05:44 PM   #14
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by Furious View Post
Anyone else know the answers to any of these questions?
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!
Spritze is offline   Reply With Quote
Old 08-28-2012, 02:49 PM   #15
Furious
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.)
Furious is offline   Reply With Quote
Old 08-29-2012, 01:38 AM   #16
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
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!
Spritze is offline   Reply With Quote
Reply

Bookmarks


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 05:05 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 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments