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 05-22-2015, 09:08 PM   #701
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
I planned on reviewing more of the formulas that make up the components so there might have been another update in a few weeks but I figured out how to chain a pitchers components in a non-linear way in one swell foop so it will be available as soon as the uploads complete.

On the OOTP Wiki now,

Dropbox soon.
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; 05-22-2015 at 09:20 PM.
Spritze is offline   Reply With Quote
Old 05-22-2015, 09:11 PM   #702
edhberg3
Minors (Rookie Ball)
 
Join Date: Apr 2007
Posts: 41
What settings do I need in historical? Automatically Import historical rookies or use random rookies from all eras, or both?
edhberg3 is offline   Reply With Quote
Old 05-22-2015, 09:48 PM   #703
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Quote:
Originally Posted by edhberg3 View Post
What settings do I need in historical? Automatically Import historical rookies or use random rookies from all eras, or both?
One or the other but not both.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-22-2015, 10:22 PM   #704
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by edhberg3 View Post
What settings do I need in historical? Automatically Import historical rookies or use random rookies from all eras, or both?
Straight historical, Auto import rookies. If you want Random debut check both.
__________________
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 05-22-2015, 10:23 PM   #705
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
I planned on reviewing more of the formulas that make up the components so there might have been another update in a few weeks but I figured out how to chain a pitchers components in a non-linear way in one swell foop so it will be available as soon as the uploads complete.

On the OOTP Wiki now,

Dropbox soon.
https://www.dropbox.com/s/nubmvyjies...OTP16.zip?dl=0
What did you update on this one? i just downloaded one yesterday and last week and the week before then 2 days before that one.
__________________
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 05-22-2015, 10:38 PM   #706
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
What did you update on this one?
pitchers components
This will be the last update until next year unless someone finds an error or seven.
The MLE portion of the database program was rewritten. Minor players were too good more often than not. That is no longer true but they still contribute just not usually in a league leading way.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-23-2015, 12:06 PM   #707
edhberg3
Minors (Rookie Ball)
 
Join Date: Apr 2007
Posts: 41
What about the Historical Rookies Settings? Do I need to do anything with those? DO I need to click the Automatically import Historical Rookies button? The Use Randon Rookies from All Eras? Both
edhberg3 is offline   Reply With Quote
Old 05-23-2015, 01:17 PM   #708
The Game
Hall Of Famer
 
The Game's Avatar
 
Join Date: Feb 2012
Location: Inside The Game
Posts: 30,937
Quote:
Originally Posted by edhberg3 View Post
What about the Historical Rookies Settings? Do I need to do anything with those? DO I need to click the Automatically import Historical Rookies button? The Use Randon Rookies from All Eras? Both
For straight historical Check import rookies uncheck RD. For RD check both.
__________________
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 05-23-2015, 05:06 PM   #709
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
Huge shout out to John Henry who was sure these MLE's could be better. Now they are.
Thanks.
That wouldn't be the John Henry, owner of the Boston Red Sox, would it? Because that would be pretty cool.

EDIT: Oh, and you rule. Thanks for all your hard work, patience, and persistence.

Last edited by actionjackson; 05-23-2015 at 08:02 PM.
actionjackson is offline   Reply With Quote
Old 05-24-2015, 03:40 PM   #710
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Joe Hauser (For Instance)

Partially due to a short porch in Minneapolis that would not allow space for a decent sized rocking chair Joe hit 69 HR's in 1933.

Currently the MLE's put him at 60 since the overall league average was 12 in that year.

BUT

Personal Park Factor...........
I just added formulas that would compare the HR's Joe hit to the other players on his team (avg 27) and what the other players in the league hit in Minneapolis (avg 20). Making these adjustments would lower his MLE HR's to 37 (if I leave his own 69 HR's in the averages) or 43 (if I don't count what he contributed hisownself). BTW his MLE doubles went up and his outs made as well using this new formula which makes pretty much sense I think. A few of his HR's got caught by the RF'er and some of them turned into doubles. K's and walks would stay the same I think.

If I make the change to adjust MLE's by team (to account for park influences) as well as league, I'd do it for the stats that a park could effect, pretty much the things that make up slugging pct for and against on both the pitching and the hitting side.

