Home | Webstore
Latest News: OOTP 26 Available - FHM 12 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 08-02-2015, 02:24 PM   #781
Timeless
Minors (Rookie Ball)
 
Timeless's Avatar
 
Join Date: Oct 2009
Location: Wilmington, North Carolina
Posts: 27
This looks very interesting and I would like to try it out. Is there somewhere a step by step instruction for downloading and using it -- let's say, for people who have zero knowledge of how to use computers?

I can click the link, download the file into the OOTP folder, but from there.... no clue what to do after that.
Timeless is offline   Reply With Quote
Old 08-02-2015, 08:16 PM   #782
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by Timeless View Post
This looks very interesting and I would like to try it out. Is there somewhere a step by step instruction for downloading and using it -- let's say, for people who have zero knowledge of how to use computers?

I can click the link, download the file into the OOTP folder, but from there.... no clue what to do after that.
I am happy you figured this out as reported in another thread.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 10-24-2015, 03:04 PM   #783
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
New one on OOTP Wiki and Dropbox
Major League and PCL players who debuted
1871-1912 now as well as 1940-1974
Plus added a few new unusual characters like Dwight Eisenhower who was historically significant in non-baseball ways.

https://www.dropbox.com/s/tzbak1a57r...Stats.zip?dl=0
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 10-24-2015, 03:05 PM   #784
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
Awesome, you rock
__________________
"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 10-25-2015, 02:29 PM   #785
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Thanks Spritze. You're the best.
actionjackson is offline   Reply With Quote
Old 10-25-2015, 07:53 PM   #786
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
New one on OOTP Wiki and Dropbox
Major League and PCL players who debuted
1871-1912 now as well as 1940-1974
Plus added a few new unusual characters like Dwight Eisenhower who was historically significant in non-baseball ways.

https://www.dropbox.com/s/tzbak1a57r...Stats.zip?dl=0
Spritze,

Any other interesting characters we should be on the lookout for?

Can I substitute this for your previous version without my universe collapsing?

Regards,

JP
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 10-25-2015, 10:42 PM   #787
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
Spritze,

Any other interesting characters we should be on the lookout for? The fun is in the finding?

Can I substitute this for your previous version without my universe collapsing? Yes

Regards,

JP
I believe this matches the old file just with more player years available. Players should still have the same debuts just different stats. More complete histories.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 10-25-2015 at 10:45 PM.
Spritze is offline   Reply With Quote
Old 10-26-2015, 01:41 AM   #788
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
I believe this matches the old file just with more player years available. Players should still have the same debuts just different stats. More complete histories.
Yes, that will be fun. You are right about that.

I DL'd the file and took a look at it. There are the usual files and some with an ootp prefix. What or how are these used or not?

Great work as always!
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 10-26-2015, 06:59 AM   #789
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
Yes, that will be fun. You are right about that.

I DL'd the file and took a look at it. There are the usual files and some with an ootp prefix. What or how are these used or not?

Great work as always!
OOTP* files are just copies of the ones that came with OOTP16. Not used.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 11-01-2015, 04:09 AM   #790
jncca1215
Minors (Rookie Ball)
 
Join Date: Oct 2015
Posts: 39
Spritze, a few questions.

1) Do I have to start a new game, or can I switch to your database mid-game?
2) How do I switch the pathway to use your stuff? I'm not good at all the technical stuff, so talk me through it pretty simply. I have downloaded your file.
jncca1215 is offline   Reply With Quote
Old 11-01-2015, 09:49 AM   #791
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by jncca1215 View Post
Spritze, a few questions.

1) Do I have to start a new game, or can I switch to your database mid-game?
2) How do I switch the pathway to use your stuff? I'm not good at all the technical stuff, so talk me through it pretty simply. I have downloaded your file.
If you already have a historical game or a random debut game going using the default DB or his previous DB you can switch mid game. Ihave and have had no issues.

