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

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

Reply
 
Thread Tools
Old 07-28-2009, 12:45 PM   #1
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
OOTPOU for OOTP X/11/12

OOTPOU (Online Utilities, for those new here) for OOTP 11/12 is released. Get the full utilities and patch here:

OOTPOU Full
OOTPOU Patch

Readme (not upgraded to X yet, but is 99% the same) found here:

Readme

The utilities contain:

1. All Star Voting Utility
2. End of Season Awards Utility (** NEW)
3. Development Tracker, including:
- Team's Sim by Sim development
- Player's Development over his career
- League-wide Talent changes (** NEW)
4. Draft Utility
5. Export Tracker
6. Hall of Fame Voting Utility (** NEW)
7. Last Sim Utility, including:
- Each Team's Sim Results
- Player Stats from Each Team
- Team by Team Stats (** NEW)
- Top Performances
- Playoff Odds
8. Manager's Page
9. Ratings Reports

This works on both versions OOTP 11 and OOTP 12. No upgrade or any changes are needed when upgrading from OOTP 11 to 12.

See it in action here

Additional features are to come!!!
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details

Last edited by Getch; 08-25-2011 at 03:59 PM.
Getch is offline   Reply With Quote
Old 07-28-2009, 02:23 PM   #2
Mike1
Minors (Triple A)
 
Join Date: Jan 2003
Posts: 209
Thanks Getch!
__________________
Mike Dills
Mike1 is offline   Reply With Quote
Old 07-28-2009, 02:27 PM   #3
Mike1
Minors (Triple A)
 
Join Date: Jan 2003
Posts: 209
Neither of the links are working for me.
__________________
Mike Dills
Mike1 is offline   Reply With Quote
Old 07-28-2009, 03:06 PM   #4
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by USBACommish View Post
Neither of the links are working for me.
Heh... that's because I couldn't spell "http". Try now.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 07-28-2009, 04:01 PM   #5
Mike1
Minors (Triple A)
 
Join Date: Jan 2003
Posts: 209
Done the trick...thanks again!
__________________
Mike Dills
Mike1 is offline   Reply With Quote
Old 07-29-2009, 08:07 PM   #6
Nutlaw
Hall Of Famer
 
Nutlaw's Avatar
 
Join Date: Apr 2003
Posts: 9,538
Thanks, Getch. These are the best. An absolute must for online leagues.
Nutlaw is offline   Reply With Quote
Old 08-02-2009, 05:34 AM   #7
Tony M
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,156
Blog Entries: 3
Quote:
Originally Posted by Getch View Post
2. The ratings for individual pitches does not match the in-game displayed values. This is because other factors such as velocity, movement ,etc. affect individual pitch ratings. I have yet to get my hands on the formulas to convert the individual pitch ratings to the displayed ratings. As soon as I do, I will update the utilities.
During gaps in my recent sojourn I've been looking at this (I know the EULA says no reverse engineering!!)

I've done a couple of pitches so far and the formulas look reasonably accurate

FASTBALL

A : ((Velocity on the 1-20 scale) - 1) * 6
B : (Internal Fastball Rating) / 2.5

Fastball Rating : A + B + 8 (on the 1-200 scale)

SINKER

A : ((Velocity on the 1-20 scale) - 1 ) * 3
B : Groundball% * 0.6
C : (Internal Movement Rating) / 6
D : (Internal Sinker Rating) * 0.3

Sinker Rating : A + B + C + D + 1
__________________
This signature is intentionally blank
Tony M is offline   Reply With Quote
Old 08-02-2009, 09:56 PM   #8
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Updated the top post with version 3.1. Two new utilities! OOTPOU now supports voting for End of Year Awards, and voting for the Hall of Fame!

And yes... there is still more to come.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 08-03-2009, 07:51 PM   #9
Mike1
Minors (Triple A)
 
Join Date: Jan 2003
Posts: 209
Quote:
Originally Posted by Getch View Post
Updated the top post with version 3.1. Two new utilities! OOTPOU now supports voting for End of Year Awards, and voting for the Hall of Fame!

And yes... there is still more to come.
Nice!
__________________
Mike Dills
Mike1 is offline   Reply With Quote
Old 08-05-2009, 03:53 PM   #10
Tony M
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,156
Blog Entries: 3
Quote:
Originally Posted by Tony M View Post
During gaps in my recent sojourn I've been looking at this (I know the EULA says no reverse engineering!!)

I've done a couple of pitches so far and the formulas look reasonably accurate
I've done 10 of the 12 pitches now.

Variables are defined

IR : Internal Rating for pitch
GB : Groundball %
M : Movement Rating
V : Velocity (1-20)

All the following give a value on the 1-200 scale (obviously it can go over 200, so these would be > MAX on chosen scale)

Fastball : (V*6)+(IR*0.4)+1
Sinker : (V*3)+(IR*0.3)+(GB*0.6)+(M/6)-(13/6) subject to a minimum of 6
Knuckleball : IR + 1
Knucklecurve : (IR*0.8)+(V*2)+1.6
Screwball : (IR*0.8)+(V*2)+1.6
Circle Change : IR + 1
Forkball : (V*4)+(IR*0.4)+(GB*0.3)+(M/12)-0.3 subject to a minimum of 6
Splitter : (V*4)+(IR*0.4)+(GB*0.3)+(M/12)-0.3 subject to a minimum of 6
Changeup : IR + 1
Cutter : (V*4)+(IR*0.4)+(GB*0.3)+(M/12)-0.3 subject to a minimum of 6
__________________
This signature is intentionally blank

