';
$sql_ips = "SELECT INET_NTOA(p.ip) AS ip, COUNT(p.id) AS matches, MIN(m.time) AS first, MAX(m.time) AS last FROM uts_player AS p, uts_match AS m WHERE p.pid = ".$pid." AND m.id = p.matchid GROUP BY ip ORDER BY ip";
$q_ips = mysqli_query($GLOBALS["___mysqli_link"], $sql_ips) or die("Can't get ip's: " . mysqli_error($GLOBALS["___mysqli_link"]));
echo '
| IP\'s used |
| IP |
Hostname |
Matches |
First |
Last |
';
while ($r_ips = mysqli_fetch_assoc($q_ips)) {
echo '
| '.$r_ips['ip'].' |
'.gethostbyaddr($r_ips['ip']).' |
'.$r_ips['matches'].' |
'.mdate($r_ips['first']).' |
'.mdate($r_ips['last']).' |
';
}
echo '
* Hostnames are real time and might have been different at the time of playing. *
';
((mysqli_free_result($q_ips) || (is_object($q_ips) && (get_class($q_ips) == "mysqli_result"))) ? true : false);
$sql_fakes = "SELECT INET_NTOA(p1.ip) AS ip, pi.name FROM uts_player AS p1, uts_player AS p2, uts_pinfo AS pi WHERE p1.pid = ".$pid." AND p1.ip = p2.ip AND p1.pid <> p2.pid AND pi.id = p2.pid GROUP BY pi.name";
$q_fakes = mysqli_query($GLOBALS["___mysqli_link"], $sql_fakes) or die("Can't retrieve fake nicks: " . mysqli_error($GLOBALS["___mysqli_link"]));
echo '
| Possible aliasses |
| Nick |
IP |
';
if (mysqli_num_rows($q_fakes) == 0) {
echo '
| No other names found |
';
}
else {
while($r_fakes = mysqli_fetch_assoc($q_fakes)) {
echo '
| '.$r_fakes[ip].' |
'.$r_fakes[name].' |
';
}
}
echo '
';
?>