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 04-28-2018, 06:39 PM   #1
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
Spritze DB for OOTP19

Done except for the export to the Internet.

Players still start at 18 (or earlier if they did IRL)

I was thinking of removing the players who are in the OOTP databases already but they don't start at 18 so I did not.

Ethnicities and arm slots have been added as have the other new OOTP items added by OOTP Developments to the OOTP file structures. There are some values that just have placeholders for now as it will take all summer to procure the data.

Real stats and neutralized stats are the same MLE's as before. So really real stats do not exist. A couple of versions ago I removed them because users of the database could not remember to only use the newts. So either one you pick produces the same results.

I'll wait a week or so to upload this in case anyone has any requests or concerns. It will be an ODB file as CSV's do not work with OOTP anymore. I have been waiting on the new historical lead to be named before I released this to make sure he would be OK with it as I would not want to do any toes stepping on but that may not happen for a while so I just decided to go for it.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
12 thanks for this post:
actionjackson (05-05-2018), endgame (04-28-2018), JaBurns (05-02-2018), jparker2112 (04-29-2018), mitchkenn (04-28-2018), mugwump1970 (05-04-2018), Orcin (04-29-2018), plannine (05-07-2018), Scott Vibert (04-29-2018), Someguy1785 (04-29-2018), The Game (05-02-2018), txranger (04-28-2018)
Old 04-28-2018, 08:17 PM   #2
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
any chance of an amended .csv, with just the players names, race, arm slot, debut year/ final year and player IDs - you know, without anything proprietary? i find that the .csv files are extremely helpful, if for nothing else to get the player IDs to make large .txt files to import. the rest of the stuff i can edit, when/as needed.

thanks for all the great DBs in the past. i've used them more than the ones that come in the game it seems. be well.
__________________
"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.

Last edited by mitchkenn; 04-28-2018 at 09:04 PM. Reason: minutia
mitchkenn is offline   Reply With Quote
Thank you for this post:
actionjackson (05-05-2018)
Old 04-29-2018, 01:58 AM   #3
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,668
Thanks: 124
Thanked 493x in 301 posts
Hi spritze.
I was just testing your 18 db with the new version, and the odd feature of not getting drafts occurred.
The new players in 1872 show up, but as free agents, not draft.
Draft is selected all is as it should be in the setup screens. You may want to double check the draft is working fine with the new one.

Ps I also tested neutralized, and 19 called up the stats odd. 1 column seemed moved over. So runs became at bats, at bats were games played. Every player imported as a .567 like hitter. Just a heads up, you might want to check that too.

Love your db and work. If I can test anything for you, shoot me over a pm
Cheers
sprague is offline   Reply With Quote
Thank you for this post:
actionjackson (05-05-2018)
Old 04-29-2018, 10:55 AM   #4
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 sprague View Post
Hi spritze.
I was just testing your 18 db with the new version, and the odd feature of not getting drafts occurred.
The new players in 1872 show up, but as free agents, not draft.
Draft is selected all is as it should be in the setup screens. You may want to double check the draft is working fine with the new one.

Love your db and work. If I can test anything for you, shoot me over a pm
Cheers
Using both the old db files (OOtp17) and the new ones, both create a draft in 1872 of 36 players and 1871 starts out with 183 players rather than the default 139. That is how it is supposed to work so whatever was weird in the OOTP18 ODB compiler seems to have adjusted itself.

I'll check the newts later today.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-29-2018, 11:14 AM   #5
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
Newts look fine as well.
You did not specify how you were viewing the newts.
This screenshot is from the newt inaugural draft.
Attached Images
Image 
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-29-2018, 02:04 PM   #6
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,668
Thanks: 124
Thanked 493x in 301 posts
Sorry Spritze. Here is a screenshot. This is 1871, spritze db 18, neutralized stats. out of the box setup. Here are how the historical stats import for everyone, just 2 examples
Attached Images
Image Image 
sprague is offline   Reply With Quote
Old 04-29-2018, 02:08 PM   #7
Orcin
Hall Of Famer
 
Orcin's Avatar
 
Join Date: Aug 2010
Location: Indiana
Posts: 8,524
Thanks: 3,598
Thanked 7,247x in 3,579 posts
New historical lead?
__________________


My Fictional Dynasty: Orcin's Story ; The Sequel: Orcin Returns ; The Conclusion: Orcin's Brave New World
Orcin is offline   Reply With Quote
Old 04-29-2018, 02:35 PM   #8
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 sprague View Post
Sorry Spritze. Here is a screenshot. This is 1871, spritze db 18, neutralized stats. out of the box setup. Here are how the historical stats import for everyone, just 2 examples
Reproducible is not what these examples are.
Attached Images
Image 
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 04-29-2018 at 02:50 PM.
Spritze is offline   Reply With Quote
Thank you for this post:
sprague (04-29-2018)
Old 04-29-2018, 02:47 PM   #9
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 Orcin View Post
New historical lead?
Aye. I have retired.

I will be around to help answer questions if the new person has any questions which they may not but I have humped my last tulip.

Golden years are burgeoning and beckoning.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
4 thanks for this post:
actionjackson (05-05-2018), mitchkenn (04-29-2018), Scott Vibert (04-29-2018), txranger (04-29-2018)
Old 04-29-2018, 03:17 PM   #10
Orcin
Hall Of Famer
 
Orcin's Avatar
 