Last edited by Tony M; 08-05-2009 at 04:22 PM. Reason: done 10th pitch
Tony M is offline   Reply With Quote
Old 08-14-2009, 11:30 AM   #11
thickman1
Minors (Double A)
 
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
has anyone had a problem with the draft utility using OOTP X? I've used it 3 previous seasons on 9 and there weren't any snafu's but this year on 10 the utility is displaying hundreds of players who aren't in the actual draft in-game. Any thoughts?
thickman1 is offline   Reply With Quote
Old 08-14-2009, 07:50 PM   #12
Killing Time
All Star Starter
 
Killing Time's Avatar
 
Join Date: May 2005
Posts: 1,097
Quote:
Originally Posted by Getch View Post
Heh... that's because I couldn't spell "http".
Done that myself.
__________________
"I'm killing time while I wait for life to shower me with meaning and happiness."

Quote:
Originally Posted by endgame View Post
In my best imitation of KT, "I don't know. Would? May? This could have been better. I'm a bit disappointed."
Please don't beat the dead graphics horse.
Killing Time is offline   Reply With Quote
Old 08-15-2009, 12:30 PM   #13
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by thickman1 View Post
has anyone had a problem with the draft utility using OOTP X? I've used it 3 previous seasons on 9 and there weren't any snafu's but this year on 10 the utility is displaying hundreds of players who aren't in the actual draft in-game. Any thoughts?
One of my leagues went thru the draft no problem. Are you using a feeder league?
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 08-15-2009, 12:53 PM   #14
thickman1
Minors (Double A)
 
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
Quote:
Originally Posted by Getch View Post
One of my leagues went thru the draft no problem. Are you using a feeder league?
Yes. We have two HS's and one college. There are crazy issues with player names too - you should check it out. Seems to be a big problem with the latin names.

Rookie Draft Report
thickman1 is offline   Reply With Quote
Old 08-15-2009, 01:22 PM   #15
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by thickman1 View Post
Yes. We have two HS's and one college. There are crazy issues with player names too - you should check it out. Seems to be a big problem with the latin names.

Rookie Draft Report
The Latin name thing seems to be a OOTP bug on certain OS's (it generates the CSV files with the funky characters). What OS are you using? It'd be nice to get this fixed in the next patch.

As for the draft, I just checked my other league which uses feeder leagues, and it looks spot on. Can you check that you put the proper age limits in the admin set up screen? Remember that you should put the age to be one more than what is in game (so if the HS age limit is 18 in OOTP, put 19 in OOTPOU).
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 08-15-2009, 01:24 PM   #16
thickman1
Minors (Double A)
 
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
Quote:
Originally Posted by Getch View Post
The Latin name thing seems to be a OOTP bug on certain OS's (it generates the CSV files with the funky characters). What OS are you using? It'd be nice to get this fixed in the next patch.

As for the draft, I just checked my other league which uses feeder leagues, and it looks spot on. Can you check that you put the proper age limits in the admin set up screen? Remember that you should put the age to be one more than what is in game (so if the HS age limit is 18 in OOTP, put 19 in OOTPOU).
I'm using Windows Vista.


As for extra players, by moving that date up won't I lose the 18 year's olds who are in the draft?
thickman1 is offline   Reply With Quote
Old 08-15-2009, 01:44 PM   #17
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by thickman1 View Post
I'm using Windows Vista.


As for extra players, by moving that date up won't I lose the 18 year's olds who are in the draft?
Looks like you moved up the date, and the draft pool looks correct now.

And yes, I think the screwed up characters are a Vista-specific issue.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 08-16-2009, 06:00 PM   #18
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
OOTPOU 3.1.1 is released! The big change is that the individual pitch ratings/talents are in the development utility (many thanks to Tony and Markus). Also, the HoF voting now displays the MVP/Cy Young/Gold Glove awards the player accumalted in his career. And of course, a few minor bug fixes here and there.

PLEASE NOTE! There are steps to upgrade properly so you don't get a whole assortment of bogus pitch rating/talent changes:

1. Before your next sim, unzip OOTPOUPatch.zip in the cgi-bin directory.
2. Go to OOTPOU/development and delete the file prevRatings.txt
3. Run the Development utility. This will regenerate prevRatings.txt but not display any new development
4. Now you're good to go. Run your sim as you normally would.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details

Last edited by Getch; 08-16-2009 at 06:02 PM.
Getch is offline   Reply With Quote
Old 08-24-2009, 09:42 PM   #19
BobDylanRH
Minors (Double A)
 
Join Date: Jun 2009
Posts: 149
I'm getting this error when I try to generate the sim results:

Error Occurred!Illegal division by zero at OOTPOU/LSAdmin.pm line 1833.
BobDylanRH is offline   Reply With Quote
Old 08-25-2009, 11:57 AM   #20
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by BobDylanRH View Post
I'm getting this error when I try to generate the sim results:

Error Occurred!Illegal division by zero at OOTPOU/LSAdmin.pm line 1833.
Make sure you fill out the parameters in the admin screen. Specifically, the Pythagorean Exponent and Seasons to Simulate. I suggest 1.83 and 100.

The error appears as if you did not fill the Seasons to Simulate value.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch 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 06:59 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 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments