StatsLab13

[MogulChamp]

Originally Posted by fhomess

I've not seen it fail to import the draft order properly or the issue you report. If you PM me with commish access to your install, I'll take a look.

Sent

[MogulChamp]

Fixed it. For some reason I had to enable draft timer

[fhomess]

Originally Posted by MogulChamp

Fixed it. For some reason I had to enable draft timer

Ah, thanks for letting me know. I do recommend upgrading to 3.0.9. There are some draft fixes in between what you've got and what's posted there, although nothing related to what you described here.

[congotim]

When trying to install StatsLab, no matter what I put in the config.txt file, I get the following error:

ERROR: dbopen.php file not found in SQL upload directory. Please create this file based on dbopen.php.sample.
After doing so, return to this page.

I am certain the I have the dbopen.php file in there. Any ideas what I could be missing?

[fhomess]

If you the contents of config.txt are correct and the file is there, the only other possible problem is permissions to access dbopen.php.

[congotim]

Originally Posted by fhomess

If you the contents of config.txt are correct and the file is there, the only other possible problem is permissions to access dbopen.php.

I am DEFINITELY missing somethings here. What should the two files (config and dbopen) look like? I am 99.9% sure that the dbopen file is not my issue... I must have the config.txt file wrong, but it says to give the path to the installation directory. How does anything know where the db folder is?

[congotim]

Originally Posted by congotim

I am DEFINITELY missing somethings here. What should the two files (config and dbopen) look like? I am 99.9% sure that the dbopen file is not my issue... I must have the config.txt file wrong, but it says to give the path to the installation directory. How does anything know where the db folder is?

As usual, as soon as I ask for help, I figure out the problem. New problem, though... It won't let me sign in with any of the 3 commish accounts using the password "baseball" any ideas?

[congotim]

Originally Posted by dangarion

Ok I'm ignoring that.

I was getting the ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table)


Interesting, I went ahead and clicked on "Admin" from the validator and it said the db wasn't loaded and to click on a link to load it. I did that and it actually was able to load the whole db... with no timeouts (remember how the old version used to do that???). And it looks like I can login now.

Wow... Statslab has really progressed from the last time I was able to use it with our old league... Amazing.

*sigh* Once again I find the fix after wasting people's time posting... The quoted response here fixed it for me

[congotim]

I, for the life of me, cannot figure out how to create a widget for something as simple as standings. Can anyone offer any hints on this?

[dangarion]

I'm not sure what happened but our Statslab stopped updating stats, even though imports seem to go fine...

I'm assuming the problem now is that the run_development.php action is taking too much time on Dreamhost.

[Thu Apr 25 09:11:08 2013] [error] [client 75.85.84.98] Premature end of script headers: run_development.php, referer: Peanuts and Cracker Jack Baseball League

[fhomess]

Originally Posted by congotim

I, for the life of me, cannot figure out how to create a widget for something as simple as standings. Can anyone offer any hints on this?

Here's a sample for standings:

/widget.php?show=standings&league_id=100&sub_league=0&division=1

Originally Posted by dangarion

I'm not sure what happened but our Statslab stopped updating stats, even though imports seem to go fine...

I'm assuming the problem now is that the run_development.php action is taking too much time on Dreamhost.

[Thu Apr 25 09:11:08 2013] [error] [client 75.85.84.98] Premature end of script headers: run_development.php, referer: Peanuts and Cracker Jack Baseball League

It sounds like your import didn't quite work. The other pages of StatsLab simply rely on the database and the development script won't have any affect on whether or not you get new data on the last sim pages.

[dangarion]

Originally Posted by fhomess

Here's a sample for standings:

/widget.php?show=standings&league_id=100&sub_league=0&division=1

It sounds like your import didn't quite work. The other pages of StatsLab simply rely on the database and the development script won't have any affect on whether or not you get new data on the last sim pages.

Well great. This has been going on for a couple imports now. The player pages aren't showing any new statistics.

I went ahead and repaired and optimized the database and ran the development report again. It is still showing out of date and not working. Should I just delete all the data in player_developement?

