|
|||||||
| OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome |
![]() |
|
|
LinkBack | Thread Tools | Display Modes |
|
|
#21 (permalink) |
|
Hall Of Famer
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? |
|
|
|
|
|
#22 (permalink) | |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
Quote:
__________________
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. |
|
|
|
|
|
|
#24 (permalink) | |
|
All Star Starter
Join Date: Apr 2007
Posts: 1,039
Thanks: 68
Thanked 64x in 46 posts
|
Quote:
__________________
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! |
|
|
|
|
|
|
#25 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
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 |
|
|
|
|
|
#26 (permalink) |
|
Minors (Rookie Ball)
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? |
|
|
|
|
|
#27 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
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 |
|
|
|
|
|
#28 (permalink) | |
|
Minors (Rookie Ball)
Join Date: May 2007
Posts: 34
Thanks: 0
Thanked 1x in 1 post
|
Quote:
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. |
|
|
|
|
|
|
#29 (permalink) | |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
Quote:
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 |
|
|
|
|
|
|
#30 (permalink) | |
|
Minors (Rookie Ball)
Join Date: May 2007
Posts: 34
Thanks: 0
Thanked 1x in 1 post
|
Quote:
|
|
|
|
|
|
|
#31 (permalink) |
|
All Star Starter
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? |
|
|
|
|
|
#32 (permalink) |
|
All Star Reserve
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
|
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 |
|
|
|
| Thank you for this post: | BMW (09-14-2009) |
|
|
#34 (permalink) |
|
All Star Starter
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) {
Code:
foreach $vote (sort {($votes{$b}/$votesCast) cmp ($votes{$a}/$votesCast)} keys %votes) {
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! |
|
|
|
|
|
#35 (permalink) |
|
All Star Reserve
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 |
|
|
|
|
|
#36 (permalink) |
|
Hall Of Famer
Join Date: Nov 2002
Posts: 2,723
Thanks: 13
Thanked 255x in 119 posts
|
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 |
|
|
|
|
|
#37 (permalink) | |
|
All Star Starter
Join Date: May 2003
Location: New Jersey
Posts: 1,471
Thanks: 125
Thanked 491x in 204 posts
|
Quote:
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;
}
|
|
|
|
|
|
|
#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. |
|
|
|
|
|
#39 (permalink) |
|
All Star Reserve
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 |
|
|
|
| Thank you for this post: | BMW (10-08-2009) |
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|