Home | Webstore
Latest News: OOTP Update 20.5.52 - OOTP 20 Available - FHM 5 Available

MLB All-Star Game Special: Save 50% on OOTP 20!

  

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 05-15-2016, 06:26 PM   #841
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,175
Thanks: 310
Thanked 3,228x in 1,897 posts
Yes
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-16-2016, 08:59 AM   #842
plannine
All Star Reserve
 
plannine's Avatar
 
Join Date: Mar 2003
Location: Michigan
Posts: 526
Thanks: 20
Thanked 14x in 13 posts
Quote:
Originally Posted by Spritze View Post
Yes
I have forgotten what settings to use for the new league import but,

If I do 'real stats', in the second year, fictional players appear rather then real players.
and if I do 'neutralized stats' players don't enter at 18, they enter as in real life.
__________________
Good pitching will always stop good hitting and vice-versa - Casey Stengel
plannine is offline   Reply With Quote
Old 05-16-2016, 09:16 AM   #843
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,175
Thanks: 310
Thanked 3,228x in 1,897 posts
Neutered stats is where you get 18's for import. If players are entering with their MLB debuts you are inadvertently pointing to another database.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-16-2016, 11:45 AM   #844
dpd376
Minors (Double A)
 
Join Date: Dec 2009
Posts: 101
Thanks: 84
Thanked 17x in 13 posts
Quote:
Originally Posted by dpd376 View Post
Yes it brings the player directly into the game with the team they spent most of their career with or the draft.

The only file you have to edit is the master.csv in the neutralized folders (if you use neutralized stats). Players that have id numbers ending in the 80's, 90's or end in 00 did not play in the major's, do a search in the second column for 8*, 9*, 00 and delete those rows (it's not that hard, they're usually in large blocks).

After this Negro League players who played in the majors will still import in the year they turned 18/19. If you want them to enter when they entered MLB or organized baseball, you have to pick them out and change their debut date (Column Z). The only way to do this is to find out who played in the Negro Leagues and the majors and when they debuted (I missed some).

The last step I took was in the game's default real stats folder and copy and paste Lahman's data over the real stats folder in Spritze's so players would import with prevous major league stats. I don't know if this is necessary.

It imports into OOTP17 and the game functions perfectly well. I haven't done a test yet to see how well it works.

Feel free to PM if me you have any problems/questions.
In case anyone is wondering,I have done a few tests and it seems to work perfectly. See the posts on the previous page.
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 is offline   Reply With Quote
Old 05-20-2016, 04:41 AM   #845
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,280
Thanks: 1,751
Thanked 222x in 161 posts
So where or how can we get the minor league guys into this mix? The continual League changes in the minors makes me dizzy!
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 05-20-2016, 09:47 AM   #846
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,175
Thanks: 310
Thanked 3,228x in 1,897 posts
There are quite a few minor league guys in the mix already.

I am not sure what you mean by dizzy? The OOTP17 real minor league setup is different than my database for OOTP16. Just stick with the fake minors in 16?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-20-2016, 12:21 PM   #847
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,280
Thanks: 1,751
Thanked 222x in 161 posts
Quote:
Originally Posted by Spritze View Post
There are quite a few minor league guys in the mix already.

I am not sure what you mean by dizzy? The OOTP17 real minor league setup is different than my database for OOTP16. Just stick with the fake minors in 16?
Spritze, thank you for all you do. When you say stick with the fake minors in 16, do you mean your stats set or the game version itself? I'm sorry to be a dunce on this. I must be missing something obvious, as usual.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 05-20-2016, 02:57 PM   #848
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,175
Thanks: 310
Thanked 3,228x in 1,897 posts
Game version or do fictional with real players in 17?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-20-2016, 05:42 PM   #849
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,121
Thanks: 9,073
Thanked 3,069x in 2,450 posts
Spritze do you have a DB for 17? It's cool to have minors but I still have Negro League and NPB players coming into the majors when they appeared in their original league vs actual ML appearance.
__________________
Hello darkness, my old friend
I've come to talk with you again
Because a vision softly creeping
Left its seeds while I was sleeping
And the vision that was planted in my brain
Still remains
Within the sound of silence