[fhomess]

I'd be happy to take a look at it before you try that if you like.

[congotim]

Originally Posted by fhomess

Here's a sample for standings:

/widget.php?show=standings&league_id=100&sub_league=0&division=1

That works and seems so simple... Yet, if I take out "&division=1" I thought it would show the whole sub league, but no such luck. Where is the flaw in my logic? Sorry for taking up so much time with my rookie questions, just trying to understand!

[fhomess]

Nope, it just doesn't work that way... specifying a division is required.

[congotim]

Originally Posted by fhomess

Nope, it just doesn't work that way... specifying a division is required.

Bummer. Is there a way to pull the top performers out? Maybe one for top performing hitters and one for top performing pitchers?

[arca]

Hello, does statlab function for offline game, or quickstart game? Is there a stats software to analyze the stats of our game when you just play quickstart game and non online game? Thank you for answer

[fhomess]

Originally Posted by congotim

Bummer. Is there a way to pull the top performers out? Maybe one for top performing hitters and one for top performing pitchers?

Can you clarify why you need to have the division not specified? If you're in a league with only 1 division, there is still a division identifier for the 1 division that exists. I can see a desire to add a wild card standings option. What other use case is there that you're looking for.

As for top performers, there's always a question of exactly what you mean by that. Here's a sample of a stat leaderboard:

widget.php?league_id=100&sub_league=0&stat=vorp&topX=5

In this case, the sub_league is optional, so you could report on the entire league if you want. Use "pvorp" for pitcher VORP if that's what you're going for.

Originally Posted by arca

Hello, does statlab function for offline game, or quickstart game? Is there a stats software to analyze the stats of our game when you just play quickstart game and non online game? Thank you for answer

There's no difference between a quickstart game and any other type of OOTP game once the game has begun.

As for running StatsLab for a non-online league, yes this is possible, however it needs to run in the context of a PHP website with MySQL. For example, it's possible to set up an Apache server on your PC and run PHP in there. You can then run StatsLab locally for any of your leagues. This is one of the ways in which I test StatsLab, and there are tutorials online on how to set up Apache with PHP and MySQL for either PC or Mac.

As for tools other than StatsLab to analyze your league, there is OOTP:OU, which also requires a website context, and there was a tool a few versions ago that would read the dat files directly. However, I don't recall seeing a recent update to it.

[congotim]

Originally Posted by fhomess

Can you clarify why you need to have the division not specified? If you're in a league with only 1 division, there is still a division identifier for the 1 division that exists. I can see a desire to add a wild card standings option. What other use case is there that you're looking for.

As for top performers, there's always a question of exactly what you mean by that. Here's a sample of a stat leaderboard:

widget.php?league_id=100&sub_league=0&stat=vorp&topX=5

In this case, the sub_league is optional, so you could report on the entire league if you want. Use "pvorp" for pitcher VORP if that's what you're going for.

