Home | Webstore
Latest News: FHM 5 Available - Update OOTP 19.8 is online - OOTP 19 Available! - MLB Manager 2018 Available Now

Perfect Team Open Beta Available Now!

  

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

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

Reply
 
Thread Tools
Old 05-02-2015, 05:24 PM   #681
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,735
Thanks: 196
Thanked 2,941x in 1,725 posts
Quote:
Originally Posted by actionjackson View Post
EDIT: Aren't the players also given "beginner" type ratings for range, arm, error, DP, experience etc. in the master.csv file? No, there is no such thing
I have also been told there is no such thing as Giant Blue Flying Squid by a 5-yr old so you should consider the source. Everyone knows they do exist but are rarer than a Sasquatch.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Thank you for this post:
actionjackson (05-02-2015)
Old 05-02-2015, 08:38 PM   #682
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 4,698
Thanks: 6,960
Thanked 2,820x in 1,719 posts
Quote:
Originally Posted by Spritze View Post
I have also been told there is no such thing as Giant Blue Flying Squid by a 5-yr old so you should consider the source. Everyone knows they do exist but are rarer than a Sasquatch.
...And here I thought it was Flying Spaghetti Monsters...Who knew?
actionjackson is offline   Reply With Quote
Old 05-05-2015, 02:04 PM   #683
jparker2112
Minors (Triple A)
 
Join Date: Nov 2012
Posts: 297
Thanks: 346
Thanked 72x in 48 posts
So I just loaded the ootp16 version of your DB. What do I do now? Im on a macbook and have not much of a clue how to install your DB over the one that came with the game. quick steps would be helpful. Thanks to any and all!
jparker2112 is offline   Reply With Quote
Old 05-05-2015, 02:26 PM   #684
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 4,698
Thanks: 6,960
Thanked 2,820x in 1,719 posts
Quote:
Originally Posted by jparker2112 View Post
So I just loaded the ootp16 version of your DB. What do I do now? Im on a macbook and have not much of a clue how to install your DB over the one that came with the game. quick steps would be helpful. Thanks to any and all!
What I do is extract the "stats" folder from the zip file to my "Out of the Park Developments" folder. I'm not sure where that is on a macbook as I have a PC. I then re-name the "stats" folder that I've just extracted to "Spritze HS for OOTP16" and put it into the OOTP Baseball 16 folder and then into the stats folder that is in OOTP Baseball 16. That way it is a separate file within the stats folder and will never be overwritten when I update with a patch. You just have to make sure you point to it properly when you go to import your players. Not that difficult. It keeps it separate from the default database and that's the way I like it because it is a different database. I'd be very careful about overwriting the default database with the Spritze database, just in case you discover you want to return to the default database after all. Any other questions, post away.
actionjackson is offline   Reply With Quote
Old 05-05-2015, 02:43 PM   #685
jparker2112
Minors (Triple A)
 
Join Date: Nov 2012
Posts: 297
Thanks: 346
Thanked 72x in 48 posts
so the game will know to look into the spritze DB in the stats file instead of the default?
jparker2112 is offline   Reply With Quote
Old 05-05-2015, 02:44 PM   #686
jparker2112
Minors (Triple A)
 
Join Date: Nov 2012
Posts: 297
Thanks: 346
Thanked 72x in 48 posts
so looking like this:
jparker2112 is offline   Reply With Quote
Old 05-05-2015, 02:45 PM   #687
jparker2112
Minors (Triple A)
 
Join Date: Nov 2012
Posts: 297
Thanks: 346
Thanked 72x in 48 posts
so it looks like this?
Attached Images
Image 
jparker2112 is offline   Reply With Quote
Old 05-05-2015, 02:48 PM   #688
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 4,698
Thanks: 6,960
Thanked 2,820x in 1,719 posts
Quote:
Originally Posted by jparker2112 View Post
so the game will know to look into the spritze DB in the stats file instead of the default?
No, you have to point it to look there. i.e. in game, if you've done it the way I do, you should see the Spritze HS for OOTP16 folder inside the stats folder. Click on that. Now, you're inside the Spritze HS for OOTP16 database. Click on the historical_database.ODB in order to import your players.
actionjackson is offline   Reply With Quote
Thank you for this post:
jparker2112 (05-05-2015)
Old 05-05-2015, 02:51 PM   #689
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 4,698
Thanks: 6,960
Thanked 2,820x in 1,719 posts
Quote:
Originally Posted by jparker2112 View Post
so it looks like this?
Yes...And in game, you click on the Spritze HS DB OOTP16 in order to get into it and access it's historical_database.odb file, which is where all the players come from.
actionjackson is offline   Reply With Quote
Thank you for this post:
jparker2112 (05-05-2015)
Old 05-05-2015, 02:52 PM   #690
jparker2112
Minors (Triple A)
 
