Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 03-10-2016, 07:02 PM   #1
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Negro League Database

I am creating a negro league database and will post my requests for ideas here.

1) OOTP has a downgrade players with less than 300 at bats feature on the create new game advanced options page. Only 140 of the 18,572 player seasons comes in over this threshold due to the much shorter league seasons. Should I take an action step by increasing at bats in some way or leave this as is?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 03-10-2016, 08:54 PM   #2
swampdragon
Hall Of Famer
 
swampdragon's Avatar
 
Join Date: May 2002
Location: The Lonely Mountain
Posts: 2,508
Just warn us that we need to reduce that number when we check options. I'd guess 100 AB would be an acceptable level?
__________________
“Of all tyrannies, a tyranny sincerely exercised for the good of its victims may be the most oppressive. It would be better to live under robber barons than under omnipotent moral busybodies." -- C.S. Lewis
swampdragon is offline   Reply With Quote
Old 03-10-2016, 10:23 PM   #3
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Yup but each gamer can make their own decision of course.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 03-22-2016, 12:04 PM   #4
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 67
Spritze, with your handle on how databases are used by the game, you might be the only human who can answer this question:

When Negro Leaguers are added -- some or all -- would it be possible in OOTP17 to set up a fictional league (one using a dbse of real players, if I am saying that correctly) where the random-debut player pool consists a) all MLB players/history (~18k), b) all affiliated post-1919 MiLB players (~150k) and c) whatever Negro Lg. players can be created in a file. So in other words, a player pool of 175-200k real players that get used in a league history.

I think this was possible in an MLB-NL-PCL-Japan roster set you created that I used in OOTP16. I'm just trying to see if I can run a league where starting in a given year-forward, all levels of a league with at least some minor league levels can be stocked with this giant pool of real players.

Sorry for the verbose question and clarification .. I'm a noob confused on what is possible with the new MiLB database. Thanks.
froghair is offline   Reply With Quote
Old 03-22-2016, 12:10 PM   #5
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Currently none of that is possible but I am sure Markus is not done yet even if it takes to OOTP18 or 19 to finish off the minor, foreign and negro leagues.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 03-22-2016, 12:25 PM   #6
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 67
I guess what I don't understand is that the game has the major leaguers .. and the bulk of the minor leaguers .. what prevents the realization of the concept that puts them all together as one player pool to be used in random debut? Just curious.
froghair is offline   Reply With Quote
Old 03-22-2016, 12:50 PM   #7
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
It does not happen automagically. Takes programming time away from other things that need doing. The minor leagues cannot leap fully formed to match every possible style of play. Plus many of your data wants do not exist yet. Patience is called for.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 03-23-2016, 06:33 PM   #8
jncca1215
Minors (Rookie Ball)
 
Join Date: Oct 2015
Posts: 39
This is great. Any idea when you expect it to be done?
jncca1215 is offline   Reply With Quote
Old 03-24-2016, 12:15 AM   #9
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
A few weeks but it won't be OOTP 17 compatible.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 03-24-2016, 01:19 AM   #10
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,353
Quote:
Originally Posted by Spritze View Post
A few weeks but it won't be OOTP 17 compatible.


I think this needs to be re-thunk. The new database system seems to limit much of what we can use and hamper continuing to utilize the fine work you and others have created for past game editions. Your DB where Dickie Flowers can debut in 1856 is outstanding! The fact that I can not use it in this version is mind boggling. I will be patient and hope Markus and company address this at some point. OOTP17 is an amazing achievement overall.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 03-24-2016, 01:14 PM   #11
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 67
If a Spritze dbse game is started in OOTP 16, can it than be opened in OOTP 17? Seems like I was able to do that in a test this morning.
froghair is offline   Reply With Quote
Old 03-24-2016, 02:06 PM   #12
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Afaik
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 03-24-2016, 02:15 PM   #13
swampdragon
Hall Of Famer
 
swampdragon's Avatar
 
