'; echo''; mysql_query("TRUNCATE uts_rank") or die(mysql_error()); echo''; echo''; echo'

Recalculating Rankings
Deleting rankings	Done
Recalculating Rankings:	'; $playerbanned = false; $q_pm = mysql_query( " SELECT p.id, p.matchid, p.pid, p.gid, m.gamename FROM uts_player p, uts_pinfo pi, uts_match m WHERE pi.id = p.pid AND pi.banned <> 'Y' AND m.id = p.matchid ORDER BY p.matchid ASC, p.playerid ASC"); $i = 0; while ($r_pm = mysql_fetch_array($q_pm)) { $i++; if ($i%50 == 0) { echo '. '; flush(); } $playerecordid = $r_pm['id']; $matchid = $r_pm['matchid']; $pid = $r_pm['pid']; $gid = $r_pm['gid']; $gamename = $r_pm['gamename']; // echo "$pid|$gid|$matchid "; include('import/import_ranking.php'); } echo 'Done
Rankings recalculated - Go Back To Admin Page

'; ?>