StatsLab SQL Utilities for OOTPX

[snnort]

Originally Posted by snnort

Any thoughts on adding HOF voting? It's not that it's totally necessary, but since this has become the god of all OOTP Utilities and has nearly everything you could want to supplement the reporting, voting, drafting aspect of any online league... just thought it wouldn't hurt to ask.

Originally Posted by fhomess

I've thought about it. I have a partial design for it that I haven't gotten around to finishing yet. I've just not been happy with some of the considerations to this point, so I need to think on it some more.

Cool enough. I've set up StatsLab for the BCBL (a league I commish) as well as the SIMBL (a league I am in, but I help out with some behind the scenes stuff too). And owners in both leagues LOVE it.

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.

[BobDylanRH]

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

[Stu]

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?

[Stu]

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:

Warning: fopen(./cache/player_429_sim_stats_Season.html) [function.fopen]: failed to open stream: Permission denied in /home/.../blb/utilities/ootpsqlou/playerStats.php on line 995

Warning: fwrite(): supplied argument is not a valid stream resource in /home/.../blb/utilities/ootpsqlou/playerStats.php on line 996

Warning: fclose(): supplied argument is not a valid stream resource in /home/.../blb/utilities/ootpsqlou/playerStats.php on line 997

If I set the permissions to 777 it works but I obviously don't want to leave them at 777. Is there something wrong in my configuration that would be causing this?

[fhomess]

Originally Posted by snnort

OOTP has come a long way with the help of peeps like you writing utilities that become easier and easier to update.

Thank you.

You're welcome.

Originally Posted by BobDylanRH

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

Nothing's changed in the patch with the Win Shares utility. I'll look into this some more.

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.

Originally Posted by Stu

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?

Yeah, actually you could do that. Upload the end of season SQL files, then run the season metrics for each season. Rinse and repeat for each year. This'll work as long as those backups still spit out all the necessary data.

Originally Posted by Stu

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:

If I set the permissions to 777 it works but I obviously don't want to leave them at 777. Is there something wrong in my configuration that would be causing this?

Not in your StatsLab config, that's just installing files on your server and setting up information so it knows how to access the data. However, it has been my experience that not all server configurations are as flexible as others. It may be that on your server, you need to give 757 or 777 permissions to get it to write those files in the cache folder.

[BobDylanRH]

Originally Posted by fhomess

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.

I ran it a few times. The conversion tool says the tables were removed and to run player development again. But it doesn't seem to fix my whacky reports.

[fhomess]

Originally Posted by BobDylanRH

I ran it a few times. The conversion tool says the tables were removed and to run player development again. But it doesn't seem to fix my whacky reports.

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.

[MrWorkrate]

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?

[fhomess]

Originally Posted by MrWorkrate

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?

The ReadMe has a handy table in the appendix that tells you which SQL tables are needed for each utility. For development, you'll see that the following is checked:
leagues
teams
players
players_batting
players_fielding
players_pitching

[BobDylanRH]

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.

[fhomess]

Originally Posted by BobDylanRH

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.

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.

[Stu]

Originally Posted by Stu

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?

For anybody who is interested I was able to run the season metrics for all but the first 3 years of my league. I had all my old backups so just imported the backup from before the World Series of each year as if it was an OOTP 9 league. This worked for league files from OOTP 2007, 8 and 9.

I wasn't able to import the first 3 seasons because I can't find the backups.

[satchel]

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.

[fhomess]

Originally Posted by satchel

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.

PM Sent.

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.

[snnort]

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.

[fhomess]

Originally Posted by snnort

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.

I think your proposed plan of adding a round and picking scrubs for the teams that don't have sandwich picks is the best plan in the current version.

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.

[Recte44]

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?

[snnort]

Originally Posted by Recte44

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?

First place I would check is the link "SQL Files" from the Admin section... and make sure that all the files are up-to-date...meaning... they should all basically have the time/date stamp within a few minutes of one another... OR at least the important ones for the "last sim" utility... which is basically any SQL file that has the word "game" in it.

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.

[Recte44]

They are all current files.

I imported once, then I imported each individually. No change.

[fhomess]

Originally Posted by Recte44

They are all current files.

I imported once, then I imported each individually. No change.

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.