iphistory.php

<?php
require "include/bittorrent.php";
dbconn();
require_once(get_langfile_path());
loggedinorreturn();
global $userprofile_class;

if (get_user_class() < $userprofile_class)
    permissiondenied();

$userid = 0 + $_GET["id"];
if (!is_valid_id($userid))
    stderr($lang_iphistory['std_error'], $lang_iphistory['std_invalid_id']);

$res = sql_query("SELECT username FROM users WHERE id = $userid") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) == 0)
    stderr($lang_iphistory['error'], $lang_iphistory['text_user_not_found']);

$arr = mysql_fetch_array($res);
$username = $arr["username"];

$perpage = 20;

$ipcountres = sql_query("SELECT COUNT(DISTINCT(access)) FROM iplog WHERE userid = $userid");
$ipcountres = mysql_fetch_row($ipcountres);
$countrows = $ipcountres[0] + 1;
$order = $_GET['order'];

list($pagertop, $pagerbottom, $limit) = pager($perpage, $countrows, "iphistory.php?id=$userid&order=$order&");

/*
$query = "SELECT u.id, u.ip AS ip, last_access AS access FROM users as u WHERE u.id = $userid
UNION DISTINCT SELECT u.id, iplog.ip as ip, iplog.access as access ,iplog.duplicate FROM users AS u
RIGHT JOIN iplog on u.id = iplog.userid WHERE u.id = $userid ORDER BY access DESC $limit";
*/

$query = "SELECT u.id, iplog.ip as ip, iplog.access as access , iplog.duplicate as duplicate FROM users AS u
RIGHT JOIN iplog on u.id = iplog.userid WHERE u.id = $userid ORDER BY access DESC $limit";


$res = sql_query($query) or sqlerr(__FILE__, __LINE__);

stdhead($lang_iphistory['head_ip_history_log_for'] . $username);
begin_main_frame();

print("<h1 align=\"center\">" . $lang_iphistory['text_historical_ip_by'] . get_username($userid) . "</h1>");

if ($countrows > $perpage)
    echo $pagertop;

print("<table width=500 border=1 cellspacing=0 cellpadding=5 align=center>\n");
print("<tr>\n
<td class=colhead>" . $lang_iphistory['col_last_access'] . "</td>\n
<td class=colhead>" . $lang_iphistory['col_ip'] . "</td>\n
<td class=colhead>" . $lang_iphistory['col_location'] . "</td>\n
</tr>\n");
while ($arr = mysql_fetch_array($res)) {
    $addr = "";
    $ipshow = "";
    if ($arr["ip"]) {
        $ip = $arr["ip"];
//        $dom = @gethostbyaddr($arr["ip"]);
//
////显示IP对应的主机名
//
//        if ($dom == $arr["ip"] || @gethostbyname($dom) != $arr["ip"])
//            $addr = $lang_iphistory['text_not_available'];
//        else
//            $addr = str_replace(".tju.edu.cn", "", $dom);
//$addr = $dom;


        /*

        $queryc = "SELECT COUNT(*) FROM
        (
        SELECT u.id FROM users AS u WHERE u.ip = " . sqlesc($ip) . "
        UNION SELECT u.id FROM users AS u RIGHT JOIN iplog ON u.id = iplog.userid WHERE iplog.ip = " . sqlesc($ip) . "
        GROUP BY u.id
        ) AS ipsearch";
        $resip = sql_query($queryc) or sqlerr(__FILE__, __LINE__);
        $arrip = mysql_fetch_row($resip);
        $ipcount = $arrip[0];



        if ($ipcount > 1)
        */

        $ipshow = "<a href=\"ipsearch.php?ip=" . $arr['ip'] . "\">" . $arr['ip'] . "</a>" . ($arr["duplicate"] == "yes" ? " <b>(<font class='striking'>" . $lang_iphistory['text_duplicate'] . "</font>)</b>" : "");
        /*
        else
        $ipshow = "<a href=\"ipsearch.php?ip=". $arr['ip'] ."\">" . $arr['ip'] ."</a>";
        */
    }
    $date = gettime($arr["access"]);
    print("<tr><td class='rowfollow'>" . $date . "</td>\n");
    print("<td class='rowfollow'>" . $ipshow . "</td>\n");
    print("<td class='rowfollow'>" . ip_to_location($arr["ip"]) . "</td></tr>\n");
}

print("</table>");

echo $pagerbottom;

end_main_frame();
stdfoot();
die;