|
||||
|
09-10-2010, 10:22 PM | #81 |
Major Leagues
Join Date: Dec 2001
Posts: 386
|
Thanks for the offer of help, PM sent.
|
09-11-2010, 03:23 PM | #82 |
All Star Reserve
Join Date: Mar 2007
Posts: 982
|
Have been playing in an online league with stats lab for a while. But just wanted to say what a great utility it is. Tons of useful and interesting information available. I don't know why every online league doesn't use it.
|
09-14-2010, 11:06 AM | #83 | |
Hall Of Famer
Join Date: Dec 2001
Posts: 3,326
|
Quote:
MySQL related question: I don't see any char length limits in any of the PHP code - couldn't I simply increase the size of my varchar field in the MySQL DB to make a long email list work? I'm used to working with Oracle but I would assume MySQL allows large char fields. I'm hesitant to try this now in case I break something during an active draft, but I'll experiment with this after the current draft. Last edited by Killebrew; 09-14-2010 at 11:21 AM. |
|
09-14-2010, 11:32 AM | #84 | |
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. Last edited by fhomess; 09-14-2010 at 11:35 AM. |
|
09-14-2010, 07:57 PM | #85 | |
Hall Of Famer
Join Date: Dec 2001
Posts: 3,326
|
Quote:
Values in VARCHAR columns are variable-length strings. The length can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions. The effective maximum length of a VARCHAR in MySQL 5.0.3 and later is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used. |
|
09-15-2010, 12:44 PM | #86 | |
Hall Of Famer
Join Date: Dec 2001
Posts: 3,326
|
Quote:
|
|
09-16-2010, 09:14 AM | #87 |
Global Moderator
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,754
|
Just added by 2 expansion teams for 1977. Now, when editing the Ammy Draft order, every time I save changes it reverts these teams back to the first alphabetical team in the order
(Ex, I set Toronto to pick, click save, and it shows Atlanta as having that pick). Any ideas for a fix?
__________________
Matt Rectenwald Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW) |
09-17-2010, 12:58 AM | #88 | |
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. |
|
09-17-2010, 01:11 AM | #89 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Believe this is fixed now... same download as in the first post. Still labeled version 2.0.2.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
09-21-2010, 08:45 AM | #90 |
All Star Starter
Join Date: Mar 2002
Location: Mass.
Posts: 1,963
|
I am getting the following when I try to update Development:
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 2484 bytes) in /<DIR>/ootpsqlou/development.php on line 288 I run on a hosted (shared) server where I can not modify the php.ini to increase the memory size. Is this a bug, or just an issue with our online league running for more years than most online leagues?
__________________
- Front Office Offseason League. (Fast Paced OOTP-X and OOTP11 leagues, sims one season every week) |
09-21-2010, 10:49 AM | #91 |
All Star Starter
Join Date: Dec 2005
Posts: 1,674
|
Frank,
I'm trying out V 11 on my local Vertrigo desktop server (running locally on Windows) and I can't get the Admin page to save my nav menu options (I want to turn on Career metrics, Last Sim, Awards, etc). When I check the database, I see you have two type of "install" values (4dmln which seems to be the default) and the my local file directory (which stats lab or MySQL is stripping the Window "\" character out of so my path never matches the value saved from the admin page). Any thoughts? Curious why the server path is used as a value for the install property as well. Also, having used v9 and 10, the install process for 11 is a little convoluted now. Took me a few more tries to get everything up and running as opposed to StatsLabX. -Fox
__________________
My OOTP Gaming Channels:
|
09-21-2010, 06:23 PM | #92 | ||
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
Quote:
The server path is used to provide differenent settings for leagues that install multiple StatsLab instances for different leagues in their universe (e.g. MLB, NPL using the same MySQL database). Settings such as enabled pages are league specific, as you may want to enable All-Star voting in one instance and not another. Some of the differences avoid requiring write access to the server folders. In general, I’ve had far fewer questions about installation of StatsLab11 than StatsLabX. Some of that is probably that a lot of leagues were just converting over.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
||
09-21-2010, 08:49 PM | #93 | |
All Star Starter
Join Date: Mar 2002
Location: Mass.
Posts: 1,963
|
Quote:
I can attest to that. I've tried doing it by individual leagues and it failed the same way unfortunately. Thanks for the quick response though!
__________________
- Front Office Offseason League. (Fast Paced OOTP-X and OOTP11 leagues, sims one season every week) |
|
09-23-2010, 12:08 PM | #94 |
Hall Of Famer
Join Date: Dec 2001
Posts: 3,326
|
Regarding the generated emails for a draft...
Thanks a lot, the manual DB change (changed the email address field type in the mySQL DB) and rolling out those last updated PHP pages was successful for us, emails are working fine for us now. |
09-23-2010, 04:47 PM | #95 |
Hall Of Famer
Join Date: Dec 2001
Posts: 3,326
|
... and as that issue is solved...
Has anyone noticed that the "Set Team to Auto After Auto Pick" setting does not seem to work in statlab11 (version 2.0.2)? I know it worked well in the pre-statslab11 version we used, but unfortunately no longer. Not sure what goes on in the back-end, but this setting is supposed to auto-pick for any team that previously had their draft pick clock run out. Initially when picks were not getting auto'd I figured the users had logged in and that might be enough to reset this, but now I'm sure it occurs even when the user does not log in. |
09-25-2010, 04:16 PM | #96 |
Global Moderator
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,754
|
StatsLab is hanging up on us. F- you have my login info still.
http://baseballretrospective.com/MBBA/statslab/
__________________
Matt Rectenwald Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW) |
09-28-2010, 04:02 PM | #97 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
Did anyone ever figure out a way to have StatsLab hosted on one server and the HTML on another?
|
09-28-2010, 05:09 PM | #98 |
Global Moderator
Join Date: Dec 2001
Location: Muscatine, IA
Posts: 8,277
|
Hmmm.... went through the steps and now when I go to get onto admin.php, I get:
ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table) So I can't save any settings on that page at all. |
10-01-2010, 05:13 PM | #99 | |
Major Leagues
Join Date: Mar 2002
Posts: 452
|
Quote:
ERROR: Unable to connect to SQL. Please verify utility configuration ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table) I've verified my dbopen.php file/permissions/location, as well as my config file. Any help greatly appreciated! |
|
10-01-2010, 05:26 PM | #100 | |
Global Moderator
Join Date: Dec 2001
Location: Muscatine, IA
Posts: 8,277
|
Quote:
/ootpu for example. fhomess fixed it by using: ../../ootpu instead. |
|
Bookmarks |
|
|