|
||||
|
07-12-2011, 12:42 PM | #1 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
StatsLab12
It has been a couple of weeks so it's time to have an updated version of StatsLab that will work with OOTP12. I haven't made any enhancements or improvements yet, and I haven't tested every page thoroughly. The read me is not updated either. Hence, this is officially version 0.0.1. When 1.0.0 comes out, there will be some enhancements and improvements.
NOTE: Links and web styles require that you use the full reports. I haven't done anything with the SQL reports upload yet. In the meantime, this should work: StatsLab12.zip One thing to note, the SQL configuration in OOTP12 has some additional options. The following should be checked:
I'll update this post and thread when I've got more for all of you.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. Last edited by fhomess; 07-14-2011 at 11:05 AM. |
07-12-2011, 01:02 PM | #2 |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
First in. Thanks, Frank!
|
07-17-2011, 02:57 PM | #3 |
Minors (Double A)
Join Date: Apr 2002
Posts: 184
|
Anybody got this set up for an OOTP12 league yet?
Any problems so to speak? |
07-18-2011, 07:52 PM | #4 |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
So far, so good. Working like a champ. Thanks for this Frank. You are awesome!
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb |
07-19-2011, 01:27 PM | #5 |
Major Leagues
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
|
Same install instructions that were used in 11? Is there anything different from an install perspective with regards to 12?
Thanks for any help I can get. Soon to be new OOTP commish. Almo |
07-19-2011, 03:04 PM | #6 |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
The same instructions work just fine. At least they did for me. Good luck commish.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb |
07-20-2011, 12:56 PM | #7 |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
Frank,
It seems the finance stuff is currently not working. I'm seeing this on the finance sheet. Projected Payroll - StatsLab for OOTP12
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb Last edited by cody8200; 07-20-2011 at 02:10 PM. |
07-20-2011, 07:56 PM | #8 | |
Minors (Double A)
Join Date: Jun 2010
Location: Calgary, AB
Posts: 118
|
I'm getting the following errors after installing, when logging in. Can anyone help?
Quote:
|
|
07-20-2011, 11:28 PM | #9 | |
Major Leagues
|
Quote:
EDIT: I now see why. It's a bug. I converted from OOTP X to OOTP 12. Obviously will need to be fixed. Last edited by hank9481; 07-20-2011 at 11:30 PM. |
|
07-21-2011, 08:49 AM | #10 |
Major Leagues
Join Date: Jan 2011
Posts: 332
|
I too am getting these errors when logging in
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mlob/public_html/StatsLab/login.php on line 151 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mlob/public_html/StatsLab/login.php on line 168 Also, it will not save any of my contact information.. Just resets to blank boxes Last edited by sdodd; 07-21-2011 at 08:50 AM. |
07-21-2011, 08:49 PM | #11 | |
Major Leagues
Join Date: Jan 2011
Posts: 332
|
Quote:
|
|
07-21-2011, 09:10 PM | #12 |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
I had this issue as well. It's because you ootp 11 import saves the sql config. files. The new options in 12 weren't on the old config files. Simply delete that config file and it will give you all of the options. I would tell you where that location is but I'm not on my home PC right now. Sorry.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb |
07-21-2011, 10:32 PM | #13 |
Minors (Single A)
Join Date: Apr 2011
Posts: 73
|
Thank you Sdodd! First time user here and excited about it
|
07-22-2011, 01:29 AM | #14 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
File updated with some minor fixes:
1. Login page will no longer cause errors and user info will save properly. 2. Coded around issues with #INF errors in SQL load.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
07-22-2011, 10:27 AM | #15 |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
I'm still getting the following message on the contract/finance screens
Contract screen:
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 102 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 103 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 178 Payroll (front office screen) Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 513 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 514 Warning: arsort() expects parameter 1 to be array, null given in /home/ootpbeli/public_html/StatsLab/payroll.php on line 623
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb |
07-22-2011, 10:53 AM | #16 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
|
07-22-2011, 11:03 AM | #17 |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
Weird. The contract extension sql file is def. loaded. I just went back to the file load list to make sure.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb Last edited by cody8200; 07-22-2011 at 11:05 AM. |
07-23-2011, 11:14 AM | #18 |
Global Moderator
|
A quick question Frank. I have a universe with four major leagues - is there a way of not having StatsLab defaulting to one particular league.
__________________
This signature is intentionally blank |
07-23-2011, 11:27 AM | #19 |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
|
07-23-2011, 07:29 PM | #20 |
Minors (Single A)
Join Date: Apr 2011
Posts: 73
|
2 Things....
1. When I try to load all the SQL Files through StatsLab I am able to load everything except the league_history_batting_stats.mysql.sql and players.mysql.sql files.
I get the following errors.... league_history_batting_stats.mysql.sql Loading league_history_batting_stats.mysql.sql insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 87032, 77965, 20783, 15309, 0, 0, 4131, 388, 2560, 1541, 542, 0, 10938, 7694, 0, 725, 0, 648, 0, 0, 2270, 0, 7079, 0, 0.2666, 0.3355, 0.4280, 11961.8121, 5.5329, 0.1614, 1.#INF, 0.7635, 73.9798, 0.0000, 0.0000); -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 98393, 87884, 22741, 18282, 0, 0, 4606, 561, 2482, 1429, 591, 0, 11481, 8926, 0, 865, 0, 718, 0, 0, 2590, 0, 7649, 0, 0.2588, 0.3306, 0.4087, 12755.6118, 5.1827, 0.1499, 1.#INF, 0.7393, 70.7426, 0.0000, 0.0000); -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 86187, 77467, 20131, 15214, 0, 0, 4016, 368, 2209, 1505, 540, 0, 10097, 7367, 0, 727, 0, 626, 0, 0, 2268, 0, 6593, 0, 0.2599, 0.3275, 0.4068, 11040.9813, 5.0957, 0.1469, 1.#INF, 0.7342, 73.5941, 0.0000, 0.0000); -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 97794, 87886, 22423, 19092, 0, 0, 4470, 498, 2404, 1454, 589, 0, 11211, 8411, 0, 822, 0, 675, 0, 0, 2592, 0, 7372, 0, 0.2551, 0.3237, 0.3994, 12168.1925, 4.9237, 0.1443, 1.#INF, 0.7231, 71.1698, 0.0000, 0.0000); -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 ... 282 queries executed players.mysql.sql ... 42000 queries executed insert into `players` VALUES (31388, 0, 0, "Lloyd", "Shunick\", "", 18, "1992-10-2", 81480, 206, 0, 220, 201, 0, 1, 100, 0, 0, 0, 0, -1, 23, 0, 0, 1, 1, 166, 104, 37, 29, 118, 72, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 52, 51, 42, 63, 0, 0, 0, 0, 0, 0, 0, 0, 16, 1, 1, 3, 0, 0, 0, 0, 0, 1, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0); -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1992-10-2", 81480, 206, 0, 220, 201, 0, 1, 100, 0, 0, 0, 0, -1, 23, 0, 0, 1, 1, ' at line 1 ... 42587 queries executed 2. I am trying to set up the draft ultity to no avil. We have already started the draft on our forums and so right now I need to manually enter our first 2 rounds through statslab. When selected manual pick, I am then needed to enter a player ID. When I do that, I get the following error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/primetim/public_html/StatsLab/draftProcess.php on line 383 player not draft eligible Any help or direction would be greatly appreciated. Thanks! |
Bookmarks |
|
|