StatsLab11

[Cooleyvol]

Originally Posted by Chicagofan76

Ok I probably should read all the pages before asking this

1. Cqn i use this in solo leagues?
2. I am not the commish of my online league, is it a crime to use this and what benefits can i see for both?

You can.

As for #2..............you can only create the files needed to use statslab if you have commish access.

[BleedingCubbyBlue]

SO has anyone come across any issues with MySQL files created on a Mac? We recently installed StatsLab for the HBL and get an error with the file below if it's created on a Mac. If I create it in my PC, but the guy who runs most of the sims uses a Mac. Any ideas?

Loading team_history_pitching_stats.mysql.sql
... 1000 queries executed
... 2000 queries executed
insert into `team_history_pitching_stats` VALUES (1, 2001, 100, 0, 1, 0, 0, 5869, 1452, 6587, 0, 1511, 1027, 0, 718, 909, 851, 0, 0, 0, 2, 162, 0, 0, 0, 41, 0, 0, 0, 0, 0, 183, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13, 4, 0, 0, 0, 13.8098, 0.2575, 0.3384, 0.3510, 0.6894, 9.3614, 6.3628, 1.1338, 4.4484, 0.0000,'', 0.0000, 0.0000, 0.0000, 1.0000, nan, 0.0000, 5.2724, 0.0000, 0.0000, 1.5344, 0.0000, 1.4304, 0.2850, 0.0000); -> Unknown column 'nan' in 'field list'

[fhomess]

You'll need to manaully replace "nan" with 0 in that file and reload it. I had caught many of these, but clearly this one got missed. It's a bug in the SQL dump and has been reported now.

[fhomess]

Originally Posted by Chicagofan76

Ok I probably should read all the pages before asking this

1. Can i use this in solo leagues?

You can use this in a solo league if you set up a web server with php and mysql installed. You can actually do this on your own PC, but I've only ever heard of one person actually doing that. It's not designed to be a standalone utility. For that, you'd want to look at OOTP Companion.

Your other question has been answered well enough. Thanks, guys!

[Chicagofan76]

my commish said that statslab isnt set up for the league.

[BleedingCubbyBlue]

Originally Posted by fhomess

You'll need to manaully replace "nan" with 0 in that file and reload it. I had caught many of these, but clearly this one got missed. It's a bug in the SQL dump and has been reported now.

Thanks Frank. There's a bug when he exports HTML from his Mac too. Where can I report the bug?

[PotatoPeeler]

Which game generated SQL files handle the data for the General Manager of the Year category for awards voting? Anyone know?

Thanks.

[BleedingCubbyBlue]

Originally Posted by PotatoPeeler

Which game generated SQL files handle the data for the General Manager of the Year category for awards voting? Anyone know?

Thanks.

I would assume human_managers.mysql.sql or players_awards.mysql.sql.

[BleedingCubbyBlue]

It looks like something is wrong with the draft timer in the Beta. My settings have the timer starting at 0700 Eastern and stopping at 2200. The next pick should be at 2045 today, but it's not showing until 1006 tomorrow. Makes no sense to me...

[PotatoPeeler]

Originally Posted by BleedingCubbyBlue

I would assume human_managers.mysql.sql or players_awards.mysql.sql.

Well, the problem is that the manager records are not accurate for the GM of the Year award. I've added all the manager SQL files and that doesn't seem to be resolving it.

[cody8200]

Frank,

Can you take a look at the Hall of Fame standards on my league? It seems messed up as a bunch of players who have never played in the league have 50+ HOF standards. Anything I can do to fix this?

Players Leaderboards - StatsLab for OOTP11

[BleedingCubbyBlue]

Originally Posted by PotatoPeeler

Well, the problem is that the manager records are not accurate for the GM of the Year award. I've added all the manager SQL files and that doesn't seem to be resolving it.

Are they accurate in-game?

[fhomess]

Originally Posted by PotatoPeeler

Which game generated SQL files handle the data for the General Manager of the Year category for awards voting? Anyone know?

human_managers, teams, and team_record are the files used to generate the ballot.

Originally Posted by cody8200

Can you take a look at the Hall of Fame standards on my league? It seems messed up as a bunch of players who have never played in the league have 50+ HOF standards. Anything I can do to fix this?

Players Leaderboards - StatsLab for OOTP11

This certainly is odd. HOF Standards get calculated when you run the Career Metrics tool. You probably need to increase the Similarity Scores minimum PT settings on the Metrics Admin page. This is also what's used to determine minimum PT for the rate stat additions in HOF Standards.

[fhomess]

Originally Posted by BleedingCubbyBlue

It looks like something is wrong with the draft timer in the Beta. My settings have the timer starting at 0700 Eastern and stopping at 2200. The next pick should be at 2045 today, but it's not showing until 1006 tomorrow. Makes no sense to me...

That's definitely wrong. Are you using the 2.2.0 beta or 2.1.3?

[BleedingCubbyBlue]

Originally Posted by fhomess

That's definitely wrong. Are you using the 2.2.0 beta or 2.1.3?

Beta with Live Draft Room disabled.

[cody8200]

Originally Posted by fhomess

This certainly is odd. HOF Standards get calculated when you run the Career Metrics tool. You probably need to increase the Similarity Scores minimum PT settings on the Metrics Admin page. This is also what's used to determine minimum PT for the rate stat additions in HOF Standards.

Hmm. I tried increasing that info but it still isn't working. In fact, none of the filters are working at all on the leaderboard page for the HOF standards. Picking western or eastern results in the same numbers...

[BleedingCubbyBlue]

nm

[BleedingCubbyBlue]

Originally Posted by BleedingCubbyBlue

Frank, I came across a couple bugs on the Awards Voting page. Page is OTBA - Hank Aaron Award (BOY) - StatsLab for OOTP11.

Errors are:

Warning: asort() expects parameter 1 to be array, null given in ../ootpsqlou/eos_ballot.php on line 1190

Warning: Invalid argument supplied for foreach() in ../ootpsqlou/eos_ballot.php on line 1192

We don't have sub-leagues, just one league with 3 divisions. Could that be the issue?

Originally Posted by fhomess

This probably means you don't have your qualifications set to identify any eligible candidates.

I'm seeing this in the HBL too, using the latest Beta. Settings are below.

http://www.hblbaseball.com/statslab

[fhomess]

Yep, those settings will not work. You need to specify innings requirements per team game, not over the course of the season.

So the minimum PA requirement should be something like 3.1, not 400. There are suggested settings in the readme, which are as follows:
Min PA: 3.1
Min IP: 1.0
Min Def. Inn: 5.0

[fhomess]

There is a performance issue that can be addressed by updating the career position tool. Download the following file into your StatsLab directory to take this fix.
career_position.zip