StatsLab13 - Page 8

fhomess · 07-10-2013, 02:10 PM

Quote:

Originally Posted by Operation Shutdown

I managed to get everything set up and the league was able to cast their first ballots. How do I close out the voting so that the results are saved and owners are no longer able to change their ballots? We are just about to finish up the world series and I wanted to finish the voting before the offseason began.

Uncheck the Enable Voting option on the HOF Admin page.

Quote:

Originally Posted by Operation Shutdown

Secondly, is there any way to hard code previous voting data for players. I've had several players appear on the ballot for previous years when we were doing the voting on the message boards and I want them to be limited to being on only five total ballots. So if they were voted on three times already, I want them to only appear for two more times while we're using statslab. I know I can exclude or include players, but I was hoping to be able to modify the SQL table somehow manually.

Yes, it is possible. You need to populate the SQL table with the ballot for each season, then populated the SQL table with the votes cast. You need to have access to the SQL database to run the queries and be comfortable modifying them. If you want specific details on how to do this, please send me a PM.

Quote:

Originally Posted by bulldog55

Of course now I can't recreate it, but I get one of two errors: one will say "ERROR: No player found for auto pick!" and the other will be something about not having valid email addresses. Worse, every time I reload, it seems to autopick for the next team in line. I would say I get errors more than I'm actually able to view the draft board, and the autopicking is ruining our draft.

Please be sure you're running the latest version of StatsLab. There were some fixes to the draft a few patches ago. I'm not sure, otherwise, why you'd be getting these errors, although the invalid email addresses would be related to sending out notifications about draft progress. Make sure your GM's have entered proper email addresses in their profile. If you're still having issues, I'm willing to look into it in more detail but unfortunately won't have much time to do that in the near term.

Robmb · 07-11-2013, 03:34 AM

Quote:

Originally Posted by Halara

Just to clarify, are you using either a virtual dedicated server or a dedicated server through godaddy? From what I can tell that is the requirement in order to create and change the permissions fora MySQL user at godaddy. Unfortunately both of those options are quite a bit more expensive than what I had paid for.

I have a shared hosting account. No issues creating the necessary MySQL data base and associated user.

Operation Shutdown · 07-12-2013, 03:00 PM

Quote:

Originally Posted by fhomess

Uncheck the Enable Voting option on the HOF Admin page.

Okay, when I do this the HOF tab goes completely away so users can no longer see the results. Is there a way to leave the HOF page open but only close out the voting on the current ballot? If not, do you think it might be possible to add this at some point in time. It would be nice to see past voting results even when owners are not currently voting on the hall of fame.

Spindel · 07-16-2013, 12:29 PM

I get the following error on StatsLab 14 when trying to view player's pages:

Quote:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/spindel/public_html/unionleague/StatsLab/player.php on line 39

http://unionleaguebaseball.com/union...layer_id=19762

fhomess · 07-16-2013, 02:03 PM

Quote:

Originally Posted by Operation Shutdown

Okay, when I do this the HOF tab goes completely away so users can no longer see the results. Is there a way to leave the HOF page open but only close out the voting on the current ballot? If not, do you think it might be possible to add this at some point in time. It would be nice to see past voting results even when owners are not currently voting on the hall of fame.

I'll consider that for a patch. You can still see who's in the HOF in the History section. I'm working on a response to your PM as well.

Quote:

Originally Posted by Spindel

I get the following error on StatsLab 14 when trying to view player's pages:

You appear to be running the StatsLab13 version of the player page. Did you overwrite all files when you upgraded?

fhomess · 07-16-2013, 03:11 PM

Quote:

Originally Posted by fhomess

I'll consider that for a patch.

Ok, fine. Patch released. v3.0.12 has the following:

Fixed HOF pages to allow seeing voting results when voting is disabled
Added team and league postseason appearances page to History section
Added a few stats to the milestones/records watch page
Fixed some minor bugs

Spindel · 07-16-2013, 09:53 PM

Quote:

Originally Posted by fhomess

I'll consider that for a patch. You can still see who's in the HOF in the History section. I'm working on a response to your PM as well.

You appear to be running the StatsLab13 version of the player page. Did you overwrite all files when you upgraded?

Apparently not. Whoops! Thanks!

Spindel · 07-16-2013, 11:00 PM

I reuploaded all the files, but I'm still seeing this error. What am I doing wrong?

fhomess · 07-17-2013, 01:34 PM

Quote:

Originally Posted by Spindel

I reuploaded all the files, but I'm still seeing this error. What am I doing wrong?

Can you shoot me a PM with commish access to your StatsLab install? I can troubleshoot further that way.

WillieMaysHayes · 08-16-2013, 01:45 AM

The only statslab problem I am having is that I don't have team logos with the _20.png ending. The game has generated logos in every size except for this one. Weird.

Just to clarify, during the draft the statslab draft board is looking for the _20.png files...I have 25, 60, 120...just about every size that the game generates except 20

dangarion · 08-20-2013, 12:51 PM

So I'm assuming since the DB now lets us choose the type of ratings shown we can use Real Ratings or OSA Ratings now?

In OOTP14.

WillieMaysHayes · 08-22-2013, 03:26 PM

Just one more problem - I have a draft with no timer between about 10PM and 7AM. 3 Hour pick timer. I had my schedule set and everything was correct but when someone makes a pick at 11PM, the next pick is due at 2AM instead of 10AM. It's like that pick resets the whole schedule of the draft.

kleric · 10-10-2013, 04:49 PM

Where are the settings for sending emails? We're doing our draft right now and no one is seeing any emails sent. I'm not even sure where those settings are. Can anyone enlighten me?

WillieMaysHayes · 10-16-2013, 01:00 PM

Quote:

Originally Posted by kleric

Where are the settings for sending emails? We're doing our draft right now and no one is seeing any emails sent. I'm not even sure where those settings are. Can anyone enlighten me?

In the managers profiles, they have to have their emails populated. As the commish of my league, I went into each one of their profiles (in the admin, you can select "Act As...") and I just populated the emails for the GM's myself.

WillieMaysHayes · 10-16-2013, 01:01 PM

One more question - in the newest update, the draft logos are a png size 30 or something (on the draft board). How can I generate those logos? I can't find that size in any photopacks either.

Huckleberry · 10-28-2013, 12:04 AM

This isn't necessarily a StatsLab question in particular, but does anyone know when the players_league_leader SQL export starts being updated during a season? My online league has already played a week of games and the SQL export for that file has no data. I've written my league's homepage code to pull from it, so just curious.

Thanks.

Huckleberry · 10-29-2013, 08:03 AM

Above question answered. I rewrote the php to compile the leaders from the players_game_batting and players_game_pitching_stats tables.

breich90 · 11-11-2013, 10:26 PM

Do drafts in StatsLab account for fixed budgets in an inaugural draft?

fhomess · 11-12-2013, 02:19 AM

Quote:

Originally Posted by breich90

Do drafts in StatsLab account for fixed budgets in an inaugural draft?

Nope.

Halara · 11-21-2013, 01:22 PM

I have sucesfully installed StatsLab14 on my godaddy account but have some troubles when it comes to loading files. If I just tell SL to do a full SQL file load it gets a connection dropped by the server error. If I go to the SQL files tab and try to load more than one file using the checkboxes I get dropped by godaddy as well (even with tiny files).

I am able to load all of my SQL files as long as I split the files to under 2.5MB and load them individually by clicking on the load link next to the file name. While this works, at least one of my files needs to be split into 30+ smaller files which takes way too much time.

In an effort to get around this I've installed a virtual linux box with apache any mysqlserver on it. I'm able to run SL locally with no problems so my plan for each sim (three times a week) is to...

1. Create a backup of my DB on godaddy using myphpadmin

2. Download the DB backup.

