StatsLab13

[Dbobola22]

Is there no answer for this?

Trying for almost two weeks to get this figured out and now I got it and am just a login issue away.... SO CLOSE... HELP!!!!!

[farmkidD2]

I was able to load everything else except for:

players_career_batting_stats_12.mysql.sql
players_career_pitching_stats_7.mysql.sql
players_career_pitching_stats_8.mysql.sql

I've gone to the OOTP game 3 times and created new mysql dumps to overrite these files with on the server but get the same result.

When I try to load them it fills the entire page up with numbers. Could this be why when I import my inagural draft pool from my league, nobody shows up?

[Deron]

Originally Posted by Dbobola22

Is there no answer for this?

Trying for almost two weeks to get this figured out and now I got it and am just a login issue away.... SO CLOSE... HELP!!!!!

Have the same problem as you the validation page all looks good, but no mangers show up so I can't login. I no longer had time for it so ended up using the Online Utilities. I would like to give it another shot if someone has an answer for this.

[breich90]

Does statsLab support a League Association amateur draft? I've imported the draft order/draft list, but the managers in the other league are unable to see the draft when they login.

[fhomess]

Originally Posted by Deron

Have the same problem as you the validation page all looks good, but no mangers show up so I can't login. I no longer had time for it so ended up using the Online Utilities. I would like to give it another shot if someone has an answer for this.

This one's old, but I'm not sure if it's been responded to. I believe that I resolved the issue with Dbobola by making sure to import the teams file before the human_managers file. If you import them manually, I believe that'll do the trick.

Originally Posted by breich90

Does statsLab support a League Association amateur draft? I've imported the draft order/draft list, but the managers in the other league are unable to see the draft when they login.

I don't think this will work since StastLab's draft util was designed to be league specific. That said, you might be able to trick it into working by enabling the draft with the exact same draft settings in both leagues. The player pool can be the same. I think you might still run into problems, though, when players are taken, since I think it'll only remove players from the draft pool of the league in which those players were drafted.

[breich90]

Originally Posted by fhomess

This one's old, but I'm not sure if it's been responded to. I believe that I resolved the issue with Dbobola by making sure to import the teams file before the human_managers file. If you import them manually, I believe that'll do the trick.


I don't think this will work since StastLab's draft util was designed to be league specific. That said, you might be able to trick it into working by enabling the draft with the exact same draft settings in both leagues. The player pool can be the same. I think you might still run into problems, though, when players are taken, since I think it'll only remove players from the draft pool of the league in which those players were drafted.

Yep, I think I'd have to move all the second league teams into the Premier league to get the draft to work right, then move them back.

[USF]

I'm shopping for a new server provider and one of the issues I am looking to address is the OUT of Resources errors I get trying to run programs such as Statslab. Can anyone give me an idea of the memory I need to be able to run this program on a server without this issue? Also does anyone have advice on a great server provider for such mysql database and also fast d/l times. I'm with IPAGE now (shared server) and it is slow super slow...

[cody8200]

I user belira.Info and I have never had any issues running the sql loads. It costs $2 per month on their cheap server and $4 per month on their better one. I've used both but you might as well start on the cheapest end. They are month to month and take PayPal.

[USF]

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/usflea5/public_html/statslab14/session_functions.php on line 75

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/usflea5/public_html/statslab14/session_functions.php on line 118

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/usflea5/public_html/statslab14/nav_functions.php on line 838
StatsLab Validator


I am getting the above errors when I try to install Statslab 14.

does anyone know how to fix this?

Thanks!!
Jason

[USF]

Originally Posted by cody8200

I user belira.Info and I have never had any issues running the sql loads. It costs $2 per month on their cheap server and $4 per month on their better one. I've used both but you might as well start on the cheapest end. They are month to month and take PayPal.

THANKS FOR THE INPUT!!
Jason

[USF]

Originally Posted by dangarion

When I run validate I get the following two errors.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pcjbl/pcjbl.com/StatsLab/session_functions.php on line 79

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pcjbl/pcjbl.com/StatsLab/nav_functions.php on line 335


Although for the life of me I can't see the issues with those rows after looking through the code.

Also in the manual it says to put the path of the StatsLab install folder in config.txt but I think you meant for it to include the path to the sql folder.... right?

Did you ever find out the fix for the above. Looks like I have a similar error. Also yes the manual should read that way. I found out by trial and error myself too. :-)

