Home | Webstore
Latest News: OOTP 26 Available - FHM 11 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 04-08-2015, 11:30 PM   #561
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by MUFC1878 View Post
How many *** players that never made it to the US are in the db?
Pretty much all of them. As you play you'll notice a few that make the bigs in the 30's, 40's and 50's. Most of them are Hawaiian asians by birth or grew up in Hawaii or California. There was a "yellow" line as well as a "black" one that couldn't be crossed. Some of them were really quite good players. The asians were kept away for several extra decades probably partially due to WWII.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 04-08-2015 at 11:33 PM.
Spritze is offline   Reply With Quote
Old 04-09-2015, 06:26 AM   #562
MarkInCincy
All Star Reserve
 
MarkInCincy's Avatar
 
Join Date: Oct 2012
Location: Cincinnait, OH (WestSider)
Posts: 657
Quote:
Originally Posted by Spritze View Post
historicaldatabase.odb

The files with OOTP in front are just the ones that came with the game.
Thanks for the quick response, thought thats what I did but did it in a rush so anything is possible. Will give it another shot later

NOTE to self: Mark, take your time, slow down. You have waited this long for a Spritze RD, another 30 minutes to set up the league ain't gonna kill ya.
__________________
"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 04-09-2015, 09:03 AM   #563
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
Quote:
Originally Posted by Spritze View Post
https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

Try this one....I made random a part of the regular Spritze DB now. The random ODB is now incorporated.
one of these years I am going to get you guys to use the wiki's drag & drop file gallery for this stuff

OOTP Community Wiki | Spritze's db for OOTP16
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball
jazzrack is offline   Reply With Quote
Old 04-09-2015, 12:39 PM   #564
doubles
Major Leagues
 
Join Date: Dec 2001
Posts: 480
I point the game to the ODB file with random debut and I get no players in the inaugural draft. This is using the new ZIP file.

Am I doing anything wrong?
doubles is offline   Reply With Quote
Old 04-09-2015, 01:03 PM   #565
MUFC1878
All Star Reserve
 
MUFC1878's Avatar
 
Join Date: Sep 2012
Location: Venezuela
Posts: 621
Quote:
Originally Posted by Spritze View Post
Pretty much all of them. As you play you'll notice a few that make the bigs in the 30's, 40's and 50's. Most of them are Hawaiian asians by birth or grew up in Hawaii or California. There was a "yellow" line as well as a "black" one that couldn't be crossed. Some of them were really quite good players. The asians were kept away for several extra decades probably partially due to WWII.
Is it possible to have these Japanese players debuting every year in a draft in their own league, or even just as free agents?
MUFC1878 is offline   Reply With Quote
Old 04-09-2015, 02:16 PM   #566
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by doubles View Post
I point the game to the ODB file with random debut and I get no players in the inaugural draft. This is using the new ZIP file.

Am I doing anything wrong?
No I did. I got the wrong file in the right place. just one of them but it was enough to kill random. I'll have a new and well tested one in about 5 minutes. Sorry.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 04-12-2015 at 04:44 PM.
Spritze is offline   Reply With Quote
Old 04-09-2015, 07:45 PM   #567
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
I updated the file on the wiki & changed how the wiki page works, any changes to the file gallery OOTP Community Wiki | Spritze will automatically be reflected on the wiki page

OOTP Community Wiki | Spritze's db for OOTP16
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball

Last edited by jazzrack; 04-09-2015 at 11:33 PM.
jazzrack is offline   Reply With Quote
Old 04-12-2015, 01:20 AM   #568
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
First off Spritze, congrats. Take a bow. This looks like an amazing database and it looks like a helluva lot of work went into it.

I'm just curious though as to why there are no 2014 seasons for current players, except for those that debuted in 2014. As a result guys that enjoyed breakout seasons in 2014 like Jose Altuve, J D Martinez, Corey Kluber etc probably won't get the ratings bump that their breakout seasons suggest they should, or other guys who escape me at the moment who took big steps back in 2014 won't have that show up either. Jacob DeGrom and Jose Abreu will be fine because they debuted in 2014, but others who did not debut in 2014 won't have their breakout 2014 seasons reflected in their ratings. Like I said, I think this looks like the best database going. I'm just confused by this seeming omission. Maybe, I'm just confused period. Thanks in advance for your response.
actionjackson is offline   Reply With Quote
Old 04-12-2015, 06:01 AM   #569
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by Spritze View Post
No I did. I got the wrong file in the right place. just one of them but it was enough to kill random. I'll have a new and well tested one in about 5 minutes. Sorry.

