ipinfo.php

   1 <?php
   2 require ('config.php');
   3 $level_restriction = MOD;
   4 $require_login = true;
   5
   6 $ipaddr = isset ($_GET['ip']) ? mysql_real_escape_string ($_GET['ip']) : $userinfo['lastacip'];
   7 $page_name = 'Stats for '.$ipaddr;
   8 require ('top.inc.php');
   9
  10 echo '<form action="'.urlpath(2).'" method="get" style="display: inline">
  11 <div class="alert">IP address: <input type="text" name="ip" value="'.$ipaddr.'"/></div>
  12 </form>
  13
  14 <div class="c3">Usermap by last user IPs</div>';
  15 $list_criteria = '`lastacip` = \''.$ipaddr.'\'';
  16 require ('users.inc.php');
  17
  18 echo '<div class="c3">Usermap by iplog table</div>';
  19 $list_criteria = '`userid` IN (SELECT `userid` FROM `iplog` WHERE `remoteip` = \''.$ipaddr.'\')';
  20 require ('users.inc.php');
  21
  22 $stats[] = mysql_result (mysql_query ('SELECT COUNT(*) FROM `iplog` WHERE `actiontype` = \'login\' AND `remoteip` = \''.$ipaddr.'\''), 0);
  23 $stats[] = mysql_result (mysql_query ('SELECT COUNT(*) FROM `iplog` WHERE `actiontype` = \'oklogin\' AND `remoteip` = \''.$ipaddr.'\''), 0);
  24 $stats[] = mysql_result (mysql_query ('SELECT COUNT(*) FROM `iplog` WHERE `actiontype` = \'message\' AND `remoteip` = \''.$ipaddr.'\''), 0);
  25 $stats[] = mysql_result (mysql_query ('SELECT COUNT(*) FROM `iplog` WHERE `actiontype` = \'topic\' AND `remoteip` = \''.$ipaddr.'\''), 0);
  26 $stats[] = mysql_result (mysql_query ('SELECT COUNT(*) FROM `iplog` WHERE `actiontype` = \'resendpass\' AND `remoteip` = \''.$ipaddr.'\''), 0);
  27 $stats[] = mysql_result (mysql_query ('SELECT COUNT(*) FROM `iplog` WHERE `actiontype` = \'ipban\' AND `remoteip` = \''.$ipaddr.'\''), 0);
  28 echo '<div class="c3">Logged actions from this IP address</div>
  29 <table>
  30 <tr class='.colour().'><td>Bad Logins</td><td>'.$stats[0].'</td></tr>
  31 <tr class='.colour().'><td>Logins</td><td>'.$stats[1].'</td></tr>
  32 <tr class='.colour().'><td>Posts</td><td>'.$stats[2].'</td></tr>
  33 <tr class='.colour().'><td>Topics</td><td>'.$stats[3].'</td></tr>
  34 <tr class='.colour().'><td>Resendpass</td><td>'.$stats[4].'</td></tr>
  35 <tr class='.colour().'><td>Hostname</td><td>'.gethostbyaddr ($ipaddr).'</td></tr>
  36 <tr class='.colour().'><td>Is IP-banned</td><td>'.($stats[5] ? 'Yes' : 'No').'</td></tr>
  37 </table>
  38
  39 <div class="c3">Post history from this IP</div>';
  40 $list_criteria = 'postedip = \''.$ipaddr.'\' ORDER BY `messsec` DESC';
  41 $show_titles = true;
  42 require ('messages.inc.php');
  43
  44 require ('foot.php');
  45 ?>