Jason

[USF]

I got past Step 19 in the instructions where I loaded the mysql pages but, when I hit the Login Link to select my name (commissioner) and enter the password - it doesn't work.

I get this red error at the top of the screen:

ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table)

I am currently running statslab for this league on an existing server but, I am also trying to run it on a new server to compare the performance. Is there an issue doing this that I don't know about?

Jason

Here were the other areas at the top of the sign in screen:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/usflea5/public_html/statslab14/nav_functions.php on line 846

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/usflea5/public_html/statslab14/session_functions.php on line 229

Warning: Cannot modify header information - headers already sent by (output started at /home/usflea5/public_html/statslab14/nav_functions.php:846) in /home/usflea5/public_html/statslab14/session_functions.php on line 341

[USF]

Ok I fixed this by loading all the databases and not just the ones listed in the setup instructions. After the validator was run again, I hit the statslab admin link instead. It took me another screen that asked me to load the databases. I hit that link, it ran and took me to the sign in screen and I was able to sign in with the password listed in the setup instructions. Kinda a backwards way of doing it vs the instructions but, it looks to work now.

Jason

[Huckleberry]

In draft_auto_list_generate.php is there an error here?

  while ($row=mysql_fetch_array($result))
  {
	  $pid=$row['player_id'];

	  $mod=0;
       	  $bcnt=0;
	  if ($row['fielding_rating_pos2']>1)
	  {
		  $mod+=.02;$bcnt+=1;
		  if ($row['fielding_ratings_catcher_arm']>100) {$mod+=.005;$bcnt+=1;}
	  }
	  if ($row['fielding_rating_pos4']>100) {$mod+=.01;$bcnt+=1;}
       	  if ($row['fielding_rating_pos5']>120) {$mod+=.008;$bcnt+=1;}
	  elseif (($row['fielding_rating_pos5']>60)&&($row['fielding_ratings_infield_arm']>100)) {$mod+=.005;$bcnt+=1;}
       	  if ($row['fielding_rating_pos6']>100) {$mod+=.017;$bcnt+=1;}
	  if ($row['fielding_rating_pos8']>100) {$mod+=.0075;$bcnt+=1;}
       	  if (($row['fielding_rating_pos9']>60)&&($row['fielding_ratings_outfield_arm']>100)) {$mod+=.005;$bcnt+=1;}
	  switch ($bcnt)
	  {
    	  case 0: 
	  case 1: $mod=$mod*1.00; break;
    	  case 2: $mod=$mod*.800; break;
	  case 3: $mod=$mod*.650; break;
    	  case 4: $mod=$mod*.600; break;
	  case 5: $mod=$mod*.575; break;
    	  case 6: 
	  case 7: 
    	  case 8: $mod=$mod*.550; break;
	  default: break;
      	  }
	  $bvalues[$pid]=$bvalues[$pid]*(1+$mod);
  }

The cases where $bcnt=6 or 7 should have values of some sort, no? Based on the code that precedes the switch command, I can come up with combinations of fielding ratings that result in both those values but can't come up with a combination that results in 8. Perhaps I don't understand what is happening here, but just wanted to check.

If I'm correct then obviously the auto list will overvalue players that have $bcnt equal to 6 or 7. Then again I haven't noticed those players being drafted way too high so I lean toward the answer that I'm not interpreting this correctly.

[fhomess]

PHP switch/case statements evaluate until they hit a "break", so the case 6 and 7 cases evaluate the statement listed for case 8.

[Huckleberry]

Originally Posted by fhomess

PHP switch/case statements evaluate until they hit a "break", so the case 6 and 7 cases evaluate the statement listed for case 8.

Ah, okay. Thanks for the quick response, sir!

[sjshaw]

Think an update will be needed for v15, or should things roll along with no hiccups?

[fhomess]

There was very little needed for OOTP14, and I expect the same will be true for OOTP15.

[fhomess]

First post updated with OOTP15 version of StatsLab.

Perhaps a mod can change the title of this thread from "StatsLab13" to just "StatsLab"? That would be great!

[cody8200]

Originally Posted by fhomess

First post updated with OOTP15 version of StatsLab.

Perhaps a mod can change the title of this thread from "StatsLab13" to just "StatsLab"? That would be great!

Tremendous news! Thanks for all of your effort with this.