I chose Joe for this example as he is the most extreme sample I could think of. I also used Jim Baxes and his years in Hollywood as a sample as well as several others.

Implement or not?

Better ideas?
__________________
It's madness, madness, I tell you! For the love of God, don't do it!

Last edited by Spritze; 05-24-2015 at 08:10 PM.
Spritze is offline   Reply With Quote
Old 05-24-2015, 04:21 PM   #711
Jeff1787
Hall Of Famer
 
Jeff1787's Avatar
 
Join Date: Oct 2005
Location: The Doghouse
Posts: 3,535
Implement.....
Jeff1787 is offline   Reply With Quote
Old 05-24-2015, 07:30 PM   #712
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Implement I would say, but I would also say it's your work, so go with what you think is right. That 60 HR would make Hauser beastly in and around 1933, especially for those of us that use recalc three years (double weighted on the year in question). Perhaps too beastly for those of us that want some semblance of realism (after all he was in the minor leagues in a stadium with a short porch at the time).
actionjackson is offline   Reply With Quote
Old 05-24-2015, 08:15 PM   #713
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
1) 37 (if I leave his own 69 HR's in the averages)
2) 43 (if I don't count what he contributed hisownself)


I'm leaning to #2 because I'm not sure he should be penalized for being able to take better advantage of the park exploit than the other players in the league. Reward should go to the better adapted? Kind of like a sea turtle or a saltwater croc or a giant blue flying squid.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-24-2015, 10:54 PM   #714
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
1) 37 (if I leave his own 69 HR's in the averages)
2) 43 (if I don't count what he contributed hisownself)


I'm leaning to #2 because I'm not sure he should be penalized for being able to take better advantage of the park exploit than the other players in the league. Reward should go to the better adapted? Kind of like a sea turtle or a saltwater croc or a giant blue flying squid.
Sounds good to me Sir Spritze. After all, it all goes towards making this database even better.
actionjackson is offline   Reply With Quote
Old 05-25-2015, 07:17 PM   #715
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
On third thought I'm thinking #1 since the point of the database is to remove all vestiges of any exploits.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-25-2015, 08:42 PM   #716
actionjackson
Hall Of Famer
 
actionjackson's Avatar
 
Join Date: Apr 2009
Location: Toronto, ON
Posts: 6,163
Quote:
Originally Posted by Spritze View Post
On third thought I'm thinking #1 since the point of the database is to remove all vestiges of any exploits.
I am on board with whatever you decide to do. I'm sure it will make it even better.
actionjackson is offline   Reply With Quote
Old 05-27-2015, 05:47 PM   #717
italyprof
All Star Starter
 
Join Date: Feb 2014
Posts: 1,024
Spritze, thanks for the great database and all your work - using it with an OOTP 16 Random Debut historical league in 1920 and it just a blast. Masaichi Kenada as my Brooklyn Robins' ace, a nice twist.
italyprof is offline   Reply With Quote
Old 05-27-2015, 07:25 PM   #718
skyballer455
All Star Reserve
 
Join Date: Jul 2014
Posts: 701
I was recently doing a MLB historical replay and saw that in 1914, the Federal League teams got added to the league. Although that is a very interesting addition, I would prefer that the Federal League not show up in my game.

Is there any way to prevent that from happening?
skyballer455 is offline   Reply With Quote
Old 05-28-2015, 12:25 AM   #719
Spritze
OOTP Historical Czar
 
Spritze's Avatar
 
Join Date: Dec 2001
Location: Bothell Wa
Posts: 7,253
Just make any players they have signed free agents and delete the teams from your league.
__________________
It's madness, madness, I tell you! For the love of God, don't do it!
Spritze is offline   Reply With Quote
Old 05-28-2015, 02:09 PM   #720
skyballer455
All Star Reserve
 
Join Date: Jul 2014
Posts: 701
Quote:
Originally Posted by Spritze View Post
Just make any players they have signed free agents and delete the teams from your league.
Thanks, but don't want it to happen entirely. Perhaps I need to edit the database?
skyballer455 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 01:00 PM.

 

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