Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 25 > OOTP Mods > OOTP Mods - Database Tools
Register Blogs FAQ Calendar Today's Posts Search

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 04-19-2015, 02:17 PM   #581
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,123
Quote:
Originally Posted by Spritze View Post
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.
Thanks for the explanation Sir Spritze. I knew you'd make it make sense.
actionjackson is offline   Reply With Quote
Old 04-19-2015, 04:12 PM   #582
Germaniac
Hall Of Famer
 
Germaniac's Avatar
 
Join Date: Apr 2011
Location: Frankenthal, Germany
Posts: 2,993
I simply expected Ruth to hit close to 700 ... and expected that guys like Josh Gibson would also be in that neighborhood.

What I didn't consider is the fact that if you add enormous talent from the Negro Leagues into a 16-team league it drastically raises the amount of very good big league players.

So now it will be interesting to see how the league develops once we're past the color barrier
__________________
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, 09:47 PM   #583
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
The next thing you might notice is that Ted Williams usually leads in nearly every career batting category since he doesn't miss time for WWII and WWII.5
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-20-2015, 08:49 PM   #584
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,420
In my dynasty, Ruth retired with 554 in 1935, number one so far...
Jeff1787 is offline   Reply With Quote
Old 04-20-2015, 08:56 PM   #585
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,807
Quote:
Originally Posted by Germaniac View Post
I simply expected Ruth to hit close to 700 ... and expected that guys like Josh Gibson would also be in that neighborhood.

What I didn't consider is the fact that if you add enormous talent from the Negro Leagues into a 16-team league it drastically raises the amount of very good big league players.

So now it will be interesting to see how the league develops once we're past the color barrier
In my ABF league Ruth has close to 1100 HR and Gibson had 620. Ruth didn't even turn into a hitter full time until age 31.
__________________
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-23-2015, 01:27 PM   #586
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,123
Spritze, I'm also noticing that players that debuted in 2014 are importing with no stats, and I've noticed that Jacob deGrom and Jose Abreu specifically have no stats in the pitching2.csv and batting2.csv files respectively. Perhaps this is what's causing the imports with no stats, which of course causes imports with no ratings. Thanks for this database nonetheless. Cheers.
actionjackson is offline   Reply With Quote
Old 04-23-2015, 01:53 PM   #587
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,807
For RD league with Negro league, *** etc do I select the ODB? While i had some Negro leaguers in my 1st attempt all *** players seemed to be after ML debut. 2nfd attempt i had no known Negro Leaguers and all *** guys were after ML debut.
I took the RD ODB that you posted and copied that over the HS stats file you posted recently. Was that the right way to go?
__________________
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-23-2015, 03:28 PM   #588
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Quote:
Originally Posted by The Game View Post
I took the RD ODB that you posted and copied that over the HS stats file you posted recently. Was that the right way to go?
Nope. The latest HS db has the random in it already. Just use it as is.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-23-2015, 03:31 PM   #589
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Quote:
Originally Posted by actionjackson View Post
Spritze, I'm also noticing that players that debuted in 2014 are importing with no stats, and I've noticed that Jacob deGrom and Jose Abreu specifically have no stats in the pitching2.csv and batting2.csv files respectively. Perhaps this is what's causing the imports with no stats, which of course causes imports with no ratings. Thanks for this database nonetheless. Cheers.
You are using the second to latest db. The latest one has this fixed. I oops'ed the previous one and had to give it an oopsdectomy.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-23-2015, 04:56 PM   #590
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,123
Quote:
Originally Posted by Spritze View Post
You are using the second to latest db. The latest one has this fixed. I oops'ed the previous one and had to give it an oopsdectomy.
Just downloaded the latest one (from post #572) and deGrom and Abreu still don't have stats in pitching2 and batting2 respectively, while guys like Jose Bautista and Chase Utley still don't have 2014 stats in batting2, along with Cole Hamels and Felix Hernandez in pitching2, with all due respect Sir Spritze. I'm guessing this holds true for the entire database, and I could check more if you like, but I think you get the gist. You are still da man.

Last edited by actionjackson; 04-23-2015 at 05:08 PM.
actionjackson is offline   Reply With Quote
Old 04-23-2015, 09:29 PM   #591
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
They seem to be in my copy of the latest Pitching2 and Batting2. Did you try the one on OOTP Wiki? That was also updated. I'll look into this more soon.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-23-2015, 10:22 PM   #592
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,123
Quote:
Originally Posted by Spritze View Post
They seem to be in my copy of the latest Pitching2 and Batting2. Did you try the one on OOTP Wiki? That was also updated. I'll look into this more soon.
Thanks much Spritze. The good news is that yes the current players who debuted prior to 2014 have been updated with their 2014 stats in the neutered stats (or batting2, pitching2, fielding2 if you will) files in the download from the OOTP wiki. Yay!

The bad news is that the 2014 debut guys are still without neutered stats from what I can see. That would be guys like deGrom, Abreu and the lesser lights from the 2014 debut class.

As I have said before, your db is awesome and mind bogglingly comprehensive. I hope you take my comments as me trying to help you make it awesomer, and not me being a whiny little b*tch. Whenever you can get to it is A-OK by me. After all, you can't rush greatness. Thanks again for the incredible contributions you make around here. Cheers.
actionjackson is offline   Reply With Quote
Old 04-25-2015, 02:38 PM   #593
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
More Better

https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

I'll update the Wiki tomorrow. Yard work 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-25-2015, 04:39 PM   #594
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,807
Quote:
Originally Posted by Spritze View Post
https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0

I'll update the Wiki tomorrow. Yard work today.
This is the most up to date version? for historical 1901 & beyond i can still use real stats and 1 yr recalc right with your DB? Gonna start a History of the White Sox soon.
__________________
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-25-2015, 05:04 PM   #595
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Quote:
Originally Posted by The Game View Post
This is the most up to date version? Yes for historical 1901 & beyond i can still use real stats and 1 yr recalc right with your DB? Yes Gonna start a History of the White Sox soon.
Found and fixed the challenges in the program that produces the CSV files.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-25-2015, 06:00 PM   #596
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,123
Thank You! Thank You! Thank You! You are the best!



actionjackson is offline   Reply With Quote
Old 04-25-2015, 09:18 PM   #597
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,123
I've crawled all over the stats2 files, and this database is extremely impressive/comprehensive. The following 2014 debut players are still missing neutered stats though:

Erisbel Arruebarrena (SS LAD) (arrueer01)
Rusney Castillo (CF BOS) (castiru01)
Bryan Price (P CLE) (pricebr01), not Bryan Price the CIN manager (pricebr99)
Chad Smith (P DET) (smithch08)

Like I said though, this is a work of art, and you sir are a genius.
actionjackson is offline   Reply With Quote
Old 04-25-2015, 10:24 PM   #598
etothep
Minors (Double A)
 
Join Date: Aug 2008
Posts: 102
Sorry for noobing up the thread, but I DLed the updated dropbox file linked a few posts above. I made a backup of my default stats folder and saved it on my external hard drive & then copied Spritze's zipped up stats files over to replace the stats folder used normally by OOTP

Is that all I need to do to use this database in a new historical game?
etothep is offline   Reply With Quote
Old 04-25-2015, 10:25 PM   #599
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,254
Quote:
Originally Posted by etothep View Post
Is that all I need to do to use this database in a new historical game?
Yes
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 04-25-2015, 10:28 PM   #600
etothep
Minors (Double A)
 
Join Date: Aug 2008
Posts: 102
Quote:
Originally Posted by Spritze View Post
Yes
Now I need to figure out which year I want to start
etothep 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 11:03 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 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments