|
||||
|
09-01-2009, 12:52 AM | #121 | ||
Minors (Triple A)
Join Date: Apr 2004
Posts: 272
|
Quote:
Quote:
The HOF voting would be just icing on an already very yummy cake. Those divisional race graphs... they used to have those on ESPN's site for MLB and I used to create them using MS Excel for an OOTP league I helped with back in 2003. That was a lot of work entering the data by keyboard after every sim. Nice to see something like that implimented using data dumps. OOTP has come a long way with the help of peeps like you writing utilities that become easier and easier to update. Thank you. |
||
09-01-2009, 02:09 AM | #122 |
Minors (Double A)
Join Date: Jun 2009
Posts: 149
|
With the patch installed, I'm getting some whacky player development. Kind of need to look at it yourself: Development Tracker - StatsLab for OOTPX
Also a string of errors running the win shares utilities: Warning: Division by zero in /home/.../forum/statslab/ootpsqlou/winshares.php on line 1118 |
09-01-2009, 07:51 AM | #123 |
All Star Starter
Join Date: Dec 2005
Posts: 1,255
|
Is there any way to retroactively run the season metrics (namely OPS+ and ERA+) if we have a backup of every end of season file. So if I restored year 1 ran the metrics, restored year 2 ran the metrics, would it work or screw stuff up?
__________________
Brewers League Baseball |
09-01-2009, 08:07 AM | #124 | |
All Star Starter
Join Date: Dec 2005
Posts: 1,255
|
Also I'm still getting strange permission issues. All folders are currently set to 755 but anytime it needs to write a file I get an error. As an example, I get this when trying to view a players game logs:
Quote:
__________________
Brewers League Baseball |
|
09-01-2009, 11:41 AM | #125 | ||||
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
Quote:
As for development, it looks like you didn't run the conversion after installing the patch. There was another problem with the development getting GB% and Knucklecurve Talent confused. I've fixed that and now re-uploaded the patch. The conversion will need to be rerun. Quote:
Quote:
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
||||
09-01-2009, 01:47 PM | #126 | |
Minors (Double A)
Join Date: Jun 2009
Posts: 149
|
Quote:
|
|
09-02-2009, 12:01 AM | #127 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
FYI to everyone else, we got this fixed via PM. If you're running into the same problem, it could be because you ran development without running the conversion after installing the patch.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
09-02-2009, 12:03 PM | #128 |
All Star Starter
Join Date: Mar 2002
Location: Raleigh, NC
Posts: 1,262
|
I would have PMed this but I figured this was good info for others.
If you're in the offseason and just updating development, which SQL files should you upload?
__________________
I used to come here a lot. Now, not so much. |
09-02-2009, 12:34 PM | #129 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
leagues teams players players_batting players_fielding players_pitching
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
|
09-02-2009, 04:36 PM | #130 |
Minors (Double A)
Join Date: Jun 2009
Posts: 149
|
Small issue here...
The last sim tool doesn't show the inning by inning tallies. And it doesn't pull up any stats for pitchers in any of the last sim statistic pages. Not a big deal, so throw this on the bottom of your support list, fhomess. |
09-02-2009, 04:49 PM | #131 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Make sure you've loaded the latest games_score and players_game_pitching_stats SQL files for your league. You can verify the load date of all your SQL files on the SQL File Load page accessible from the admin page of StatsLab.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
09-02-2009, 05:36 PM | #132 | |
All Star Starter
Join Date: Dec 2005
Posts: 1,255
|
Quote:
I wasn't able to import the first 3 seasons because I can't find the backups.
__________________
Brewers League Baseball |
|
09-04-2009, 12:56 PM | #133 |
Hall Of Famer
Join Date: Apr 2002
Location: Ft Smith AR
Posts: 2,681
|
In the Jamaica League, our season just ended, and I put up Awards ballots, and for the Outstanding Batter awards candidates, several of the batters' statistics are doubled. They have two times the number of all of their statistics: games, at-bats, RBI, everything. This is only the case for about half of the batters on the ballot, and the half who are doubled are the ones who had the highest totals, going in (that is, before the doubling).
This doubling has taken place in both sub-leagues. The doubling has not occurred in any other awards categories. Last edited by satchel; 09-04-2009 at 12:58 PM. |
09-04-2009, 01:09 PM | #134 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
EDIT: If you split your SQL files before loading them, do be careful you don't load any of the split files more than once. The SQL dump doesn't prevent duplicate rows from being created in some tables since there are no primary keys defined in the table definition.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. Last edited by fhomess; 09-04-2009 at 04:19 PM. |
|
09-10-2009, 01:03 PM | #135 |
Minors (Triple A)
Join Date: Apr 2004
Posts: 272
|
Sandwich picks (between rounds 1 and 2)
How should this be handled in league that use the new FA Compensation option in OOTP X... using the StatsLab Draft Utility?
My thought was to treat the "sandwich" round as round 2 and move each round after that down one (so round 3 in the utility would actually be round 2 in the OOTP X game... and so on). In the case of the league I commish... we have less sandwich picks total, than we have teams... so all the sandwich picks fit into one round. The extra picks at the end of the round will just be drafting the worst players of the draft as fillers so that we can move to the next round. Fhomess, is this the best way to handle this kind of situation AND do you (or anyone else in this thread) see any possible hang ups? In a possible future patch.... it would be cool if you could have the option when assigning picks to each round, of choosing to not list a team and then move it to the next round. OR even better would be if you could simply choose a toggle for the sandwich pick round to be active or not (between round 1 and 2) and then choose how many picks, exactly, to have in that round. |
09-10-2009, 02:54 PM | #136 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
I have a second patch in the works which includes the ability to mark picks to skip over. This lets you have the flexibility to create a sandwich pick round with less picks than the number of teams in your league, but also allows you to impose sanctions on teams by skipping any pick in any round. You could even create additional sandwich pick rounds later in the same draft if your league has custom FA compensation rules. If you're interested in beta testing this patch, I'll send you a link where you can download it. Just shoot me a PM. The patch will also contain the ability to display fielding stats, career metrics, and season metrics on the leaderboards pages.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. Last edited by fhomess; 09-10-2009 at 02:59 PM. |
|
09-10-2009, 03:35 PM | #137 |
Global Moderator
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,754
|
I just loaded all my SQL files, and the date at the top left of the page is the current game date, but on "Last Sim" it shows the boxscores for the sim before this current one.
Any ideas?
__________________
Matt Rectenwald Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW) |
09-10-2009, 04:25 PM | #138 | |
Minors (Triple A)
Join Date: Apr 2004
Posts: 272
|
Quote:
For you the link to see those files listed is here: http://mbwba.whsites.net/ootpsqlou/sql_file_load.php Being that I don't have admin access to your StatsLab... I can't view that page. Last edited by snnort; 09-10-2009 at 04:30 PM. |
|
09-10-2009, 04:46 PM | #139 |
Global Moderator
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,754
|
They are all current files.
I imported once, then I imported each individually. No change.
__________________
Matt Rectenwald Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW) |
09-10-2009, 06:28 PM | #140 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
The utility stores these pages in the cache folder so they can be accessed again without hitting the database or taking the time to recreate a large page. If the page exists already in the cache, then the util checks the date/timestamp and compares it to the last SQL file load. If it's older than the file load, it should create the page anew. The utility is also supposed to clear out the cache folder of these pages when a file load is performed or the last sim settings are saved from the last sim admin page. If it's not getting cleared out, then there are permissions that aren't configured to allow it. I'm not sure why it wouldn't still create the new page, though, if the SQL load has happened recently.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
Bookmarks |
|
|