Latest News: OOTP 13 Announced with Screenshots & Feature List! Pre-Order Now! - OOTP Baseball 12 Available! - iOOTP Baseball 2011 Available! - Title Bout Championship Boxing 2.5 released! - Inside the Park Baseball Patch 1.03 released, DEMO now available

Pre-Order OOTP 13, Save & Win! | OOTP 12 Off-Season Special, just $19.99!

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

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

Reply
 
LinkBack Thread Tools Display Modes
Old 08-25-2009, 01:25 PM   #21 (permalink)
Hall Of Famer
 
Afino's Avatar
 
Join Date: Sep 2008
Location: Rochester, NY
Posts: 2,729
Blog Entries: 1
Thanks: 329
Thanked 296x in 174 posts
Here's an example of something a lot of the GUBA owners have been seeing regarding pitch ratings. It seems to not separate Rating from Talent - they move in tandem without the Talent actually changing.

Roberto Martínez: Changeup Rating Increases from 4 to 5
Roberto Martínez: Changeup Talent Increases from 4 to 5

Only his rating has moved from 4 to 5 - not his talent. His talent is a 3.

Player Report for #21 Roberto Martínez
Development - Roberto Martínez



Development - Moscow Enforcers

Is it something we're doing or is it a known bug?
__________________
Quote:
Originally Posted by mgom27 View Post
It's makes the Game more funner.
GUBA: Moscow Enforcers (2014-)
CBL: St. John's Explorers (2031-)
2037 Eastern League Champs
Afino is offline   Reply With Quote
Old 08-25-2009, 01:58 PM   #22 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Here's an example of something a lot of the GUBA owners have been seeing regarding pitch ratings. It seems to not separate Rating from Talent - they move in tandem without the Talent actually changing.
You are using 3.1.0 of my utilities. 3.1.1 is when I fixed it to handle the individual pitch ratings/talents properly. Check my post on 08-16-2009 on how to properly install it to not cause some erroneous development reports.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme

Last edited by Getch; 08-25-2009 at 02:00 PM.
Getch is offline   Reply With Quote
Old 08-25-2009, 03:00 PM   #23 (permalink)
Minors (Double A)
 
Join Date: Jun 2009
Posts: 103
Thanks: 0
Thanked 0x in 0 posts
Quote:
Originally Posted by Getch View Post
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.
That fixed it. Thanks, I figured that's where the error was coming from, but I wasn't sure what values to enter.
BobDylanRH is offline   Reply With Quote
Old 08-25-2009, 10:39 PM   #24 (permalink)
All Star Starter
 
udbacker58's Avatar
 
Join Date: Apr 2007
Posts: 1,039
Thanks: 68
Thanked 64x in 46 posts
Quote:
Originally Posted by Getch View Post
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.
Okay, dumb question. I can only view 2000 files at a time and the prevRatings.txt file doesn't show up. I know it's there, because I can go directly to the link and see the text file. How can I get around this?
__________________
USBA (Commish): New Orleans Ragin' Cajuns
BLSN: Atlanta Braves: BLB (Commish) - BLHB

Interested in a MLB league? Apply to join the BLB!....
Fictional more your taste? Send me a PM and Apply to join the USBA!
udbacker58 is offline   Reply With Quote
Old 08-26-2009, 01:27 PM   #25 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Originally Posted by udbacker58 View Post
Okay, dumb question. I can only view 2000 files at a time and the prevRatings.txt file doesn't show up. I know it's there, because I can go directly to the link and see the text file. How can I get around this?
Can you reverse sort by name? If not that, just upload a blank prevRatings.txt and overwrite it. A blank one should do the trick fine.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 08-28-2009, 06:59 PM   #26 (permalink)
Minors (Rookie Ball)
 
mjdoom's Avatar
 
Join Date: May 2007
Posts: 34
Thanks: 0
Thanked 1x in 1 post
I just updated the utilities for our league and since All-Star voting has become active I went and enabled the All-Star voting utility and I've noticed one odd thing...

The utility is listing some people who are clearly SPs in the reliever list. Guys who have only started games (not a single game in relief) are being listed presumably based on the fact that they have passed the reliever IP threshold. I have double-checked and these guys *are* listed as SPs in game (so it's not like someone has their position set to MR). Is there any way I can change this so that it will only pull players who have pitched in relief for the reliever list?
mjdoom is offline   Reply With Quote
Old 08-29-2009, 11:04 AM   #27 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Originally Posted by mjdoom View Post
\ Is there any way I can change this so that it will only pull players who have pitched in relief for the reliever list?
Check your settings in the admin panel for "Minimum Games Started for Starting Pitchers" and "Minimum Innings Pitched for Starting Pitchers". If they do not meet both criteria, they will be listed as a reliever. Sounds like you set one of those values too high.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 08-29-2009, 11:21 AM   #28 (permalink)
Minors (Rookie Ball)
 
mjdoom's Avatar
 
Join Date: May 2007
Posts: 34
Thanks: 0
Thanked 1x in 1 post
Quote:
Originally Posted by Getch View Post
Check your settings in the admin panel for "Minimum Games Started for Starting Pitchers" and "Minimum Innings Pitched for Starting Pitchers". If they do not meet both criteria, they will be listed as a reliever. Sounds like you set one of those values too high.
The three specific examples I saw at first glance are one guy who got called up from AAA a month and a half into the season and two guys who injured so they haven't played that many games. For reference:

Tenzig Cubitt (callup)
Manuel Leyva (injury)
Louie Pulaski (2 injuries!)

Does this mean that I should set the starting pitcher settings very low to be able to catch guys with injuries or callups? What if we don't want those guys to be listed?

Last edited by mjdoom; 08-29-2009 at 11:22 AM.
mjdoom is offline   Reply With Quote
Old 08-29-2009, 03:02 PM   #29 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Originally Posted by mjdoom View Post
Does this mean that I should set the starting pitcher settings very low to be able to catch guys with injuries or callups? What if we don't want those guys to be listed?
OOTPOU does not show every possible pitcher that meets the criteria in the admin screen. It only takes the top 10 in ERA, top 8 in wins, etc (I forget the exact numbers). The parameters you see in the admin screen are just responsible for determining where the pitcher (or DH) is listed.

The only time the parameters would completely exclude a player is if they did not meet the minimum innings pitched for both starters and relievers.

Feel free to play around with the parameters until you get the ballots the way you want, then reset the votes.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 08-29-2009, 07:51 PM   #30 (permalink)
Minors (Rookie Ball)
 
mjdoom's Avatar
 
Join Date: May 2007
Posts: 34
Thanks: 0
Thanked 1x in 1 post
Quote:
Originally Posted by Getch View Post
OOTPOU does not show every possible pitcher that meets the criteria in the admin screen. It only takes the top 10 in ERA, top 8 in wins, etc (I forget the exact numbers). The parameters you see in the admin screen are just responsible for determining where the pitcher (or DH) is listed.

The only time the parameters would completely exclude a player is if they did not meet the minimum innings pitched for both starters and relievers.

Feel free to play around with the parameters until you get the ballots the way you want, then reset the votes.
Ok, thanks.
mjdoom is offline   Reply With Quote
Old 09-12-2009, 03:03 PM   #31 (permalink)
BMW
All Star Starter
 
BMW's Avatar
 
Join Date: May 2003
Location: New Jersey
Posts: 1,471
Thanks: 125
Thanked 491x in 204 posts
Getch, a question:

Does the HOF utility know who is currently in your HOF? (I'm asking this not knowing if the CSVs have this data).

How would the players voted in during ballot year 2009 not appear on the 2010 ballot?
BMW is offline   Reply With Quote
Old 09-14-2009, 12:28 PM   #32 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Originally Posted by BMW View Post
Getch, a question:

Does the HOF utility know who is currently in your HOF? (I'm asking this not knowing if the CSVs have this data).

How would the players voted in during ballot year 2009 not appear on the 2010 ballot?
The csv files have a column for players in the HoF. So, if a player is in the HoF in-game, I'll know it and he won't appear on the ballot any more.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Thank you for this post:
BMW (09-14-2009)
Old 09-14-2009, 01:16 PM   #33 (permalink)
BMW
All Star Starter
 
BMW's Avatar
 
Join Date: May 2003
Location: New Jersey
Posts: 1,471
Thanks: 125
Thanked 491x in 204 posts
Quote:
Originally Posted by Getch View Post
The csv files have a column for players in the HoF. So, if a player is in the HoF in-game, I'll know it and he won't appear on the ballot any more.
Excellent! Thank you very much. I honestly hadn't noticed that flag.
BMW is offline   Reply With Quote
Old 09-14-2009, 04:51 PM   #34 (permalink)
BMW
All Star Starter
 
BMW's Avatar
 
Join Date: May 2003
Location: New Jersey
Posts: 1,471
Thanks: 125
Thanked 491x in 204 posts
I was using the HOF Voting, and it sorts the numbers as strings. So 10 comes after 2.

I changed:
Code:
    foreach $vote (sort {$votes{$b} cmp $votes{$a}} keys %votes) {
To:
Code:
    foreach $vote (sort {($votes{$b}/$votesCast) cmp ($votes{$a}/$votesCast)} keys %votes) {
And that sorts it properly.

After we upgraded, we suddenly have a problem with extended characters.

Juan Iñiguez now shows up as Juan Iñiguez on all the OOTPOU pages. Any ideas on what we can do?

Thanks!
BMW is offline   Reply With Quote
Old 09-15-2009, 12:54 PM   #35 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
The number sorting thing was fixed a while back. Make sure you have the latest version.

As for the character issue, yeah. It's known. Markus changed the encoding on the csv files. I bugged him about it but haven't heard back.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 09-18-2009, 12:38 PM   #36 (permalink)
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 2,723
Thanks: 13
Thanked 255x in 119 posts
Quote:
Originally Posted by Getch View Post
As for the character issue, yeah. It's known. Markus changed the encoding on the csv files. I bugged him about it but haven't heard back.
BZ3301 for anyone who's interested. Originally submitted 18-Jun-2009. It affects all the data dumps.
__________________
StatsLab11 - PHP/MySQL based utilities for Online Leagues
Other Mods:
19th Century: Schedules, FaceGen
BBCards: 1887 Allen & Ginter, 1934 Goudey, 1988 Score, 1996 fhomess, 2005 fhomess
FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds

PEBA - Connecticut Nutmeggers
fhomess is offline   Reply With Quote
Old 09-28-2009, 06:08 PM   #37 (permalink)
BMW
All Star Starter
 
BMW's Avatar
 
Join Date: May 2003
Location: New Jersey
Posts: 1,471
Thanks: 125
Thanked 491x in 204 posts
Quote:
Originally Posted by Getch View Post
The number sorting thing was fixed a while back. Make sure you have the latest version.

As for the character issue, yeah. It's known. Markus changed the encoding on the csv files. I bugged him about it but haven't heard back.
Getch, I put this function in the Utils (it's messy as I know nothing about PERL, but it does the job for every generated name in my league right now):

Code:
sub convertAscii {
    my ($text) = @_;

        my $HEXa0;
        $HEXa0 = "a0";
        $HEXa0 =~ s/([a-fA-F0-9]{2})/chr(hex $1)/eg;
        $HEXa0 = 'Ã' . $HEXa0;

        my $HEX81;
        $HEX81 = "81";
        $HEX81 =~ s/([a-fA-F0-9]{2})/chr(hex $1)/eg;
        $HEX81 = 'Ã' . $HEX81;

        $text =~ s/$HEXa0/à/g;
        $text =~ s/á/á/g;
        $text =~ s/ã/ã/g;
        $text =~ s/é/é/g;
        $text =~ s/Ã*/í/g;
        $text =~ s/ó/ó/g;
        $text =~ s/ú/ú/g;

        $text =~ s/$HEX81/Á/g;
        $text =~ s/É/É/g;

        $text =~ s/ç/ç/g;
        $text =~ s/ñ/ñ/g;

    return $text;
}
You just need to reference it any time you are about to put a name field into the HTML (which is an awful lot of places, or course).
BMW is offline   Reply With Quote
Old 09-29-2009, 09:29 AM   #38 (permalink)
Minors (Single A)
 
Join Date: Aug 2008
Posts: 87
Thanks: 9
Thanked 0x in 0 posts
I have added personality traits to the draft utility.

Rookie Draft Report

I can send you the files that I updated if you want to include this. A lot of people in my league wanted to see this information on the utility. I don't know if others want to see it.
eodgooch is offline   Reply With Quote
Old 10-05-2009, 11:39 AM   #39 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
I'll have to make some modifications for the next OOTP patch, so I will try to add these things as well to it. Been real busy with my newborn, sorry for the delay in response.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Thank you for this post:
BMW (10-08-2009)
Old 10-08-2009, 05:08 PM   #40 (permalink)
Minors (Double A)
 
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
Thanks: 1
Thanked 0x in 0 posts
I'm getting this error: Could not open awField0.html at OOTPOU/AWAdmin.pm line 606.

when I try to enable EOY awards voting...ideas?
thickman1 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 12:37 PM.


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