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)." |