https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0
I didn;t seem to have a problem getting RD to work, why did others? i drafted 2 Negro league players. One was Barney Brown who might have been rated a bit high at 4 stars but had some good stats.
__________________
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 04-12-2015, 09:47 AM   #570
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 67
[new to OOTP} Is there an OOTP16 version of this database sans Asian players? And/or is there a way for me to monkey with the csv files to remove Asian players and Negro Leaguers and add them to later years? (Basically I want to start in 1871 and play forward, diversifying the player pool starting in about the late 20s.)
froghair is offline   Reply With Quote
Old 04-12-2015, 01:07 PM   #571
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Asian players don't come in until the 1930's and Negro Leaguers start in 1901 or thereabouts.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-12-2015, 01:21 PM   #572
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Mr. Lahmans database that I use to build both mine and the two historical databases that come with the game changed a lot this year.

Fielding stats for all of 2014 are missing important information and this caused the fielding processing of 2014 to fail. Which in turn led that process to be unable to export players 2014 records properly. I did not notice this undocumented change when creating the databases.

I'll need to find a source other than Lahman for these fielding records and check to see if that made the historical part of generic OOTP fail as well. I'm thinking the roster team has a different source.

I'd say that next year I'll need to use information other than what Lahman provides as this is about the 20th undocumented change he has made for his current version which has caused challenges with OOTP16's two historical databases. That is 20 too many.

Thanks for catching this.

https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 04-12-2015 at 04:43 PM.
Spritze is offline   Reply With Quote
Old 04-12-2015, 01:24 PM   #573
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by The Game View Post
I didn;t seem to have a problem getting RD to work, why did others?
I made a mistake that killed random while I was fixing something else so not every iteration did not work randomly.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 04-12-2015 at 01:25 PM.
Spritze is offline   Reply With Quote
Old 04-12-2015, 01:47 PM   #574
froghair
Minors (Single A)
 
Join Date: Mar 2015
Location: Rocky River, Ohio
Posts: 67
Quote:
Originally Posted by Spritze View Post
Asian players don't come in until the 1930's and Negro Leaguers start in 1901 or thereabouts.
Thanks .. I should've clarified though -- I am aiming to run a random debut game whereby Asian players and Negro Lg players start arriving in 20s or 30s.

Only way I can think of is to delete unwanted players that show up in draft pool and import them in individually once I reach that stage in the game's history.
froghair is offline   Reply With Quote
Old 04-12-2015, 03:08 PM   #575
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by froghair View Post
Only way I can think of is to delete unwanted players that show up in draft pool and import them in individually once I reach that stage in the game's history.
Yup do that, cause random means anyone can show up at anytime. Randomly.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-19-2015, 10:54 AM   #576
Germaniac
Hall Of Famer
 
Germaniac's Avatar
 
Join Date: Apr 2011
Location: Frankenthal, Germany
Posts: 3,058
Awesome database, indeed - it's great to have the chance to have all the great Negro League players in the majors ... but one thing stunned me:

I now twice simmed up until the late 30's and found a drastic lack of HR's.

While all offensive categories are close to what happened in real life, Babe Ruth is the all-time champ at an even 400

Are there any settings I should/could change to get HR totals closer to real life ?
Attached Images
Image Image 
__________________
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 04-19-2015, 11:00 AM   #577
Germaniac
Hall Of Famer
 
Germaniac's Avatar
 
Join Date: Apr 2011
Location: Frankenthal, Germany
Posts: 3,058
The other was simmed through 1950:
Attached Images
Image Image 
__________________
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 04-19-2015, 12:12 PM   #578
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Germaniac View Post
The other was simmed through 1950:
Whoa! Babe Ruth's career OBP was in the neighbourhood of his RL OBP, but his SLG is nowhere near what it was IRL. I wonder if having all those stars in the game at the same time made it tougher to divvy up the HR and XBH properly. Only Spritze knows.
actionjackson is offline   Reply With Quote
Old 04-19-2015, 01:53 PM   #579
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Well not tougher really but there are a fairly finite number of HR's for a season as a whole and Mr. Ruth just does not stick so far above the tide when it includes star Negro Leaguer Hitters and Pitchers as well.

If you want more HR's and such you can set the LeagueSettings/ StatsandAI/ league Strategy/ historical year to the Steroid Era and things might be different.

OOTP just lets the chips fall where they may. Bottom line is if the color line had not existed player records would have been very different. Mr. Ruth would have faced a better class of pitchers as a whole. The point of my database is "What if.....".

Oh yeah, in my personal game I usually have 24 to 32 teams in my league and adding the extra bad pitchers gets Mr. Ruth back to 600-700 HR's.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 04-19-2015 at 01:59 PM.
Spritze is offline   Reply With Quote
Old 04-19-2015, 01:57 PM   #580
Germaniac
Hall Of Famer
 
Germaniac's Avatar
 
Join Date: Apr 2011
Location: Frankenthal, Germany
Posts: 3,058
Okay, that definitely makes sense - thanks a lot !

And thanks for that great database - I don't even want to think about how many hours you put into this !
__________________
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
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 08:25 AM.

 

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