|
||||
|
07-08-2009, 03:36 PM | #41 | ||||
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
There isn't a way to revert the SQL and do it again because of the way OOTP has decided to provide the data. Their method is to delete the whole table, then rebuild it completely, so once it's deleted it's lost. Quote:
Quote:
Quote:
Added to the documentation.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
||||
07-08-2009, 03:49 PM | #42 |
All Star Reserve
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
|
Awesome! Thanks. If you need help testing things out I can always throw the data on another domain so we can look at it.
__________________
DanGarion GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League PCJBL! |
07-11-2009, 06:06 PM | #43 |
All Star Reserve
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
|
How are you coming about the ratings? We've been seeing some issues with the ratings being off from what StatsLab shows and in game shows (we don't use coaches and scouts so we should only see true ratings).
We are using 1-10 for all our ratings we have a guy that shows in statslab to have Stuff Talent of 8, but in game it shows 9, and then in the CSV it shows 141. Is this right?
__________________
DanGarion GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League PCJBL! |
07-12-2009, 12:19 AM | #44 | |
All Star Starter
Join Date: Apr 2006
Posts: 1,577
|
Quote:
At this point, we don't know what that formula is or if we ever will.
__________________
GM Havana Sugar Kings, World Baseball League - 2000, 2003, 2005 WBL Champions Former GM Washburn Sea Wolves Dog Days Baseball - 1981 & 1986 Kennel Cup Champions |
|
07-12-2009, 02:39 AM | #45 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
StatsLab merely divides the 1-200 actual range by the scale that you're using. As neags says, there appear to be some cases where OOTP reports it slightly different than what dividing up the scale evenly would give based on some additional ratings. If anyone gets the exact formula from Markus, I'll happily incorporate it.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
07-12-2009, 05:56 PM | #46 | |
Hall Of Famer
Join Date: Dec 2001
Posts: 3,326
|
Hmmm, I noticed some HTML/game ratings were way off from the statslab display, for example a 10/10 in statslab shows up as 7/10 in the game and the game HTML.
Quote:
If that understanding is accurate doesn't that mean this is a significant change for the way the game displays player ratings? Last edited by Killebrew; 07-12-2009 at 06:27 PM. |
|
07-12-2009, 06:26 PM | #47 |
Hall Of Famer
Join Date: Dec 2001
Posts: 3,326
|
Hey wait a sec, isn't the actual range is 1-250? D'oh, I hope that is a typo otherwise this is pretty significant bug in StatsLab:P.
|
07-13-2009, 09:16 PM | #48 |
Hall Of Famer
Join Date: Dec 2001
Posts: 3,326
|
....
Last edited by Killebrew; 07-14-2009 at 11:21 AM. Reason: Wrong guess.... |
07-14-2009, 01:48 AM | #49 |
All Star Starter
Join Date: Apr 2007
Posts: 1,140
|
I've noticed that for some reason the Player pictures don't seem to show up in the Career Metrics for the X version, but it seems to be ok for the ones for v9.
Player Report for #47 Dion James - StatsLab for OOTPX Player Report for #26 Bud Hoffmann - StatsLab for OOTP9
__________________
Heartland Baseball League Commissioner Fictional - Stats Only - 30 years of History! HBL HOME PAGE | HBL REPORTS HOME | HBL UTILITIES HOME |
07-14-2009, 10:08 AM | #50 | |
All Star Starter
Join Date: Apr 2006
Posts: 1,577
|
Quote:
__________________
GM Havana Sugar Kings, World Baseball League - 2000, 2003, 2005 WBL Champions Former GM Washburn Sea Wolves Dog Days Baseball - 1981 & 1986 Kennel Cup Champions |
|
07-14-2009, 10:28 AM | #51 |
Global Moderator
|
And each pitch also has an effect on the L-R split for pitching as well.
__________________
This signature is intentionally blank |
07-14-2009, 12:59 PM | #52 |
Hall Of Famer
Join Date: Dec 2001
Posts: 3,326
|
Hmm, so what is the point of a dev changes app if the displayed dev does not match the game or the game HTML? You can tell there was some kind of ratings/talent movement, but that benefit seems to be nullified by the confusing numbers displayed.
|
07-14-2009, 01:19 PM | #53 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
The issues people are seeing with ratings are due to the fact that the game now combines several internal ratings to determine the displayed ratings. I wasn't aware of this when I converted the OOTP9 version of these utils to OOTPX. If you review the threads in this forum for neags' dev tracker and Getch's OOTP OU, you'll see that they have the same problems.
Your options are the following: 1. Install and use given the understanding that the ratings reported are based on the internal ratings. 2. Do not use the ratings or development tracker until it's addressed. Either way, pestering Markus and Andreas to either release the formula or export the reported ratings in the SQL dump would be helpful.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
07-14-2009, 02:25 PM | #54 | |
Hall Of Famer
Join Date: Dec 2001
Posts: 3,326
|
Quote:
|
|
07-14-2009, 04:08 PM | #55 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Updated the download file with some fixes and enhancements:
1. Player pictures should appear correctly 2. There's now a sql_file_load.php page where you can load SQL files individually if your load button is causing timeout errors. 3. Leaderboards page now has a bottom 100 option so you can see who was the biggest waste of roster space in your league. 4. Leaderboards page now has additional draft round and draft team options. 5. Fixed date issue with dates prior to 1969 and post 2039 (php limitation). 6. Fixed a team record issue on Team Index page related to data from certain older versions of OOTP. 7. Other miscelaneous fixes.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
07-14-2009, 08:47 PM | #56 | |
All Star Starter
Join Date: Apr 2007
Posts: 1,140
|
Quote:
__________________
Heartland Baseball League Commissioner Fictional - Stats Only - 30 years of History! HBL HOME PAGE | HBL REPORTS HOME | HBL UTILITIES HOME |
|
07-14-2009, 11:44 PM | #57 |
All Star Starter
Join Date: Apr 2007
Posts: 1,140
|
Just messing around with the Awards utility for the v10 utilities, when I sort by a category and then try to select/add to list, it doesn't work. I dont' get an error, it just doesn't add the player(s) to the list.
__________________
Heartland Baseball League Commissioner Fictional - Stats Only - 30 years of History! HBL HOME PAGE | HBL REPORTS HOME | HBL UTILITIES HOME |
07-15-2009, 12:02 AM | #58 | |
All Star Starter
Join Date: Apr 2007
Posts: 1,140
|
Quote:
__________________
Heartland Baseball League Commissioner Fictional - Stats Only - 30 years of History! HBL HOME PAGE | HBL REPORTS HOME | HBL UTILITIES HOME |
|
07-15-2009, 01:44 PM | #59 | |
Major Leagues
Join Date: Mar 2002
Location: Colorado
Posts: 352
|
Quote:
Dan |
|
07-15-2009, 05:11 PM | #60 |
All Star Starter
Join Date: Mar 2002
Location: Raleigh, NC
Posts: 1,262
|
I'm not seeing these - did they make it in? leaderHist.php file is showing a mod date of 7/3/09
__________________
I used to come here a lot. Now, not so much. |
Bookmarks |
|
|