include ("config2.php"); mysql_connect("localhost","root",""); mysql_select_db("trgo2"); $users = ""; $q = mysql_query ("select * from players2 order by seviye desc"); while ($m=mysql_fetch_array ($q)){ $users[$m["id"]] = $m["seviye"]; } echo "
";
// print_r($users);
// die();
// $c = mysql_query ("select * from games where id > 81 and id in ('89','93','101','109','114')");
// print_r($users);
$c = mysql_query ("select * from games2");
while ($g = mysql_fetch_array ($c)){
$siyah = $g["black"];
$beyaz = $g["white"];
// veritabaninda beyaz - siyah 'a gore result var.. bizimkinde
// ise siyah - beyaz seklinde girilmesi gerekiyor bu yuzden asagidaki ifi yazdim
if ($g["result"]==1) $result=2;
else $result = 1;
hesapla ($siyah,$beyaz,$g["handicap"],$result);
// echo $siyah ." - " .$beyaz . " - " . $result . "\n";
// print_r($users)."
";
}
// print_r($users);
// die();
/*
for ($x = 1;$x<=count($users);$x++){
$u = mysql_query ("select * from players where id='$x'");
$i = mysql_fetch_array ($u);
echo $x."-> ". $i["name"].": ".($users[$x]<100?100:$users[$x])."\n";
}
*/
arsort($users);
reset($users);
echo "| Id | Isim | TGOD Rating | Rank | |
| ".$key." | ". $i["name"]." | ".($users[$key]<100?100:intval($users[$key]))." | ".rating2rank($users[$key])." | ...".substr(strrev($i["email"]),6)." |