'; echo''; echo'

Recalculating Countryflags
Recalculating Rankings:	'; echo'Recalculating pinfo table... '; /* update pinfo table */ $sql_pids = mysqli_query($GLOBALS["___mysqli_link"], "SELECT uts_pinfo.id as pid, uts_pinfo.country as country, uts_player.ip as ip FROM uts_pinfo, uts_player WHERE uts_pinfo.id = uts_player.pid GROUP BY uts_player.pid;") or die(mysqli_error($GLOBALS["___mysqli_link"])); while($sql_pid = mysqli_fetch_array($sql_pids)) { $playercountry = strtolower(geoip_country_code_by_addr($gi,long2ip($sql_pid['ip']))); if ($playercountry != $sql_pid['country'] ) { mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_pinfo SET country = '$playercountry' WHERE id = '".$sql_pid['pid']."'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } } echo'Recalculating player table... '; /* update player table */ $sql_pids = mysqli_query($GLOBALS["___mysqli_link"], "SELECT pid, ip, country FROM uts_player"); while ($sql_pid = mysqli_fetch_array($sql_pids)) { $playercountry = strtolower(geoip_country_code_by_addr($gi,long2ip($sql_pid['ip']))); if ($playercountry != $sql_pid['country']) { mysqli_query($GLOBALS["___mysqli_link"], "UPDATE uts_player SET country = '$playercountry' WHERE pid = '".$sql_pid['pid']."'") or die(mysqli_error($GLOBALS["___mysqli_link"])); } } echo 'Done
Countryflags recalculated - Go Back To Admin Page

'; ?>