Congrats Harold Baines

"Stay Strong"
The Game is offline   Reply With Quote
Old 05-20-2016, 08:48 PM   #850
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,175
Thanks: 310
Thanked 3,228x in 1,897 posts
Quote:
Originally Posted by The Game View Post
It's cool to have minors but I still have Negro League and NPB players coming into the majors when they appeared in their original league vs actual ML appearance.
The Spritze database has Japanese, Korean and Negro Leaguers. OOTP 17 does not.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-06-2016, 09:52 AM   #851
dpd376
Minors (Double A)
 
Join Date: Dec 2009
Posts: 101
Thanks: 84
Thanked 17x in 13 posts
In last year's HS database for OOTP16 what are the csv's like "ootpbatting," etc. for?

Thanks
__________________
"I hate astroturf, but I love the game astroturf produces."
Bill James
dpd376 is offline   Reply With Quote
Old 06-06-2016, 10:01 AM   #852
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,175
Thanks: 310
Thanked 3,228x in 1,897 posts
Not used. A copy of the original OOTP files.
__________________
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:
dpd376 (06-06-2016)
Old 06-07-2016, 11:19 AM   #853
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,175
Thanks: 310
Thanked 3,228x in 1,897 posts
Sometime in the next week or two I'll have a new Spritze database available with about 83,000 new player seasons added.

It will now cover MLB and PCL rookie debuts from 1871-1914 and 1940-2015 completely and partials for 1915-1939.
__________________
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:
Jeff1787 (06-07-2016), RANGER11JP (06-07-2016), The Game (06-08-2016)
Old 06-07-2016, 11:32 AM   #854
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Covington, KY
Posts: 650
Thanks: 224
Thanked 265x in 182 posts
WOOT!!!!!!

Sent from my Z812 using Tapatalk
__________________
"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-07-2016, 02:34 PM   #855
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,280
Thanks: 1,751
Thanked 222x in 161 posts
Quote:
Originally Posted by Spritze View Post
Sometime in the next week or two I'll have a new Spritze database available with about 83,000 new player seasons added.

It will now cover MLB and PCL rookie debuts from 1871-1914 and 1940-2015 completely and partials for 1915-1939.
Spritze,

Will we be able to create our own minor leagues and still use it? I am not having much luck with the yearly changes in all the minor leagues and their structures and affiliations. Hoping to find a workable alternative.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 06-07-2016, 02:56 PM   #856
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,175
Thanks: 310
Thanked 3,228x in 1,897 posts
Quote:
Originally Posted by RANGER11JP View Post
Spritze,

I am not having much luck with the yearly changes in all the minor leagues and their structures and affiliations.
I do not know what this means.

Just don't load the real minor leagues and away you go?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-07-2016, 03:07 PM   #857
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,280
Thanks: 1,751
Thanked 222x in 161 posts
Quote:
Originally Posted by Spritze View Post
I do not know what this means.

Just don't load the real minor leagues and away you go?
I would like the minor league players, but in the minor leagues setup (or close to it) that I have been using for years. Can I get the players without the leagues?
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 06-07-2016, 03:12 PM   #858
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,175
Thanks: 310
Thanked 3,228x in 1,897 posts
Yes; with the Spritze database

No; with the built in one.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-07-2016, 06:57 PM   #859
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,280
Thanks: 1,751
Thanked 222x in 161 posts
Quote:
Originally Posted by Spritze View Post
Yes; with the Spritze database

No; with the built in one.
So will we be able to get all the players that appear in the built in as well as your wonderful other additions in the new soon to be released wiz-bang update of your database mentioned elsewhere?
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 06-07-2016, 07:14 PM   #860
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,175
Thanks: 310
Thanked 3,228x in 1,897 posts
Quote:
Originally Posted by RANGER11JP View Post
So will we be able to get all the players that appear in the built in No as well as your wonderful other additions in the new soon to be released wiz-bang update of your database mentioned elsewhere?
Same players as before, just a few more complete season records have been added.

The Spritze database does not care about affiliated teams and leagues (anything goes) and has 150,000 fewer players in it than the built in one.
__________________
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:
RANGER11JP (06-08-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 07:11 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 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments