StatsLab11

[fhomess]

StatsLab11 Is Now Released!

Download it here
Latest Patch: Patch 2.1.1 (You'll need the full file, too)
Fidel's Install Tutorial: http://www.ootpdevelopments.com/boar...sion-11-a.html
Setting Up the SQL Dump: StatsLab Upload Procedure

Donate to StatsLab - StatsLab is free to use. Donations are not required, but greatly appreciated.

StatsLab is a set of web pages/utilities for use with online leagues, and requires PHP and MySQL on a webserver. The ReadMe includes instructions for a new StatsLab install as well as how to upgrade from StatsLab for OOTPX if you're running that.

Features:
- Last Sim module with adjustable date ranges of player stats, team stats, and graphs. Playoff odds, top performances, and more.
- All-Star, End-of-Season Awards, and Hall of Fame voting modules
- Draft Module
- Development Tracker
- Front office module including trade block, payroll projections, and projected FA reports
- Export Tracker
- Career Metrics module containing player and team pages as well as filterable leaderboards pages
- Widgets that can be used to put stats on your online league's home page
- Quite a bit more...

Improvements and Updates for StatsLab11:
- New Career Graphs page in the Career Metrics section
- Last Sim Graphs page has been overhauled.
- Team Stats page will show head-to-head record when looking at leagues or divisions
- You can now optionally have Playoff Odds calculations that "regress to mean", reducing early season sample size issues
- Direct widget calls provide more flexible widget options for your league home page
- New table view of Hall of Fame inductees
- Player page will underline league leading stats
- More filter options on player leaderboards page
- Some minor enhancements to the draft module (including ability to view amateur stats without feeder leagues enabled)
- StatsLab settings now stored in the DB rather than flat files on your server
- Plenty o' bug fixes

Once again, many thanks to John and the rest of the PEBA for beta testing all things StatsLab!

I'm sure it's possible that some things have been missed, so questions/bug reports/enhancement suggestions and the like are all welcome. The best way to get a response from me is to PM me on these forums, although there's enough StatsLab experience floating around the OOTP community that posting in this thread may get your question answered by a forum member faster than I will get to it.

AFAIK, StatsLab11 is compatible with OOTPX (not OOTP9, though).
StatsLab for OOPX Thread

v2.0.2 Added:
- Fixed memory leak on admin page
- Updated server SQL load file for advanced users
- Fixed OPS display on eos awards voting ballot
- Fixed development tracker
- Fixed calculated sim length
- Fixed sorting on draft warroom page
- Improved performance on auto picks in draft module
- Added position filter to projected free agents page
- Fixed various errors on last sim graphs page
- Fixed issue with Ink Scores/HOF Standards on players leaderboard page
- Fixed issue with voting modules disappearing from nav bar if voting is disabled.

v2.1.1 File Last Updated: 1/22/2011
- New Sim Preview page available in Last Sim module, including the following:
- - Noteworthy upcoming matchups
- - Active team win/loss streaks
- - Active player streaks (pitcher wins, batter hits, etc)
- - Hot/Cold lists
- - Listing of players on DL who are expected back in the next sim
- - Triple crown contenders (after 1/3 of the season is complete)
- - Players with chance to hit .400 (after 1/3 of the season is complete)
- Team stats page in Last Sim module now has game splits section to display inning-by-inning scoring and record when winning, losing, or tied after X innings.
- Team stats page in Last Sim module now has Starter and Reliever splits under pitching stats.
- Player stats page in Last Sim module now has ability to display stats accrued versus a single opponent
- Player stats page will now display strength of opposition for pitchers
- Ground balls, fly balls, and ground ball percentage added to player leaderboards
- The Draft admin page now lets you define draft rounds as supplemental rounds (just a display change, and you'll need to schedule an additional round)
- When the draft timer is on, a floating sidebar will now display the time remaining till the next pick is due, and will scroll with your screen
- The draft war room can now be filtered depending on if a player is on your team's draft list or not.
- New widget that can be used to display the last X and/or next X picks in your draft
- - Format is "widget.php?show=draftList&league_id=100&lastX =3&n extX=5"
- Several draft fixes, notably one where the entire draft would uncontrollably auto draft itself even if told not to.
- Fixed issue with pitcher innings in team history pitching records
- Fixed team stats page to show only regular season games when "Season" option is selected
- Various other miscellaneous enhancements and fixes

[Corsairs]

If you're the commissioner of an online league, you simply must put this amazing tool into play. StatsLab was already the preeminent utility suite for online OOTP leagues. With this new release, fhomess has (literally) turned it up to "11". It's never been easier to conduct a draft through StatsLab; every little touch (like user-customizable auto-refreshing of the Draft Results page) makes running things a breeze. Owners now have a plethora of new information at their fingertips. Old menus like the Projected Free Agents page have had new life breathed into them with little touches like the addition of current-year stats, making it easier to determine whom you'd like to target in the upcoming offseason. There's even fun little additions like tons of new Stats of the Day; you'll lose all kinds of time discovering all kinds of little factoids you never knew about your league.

Running an online league without StatsLab is something I could never dream of at this point. Simply put, it's an invaluable tool. Grab it, enjoy it, reap the praise from your owners. Your league will be a better place for it.

[dangarion]

Will this still work with the special shell side import file you sent me?

Originally Posted by fhomess

StatsLab11 Is Now Released!

Download it here

StatsLab is a set of web pages/utilities for use with online leagues, and requires PHP and MySQL on a webserver. The ReadMe includes instructions for a new StatsLab install as well as how to upgrade from StatsLab for OOTPX if you're running that.

Features:
- Last Sim module with adjustable date ranges of player stats, team stats, and graphs. Playoff odds, top performances, and more.
- All-Star, End-of-Season Awards, and Hall of Fame voting modules
- Draft Module
- Development Tracker
- Front office module including trade block, payroll projections, and projected FA reports
- Export Tracker
- Career Metrics module containing player and team pages as well as filterable leaderboards pages
- Widgets that can be used to put stats on your online league's home page
- Quite a bit more...

Improvements and Updates for StatsLab11:
- New Career Graphs page in the Career Metrics section
- Last Sim Graphs page has been overhauled.
- Team Stats page will show head-to-head record when looking at leagues or divisions
- You can now optionally have Playoff Odds calculations that "regress to mean", reducing early season sample size issues
- Direct widget calls provide more flexible widget options for your league home page
- New table view of Hall of Fame inductees
- Player page will underline league leading stats
- More filter options on player leaderboards page
- Some minor enhancements to the draft module (including ability to view amateur stats without feeder leagues enabled)
- StatsLab settings now stored in the DB rather than flat files on your server
- Plenty o' bug fixes

Once again, many thanks to John and the rest of the PEBA for beta testing all things StatsLab!

I'm sure it's possible that some things have been missed, so questions/bug reports/enhancement suggestions and the like are all welcome. The best way to get a response from me is to PM me on these forums, although there's enough StatsLab experience floating around the OOTP community that posting in this thread may get your question answered by a forum member faster than I will get to it.

AFAIK, StatsLab11 is compatible with OOTPX (not OOTP9, though).
StatsLab for OOPX Thread

[fhomess]

Originally Posted by dangarion

Will this still work with the special shell side import file you sent me?

It should... If I'm remembering correctly, it's included, albeit undocumented.

[dangarion]

Everything is working great now.

I think I've found a bug in the stats showing on the Awards voting page. The OPS seems a little low for all the players.

I have a guy that has a .431 OBP and a .597 slugging but his OPS shows up as .431.

His OPS shows correctly on his metrics page though.

It should be 1.027

It appears to just being showing the wOBA as the OPS, because the same number is repeated under wOBA.

[MrWorkrate]

Not sure if I did something wrong - my development is showing "no development history" across the board and the status for all the leagues says "out of date", but I had development before I went from StatsLab OOTPX to StatsLab OOTP11.

It just seems like it's not finding the table/info where the development was. I installed in a different directory (as per the document) - could it be getting confused somewhere along the line to a folder location or table in the DB?

[Sabermetric Baseball]

I'm trying to use StatsLab for the Inaugural Draft in my online league. Very slow and getting timeouts over 90% of the time. Also, when teams try to make picks, sometimes the page will load but their pick won't get in. I have a very fast web host, and loading the files was almost immediate. Any suggestions?

[fhomess]

Originally Posted by dangarion

It appears to just being showing the wOBA as the OPS, because the same number is repeated under wOBA.

Originally Posted by MrWorkrate

Not sure if I did something wrong - my development is showing "no development history" across the board and the status for all the leagues says "out of date", but I had development before I went from StatsLab OOTPX to StatsLab OOTP11.

Both should be fixed now (you'll need to re-run dev). Also, make sure you've checked some ratings to track in the dev admin page.

[fhomess]

Originally Posted by Sabermetric Baseball

I'm trying to use StatsLab for the Inaugural Draft in my online league. Very slow and getting timeouts over 90% of the time. Also, when teams try to make picks, sometimes the page will load but their pick won't get in. I have a very fast web host, and loading the files was almost immediate. Any suggestions?

PM me a link to your StatsLab install and a working login.

[Sabermetric Baseball]

Originally Posted by fhomess

PM me a link to your StatsLab install and a working login.

I sent you a PM with the information.

Thanks, this goes well above and beyond expectations!

[GMGOD]

Thanks Frank Homes and the guys in PEBA for your talents and efforts in offering this great and fun tool to the OOTP community.

We have enjoyed StatsLab in the SIMBL since being turned onto it by Jamey Carter (snort), the Commish of the BCHBL. It's the ultimate tool for any statsfreak and/or baseball fan.

You rule Frank!

Thanks again.

[John P. Yuda]

Frank,

For those of us moving directly from OOTP9 to 11, is there a direct upgrade or will I need to upgrade to the statslab for X first?

Thanks

[snnort]

Frank... in the SIMBL we are on April 1st. The draft pool was JUST released (to the day)... We set up the ammy draft in StatsLab and when the first team goes to pick any player this message comes up:

"player not draft eligible"

Then if I try to autopick to see if any player is eligible I get this:

"no players remaining in draft pool"

Have you seen this issue? Know the fix?

[Solonor]

After I upgraded, I'm getting a lot of "mysql_num_rows(): supplied argument is not a valid MySQL result resource" errors when I try to run any metrics that include things like Win Shares, HoF Standards...and just now I got it on the Stat of the Day page.

The Stat of the Day error actually had two lines that said that, but the second one included a message "No seasons completed". It was trying to calculate "Highest Number Of Runs Scored Relative to League (Top 25 Teams, SD is number of standard deviations better than league average)".

All my SQL files loaded without error except for coaches.

Any clues?

EDIT: I just looked at the Records Watch page. It's a mess. On the Seasonal side of the page, it shows the leader correctly, but everyone underneath it has 0 for Current and Projected. Everything on the Career side has the projected total showing up under both Years and Projected.

[fhomess]

Originally Posted by John P. Yuda

Frank,

For those of us moving directly from OOTP9 to 11, is there a direct upgrade or will I need to upgrade to the statslab for X first?

If you're using the development tracker, you'll need to upgrade to X first. If not, I think you'll be ok making the jump directly, but I haven't tried it myself and don't remember if there was any other tool that required a conversion.

Originally Posted by snnort

Frank... in the SIMBL we are on April 1st. The draft pool was JUST released (to the day)... We set up the ammy draft in StatsLab and when the first team goes to pick any player this message comes up:

"player not draft eligible"

Then if I try to autopick to see if any player is eligible I get this:

"no players remaining in draft pool"

Have you seen this issue? Know the fix?

I've seen this happen when you've turned on the draft timer and the util is trying to auto pick but there aren't any players available in the pool. I thought I had fixed that, and it doesn't sound quite like what you're describing anyway. Shoot me a PM with a link to your install and commish credentials to log in to StatsLab and I'll take a look.

Originally Posted by Solonor

After I upgraded, I'm getting a lot of "mysql_num_rows(): supplied argument is not a valid MySQL result resource" errors when I try to run any metrics that include things like Win Shares, HoF Standards...and just now I got it on the Stat of the Day page.

The Stat of the Day error actually had two lines that said that, but the second one included a message "No seasons completed". It was trying to calculate "Highest Number Of Runs Scored Relative to League (Top 25 Teams, SD is number of standard deviations better than league average)".

All my SQL files loaded without error except for coaches.

Any clues?

EDIT: I just looked at the Records Watch page. It's a mess. On the Seasonal side of the page, it shows the leader correctly, but everyone underneath it has 0 for Current and Projected. Everything on the Career side has the projected total showing up under both Years and Projected.

Generally speaking, these errors are the result of not having all the proper SQL tables loaded in your install or of not being able to connect to the database. If you don't see them on the admin page, then it's that you're missing a key table or two. If you also send me a PM with a link to your install and commish credentials to log in to StatsLab I can tell for sure.

[fhomess]

Originally Posted by Solonor

EDIT: I just looked at the Records Watch page. It's a mess. On the Seasonal side of the page, it shows the leader correctly, but everyone underneath it has 0 for Current and Projected. Everything on the Career side has the projected total showing up under both Years and Projected.

Just a separate note on this bit: In the offseason, the current seasonal total is 0 because no games have been played yet. The career total is the player's career total to date. The projected column on both sides of the page will only be updated during the season. Projections are based on current performance in the current season, then projected out to the remainder of the current season based on the player's playing time and the team's remaining games. So during the offseason, the player's projection is 0 because he hasn't collected any of the indicated stat this year. StatsLab doesn't try to project career totals out beyond the current season due to the many different ways OOTP leagues can be configured (aging factors, primarily).

[snnort]

Originally Posted by snnort

Frank... in the SIMBL we are on April 1st. The draft pool was JUST released (to the day)... We set up the ammy draft in StatsLab and when the first team goes to pick any player this message comes up:

"player not draft eligible"

Then if I try to autopick to see if any player is eligible I get this:

"no players remaining in draft pool"

Have you seen this issue? Know the fix?

Originally Posted by fhomess

I've seen this happen when you've turned on the draft timer and the util is trying to auto pick but there aren't any players available in the pool. I thought I had fixed that, and it doesn't sound quite like what you're describing anyway. Shoot me a PM with a link to your install and commish credentials to log in to StatsLab and I'll take a look.

I found out what the issue was and thought I'd post this up for you.

Apparently the draft pool players are not set up as "draft eligible" by the league on the very first day in which they are created. As soon as you flip the league file one day farther... it is then the OOTP gives them their actual "draft eligible" status.

In our case, as soon as we ran the next sim and uploaded the results to statslab, the players were all draft eligible. I went ahead and created a temporary league to test the theory once more and was able to duplicate the exact situation.

In the end, it's not and issue at all with StatsLab, it's just a very small bug in the OOTP code that is easily remedied by making sure than if you use StatsLab to start your ammy draft 75 days prior to the actual draft in-game (by having the players announced that early)... you MUST make sure that opening day is at least the day after the announcement of the player pool in game. Often this just means making opening day start on or after April 2nd, since the draft pool is usually announce on April 1st.

[Solonor]

Just as an update on my issues, everything is fine now that I've moved it to a host with MySQL 5 and gotten the very latest patch. Thank you for the help!!

[fhomess]

Originally Posted by snnort

Apparently the draft pool players are not set up as "draft eligible" by the league on the very first day in which they are created. As soon as you flip the league file one day farther... it is then the OOTP gives them their actual "draft eligible" status.

Ah, interesting. Thanks for reporting back on this! I'll add a note to the ReadMe about it.

[DWK]

Any body else having a problem with the End Of The Season Awards button my just doesn't show up. I do have it check in the enable page.