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 07-11-2016, 05:04 PM   #1
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,146
Thanks: 306
Thanked 3,214x in 1,888 posts
Spritze Negro League Database Bug Reports

I have noticed that the sources are often differing on negro league player names. This can result in duplicate players.

Jose Acosta could be in the database twice once with the accent ' over the e and once without.

Buddy Armour could be in under his nickname as well as his given name.

If you come across these please post them here so I can clean them up. I'd like to have the negro league players ready for OOTP18 in as good a condition as possible.

Thanks
__________________
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-11-2016)
Old 07-11-2016, 06:31 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
is this a separate data base, or included in your high school one? i saw a link to HS database on another thread ... downloaded a version of that a few weeks ago - obviously need to get a newer version if these are to be included ... is it the .odb or .csv file we need to look at for name variations?
__________________
"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; 07-11-2016 at 07:17 PM.
mitchkenn is offline   Reply With Quote
Old 07-11-2016, 08:30 PM   #3
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,146
Thanks: 306
Thanked 3,214x in 1,888 posts
Quote:
Originally Posted by mitchkenn View Post
is this a separate data base, or included in your high school one? High School i saw a link to HS database on another thread ... downloaded a version of that a few weeks ago - obviously need to get a newer version if these are to be included ... is it the .odb or .csv file we need to look at for name variations? Just play and if you notice something post it here.
I am changing the compilation process as it did create a too large database. I am splitting it into 3 databases (it used to be two).
__________________
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-11-2016)
Old 07-11-2016, 08:51 PM   #4
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
thanks for the info ... looking forward to the release. will use it when i get bored with my current league and start a new one, most likely in the next month.

edit:

well, next month came early .... decided to give your DB a try and in process of creating a new game. thanks again for all the work you've done on this.
__________________
"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; 07-13-2016 at 10:55 AM. Reason: add edit
mitchkenn is offline   Reply With Quote
Old 07-14-2016, 12:01 AM   #5
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,146
Thanks: 306
Thanked 3,214x in 1,888 posts
FYI: I have been using the database and notice Babe Ruth only had 385 career HR's which is still the most. The reason for this is that adding Josh Gibson, Mule Suttles, Turkey Stearns and the other negro players sucks up many of the available HR's. The league totals are not out of line.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 07-14-2016, 04:53 AM   #6
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
FYI: I have been using the database and notice Babe Ruth only had 385 career HR's which is still the most. The reason for this is that adding Josh Gibson, Mule Suttles, Turkey Stearns and the other negro players sucks up many of the available HR's. The league totals are not out of line.
You well know how OOTP works, off the totals modifiers, so bring in more good players, and the stats of those players will drop to keep the total.

When I used your database, because there were so many other good players, I played with 8 more teams than required. So the pre 1960's I had 24 teams running, and then added teams when they came in after that, so my modern era ending would be 38 teams.
The individual stats for players tended to turn out much better .

Give that a shot. Play out the 1920's with 8 more teams and see if Ruth gets closer to 700 hr and the new negro league players put up more exacting stats.
As I say I tested a few things long ago and found 8 additional teams to be about the optimal number.

Also, becuase of how pitching stats get imported. Each year I would take who should be the 4-5 best starting pitchers, and gave them a 7-10 point rise in GB%. A 55 to 65 for example. That was enough to keep Cy Young, Mathewson, Grove or whatnot near the top of the list- otherwise (with so many more pitchers, and often real high rated guys who played only a few years but become great in OOTP engine) the star pitchers were about 70% as effective as real life.
That shift too made a big difference.

Anyway, just passing that along to you in case any of it could be of use to you.
Cheers
sprague is offline   Reply With Quote
Old 07-14-2016, 09:33 AM   #7
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,146
Thanks: 306
Thanked 3,214x in 1,888 posts
When not testing the OOTP defaults I start with 32 teams in 1901 and add 16 more in 1940. The 32 are the current MLB 30 plus the Havana Sugar Kings and the Mexico City Red Devils. In 1940 I add 8 Negro League teams and the PCL. With the additional new players I may move up expansion to 1930.

I will try the pitcher adjustment next go round.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 07-14-2016, 05:16 PM   #8
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
back to the dupilcate players:

in the 1901 draft - i found these players (possibly more, but only looked at pitchers and catchers) are duplicated (with the accent ' .....)

Candido Fontantals
R. Mendez
Jose Munos
Luis Padron
Gonzalo Sanchez
Juan Viola
Regino Garcia
Francisco Moran

think i spell those correct, but when i jotted down the names my handwritting left a lot to be desired, and i'm not at the game comuter to double check right now.

question: in the master csv Albert Toney is shown as starting in 1901. He isn't in this draft. Possibly 1902 or ??? . Must be somewhere as he's in the .csv file. Just wondering. Great work. Loving this db so far.
__________________
"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; 07-14-2016 at 06:11 PM.
mitchkenn is offline   Reply With Quote
Old 07-14-2016, 06:52 PM   #9
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,146
Thanks: 306
Thanked 3,214x in 1,888 posts
I will clean these up right away. But I won't use my tongue.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 07-14-2016, 07:33 PM   #10
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,146
Thanks: 306
Thanked 3,214x in 1,888 posts
Changed about 900 names with accented letters to remove the accents.

Next I need to remove the duplicates that change made (653 of them) and move the stats from the accented player to the unaccented one.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 07-14-2016 at 07:39 PM.
Spritze is offline   Reply With Quote
Thank you for this post:
mitchkenn (07-15-2016)
Old 07-15-2016, 11:40 AM   #11
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
Changed about 900 names with accented letters to remove the accents.

Next I need to remove the duplicates that change made (653 of them) and move the stats from the accented player to the unaccented one.
NICE! will wait for the updated files, as i'm just a few days before the draft and the updated files/stats will help avoid later editing. Suppose this will take a few days before the db is updated and made available? Thanks for your work.
__________________
"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; 07-15-2016 at 06:43 PM.
mitchkenn is offline   Reply With Quote
Old 07-17-2016, 07:59 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
got the updated version this morning. fantastic job, sir! 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.
mitchkenn is offline   Reply With Quote
Old 07-17-2016, 10:19 PM   #13
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,146
Thanks: 306
Thanked 3,214x in 1,888 posts
I just added a stats cap of a bit over 400 IP in a year for each Pitcher in any year >1900. Pre-1901 anything goes.

This was needed due to the way BBref stores its pitching stats which is like a squid in a mirror. There really aren't two of them.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 08-24-2016, 10:33 AM   #14
klonewarrior
Minors (Double A)
 
Join Date: Jul 2010
Posts: 111
Thanks: 199
Thanked 35x in 22 posts
It seems Cy Youngs historical stats are wrong, at least going back before 1901.
klonewarrior is offline   Reply With Quote
Old 08-24-2016, 11:57 AM   #15
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Redmond Wa and Cape Coast Ghana
Posts: 7,146
Thanks: 306
Thanked 3,214x in 1,888 posts
Specifics please.

Just one or two stats so I can track what you are seeing.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze 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 04:47 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