<?php
set_time_limit(1200);

#How many
$rk[-4]="1";
$rk[-3]="3";
$rk[-2]="6";

#Percentage
$rk[-1]="0.1";
$rk[0]="1";
$rk[1]="3";
$rk[2]="6";
$rk[3]="10";
$rk[4]="20";
$rk[5]="30";
$rk[6]="50";
$rk[7]="70";
$rk[8]="90";

#GP per Rank
$rk[9]="6000";
$rk[10]="5100";
$rk[11]="4200";
$rk[12]="3500";
$rk[13]="2800";
$rk[14]="2300";
$rk[15]="1800";
$rk[16]="1500";
$rk[17]="1200";
$rk[18]="1100";
$rk[19]="0";

$SQL_User="root";
$SQL_Pass=" ";
$SQL_Host="127.0.0.1";
$SQL_Base="gunbound";

mysql_connect($SQL_Host,$SQL_User,$SQL_Pass);
mysql_select_db($SQL_Base);

$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++;

mysql_query("UPDATE `game` SET TotalRank = '".$count."' WHERE Id = '".$row['Id']."' ");

if($row['TotalGrade'] >= "-4" && $row['TotalGrade'] <= "19"){

if($count == $rk[-4]){
mysql_query("UPDATE `game` SET TotalGrade = '-4' WHERE Id = '".$row['Id']."' ");
$h_grade = "-4";
}

if($count > $rk[-4] && $count <= ($rk[-4] + $rk[-3]) ){
mysql_query("UPDATE `game` SET TotalGrade = '-3' WHERE Id = '".$row['Id']."' ");
$h_grade = "-3";
}

if($count > ($rk[-4] + $rk[-3]) && $count <= ($rk[-4] + $rk[-3] + $rk[-2]) ){
mysql_query("UPDATE `game` SET TotalGrade = '-2' WHERE Id = '".$row['Id']."' ");
$h_grade = "-2";
}

if ($count == ($rk[-4] + $rk[-3] + $rk[-2]) ){
$max = $row['TotalScore'];
}

if($count > ($rk[-4] + $rk[-3] + $rk[-2]) ){

for($rank = "19"; $rank >= "-1" && $rank <= "19"; $rank--){

if($rank <= "8"){
$update = ($max-($rk[$rank]*$max/100));
} else {
$update = $rk[$rank];
}

if($row['TotalScore'] >= $update){
mysql_query("UPDATE `game` SET TotalGrade = '".$rank."' WHERE Id = '".$row['Id']."' ");
}
}
}
}

echo (" <b>No:</b> ".$count." <b>Name:</b> ".$row['Id']." <b>GP:</b> ".$row['TotalScore']." <br> ");

}
?>