After you downloaded the file, go to the html line ( whatever it's called, waiting for someone to tell me what it is called) copy it using keyboard controls CTL-C. Go to league settings - historical or ina custom game options. Look for the database path and paste the thing you copied into there using CTRL-V.
Here what mine looks like.
C:\Users\Todd\Documents\OOTP 11 DL\databases\Spritze HS for OOTP16\stats
Attached Images
Image Image 
__________________
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 12-05-2015, 06:36 PM   #792
Torgo Johnson
Bat Boy
 
Join Date: Oct 2012
Posts: 3
Quote:
Originally Posted by Spritze View Post
New one on OOTP Wiki and Dropbox
Major League and PCL players who debuted
1871-1912 now as well as 1940-1974
Plus added a few new unusual characters like Dwight Eisenhower who was historically significant in non-baseball ways.

https://www.dropbox.com/s/tzbak1a57r...Stats.zip?dl=0
This version does not import the players as high schoolers. I compared the master.csv for this version and the previous version. For example in the previous version, Sherry Magee's first year in the master.csv is 1902. In this version, it is not till 1903.His fake 1902 year is in the batting.csv. I noticed this because when I ran a draft for 1902, I was getting 29-year-olds in the pool.

Last edited by Torgo Johnson; 12-05-2015 at 06:45 PM.
Torgo Johnson is offline   Reply With Quote
Old 12-05-2015, 09:15 PM   #793
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
My current copy shows 1902 in the master for Magee not 1903. 1903 is what the regular OOTP master has.

I'll be setting up a new download tomorrow with 2015 added anyway. Use that.

Uploaded to DropBox
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 12-07-2015 at 04:46 AM.
Spritze is offline   Reply With Quote
Old 01-18-2016, 03:04 AM   #794
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
My current copy shows 1902 in the master for Magee not 1903. 1903 is what the regular OOTP master has.

I'll be setting up a new download tomorrow with 2015 added anyway. Use that.

Uploaded to DropBox
Did this ever happens? Most recent file that I can find is from October. I had a few anomalies, but I was waiting to see if they were corrected before I started blabbing on.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 01-18-2016, 10:44 AM   #795
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by RANGER11JP View Post
Did this ever happens? Most recent file that I can find is from October. I had a few anomalies, but I was waiting to see if they were corrected before I started blabbing on.
DropBox = Yes
OOTPWiki = No - I was not able to update the file.

Just finished adding the full careers of players who debuted in 1913. I'll be updating the files again after testing over the next few days.

If you have noted challenges I will check them out and include fixes with 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 01-18-2016, 02:57 PM   #796
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,363
Quote:
Originally Posted by Spritze View Post
DropBox = Yes
OOTPWiki = No - I was not able to update the file.

Just finished adding the full careers of players who debuted in 1913. I'll be updating the files again after testing over the next few days.

If you have noted challenges I will check them out and include fixes with the next release.
After further review, I believe it is I who is challenged. What is the dropbox location and how do I confirm I have your latest issue?

Thanks!
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 01-18-2016, 04:13 PM   #797
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

File Dated in December
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 01-18-2016 at 04:17 PM.
Spritze is offline   Reply With Quote
Old 01-26-2016, 01:10 PM   #798
Germaniac
Hall Of Famer
 
Germaniac's Avatar
 
Join Date: Apr 2011
Location: Frankenthal, Germany
Posts: 3,059
One small mistake I found in the database ... simply because he's my all-time favorite player:

Robin Yount's birthplace is listed as Danville, Virginia ... but it actually is Danville, Illinois.

But your database simply is awesome
__________________
I'm going to have to meet my Maker some day.
And if He asks me why I didn't let this boy play,
and I say it's because he's black,
that might not be a satisfactory answer.


Happy Chandler, 1947




Germaniac is offline   Reply With Quote
Old 01-28-2016, 12:18 AM   #799
JcBoscan
Minors (Single A)
 
JcBoscan's Avatar
 
Join Date: Apr 2014
Posts: 65
Spritze - just used this database for the first time and it's awesome. Thanks!
JcBoscan is offline   Reply With Quote
Old 02-12-2016, 03:59 AM   #800
reflections
Minors (Double A)
 
reflections's Avatar
 
Join Date: Oct 2010
Location: Tumwater, Washington
Posts: 175
I love the database. I was wondering if there will be a update with 2014 and 2015 rookies?
reflections 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 06:40 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