Home | Webstore
Latest News: OOTP Update 20.8 - OOTP 20 Available - FHM 6 Available

Offseason Discount! SAVE 50%!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > 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,227
Thanks: 334
Thanked 3,258x in 1,923 posts
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
4 thanks for this post:
gRaider2001 (03-20-2016), JungleJim99 (09-26-2016), Moneybrawler (03-22-2016), txranger (03-10-2016)
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,495
Thanks: 136
Thanked 358x in 242 posts
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,227
Thanks: 334
Thanked 3,258x in 1,923 posts
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: 63
Thanks: 25
Thanked 26x in 11 posts
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,227
Thanks: 334
Thanked 3,258x in 1,923 posts
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: 63
Thanks: 25
Thanked 26x in 11 posts
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,227
Thanks: 334
Thanked 3,258x in 1,923 posts
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
2 thanks for this post:
JaBurns (03-22-2016), Lukas Berger (06-13-2016)
Old 03-23-2016, 06:33 PM   #8
jncca1215
Minors (Rookie Ball)
 
Join Date: Oct 2015
Posts: 30
Thanks: 5
Thanked 9x in 5 posts
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,227
Thanks: 334
Thanked 3,258x in 1,923 posts
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,280
Thanks: 1,755
Thanked 222x in 161 posts
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
Thank you for this post:
froghair (03-24-2016)
Old 03-24-2016, 01:14 PM   #11
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 63
Thanks: 25
Thanked 26x in 11 posts
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,227
Thanks: 334
Thanked 3,258x in 1,923 posts
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,495
Thanks: 136
Thanked 358x in 242 posts
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: 63
Thanks: 25
Thanked 26x in 11 posts
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,495
Thanks: 136
Thanked 358x in 242 posts
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
2 thanks for this post:
dewelar (03-24-2016), RANGER11JP (03-24-2016)
Old 03-24-2016, 06:51 PM   #16
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 63
Thanks: 25
Thanked 26x in 11 posts
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
Thank you for this post:
RANGER11JP (03-27-2016)
Old 05-01-2016, 09:37 AM   #17
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Covington, KY
Posts: 650
Thanks: 224
Thanked 265x in 182 posts
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: Covington, KY
Posts: 650
Thanks: 224
Thanked 265x in 182 posts
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: 30
Thanks: 5
Thanked 9x in 5 posts
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,227
Thanks: 334
Thanked 3,258x in 1,923 posts
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, 191 views)
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
7 thanks for this post:
boblight24 (09-05-2016), JaBurns (06-10-2016), jncca1215 (06-17-2016), mitchkenn (07-11-2016), Motorhead667 (06-22-2016), RANGER11JP (06-14-2016), txranger (06-11-2016)
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:31 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

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 © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments