Home | Webstore
Latest News: OOTP 26 Available - FHM 12 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 06-27-2011, 03:44 PM   #1
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
International League db

Now that the PCL database construction is winding down, I am going to turn my attention towards gathering data for an International League equivalent.

From my reading, the IL's time as a NON minor league to MLB is from 1912-1945. If anyone has different ideas, please let me know.


I am going to begin putting together data from BBRef on these years first. Then fielding stats will have to be added from Spaulding's guides most likely (as the PCL required).

Is there interest in such a db being added to what available for OOTP?
Cooleyvol is offline   Reply With Quote
Old 06-29-2011, 02:44 PM   #2
risp2out
All Star Reserve
 
Join Date: Apr 2009
Posts: 648
I think these minor league databases are going to outstanding additions to the wide world of OOTP mods. So much thanks to those of you who are working on them.
risp2out is offline   Reply With Quote
Old 07-01-2011, 09:12 PM   #3
David Ball
Minors (Triple A)
 
Join Date: Jan 2006
Posts: 281
1945 is probably about as good a choice as any one year could be for the transition to teams virtually all operating purely as farm clubs for major league teams, but I think you could push your start date forward to include the Eastern League before 1912, if you wanted. The 1911 EL circuit is identical to the next season's IL. It's simply the same league operating under a different name. I wonder why they changed, actually.

Bb-ref doesn't see it this way, but I believe most authorities consider the IL to go back all the way to 1885, with occasional name changes along the way during the first thirty years. I think there probably wasn't really organizational continuity all the way back, but there certainly was for at least a few years going back past 1912.
David Ball is offline   Reply With Quote
Old 07-04-2011, 10:37 AM   #4
No Pepper
All Star Starter
 
No Pepper's Avatar
 
Join Date: Jan 2003
Location: Milwaukee, WI
Posts: 1,570
Cooley, are these databases going to conflict with the ML databases in the sense that you'll get duplicates on import? Meaning, Lefty Grove of the famous Baltimore Orioles first imports in 1920 with the IL database and when 1925 rolls around, he'll get imported again with the ML database. What's your vision in how this will be used within the game?
No Pepper is offline   Reply With Quote
Old 07-04-2011, 10:43 AM   #5
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
Quote:
Originally Posted by No Pepper View Post
Cooley, are these databases going to conflict with the ML databases in the sense that you'll get duplicates on import? Meaning, Lefty Grove of the famous Baltimore Orioles first imports in 1920 with the IL database and when 1925 rolls around, he'll get imported again with the ML database. What's your vision in how this will be used within the game?
If I understand Spritze correctly, there will not be duplicates. Once 1958 comes around, the PCL is not going to get players added to rosters. However, if you were using a draft, the PCL could continue to exist and I'm assuming share in the draft pool from that year forward.

Spritze could give the definitive answer, but since he's putting the actual data into db form, I'll assume all will work fine.
Cooleyvol is offline   Reply With Quote
Old 07-04-2011, 03:18 PM   #6
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
The database playerids that are used in the PCL and International databases are the same as the Lahman Player IDs so duplication can be averted depending on the vast number of things it depends on. Like..........

IF the PCL and/or INT db's are incorporated with the Lahman Db, there will be no duplicates.

IF the PCL and INT db's are used as seperate stand-alone db's duplication will ensue. A total of 3 iterations (max) of each player is then possible.
Spritze is offline   Reply With Quote
Old 07-04-2011, 03:52 PM   #7
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
Quote:
Originally Posted by Spritze View Post
IF the PCL and INT db's are used as seperate stand-alone db's duplication will ensue. A total of 3 iterations (max) of each player is then possible.
I believe that someone simming only the IL or PCL using these as standalones would begin getting fictional players in '58 for the PCL and 46 for the IL. Correct Spritze?
Cooleyvol is offline   Reply With Quote
Old 07-04-2011, 06:34 PM   #8
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Yes
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 08:17 PM.

 

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