Home | Webstore
Latest News: - OOTP 15: Update #5 Released! - OOTP 15 Released! - FHM 2014: Version 1.6.19 Available! - iOOTP Baseball 2014 for iOS Available NOW! - Beyond the Sideline Football Announced! - Title Bout Championship Boxing 2.5 released!

OOTP 15 Released - Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 15 > OOTP Mods > OOTP Mods - Database Tools

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

Reply
 
LinkBack Thread Tools
Old 07-28-2009, 12:45 PM   #1 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 811
Thanks: 1
Thanked 96x in 55 posts
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.

For OOTP 15
For OOTP 14
For OOTP 13
For OOTP 11/12

Last edited by Getch; 08-25-2011 at 03:59 PM.
Getch is offline   Reply With Quote
4 thanks for this post:
attackemu (10-24-2009), BlitzburghBucco (08-18-2010), bulldog55 (12-17-2009), kq76 (10-25-2009)
Old 07-28-2009, 02:23 PM   #2 (permalink)
Minors (Triple A)
 
Join Date: Jan 2003
Posts: 209
Thanks: 3
Thanked 3x in 3 posts
Thanks Getch!
__________________
Mike Dills
Mike1 is offline   Reply With Quote
Old 07-28-2009, 02:27 PM   #3 (permalink)
Minors (Triple A)
 
Join Date: Jan 2003
Posts: 209
Thanks: 3
Thanked 3x in 3 posts
Neither of the links are working for me.
__________________
Mike Dills
Mike1 is offline   Reply With Quote
Old 07-28-2009, 03:06 PM   #4 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 811
Thanks: 1
Thanked 96x in 55 posts
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.

For OOTP 15
For OOTP 14
For OOTP 13
For OOTP 11/12
Getch is offline   Reply With Quote
Old 07-28-2009, 04:01 PM   #5 (permalink)
Minors (Triple A)
 
Join Date: Jan 2003
Posts: 209
Thanks: 3
Thanked 3x in 3 posts
Done the trick...thanks again!
__________________
Mike Dills
Mike1 is offline   Reply With Quote
Old 07-29-2009, 08:07 PM   #6 (permalink)
Hall Of Famer
 
Nutlaw's Avatar
 
Join Date: Apr 2003
Posts: 9,530
Thanks: 79
Thanked 102x in 62 posts
Thanks, Getch. These are the best. An absolute must for online leagues.
__________________
BJHL: GM of the Manhattan Crime
Occasional Contributor to The Cardinal Nation
Nutlaw is offline   Reply With Quote
Old 08-02-2009, 05:34 AM   #7 (permalink)
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,134
Blog Entries: 3
Thanks: 40
Thanked 312x in 182 posts
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 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 811
Thanks: 1
Thanked 96x in 55 posts
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.

For OOTP 15
For OOTP 14
For OOTP 13
For OOTP 11/12
Getch is offline   Reply With Quote
Old 08-03-2009, 07:51 PM   #9 (permalink)
Minors (Triple A)
 
Join Date: Jan 2003
Posts: 209
Thanks: 3
Thanked 3x in 3 posts
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 (permalink)
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,134
Blog Entries: 3
Thanks: 40
Thanked 312x in 182 posts
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
2 thanks for this post:
Afino (08-05-2009), BMW (09-12-2009)
Old 08-14-2009, 11:30 AM   #11 (permalink)
Minors (Double A)
 
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
Thanks: 1
Thanked 0x in 0 posts
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 (permalink)
All Star Starter
 
Killing Time's Avatar
 
Join Date: May 2005
Posts: 1,097
Thanks: 184
Thanked 194x in 115 posts
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 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 811
Thanks: 1
Thanked 96x in 55 posts
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.

For OOTP 15
For OOTP 14
For OOTP 13
For OOTP 11/12
Getch is offline   Reply With Quote
Old 08-15-2009, 12:53 PM   #14 (permalink)
Minors (Double A)
 
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
Thanks: 1
Thanked 0x in 0 posts
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 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 811
Thanks: 1
Thanked 96x in 55 posts
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.

For OOTP 15
For OOTP 14
For OOTP 13
For OOTP 11/12
Getch is offline   Reply With Quote
Old 08-15-2009, 01:24 PM   #16 (permalink)
Minors (Double A)
 
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
Thanks: 1
Thanked 0x in 0 posts
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 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 811
Thanks: 1
Thanked 96x in 55 posts
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.

For OOTP 15
For OOTP 14
For OOTP 13
For OOTP 11/12
Getch is offline   Reply With Quote
Old 08-16-2009, 06:00 PM   #18 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 811
Thanks: 1
Thanked 96x in 55 posts
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.

For OOTP 15
For OOTP 14
For OOTP 13
For OOTP 11/12

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 (permalink)
Minors (Double A)
 
BobDylanRH's Avatar
 
Join Date: Jun 2009
Posts: 138
Thanks: 0
Thanked 1x in 1 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.
BobDylanRH is offline   Reply With Quote
Old 08-25-2009, 11:57 AM   #20 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 811
Thanks: 1
Thanked 96x in 55 posts
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.

For OOTP 15
For OOTP 14
For OOTP 13
For OOTP 11/12
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
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 11:54 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.1
Copyright © 2013 Out of the Park Developments