The reason for not having the division specified was that i wanted to show the full standings for the entire league, if possible. I am using this on the front page of my home screen (Championship League Baseball | Where the Winning Doesn't Come Easy). Right now I have not been able to find a wordpress widget that displays php for me so I am using iFrames which I hate... That said, I would love to be able to use one or two iFrames rather than 6.

As for the stats, I like being able to list guys by VORP. Is there any way to get it to show the stats too or am I out of luck? One final question that may limit firther questions: Is there a list of usable functions for the widgets.php page so I can tinker some on my own. I have no idea what does or doesnt work other than what you have showed me so far

[fhomess]

Widgets are intended to be a quick, modular way to get some information about your league to your home page. The modularity allows for flexibility, such as putting it behind a jQuery tabs, jQuery accordion, or something similar.

There isn't a way to specify additional stats to display with a player leaderboard widget.

Anyway, here is some documenation that should help:

OnDemand Widgets
On‐demand widgets allow you to call some code to display snippets of data on your website outside of StatsLab. The script that creates them is widget.php, and by including a link to the widget.php file with the appropriate parameters defined, you can get a widget to display on your website that will automatically display the most recent stats after every SQL upload.

The following parameters can be applied to widgets.php to generate a widget:

• show: The “show” parameter defines what type of widget you want to display. The following options are available:
  • leaders - By setting it to ‘leaders’, it’ll display the top teams in each division in an unnumbered list format.
  • standings - By setting it to ‘standings’, you can get the divisional standings for any division in your league (with additional parameters).
  • draftList (need version 3.0.10) - By setting it to 'draftList', you can get it to display the progress of your StatsLab draft. This has additional parameters:
    • lastX - tells it how many of the most recent picks to display
    • nextX - tells it how many of the upcoming picks to display
  • potw - Will display the current player of the week for the sub league specified. Includes player photo, name, team, and some basic stats.
  • botm - Will display the current batter of the month for the sub league specified. Includes player photo, name, team, and some basic stats.
  • potm - Will display the current pitcher of the month for the sub league specified. Includes player photo, name, team, and some basic stats.
  • rotm - Will display the current rookie of the month for the sub league specified. Includes player photo, name, team, and some basic stats.
  • Anything else, including omitting this parameter, will result in a listing of the top players in a specific stat (stat must be specified).
• league_id: Specifies the league that you wish to display the widget for. Will default to StatsLab’s primary league if omitted.
• sub_league: Specifies the sub‐league you wish to display. Use the sub league’s ID number or abbreviation (if unique). If omitted, leagues will be combined. This parameter must be specified to display a division’s standings.
• division: Specifies the division you wish to display. Use the division ID as the value, and it must be combined with the sub_league parameter. It has no effect on player stat widgets.
• topX: For player stat widgets, this parameter defines how many players to display. By default, the top 3 players will be included.
• stat: For player stat widgets, this parameter defines which stat to display the top X of.

The following stats are available for player stats widgets (note that this list is more extensive than for static widgets):
Batting Stats: AB, H, 2B, 3B, HR, RBI, R, SB, CS, BB, K, SF, SH, IBB, HP, GDP, PA, AVG, OBP, SLG, OPS, wOBA, VORP
Pitching Stats: W, L, SV, IP, K, BB, R, ER, G, GS, HP, HA, BF, GB, FB, HRA, BK, GF, QS, CG, SHO, HLD, ERA, WHIP, VORP

To include any of the above stats, set the stat parameter equal to the lowercase version of the stat (e.g. avg=batting average), with the following exceptions:
K, BB, R, G, GS, HP, and VORP for pitchers should be preceded with a “p” to differentiate them from the batter stat version (e.g.: k=batting K’s, pk=pitching K’s).
Use “s” for SV.

Examples:

• widget.php?stat=h&topX=7&sub_league=NL – Will display the top 7 NL leaders in hits.
• widget.php?stat=pk&sub_league=AL – Will display the top 3 AL leaders in pitching strikeouts
• widget.php?show=leaders – Will display the division leading teams in each division.
• widget.php?show=standings&division=1&sub_league=1 – Will display the standings for sub_league 1, division 1 (in my test case, the NL Central).
• widget.php?stat=ops&topX=10 – Will display the top 10 batters in OPS across all subleagues (e.g. All MLB, rather than just AL or NL).
• widget.php?show=draftList&league_id=100&lastX=5&ne xtX=5 - Will display the 5 most recent picks, and the 5 upcoming ones
• widget.php?show=potw&league_id=100&sub_league=0 - Will display the Player of the Week for sub league 0

You can test your on‐demand widget out in your browser before adding the code to call it to your website. If you wrap it appropriately, you can do some nice things with CSS for displaying it.

Widget CSS
wdgT – Applied to <table> tags
wdgH – Applied to <tr> tags contained inside <thead> tags.
wdgH_l – Applied to <td> tags inside <thead> tags that might require different alignment.
wdg1, wdg2 – Applied to alternating <tr> tags
wdg1_l, wdg2_l – Applied to alternating rows <td> tags that might require different alignment
wdgUL – Applied to <ul> tag in division leaders widget
wdgLI – Applied to <li> tags in division leaders widget