|
||||
|
05-17-2011, 07:04 AM | #301 | |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
Quote:
You can. As for #2..............you can only create the files needed to use statslab if you have commish access. |
|
05-18-2011, 09:45 AM | #302 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
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?
Code:
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' |
05-18-2011, 11:58 AM | #303 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
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.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
05-18-2011, 12:02 PM | #304 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
Your other question has been answered well enough. Thanks, guys!
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
|
05-18-2011, 03:40 PM | #305 |
Banned
Join Date: Oct 2009
Location: Diamond, IL
Posts: 6,339
Infractions: 2/2 (3)
|
my commish said that statslab isnt set up for the league.
|
05-19-2011, 11:41 AM | #306 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
Thanks Frank. There's a bug when he exports HTML from his Mac too. Where can I report the bug?
|
05-24-2011, 03:03 PM | #307 |
Hall Of Famer
Join Date: Aug 2002
Location: Rapid City, SD
Posts: 3,639
|
Which game generated SQL files handle the data for the General Manager of the Year category for awards voting? Anyone know?
Thanks.
__________________
培傑西 I have never taken a lesson on how to talk on TV in my life. - Tim McCarver Guns have only two enemies; rust and liberals. The world is a comedy to those that think; a tragedy to those that feel. |
05-24-2011, 05:02 PM | #308 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
I would assume human_managers.mysql.sql or players_awards.mysql.sql.
|
05-24-2011, 05:13 PM | #309 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
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...
|
05-24-2011, 07:29 PM | #310 |
Hall Of Famer
Join Date: Aug 2002
Location: Rapid City, SD
Posts: 3,639
|
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.
__________________
培傑西 I have never taken a lesson on how to talk on TV in my life. - Tim McCarver Guns have only two enemies; rust and liberals. The world is a comedy to those that think; a tragedy to those that feel. |
05-25-2011, 08:21 AM | #311 |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
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
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb |
05-25-2011, 09:41 AM | #312 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
Are they accurate in-game?
|
05-25-2011, 11:12 AM | #313 | ||
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
Quote:
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
||
05-25-2011, 11:27 AM | #314 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
That's definitely wrong. Are you using the 2.2.0 beta or 2.1.3?
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
05-25-2011, 12:10 PM | #315 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
Beta with Live Draft Room disabled.
|
05-25-2011, 12:38 PM | #316 | |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
Quote:
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb |
|
05-26-2011, 08:36 PM | #317 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
nm
Last edited by BleedingCubbyBlue; 05-26-2011 at 08:39 PM. |
05-31-2011, 10:59 PM | #318 | ||
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
Quote:
Quote:
http://www.hblbaseball.com/statslab |
||
06-01-2011, 02:55 PM | #319 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
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
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
06-01-2011, 02:58 PM | #320 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
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
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
Bookmarks |
|
|