Join Date: Aug 2010
Location: Indiana
Posts: 8,524
Thanks: 3,598
Thanked 7,247x in 3,579 posts
Quote:
Originally Posted by Spritze View Post
Aye. I have retired.

I will be around to help answer questions if the new person has any questions which they may not but I have humped my last tulip.

Golden years are burgeoning and beckoning.
Best wishes for those golden years. Hopefully you won't stop playing and you will be around to talk about that.
__________________


My Fictional Dynasty: Orcin's Story ; The Sequel: Orcin Returns ; The Conclusion: Orcin's Brave New World
Orcin is offline   Reply With Quote
2 thanks for this post:
actionjackson (05-05-2018), Spritze (04-29-2018)
Old 04-29-2018, 04:03 PM   #11
sprague
All Star Starter
 
Join Date: Aug 2011
Posts: 1,668
Thanks: 124
Thanked 493x in 301 posts
Quote:
Originally Posted by Spritze View Post
Reproducible is not what these examples are.
Well as long as the new 19 works is all that really matters. I can wait, patiently, but wait.
Thanks for all your work to keep doing these
sprague is offline   Reply With Quote
Thank you for this post:
actionjackson (05-05-2018)
Old 04-29-2018, 04:11 PM   #12
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
Aye. I have retired.

I will be around to help answer questions if the new person has any questions which they may not but I have humped my last tulip.

Golden years are burgeoning and beckoning.
may your retirement be filled with peace and contentment. All you've done, and all the help extended, remains a standard and is appreciated. if you're ever this way, a dr. pepper awaits.
__________________
"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
Thank you for this post:
actionjackson (05-05-2018)
Old 05-02-2018, 12:08 PM   #13
JaBurns
All Star Starter
 
Join Date: Sep 2015
Location: Regina, Saskatchewan
Posts: 1,226
Thanks: 3,620
Thanked 568x in 439 posts
Quote:
Originally Posted by Spritze View Post
Aye. I have retired.

I will be around to help answer questions if the new person has any questions which they may not but I have humped my last tulip.

Golden years are burgeoning and beckoning.
What mitchkenn said enjoy your retirement, hopefully you will have second thoughts regarding OOTP.
JaBurns is offline   Reply With Quote
Old 05-02-2018, 02:45 PM   #14
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 retired from working 5 years ago except for a very few consults with old clients.

I will be available for consults with OOTP if anything comes up.

Hopefully the new guy will be overflowing with new ideas and can push historicals to new heights.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
4 thanks for this post:
actionjackson (05-05-2018), JaBurns (05-02-2018), mitchkenn (05-02-2018), txranger (05-02-2018)
Old 05-02-2018, 04:52 PM   #15
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 mitchkenn View Post
any chance of an amended .csv, with just the players names, race, arm slot, debut year/ final year and player ids
ok
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
5 thanks for this post:
actionjackson (05-05-2018), JaBurns (05-02-2018), mitchkenn (05-02-2018), mpoloni23 (11-11-2018), txranger (05-02-2018)
Old 05-02-2018, 05:06 PM   #16
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
ok
mucho gracias!!!!
__________________
"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.

Last edited by mitchkenn; 05-02-2018 at 09:26 PM.
mitchkenn is offline   Reply With Quote
Thank you for this post:
actionjackson (05-05-2018)
Old 05-03-2018, 02:02 AM   #17
szathkey
Minors (Double A)
 
szathkey's Avatar
 
Join Date: Jun 2008
Posts: 103
Thanks: 25
Thanked 0x in 0 posts
I personally look forward to this update more than I do the actual release of the game, so I'm sad to hear you'll be taking a step back.

One thing you said has left me confused though...

Quote:
Originally Posted by Spritze View Post
I was thinking of removing the players who are in the OOTP databases already but they don't start at 18 so I did not.
I'm not sure what this means...The way I am reading it all of these players will continue to debut in the years in the vanilla game, while players you've added will be imported into the draft at the age of 18.

Is my interpretation correct? If not, what did you really mean?

I love starting everyone at that early age in some fictional minor leagues, so that's why I'm curious.

Thanks man
szathkey is offline   Reply With Quote
Old 05-03-2018, 11:29 AM   #18
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 szathkey View Post
I personally look forward to this update more than I do the actual release of the game, so I'm sad to hear you'll be taking a step back.

One thing you said has left me confused though...



I'm not sure what this means...The way I am reading it all of these players will continue to debut in the years in the vanilla game, while players you've added will be imported into the draft at the age of 18.

Is my interpretation correct? Yes If not, what did you really mean?

I love starting everyone at that early age in some fictional minor leagues, so that's why I'm curious.

Thanks man
Welcome
__________________
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:
szathkey (05-03-2018)
Old 05-03-2018, 07:19 PM   #19
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
Update:

Slight pause before I release this.

While I was creating the player list for those that import I decided it was too confusing to have some different player ID's in OOTP and the Spritze database so I will change mine to match OOTP. If OOTP does not have one, like for most Japanese and Korean players I will be making my own.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
4 thanks for this post:
JaBurns (05-04-2018), jparker2112 (05-03-2018), mitchkenn (05-03-2018), Scott Vibert (05-03-2018)
Old 05-03-2018, 07:22 PM   #20
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
Update:

Slight pause before I release this.
darn - but thanks for the update ....
__________________
"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.

Last edited by mitchkenn; 05-03-2018 at 08:49 PM.
mitchkenn is offline   Reply With Quote
2 thanks for this post:
actionjackson (05-05-2018), JaBurns (05-04-2018)
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 01:32 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