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

Perfect Team is LIVE!

  

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 07-19-2016, 07:29 AM   #41
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
Quote:
Originally Posted by The Game View Post
Ok so what is the difference between this and the Spritze 17 DB?
Nearly 3,500 negro league players have been added. Most will just be minor league fodder but the stars seem to rise to the top which can make for an interesting alternate history.
__________________
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:
The Game (07-19-2016)
Old 07-22-2016, 04:08 AM   #42
cultbuscus
Bat Boy
 
Join Date: Mar 2016
Posts: 18
Thanks: 6
Thanked 1x in 1 post
Sorry for a non-helpful reply, but the link doesn't seem to work?
cultbuscus is offline   Reply With Quote
Old 07-22-2016, 04:11 AM   #43
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
Took it down for a few days due to a database error I made.

It will be back this weekend.
__________________
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:
mitchkenn (07-22-2016)
Old 07-22-2016, 04:05 PM   #44
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
https://www.dropbox.com/s/c3dpdch32l...OTP17.zip?dl=0

Link to the latest version.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
6 thanks for this post:
Bigrod (07-24-2016), cultbuscus (07-26-2016), JaBurns (07-22-2016), mitchkenn (07-22-2016), sprague (07-23-2016), The Game (07-25-2016)
Old 07-22-2016, 04:14 PM   #45
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon
Posts: 2,128
Thanks: 1,290
Thanked 1,070x in 685 posts
you must take a break from work & OOTP sometime, don't you? ..... again, many thanks for this. it is truly appreciated.
__________________
"This is my opening farewell " - Jackson Browne
“They make a desolation and call it peace.” ― Agha Shahid Ali
"Maybe she just has to sing, for the sake of the song - And who do I think that I am to decide that she's wrong." - Townes Van Zandt
"I saw a young man leaning on his wooden crutch - He called out to me, 'Don't ask for so much' And a young woman leaning in her darkened door She cried out to me, 'Why not ask for more?' " - Leonard Cohen
Before Mays, before DiMaggio, there was Oscar Charleston.
"All the lies about Babe Ruth are true." - Waite Hoyt

Avatar is the late great Townes Van Zandt. rip.
mitchkenn is offline   Reply With Quote
Old 07-22-2016, 04:47 PM   #46
JaBurns
All Star Starter
 
Join Date: Sep 2015
Location: Regina, Saskatchewan
Posts: 1,172
Thanks: 3,380
Thanked 531x in 420 posts
Should I have more than one folder titled SpritzeHSforOOTP17 in the stats folder? I don't think so but I thought I would ask.....
JaBurns is offline   Reply With Quote
Old 07-22-2016, 05:55 PM   #47
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
I suggest taking the 2 files in the Spritze folder and copying them to the stats folder. They are replacements for what is there.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
2 thanks for this post:
JaBurns (07-22-2016), mitchkenn (07-22-2016)
Old 07-23-2016, 04:42 AM   #48
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,658
Thanks: 124
Thanked 488x in 296 posts
Quote:
Originally Posted by Spritze View Post
I suggest taking the 2 files in the Spritze folder and copying them to the stats folder. They are replacements for what is there.
I just bring the spritze folder into ootp 17, then navigate betjene his and the original stats database AS needed. Never Had any problems.
sprague is offline   Reply With Quote
Thank you for this post:
JaBurns (07-23-2016)
Old 08-06-2016, 12:08 PM   #49
PNatsFan703
Minors (Single A)
 
Join Date: Mar 2016
Posts: 68
Thanks: 8
Thanked 15x in 14 posts
This is a very basic question but how do I import them into a current save???
PNatsFan703 is offline   Reply With Quote
Old 08-06-2016, 02:02 PM   #50
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
I for one do not know because I have never tried this action.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-06-2016, 10:39 PM   #51
PNatsFan703
Minors (Single A)
 
