{php} see this:

I'm goin to guess this is someone elses script you just decided to use it without any clue at all how to use it....

Error I seen, Fixed
PHP:
<?php
set_time_limit(1200);
#How Many
$rk[36]="1";
$rk[35]="1";
$rk[34]="1";
$rk[33]="3";
$rk[32]="3";
$rk[31]="5";
#Percentage
$rk[30]="0.1";
$rk[29]="1";
$rk[28]="3";
$rk[27]="6";
$rk[26]="10";
$rk[25]="20";
$rk[24]="30";
$rk[23]="40";
$rk[22]="50";
$rk[21]="60";
$rk[20]="70";
$rk[19]="80";
$rk[18]="90";
#GP
$rk[17]="15000";
$rk[16]="13000";
$rk[15]="12000";
$rk[14]="11000";
$rk[13]="10000";
$rk[12]="8800";
$rk[11]="7900";
$rk[10]="7000";
$rk[9]="6200";
$rk[8]="5400";
$rk[7]="4700";
$rk[6]="4000";
$rk[5]="3500";
$rk[4]="3000";
$rk[3]="2600";
$rk[2]="2200";
$rk[1]="1900";
$rk[0]="1600";
$rk[-1]="1400";
$rk[-2]="1200";
$rk[-3]="1100";
$rk[-4]="0";
mysql_connect('localhost','root','');
mysql_select_db('gbwc');
$info = mysql_query("SELECT Id, TotalScore, TotalGrade FROM game WHERE NoRankUpdate = '0' AND LastUpdateTime != '0000-00-00' ORDER BY TotalScore DESC");
$count=0;
while($row= mysql_fetch_array($info)){
$count++;
if($row['TotalGrade'] >= "-4" && $row['TotalGrade'] <= "36"){
if($count == $rk[36]){
$mysql_query("UPDATE `game` SET TotalGrade = '36',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
$h_grade = "36";
}
if($count > $rk[35] && $count <= ($rk[36] + $rk[35]) ){
$mysql_query("UPDATE `game` SET TotalGrade = '35',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
$h_grade = "35";
}
if($count > ($rk[36] + $rk[35]) && $count <= ($rk[36] + $rk[35] + $rk[34]) ){
$mysql_query("UPDATE `game` SET TotalGrade = '34',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
$h_grade = "34";
}

if($count > ($rk[36] + $rk[35] + $rk[34]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33]) ){
$mysql_query("UPDATE `game` SET TotalGrade = '33',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
$h_grade = "33";
}

if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32]) ){
$mysql_query("UPDATE `game` SET TotalGrade = '32',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
$h_grade = "32";
}

if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32]) && $count <= ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
$mysql_query("UPDATE `game` SET TotalGrade = '31',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
$h_grade = "31";
}
if ($count == ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
$max = $row['TotalScore'];
}
if($count > ($rk[36] + $rk[35] + $rk[34] + $rk[33] + $rk[32] + $rk[31]) ){
for($rank = "30"; $rank >= "-4" && $rank <= "30"; $rank--){
if($rank >= "18"){
$update = ($max-($rk[$rank]*$max/100));
} else {
$update = $rk[$rank];
}
if($row['TotalScore'] >= $update){
mysql_query("UPDATE `game` SET TotalGrade = '".$rank."',TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");
break;
}
}
}
}
echo (" <b>No:</b> ".$count." <b>Name:</b> ".$row['Id']." <b>GP:</b> ".$row['TotalScore']." <br> ");
}
?>
Ill browse through it and see if I see any others...
 
Back