3. Load the backup (it's a SQL dump) into the DB on my virtual machine at home.

4. Udpate the DB using my local SL installation.

5. Run a SQL dump on the virutal machine database.

6. Upload the dump to the directory where godaddy stores my DB archives.

7. Use the database restore tool on godaddy to restore the dump file I created.

Sadly, I feel this will end up being a much faster process than splitting the files and loading them individually, but obviously it's not ideal

So my questions for anyone that's using godaddy to host their SL install are:

1. Have you had troubles loading more than one file at a time from the Admin/SQL Files tab? If so, how did you get around it?

2. Have you had troubles being limited by godaddy either by a timeout for how long it takes to load a dump file or by the size of your SQL files? If so, how did you get around it?

3. If anyone has a better plan that what I've outlined as my workaround, I'd love to hear it. I tried increases the max size and post size in my php5.ini file but that didn't seem to help any. My hope is that there's some sort of server setting that I can tweak that will just allow SL14 to work as designed where I can just click on the load files button.

Any help would be greatly appreciated!

07-16-2013, 11:00 PM	#148
Spindel All Star Reserve Join Date: Oct 2003 Location: NJ Posts: 763	I reuploaded all the files, but I'm still seeing this error. What am I doing wrong? __________________ Union League Baseball Commissioner Last edited by Spindel; 07-16-2013 at 11:01 PM.

08-16-2013, 01:45 AM	#150
WillieMaysHayes Minors (Double A) Join Date: Jul 2010 Location: Denver, CO Posts: 143	The only statslab problem I am having is that I don't have team logos with the _20.png ending. The game has generated logos in every size except for this one. Weird. Just to clarify, during the draft the statslab draft board is looking for the _20.png files...I have 25, 60, 120...just about every size that the game generates except 20 Last edited by WillieMaysHayes; 08-18-2013 at 03:08 PM.

08-20-2013, 12:51 PM	#151
dangarion All Star Reserve Join Date: Feb 2003 Location: Orange, CA Posts: 569	So I'm assuming since the DB now lets us choose the type of ratings shown we can use Real Ratings or OSA Ratings now? In OOTP14. __________________ DanGarion GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League PCJBL!

08-22-2013, 03:26 PM	#152
WillieMaysHayes Minors (Double A) Join Date: Jul 2010 Location: Denver, CO Posts: 143	Just one more problem - I have a draft with no timer between about 10PM and 7AM. 3 Hour pick timer. I had my schedule set and everything was correct but when someone makes a pick at 11PM, the next pick is due at 2AM instead of 10AM. It's like that pick resets the whole schedule of the draft.

10-10-2013, 04:49 PM	#153
kleric Minors (Double A) Join Date: Dec 2003 Location: Denver, CO Posts: 160	Where are the settings for sending emails? We're doing our draft right now and no one is seeing any emails sent. I'm not even sure where those settings are. Can anyone enlighten me?

10-16-2013, 01:01 PM	#155
WillieMaysHayes Minors (Double A) Join Date: Jul 2010 Location: Denver, CO Posts: 143	One more question - in the newest update, the draft logos are a png size 30 or something (on the draft board). How can I generate those logos? I can't find that size in any photopacks either.

10-28-2013, 12:04 AM	#156
Huckleberry All Star Reserve Join Date: Apr 2003 Posts: 578	This isn't necessarily a StatsLab question in particular, but does anyone know when the players_league_leader SQL export starts being updated during a season? My online league has already played a week of games and the SQL export for that file has no data. I've written my league's homepage code to pull from it, so just curious. Thanks.

10-29-2013, 08:03 AM	#157
Huckleberry All Star Reserve Join Date: Apr 2003 Posts: 578	Above question answered. I rewrote the php to compile the leaders from the players_game_batting and players_game_pitching_stats tables.

11-11-2013, 10:26 PM	#158
breich90 Minors (Double A) Join Date: Mar 2007 Posts: 109	Do drafts in StatsLab account for fixed budgets in an inaugural draft?

11-21-2013, 01:22 PM	#160
Halara Minors (Single A) Join Date: Apr 2010 Posts: 64	I have sucesfully installed StatsLab14 on my godaddy account but have some troubles when it comes to loading files. If I just tell SL to do a full SQL file load it gets a connection dropped by the server error. If I go to the SQL files tab and try to load more than one file using the checkboxes I get dropped by godaddy as well (even with tiny files). I am able to load all of my SQL files as long as I split the files to under 2.5MB and load them individually by clicking on the load link next to the file name. While this works, at least one of my files needs to be split into 30+ smaller files which takes way too much time. In an effort to get around this I've installed a virtual linux box with apache any mysqlserver on it. I'm able to run SL locally with no problems so my plan for each sim (three times a week) is to... 1. Create a backup of my DB on godaddy using myphpadmin 2. Download the DB backup. 3. Load the backup (it's a SQL dump) into the DB on my virtual machine at home. 4. Udpate the DB using my local SL installation. 5. Run a SQL dump on the virutal machine database. 6. Upload the dump to the directory where godaddy stores my DB archives. 7. Use the database restore tool on godaddy to restore the dump file I created. Sadly, I feel this will end up being a much faster process than splitting the files and loading them individually, but obviously it's not ideal So my questions for anyone that's using godaddy to host their SL install are: 1. Have you had troubles loading more than one file at a time from the Admin/SQL Files tab? If so, how did you get around it? 2. Have you had troubles being limited by godaddy either by a timeout for how long it takes to load a dump file or by the size of your SQL files? If so, how did you get around it? 3. If anyone has a better plan that what I've outlined as my workaround, I'd love to hear it. I tried increases the max size and post size in my php5.ini file but that didn't seem to help any. My hope is that there's some sort of server setting that I can tweak that will just allow SL14 to work as designed where I can just click on the load files button. Any help would be greatly appreciated!