'; mysql_query("DELETE FROM uts_rank WHERE pid = $pid") or die(mysql_error()); echo''; mysql_query("UPDATE uts_pinfo SET banned = 'Y' WHERE id = $pid") or die(mysql_error()); echo'

Banning Player
Removing Player Rank:	Done
Updating Player Record:	Done
Player Banned - Go Back To Admin Page

'; } else { echo''; mysql_query("UPDATE uts_pinfo SET banned = 'N' WHERE id = $pid") or die(mysql_error()); echo''; $sql_nrank = "SELECT SUM(gametime) AS time, pid, gid, SUM(rank) AS rank, COUNT(matchid) AS matches FROM uts_player WHERE pid = $pid GROUP BY pid, gid"; $q_nrank = mysql_query($sql_nrank) or die(mysql_error()); while ($r_nrank = mysql_fetch_array($q_nrank)) { mysql_query("INSERT INTO uts_rank SET time = '$r_nrank[time]', pid = $pid, gid = $r_nrank[gid], rank = '$r_nrank[rank]', prevrank = '$r_nrank[rank]', matches = $r_nrank[matches]") or die(mysql_error()); } echo'

Unbanning Player
Updating Player Record:	Done
Restoring Rankings	Done
Player Unbanned - Go Back To Admin Page

'; } ?>