diff options
| author | Matthijs Kuiper <info@matthijskuiper.nl> | 2017-02-04 16:05:45 +0100 |
|---|---|---|
| committer | Matthijs Kuiper <info@matthijskuiper.nl> | 2017-02-04 16:05:45 +0100 |
| commit | 40dfa7d5c0dc8e4cb2c95e403b6b4b2c4bf70644 (patch) | |
| tree | 6ac6279ac26749ffe7ca0ae9603fbcae2e757e6e /html/pages/admin/pinfo.php | |
Original UTStats beta 4.2.84.2.8
Diffstat (limited to 'html/pages/admin/pinfo.php')
| -rwxr-xr-x | html/pages/admin/pinfo.php | 91 |
1 files changed, 91 insertions, 0 deletions
diff --git a/html/pages/admin/pinfo.php b/html/pages/admin/pinfo.php new file mode 100755 index 0000000..7be13ae --- /dev/null +++ b/html/pages/admin/pinfo.php @@ -0,0 +1,91 @@ +<?php
+if (empty($import_adminkey) or isset($_REQUEST['import_adminkey']) or $import_adminkey != $adminkey) die('bla');
+
+$options['title'] = 'Extended Player Info';
+$options['requireconfirmation'] = false;
+$i = 0;
+$options['vars'][$i]['name'] = 'v_pid';
+$options['vars'][$i]['type'] = 'player';
+$options['vars'][$i]['prompt'] = 'Player?';
+$options['vars'][$i]['caption'] = 'Player:';
+$i++;
+
+if (isset($_REQUEST['pid'])) {
+ $pid = $_REQUEST['pid'];
+}else {
+ $results = adminselect($options);
+ $pid = $results['v_pid'];
+}
+
+$is_admin = true;
+include('pages/players_info.php');
+
+echo '<br>';
+
+$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 = mysql_query($sql_ips) or die("Can't get ip's: " . mysql_error());
+echo '
+<table class = "box" border="0" cellpadding="1" cellspacing="2" width="720">
+ <tbody>
+ <tr>
+ <td class="heading" colspan="5" align="center">IP\'s used</td>
+ </tr>
+ <tr>
+ <td class="smheading" width="80" align = "center">IP</td>
+ <td class="smheading" width="180" align = "left">Hostname</td>
+ <td class="smheading" width="60" align = "center">Matches</td>
+ <td class="smheading" width="200" align = "left">First</td>
+ <td class="smheading" width="200" align = "left">Last</td>
+ </tr>';
+
+while ($r_ips = mysql_fetch_assoc($q_ips)) {
+ echo '
+ <tr>
+ <td class="grey" align = "center">'.$r_ips['ip'].'</td>
+ <td class="grey" align = "left">'.gethostbyaddr($r_ips['ip']).'</td>
+ <td class="grey" align = "center">'.$r_ips['matches'].'</td>
+ <td class="grey" align = "left">'.mdate($r_ips['first']).'</td>
+ <td class="grey" align = "left">'.mdate($r_ips['last']).'</td>
+ </tr>';
+}
+
+echo '
+ </tbody>
+</table>
+<div class="opnote">* Hostnames are real time and might have been different at the time of playing. *</div>
+<br>';
+
+mysql_free_result($q_ips);
+
+$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 = mysql_query($sql_fakes) or die("Can't retrieve fake nicks: " . mysql_error());
+echo '
+<table class = "box" border="0" cellpadding="1" cellspacing="2" width="480">
+ <tbody>
+ <tr>
+ <td class="heading" colspan="2" align="center">Possible aliasses</td>
+ </tr>
+ <tr>
+ <td class="smheading" width="120" align = "center">Nick</td>
+ <td class="smheading" width="360" align = "center">IP</td>
+ </tr>';
+
+if (mysql_num_rows($q_fakes) == 0) {
+ echo '
+ <tr>
+ <td class="grey" align = "center" colspan="2">No other names found</td>
+ </tr>';
+}
+else {
+ while($r_fakes = mysql_fetch_assoc($q_fakes)) {
+ echo '
+ <tr>
+ <td class="grey" align = "center">'.$r_fakes[ip].'</td>
+ <td class="grey" align = "center">'.$r_fakes[name].'</td>
+ </tr>';
+ }
+}
+echo '
+ </tbody>
+</table><br>';
+?>
|