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

Collection Missions for Perfect Team Released!

  

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 06-10-2016, 10:58 PM   #21
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,020
Thanks: 9,058
Thanked 3,067x in 2,448 posts
Quote:
Originally Posted by froghair View Post
If a Spritze dbse game is started in OOTP 16, can it than be opened in OOTP 17? Seems like I was able to do that in a test this morning.
I have used the 16 DB in 17 but not for an extended league. I have imported many players from his DB into 17 but they seem to suck. Sadaharu Oh is like a .229 hitter with 90 career HR. All NPB imports have been bad. neutralized stats. Using his db for my ABF in 16. Gibson had 620 HR and Paige has 360 Wins.
__________________
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 06-11-2016, 11:35 AM   #22
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
I do not know what OOTP17 does with players but I think it may have an adjustment that applies to the import of non-mlb players like Oh.

I do not believe this process occurs if the Spritze db is used in place of the standard one as no import occurs.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 06-12-2016, 09:52 AM   #23
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,020
Thanks: 9,058
Thanked 3,067x in 2,448 posts
Quote:
Originally Posted by Spritze View Post
I do not know what OOTP17 does with players but I think it may have an adjustment that applies to the import of non-mlb players like Oh.

I do not believe this process occurs if the Spritze db is used in place of the standard one as no import occurs.
In my ABF league which I rebooted on 16, It is a fictional league with the occasional import, so there is no default DB i am using. I use your DB for non MLB players.
__________________
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 06-12-2016, 11:01 PM   #24
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
I checked out Oh

The Japanese leagues had a high number of hits per inning compared to the MLB in most years so Oh gets dinged for that.
Oh had a high number of HR's per game so he gets credit for that.

The meat of his career was when offense took a holiday in the MLB. He gets dinged there as well.

Once all the adjustments are applied he becomes a 500 HR hitter who barely breaks the Mendoza line.
__________________
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 (06-13-2016)
Old 07-01-2016, 02:28 AM   #25
Giants44
Hall Of Famer
 
Giants44's Avatar
 
Join Date: Dec 2001
Location: San Francisco Bay Area
Posts: 2,304
Thanks: 119
Thanked 288x in 125 posts
Sounds like this is likely a v18 thing. I am in the middle of my "better world" historical replay were we somehow abolished world wide racism in 1870 and baseball was open to all from the beginning.

My thought is to manually add in "significant" figures from th negro leagues as well as any from around the world I can think of (Sara ar Oh comes to mind, but I ought to learn to spell his name right first)

My question is do you have a good resource you can point me to that you used for your DB?
__________________
"In a text sim - Immersion is everything"
-Me

"Judge a man not by the color of their skin, but by the content of their character"
-Martin Luther King

"Not everything that counts can be counted, and not everything that can be counted counts."
-Einstein

"The man who views the world at 50 the same as he did at 20 has wasted 30 years of his life."
-Muhammad Ali

"Baseball statistics are like a girl in a bikini. They show a lot, but not everything."
-Toby Harrah
Giants44 is offline   Reply With Quote
Old 07-01-2016, 11:26 AM   #26
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
All of the Japanese and Korean players are in the database, significant or not.

There are 425 Negro Leaguers in the database which is most of the significant ones and 3,500 more coming in the next release.

The Negro League data comes from many books and a lot of sites on the internet. No one source has it all. A computer was programmed to use all known data to compile stats that could be used by OOTP to create computerized players that have a skill set that matches their IRL one as closely as currently possible.

I'll probably release a new Spritze database containing all the negro league players this month.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
7 thanks for this post:
gbmoore121 (07-01-2016), Giants44 (07-04-2016), JaBurns (07-02-2016), kev24fan (07-01-2016), Lukas Berger (07-11-2016), The Game (07-05-2016), txranger (07-01-2016)
Old 07-11-2016, 12:06 AM   #27
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
3,864 Negro League players have been added to the 450 already in the Spritze database.

That gets the database pretty close to the maximum size if not over it.

Batting, Pitching and Fielding records have been added for each year of a players career that I have found anywhere at all on the web, in books and whatnot.

I'll see if it compiles tomorrow. If it does it'll be finished. If it does not I'll need to adjust the compilation process.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 07-11-2016 at 12:07 AM.
Spritze is offline   Reply With Quote
7 thanks for this post:
JaBurns (07-11-2016), Lukas Berger (07-11-2016), MarkInCincy (07-11-2016), mitchkenn (07-11-2016), RANGER11JP (07-12-2016), The Game (07-11-2016), txranger (07-11-2016)
Old 07-11-2016, 01:36 PM   #28
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,297
Thanks: 1,373
Thanked 1,172x in 749 posts
Quote:
Originally Posted by Spritze View Post
3,864 Negro League players have been added to the 450 already in the Spritze database.

That gets the database pretty close to the maximum size if not over it.

Batting, Pitching and Fielding records have been added for each year of a players career that I have found anywhere at all on the web, in books and whatnot.

I'll see if it compiles tomorrow. If it does it'll be finished. If it does not I'll need to adjust the compilation process.
Awesome!!!!! and thank you a dozen times ....
__________________
"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-11-2016, 10:24 PM   #29
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
https://www.dropbox.com/s/3b45ued2yd...OTP17.zip?dl=0

