twiztedbluz
03-09-2007, 06:06 PM
I ge this error "Parse error: syntax error, unexpected T_VARIABLE in /home/colin/public_html/crons58745146/runshowscript.php on line 37" But I dont understand why? Can someone PLEASE help me XD
<?php
include "config.php";
$tonight= date('2007-03-08);
$event[1]="Obedience";
$event[2]="Hunting";
$event[3]="Conformation";
$event[4]="Sporting";
$event[5]="Flyball";
$event[6]="Herding";
$event[7]="Agility";
$event[8]="Working";
$event[9]="Racing";
$event[10]="Show";
$event[11]="Schutzhund";
//add rest of events here
for($s=1; $s<12; $s++){
$showtype="$event[$s]";
//this for loop runs once for every event
$level[1]="Level 1";
$level[2]="Level 2";
$level[3]="Level 3";
$level[4]="Level 4";
$level[5]="Level 5";
$level[6]="Level 6";
//add rest of levels here
for($l=1; $l<7; $l++){
$showlevel="$level[$l]";
$query=mysql_query("select showID,prize from shows where event='$showtype' and level='$showlevel' and rundate='$tonight'")or die(mysql_error());
$num=mysql_num_rows($query);
if($num == "0"){
continue;
}
for($i=0;$i<$num;$i++){
$showrow=mysql_fetch_array($query);
//this loop runs once for every show
$entryquery=mysql_query("select entererID,dogID,score from show_entries where showID='$showrow[showID]' ORDER BY score DESC");
$number=mysql_num_rows($entryquery);
if($number == "0"){
continue;
}
for($m=0;$m<$number;$m++){
$entryrow=mysql_fetch_array($entryquery);
//this loop runs once for each show entry
switch($m){
case '0':
$points=250;
$place=1;
$prize=round($showrow[prize]/1);
break;
case '1':
$points=200;
$place=2;
$prize=round($showrow[prize]/2);
break;
case '2':
$points=150;
$place=3;
$prize=round($showrow[prize]/3);
break;
default:
$points=50;
break;
}
mysql_query("update dog set points=points+$points where dogID='$entryrow[dogID]'");
if($m == "0" || $m == "1" || $m == "2"){
mysql_query("update players set money=money+$prize where playerID='$entryrow[entererID]'");
mysql_query("insert into show_places(showID,entererID,dogID,place,rundate)values('$showrow[showID]','$entryrow[entererID]','$entryrow[dogID]','$place','$tonight')");
}
}
}
}
}
mysql_query("delete from shows where rundate='$tonight'");
mysql_query("delete from show_entries where rundate='$tonight'");
echo 'Successfully ran cron.';
?>
<?php
include "config.php";
$tonight= date('2007-03-08);
$event[1]="Obedience";
$event[2]="Hunting";
$event[3]="Conformation";
$event[4]="Sporting";
$event[5]="Flyball";
$event[6]="Herding";
$event[7]="Agility";
$event[8]="Working";
$event[9]="Racing";
$event[10]="Show";
$event[11]="Schutzhund";
//add rest of events here
for($s=1; $s<12; $s++){
$showtype="$event[$s]";
//this for loop runs once for every event
$level[1]="Level 1";
$level[2]="Level 2";
$level[3]="Level 3";
$level[4]="Level 4";
$level[5]="Level 5";
$level[6]="Level 6";
//add rest of levels here
for($l=1; $l<7; $l++){
$showlevel="$level[$l]";
$query=mysql_query("select showID,prize from shows where event='$showtype' and level='$showlevel' and rundate='$tonight'")or die(mysql_error());
$num=mysql_num_rows($query);
if($num == "0"){
continue;
}
for($i=0;$i<$num;$i++){
$showrow=mysql_fetch_array($query);
//this loop runs once for every show
$entryquery=mysql_query("select entererID,dogID,score from show_entries where showID='$showrow[showID]' ORDER BY score DESC");
$number=mysql_num_rows($entryquery);
if($number == "0"){
continue;
}
for($m=0;$m<$number;$m++){
$entryrow=mysql_fetch_array($entryquery);
//this loop runs once for each show entry
switch($m){
case '0':
$points=250;
$place=1;
$prize=round($showrow[prize]/1);
break;
case '1':
$points=200;
$place=2;
$prize=round($showrow[prize]/2);
break;
case '2':
$points=150;
$place=3;
$prize=round($showrow[prize]/3);
break;
default:
$points=50;
break;
}
mysql_query("update dog set points=points+$points where dogID='$entryrow[dogID]'");
if($m == "0" || $m == "1" || $m == "2"){
mysql_query("update players set money=money+$prize where playerID='$entryrow[entererID]'");
mysql_query("insert into show_places(showID,entererID,dogID,place,rundate)values('$showrow[showID]','$entryrow[entererID]','$entryrow[dogID]','$place','$tonight')");
}
}
}
}
}
mysql_query("delete from shows where rundate='$tonight'");
mysql_query("delete from show_entries where rundate='$tonight'");
echo 'Successfully ran cron.';
?>