Join Date: May 2002
Location: The Lonely Mountain
Posts: 2,508
Quote:
Originally Posted by froghair View Post
If a Spritze dbse game is started in OOTP 16, can it than be opened in OOTP 17? Seems like I was able to do that in a test this morning.
The key would be whether OOTP 17 could do future imports from that database to advance the game. That would certainly be an easy workaround if possible.
__________________
“Of all tyrannies, a tyranny sincerely exercised for the good of its victims may be the most oppressive. It would be better to live under robber barons than under omnipotent moral busybodies." -- C.S. Lewis
swampdragon is offline   Reply With Quote
Old 03-24-2016, 02:27 PM   #14
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 67
Okay, rookie Q then: where is the Spritze dbse that has the most players from the all-time pool of MLB, PCL, Negro Leagues? That's he one I thought I was testing this morning but I couldn't find any PCL, Negro League guys.
froghair is offline   Reply With Quote
Old 03-24-2016, 03:13 PM   #15
swampdragon
Hall Of Famer
 
swampdragon's Avatar
 
Join Date: May 2002
Location: The Lonely Mountain
Posts: 2,508
I think I got mine at post 783 in the top sticky thread. It doesn't have many Negro League players, but it has the 1903-1912 PCL players. My guess is that the game will transfer to OOTP 17 OK, but that you won't be able to advance the game while pointing to that database for seasons after that.

This was probably inevitable, but the custom databases have been a valuable addition to OOTP. Creating proprietary databases that are incompatible with existing custom databases or future user-made databases removes that valuable resource. Easy moddability has been a key to the success of the OOTP franchise, and this is not a welcome development.
__________________
“Of all tyrannies, a tyranny sincerely exercised for the good of its victims may be the most oppressive. It would be better to live under robber barons than under omnipotent moral busybodies." -- C.S. Lewis
swampdragon is offline   Reply With Quote
Old 03-24-2016, 06:51 PM   #16
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 67
Thanks, Swamp. My Test 16-to-17 Spitze League seems to be working fine in year 2 on OOTP 17. Will keep keep testing.

When downloaded, the database I was using says "Spiritze HS for OOTP16." Anyway I thought there was a near 40,000-man database that includes a decent number of Negro Lg players plus a huge chunk of the PCL (thru the end in the 50s).
froghair is offline   Reply With Quote
Old 05-01-2016, 09:37 AM   #17
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
Quote:
Originally Posted by Spritze View Post
I am creating a negro league database and will post my requests for ideas here.

1) OOTP has a downgrade players with less than 300 at bats feature on the create new game advanced options page. Only 140 of the 18,572 player seasons comes in over this threshold due to the much shorter league seasons. Should I take an action step by increasing at bats in some way or leave this as is?
Pro-rate AB/PA to what they would be if they played a 140/154/162 game schedule depending on year OR just prorate all to current 162
__________________
"A baseball fan has the digestive apparatus of a billy goat. He can, and does, devour any set of statistics with insatiable appetite and then nuzzles hungrily for more." - Sportswriter Arthur Daley
"Who says there's an unemployment problem in this country? Just take the five percent unemployed and give them a baseball stat to follow." - Outfielder Andy Van Slyke
MarkInCincy is offline   Reply With Quote
Old 05-01-2016, 09:41 AM   #18
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
Quote:
Originally Posted by swampdragon View Post
The key would be whether OOTP 17 could do future imports from that database to advance the game. That would certainly be an easy workaround if possible.
One option might be to copy the Spritze DB files to the default stats directory since it also contains the .odb?
__________________
"A baseball fan has the digestive apparatus of a billy goat. He can, and does, devour any set of statistics with insatiable appetite and then nuzzles hungrily for more." - Sportswriter Arthur Daley
"Who says there's an unemployment problem in this country? Just take the five percent unemployed and give them a baseball stat to follow." - Outfielder Andy Van Slyke
MarkInCincy is offline   Reply With Quote
Old 06-10-2016, 07:45 PM   #19
jncca1215
Minors (Rookie Ball)
 
Join Date: Oct 2015
Posts: 39
How is progress going?
jncca1215 is offline   Reply With Quote
Old 06-10-2016, 08:35 PM   #20
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
All done. But not yet tested. I wanted to get a new Spritze database update out. Available on dropbox now. I did not notice any big challenges when I tested this over the last few days. I have been fixing those I did find.

The Negro database may become an addition to the regular OOTP17 in game database.

If not I'll make the players available as part of the Spritze database.

Some of the leagues on this list may be too incomplete to use without a plethora of Joe Unknowns (ghosts) being used so I'll probably just include the players. 3,981 of them.
Attached Files
File Type: csv NegroLeaguesCovered.csv (8.4 KB, 353 views)
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

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