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 05-15-2016, 06:26 PM   #841
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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: 555
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: Bothell Wa
Posts: 7,254
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: 104
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,353
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: Bothell Wa
Posts: 7,254
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,353
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: Bothell Wa
Posts: 7,254
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: 30,803
Spritze do you have a DB for 17? It's cool to have minors but I still have Negro League and *** players coming into the majors when they appeared in their original league vs actual ML appearance.
__________________
Go today don't wait for tomorrow
It isn't promised, all the time you get borrowed
Don't live your life for other people
Don't bottle your emotions till they crack and fill a couple just sorrows
Take your mind and refocus go get a paper write your goals out
Throw your middle fingers to all your haters


"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: Bothell Wa
Posts: 7,254
Quote:
Originally Posted by The Game View Post
It's cool to have minors but I still have Negro League and *** 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: 104
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: Bothell Wa
Posts: 7,254
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
Old 06-07-2016, 11:19 AM   #853
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
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
Old 06-07-2016, 11:32 AM   #854
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
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,353
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: Bothell Wa
Posts: 7,254
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,353
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: Bothell Wa
Posts: 7,254
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,353
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: Bothell Wa
Posts: 7,254
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
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:12 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