Link to the database is above
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 07-13-2016 at 12:50 PM.
Spritze is offline   Reply With Quote
2 thanks for this post:
JaBurns (07-13-2016), The Game (07-12-2016)
Old 07-11-2016, 11:13 PM   #30
txranger
Hall Of Famer
 
txranger's Avatar
 
Join Date: Dec 2008
Location: "Deep in the Heart Of"
Posts: 6,444
Thanks: 4,625
Thanked 19,267x in 5,232 posts
Quote:
Originally Posted by Spritze View Post


Is this the link to the one with the additional Negro League players? When I open the master, I can only see the 450 or so that were already included in you db... Thanks
txranger is offline   Reply With Quote
Old 07-11-2016, 11:24 PM   #31
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
Yes it is. The college field does not yet contain the "negro leaguer" designation for the new players. I'm filling that in as these players get reviewed.
__________________
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:
txranger (07-12-2016)
Old 07-12-2016, 04:21 AM   #32
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,278
Thanks: 1,751
Thanked 221x in 160 posts
Hello Spritze,

What is the status of the debut TEAM for the players? Will the Major Leaguers go to their original team or the one you designated as in earlier renditions of this DB? Could you share the proper settings for getting players to debut as intended as well?

Thanks!
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 07-12-2016, 04:44 AM   #33
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
Quote:
Originally Posted by RANGER11JP View Post
Hello Spritze,

What is the status of the debut TEAM for the players? Free Agents Will the Major Leaguers go to their original team or the one you designated Yes as in earlier renditions of this DB? Could you share the proper settings for getting players to debut as intended as well? I do not understand

Thanks!
More info may be needed on the last question. There are no settings I am aware of.

Do keep in mind that OOTP18 no longer is able to put players on their IRL and/or designated teams. That got broke many builds ago and never got fixed. All you can use is a draft.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 07-17-2016, 08:25 AM   #34
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
https://www.dropbox.com/s/1q2qd492fy...OTP17.zip?dl=0

Newest version with the accented characters removed from the player names and the thusly newly created duplicate players removed.
__________________
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-17-2016), mitchkenn (07-17-2016)
Old 07-18-2016, 03:19 AM   #35
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,020
Thanks: 9,058
Thanked 3,067x in 2,448 posts
Quote:
Originally Posted by Spritze View Post
https://www.dropbox.com/s/1q2qd492fy...OTP17.zip?dl=0

Newest version with the accented characters removed from the player names and the thusly newly created duplicate players removed.
This is only Negro leaguers?
__________________
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 07-18-2016, 08:16 AM   #36
mitchkenn
Hall Of Famer
 
mitchkenn's Avatar
 
Join Date: Jan 2015
Location: Oregon, not by design
Posts: 2,297
Thanks: 1,373
Thanked 1,172x in 749 posts
no it's his HS db with Negro (and i suspect Japanese). Same as before, but the 3000+ Negro league players without the duplicates. i've downloaded it and played part of a season, and it's definitely not just Negro Leagues.
__________________
"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-18-2016, 10:21 AM   #37
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
No segregation here. Design decision by me.

I'd even include aliens if any played ball.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 07-19-2016, 02:19 AM   #38
RANGER11JP
All Star Starter
 
Join Date: Jun 2002
Posts: 1,278
Thanks: 1,751
Thanked 221x in 160 posts
Quote:
Originally Posted by Spritze View Post
More info may be needed on the last question. There are no settings I am aware of.

Do keep in mind that OOTP18 no longer is able to put players on their IRL and/or designated teams. That got broke many builds ago and never got fixed. All you can use is a draft.
OOTP18 isn't even out yet and is already broken? I am guessing you mean OOTP17, but I am shocked and appalled that an error such as you referred to has not been addressed. What happened to designating rookies to their IRL teams?

To clarify my question, I wanted to know what settings or Team ID's needed to be set for players to import correctly. Now I'm not sure that is even possible!!!!!

I'm stunned.
__________________
BASEBALL, HOCKEY AND BOXING FAN
RANGER11JP is offline   Reply With Quote
Old 07-19-2016, 02:46 AM   #39
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 20,020
Thanks: 9,058
Thanked 3,067x in 2,448 posts
Quote:
Originally Posted by Spritze View Post
No segregation here. Design decision by me.

I'd even include aliens if any played ball.
Ok so what is the difference between this and the Spritze 17 DB?
__________________
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 07-19-2016, 06:25 AM   #40
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,147
Thanks: 307
Thanked 3,216x in 1,890 posts
Quote:
Originally Posted by RANGER11JP View Post
OOTP18 isn't even out yet and is already broken? I am guessing you mean OOTP17, but I am shocked and appalled that an error such as you referred to has not been addressed. What happened to designating rookies to their IRL teams? Does not currently work. It got destroyed a few builds ago.

To clarify my question, I wanted to know what settings or Team ID's needed to be set for players to import correctly. Now I'm not sure that is even possible!!!!! It is not currently possible.

I'm stunned.
I am stunned as well.
__________________
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 (07-25-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:14 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