Join Date: Mar 2016
Posts: 68
Thanks: 8
Thanked 15x in 14 posts
Thanks man. Second question then. How do I import it into a custom game at the start???
PNatsFan703 is offline   Reply With Quote
Old 08-06-2016, 11:53 PM   #52
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
I just replace the OOTP file in the stats folder with the Spritze one.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-22-2016, 10:42 AM   #53
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,658
Thanks: 124
Thanked 488x in 296 posts
Noticed pop Lloyd has rather low batting ratings, and only seems viable for around ten years, rest of his career shows as .150 hitter.
Looked at the neutralized, but I think regular stats are the same
sprague is offline   Reply With Quote
Thank you for this post:
MarkInCincy (08-22-2016)
Old 08-22-2016, 12:51 PM   #54
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
There were two Loyds in the db. Pop and John. They were the same guy IRL. They have been combined and will be so in the next version.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-29-2016, 08:13 PM   #55
cultbuscus
Bat Boy
 
Join Date: Mar 2016
Posts: 18
Thanks: 6
Thanked 1x in 1 post
I feel stupid...

But for the life of me, I can't figure out why there are no Negro Leaguers are appearing in the draft or in the game? I'm using the database in the file that I downloaded, and none of them are showing. I tried doing a different game with the database being the "Master" Excel File, but that's doesn't seem to be working either. Could anyone help me with what I'm doing wrong?


Edit: Sorry sorry sorry. I didn't realize it doesn't work for OOTP17. I feel like an idiot. It didn't process it reading through the first pages.

Last edited by cultbuscus; 08-30-2016 at 03:44 AM. Reason: Realized what's going on
cultbuscus is offline   Reply With Quote
Old 08-30-2016, 03:50 AM   #56
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 19,363
Thanks: 8,660
Thanked 3,002x in 2,403 posts
Quote:
Originally Posted by cultbuscus View Post
But for the life of me, I can't figure out why there are no Negro Leaguers are appearing in the draft or in the game? I'm using the database in the file that I downloaded, and none of them are showing. I tried doing a different game with the database being the "Master" Excel File, but that's doesn't seem to be working either. Could anyone help me with what I'm doing wrong?


Edit: Sorry sorry sorry. I didn't realize it doesn't work for OOTP17. I feel like an idiot. It didn't process it reading through the first pages.
I thought this was updated for 17?

Did you selct the stats folder upon league creation? Advanced options during league creation wizard. Or copy the html for the stats folder and paste using ctrl c & ctrl-v in to teh database path under historical?
__________________
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 08-30-2016, 09:12 AM   #57
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
It is built for OOTP17
__________________
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:
The Game (08-31-2016)
Old 11-29-2016, 03:40 AM   #58
Vezna31
All Star Starter
 
Vezna31's Avatar
 
Join Date: May 2004
Location: San Diego, CA
Posts: 1,905
Thanks: 12
Thanked 32x in 23 posts
Question

Question from a very Non-technical person:

I have a historical league with history already that goes from 1901 to 1936 (mid season). Can I just copy this file in the stat folder and point the game setting to it and it will automatically pull in all 1937 rookie players from original MLB plus all of the Negro League and Japanese players that you added?

Thanks.
__________________
Owner/Operator - Vezna Financial Services - Accounting and taxes.
http://www.vezna.com
Vezna31 is offline   Reply With Quote
Old 11-29-2016, 04:00 AM   #59
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 6,805
Thanks: 208
Thanked 3,019x in 1,759 posts
The rookie years in this database are different than those in the ootp database as ootp uses mlb rookie year and this db uses pro debuts.
__________________
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:
Vezna31 (11-29-2016)
Old 11-29-2016, 04:02 AM   #60
Vezna31
All Star Starter
 
Vezna31's Avatar
 
Join Date: May 2004
Location: San Diego, CA
Posts: 1,905
Thanks: 12
Thanked 32x in 23 posts
Quote:
Originally Posted by Spritze View Post
The rookie years in this database are different than those in the ootp database as ootp uses mlb rookie year and this db uses pro debuts.
Ok, thanks.
__________________
Owner/Operator - Vezna Financial Services - Accounting and taxes.
http://www.vezna.com
Vezna31 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 05:51 PM.

 

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