Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 02-02-2015, 11:19 PM   #521
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
Download the database at stats-HS.zip - Speedy Share - upload your files here

It will include 2014 major league data in a week or two.
I'll wait for the 2014 major league data. What are the files that come with it? I.e. master.csv, historical database.odb etc etc. Do I overwrite the appropriate files in my stats folder? Finally, can I use it for random debut historical? Thanks in advance.
actionjackson is offline   Reply With Quote
Old 02-03-2015, 12:25 AM   #522
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by actionjackson View Post
I'll wait for the 2014 major league data. What are the files that come with it? I.e. master.csv, historical database.odb etc etc. Do I overwrite the appropriate files in my stats folder? Finally, can I use it for random debut historical? Thanks in advance.
Yes, Yes, I have never tried this but i should think so.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 02-03-2015, 12:26 AM   #523
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by The Game View Post
Do you have an easy way to find players for individual/mass import? I know to look at the master or even the fielding to find who I want but it can take time and i still messed up and Rube Foster did not import.
The master.csv is the place I go to look.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 02-03-2015, 09:27 AM   #524
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by actionjackson View Post
I'll wait for the 2014 major league data. What are the files that come with it? I.e. master.csv, historical database.odb etc etc. Do I overwrite the appropriate files in my stats folder? Finally, can I use it for random debut historical? Thanks in advance.
AJ RD does not work with Spritze DB's. He says he has never tried. I have tried a few times and I have not been able to get them to work.
__________________
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 02-03-2015, 12:03 PM   #525
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Some of the extra fields I don't include are required for random play. I will endeavor to calculate and include them in the next release.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 02-03-2015, 12:48 PM   #526
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by Spritze View Post
Some of the extra fields I don't include are required for random play. I will endeavor to calculate and include them in the next release.
Would be great to see Paige battle Ruth & Strasburg vs Oh.
__________________
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 02-03-2015, 06:21 PM   #527
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
Some of the extra fields I don't include are required for random play. I will endeavor to calculate and include them in the next release.
Thank you Spritze. We really are spoiled here and..."We're not worthy!"

actionjackson is offline   Reply With Quote
Old 03-17-2015, 04:49 PM   #528
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Now that OOTP16 is put to bed I'll start adding the extra fields necessary for random play.

The challenge will be populating the fields with data based on younger ages that allows players to attain their skill set once they reach an appropriate major-league-ready age.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 03-17-2015, 10:13 PM   #529
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
I, for one, would love to know what those fields/columns are and which files/tables they are in. On that note are they csv changes or odb changes?
__________________
"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 03-18-2015, 12:15 AM   #530
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
The master.csv has lots of extra OOTP fields, like 20 or so and the fielding.csv has 8 extras and the pitching csv has 2 extra fields. I think it may only be the master ones that make random work but I don't really know so I'll just make them all to be safe.

The ODB file is a compiled version of all the csv files. It is not user creatable. It speeds the game up both tremendously and a lot.
__________________
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-2015, 04:41 PM   #531
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,535
Will this database work for OOTP16?
Jeff1787 is offline   Reply With Quote
Old 03-24-2015, 05:30 PM   #532
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by Jeff1787 View Post
Will this database work for OOTP16?
Yes
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 03-30-2015, 06:04 PM   #533
edhberg3
Minors (Rookie Ball)
 
Join Date: Apr 2007
Posts: 41
Spritze, greetings from a fellow Redmond, WA resident. Go Mariners!

Is the database that will work with OOTP16 ready yet? Remind me again how to make it the default when I set up my leagues. I only do draft leagues.

Thanks for all your work!
edhberg3 is offline   Reply With Quote
Old 03-30-2015, 07:02 PM   #534
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Another couple of weeks....I have added 1850's and 1860's data to players who debuted in 1871-1875 and am now developing the processes to make my database work randomly with the OOTP random option in a random way fairly randomly. the batting.csv is done and I'm now sparkling up the pitching.csv.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 03-31-2015, 01:12 AM   #535
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by Spritze View Post
Another couple of weeks....I have added 1850's and 1860's data to players who debuted in 1871-1875 and am now developing the processes to make my database work randomly with the OOTP random option in a random way fairly randomly. the batting.csv is done and I'm now sparkling up the pitching.csv.
i am holding off on a new RD league til i can use your DB for it.
__________________
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 03-31-2015, 06:49 AM   #536
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
Quote:
Originally Posted by The Game View Post
i am holding off on a new RD league til i can use your DB for it.

Same here,
waiting patiently
..waiting
..waiting
..waiting

is it done yet?
__________________
"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 03-31-2015, 11:52 PM   #537
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,535
The database did not work with OOTP16. The rookie draft pool only showed about 15 players. It should have been many more. I will probably have to import them manually.
Jeff1787 is offline   Reply With Quote
Old 04-01-2015, 01:41 AM   #538
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
A little more info please. What year did you start your league in?

I'd like to run a test to see what your challenge might be.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-01-2015, 02:41 PM   #539
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,535
I started the league in 1901 and it is now June of 1937. I have used different versions of your high school databases and they have all worked. I tried this database (Spritze's Database for OOTP14) on OOTP16 and it didn't draft any players that were 18 years old. It only drafted 14 older players.

So, I tried that database that I had been using for OOTP15 (not sure witch version) and the same thing happened.

No Japanese, minor league or Negro League players were imported.
Jeff1787 is offline   Reply With Quote
Old 04-02-2015, 01:40 AM   #540
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
In 1901 I get 169 players in the draft class. In 1937 I get 326.

I'm guessing you may have something crossed up data-wise?

The only time I have seen this before is when players have switched from the Gambo to the Spritze and back.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Reply

Bookmarks


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