Join Date: Nov 2012
Posts: 297
Thanks: 346
Thanked 72x in 48 posts
ah-HA! i gotcha...thanks!
jparker2112 is offline   Reply With Quote
Old 05-05-2015, 02:59 PM   #691
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 4,698
Thanks: 6,960
Thanked 2,820x in 1,719 posts
Quote:
Originally Posted by jparker2112 View Post
ah-HA! i gotcha...thanks!
No probs.
actionjackson is offline   Reply With Quote
Old 05-05-2015, 03:09 PM   #692
jparker2112
Minors (Triple A)
 
Join Date: Nov 2012
Posts: 297
Thanks: 346
Thanked 72x in 48 posts
Quote:
Originally Posted by actionjackson View Post
Yes...And in game, you click on the Spritze HS DB OOTP16 in order to get into it and access it's historical_database.odb file, which is where all the players come from.
when you mention in game you click on the spritze db, is that in "historicals" under database path? or when the draft pool is made avail and you can "click to add file"?

thanks...i SUCK at mods and all this!
jparker2112 is offline   Reply With Quote
Old 05-05-2015, 03:25 PM   #693
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 4,698
Thanks: 6,960
Thanked 2,820x in 1,719 posts
Quote:
Originally Posted by jparker2112 View Post
when you mention in game you click on the spritze db, is that in "historicals" under database path? or when the draft pool is made avail and you can "click to add file"?

thanks...i SUCK at mods and all this!
At some point, you're going to have to go into the stats folder in order to import players into your game. You want to make sure when you're setting up your database path that you are in the Spritze HS DB OOTP16 folder when you point to the historical_database.odb. Don't worry if you suck at it now. You'll be an expert with practice.
actionjackson is offline   Reply With Quote
Old 05-20-2015, 02:50 PM   #694
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,735
Thanks: 196
Thanked 2,941x in 1,725 posts
New database available soon. Testing it now. MLE's are way more accurate. First program change in six years. 'Bout time!
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
3 thanks for this post:
actionjackson (05-20-2015), Jeff1787 (05-20-2015), txranger (05-20-2015)
Old 05-20-2015, 02:56 PM   #695
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
new database available soon. Testing it now. Mle's are way more accurate. First program change in six years. 'bout time!
woot
__________________
"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-20-2015, 03:50 PM   #696
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,735
Thanks: 196
Thanked 2,941x in 1,725 posts
Actually it is a woot and a half times infinity plus one.

Here it is:
https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0
It'll be on the OOTP WIKI soon.

Huge shout out to John Henry who was sure these MLE's could be better. Now they are.
I plan on reviewing more of the formulas that make up the components so there may be another update in a few weeks. Let me know if any challenges raise themselves. I may have forgotten something.

Thanks.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 05-22-2015 at 10:21 PM.
Spritze is offline   Reply With Quote
5 thanks for this post:
actionjackson (05-20-2015), Jeff1787 (05-22-2015), MarkInCincy (05-21-2015), RANGER11JP (05-22-2015), The Game (05-21-2015)
Old 05-22-2015, 03:09 PM   #697
edhberg3
Minors (Rookie Ball)
 
Join Date: Apr 2007
Posts: 34
Thanks: 0
Thanked 3x in 3 posts
Need help for historical league setup

I am trying to run historical league with this awesome database, but when I get through the initial season, there ar only fictional players in the draft pool. I have set everything up to point to this database in th folder structure listed above. I there any step by steps to make sure I get this setup so it draws from the correct database?

Just want to have the real life platers available to draft each year.
edhberg3 is offline   Reply With Quote
Old 05-22-2015, 07:59 PM   #698
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,735
Thanks: 196
Thanked 2,941x in 1,725 posts
I simply put the db in the default stats folder. No troubles. Are you doing something else?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-22-2015, 09:36 PM   #699
edhberg3
Minors (Rookie Ball)
 
Join Date: Apr 2007
Posts: 34
Thanks: 0
Thanked 3x in 3 posts
I just put your stats folder in place of the original stats folder. Do I need to out the .odb file somewhere else, or just leave everything in the stats folder?
edhberg3 is offline   Reply With Quote
Old 05-22-2015, 09:53 PM   #700
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,735
Thanks: 196
Thanked 2,941x in 1,725 posts
Nope, you did it good. That way has always worked for me without fail.
__________________
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 10:31 AM.

 

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