<?php

require "include/bittorrent.php";
dbconn();
loggedinorreturn();
require_once(get_langfile_path());

if (get_user_class() < UC_MODERATOR)
	stderr("错误", "权限不足");
stdhead();
begin_frame($lang_ipcheck['head_ipcheck'], true);
begin_table();

if (get_user_class() >= UC_MODERATOR || $CURUSER["guard"] == "yes") {
	$res = sql_query("SELECT COUNT(*) AS dupl, ip FROM users WHERE enabled = 'yes' AND ip <> '' AND ip <> '127.0.0.0' GROUP BY ip ORDER BY dupl DESC, ip") or sqlerr();
	print("<tr align=center><td class=colhead width=90>" . $lang_ipcheck['text_username'] . "</td>" .
			"<td class=colhead width=70>" . $lang_ipcheck['text_email'] . "</td>" .
			"<td class=colhead width=70>" . $lang_ipcheck['text_registered'] . "</td>" .
			"<td class=colhead width=75>" . $lang_ipcheck['text_lastaccess'] . "</td>" .
			"<td class=colhead width=70>" . $lang_ipcheck['text_downloaded'] . "</td>" .
			"<td class=colhead width=70>" . $lang_ipcheck['text_uploaded'] . "</td>" .
			"<td class=colhead width=45>" . $lang_ipcheck['text_ratio'] . "</td>" .
			"<td class=colhead width=125>" . $lang_ipcheck['text_ip'] . "</td>" .
			"<td class=colhead width=40>" . $lang_ipcheck['text_peer'] . "</td></tr>\n");
	$uc = 0;
	while ($ras = mysql_fetch_assoc($res)) {
		if ($ras["dupl"] <= 1)
			break;
		if ($ip <> $ras['ip']) {
			$ros = sql_query("SELECT  id, username, email, added, last_access, downloaded, uploaded, ip, warned, donor, enabled FROM users WHERE ip = '" . $ras['ip'] . "' ORDER BY id") or sqlerr();
			$num = mysql_num_rows($ros);
			if ($num > 1) {
				$uc++;
				while ($arr = mysql_fetch_assoc($ros)) {
					if ($arr['added'] == '0000-00-00 00:00:00')
						$arr['added'] = '-';
					if ($arr['last_access'] == '0000-00-00 00:00:00')
						$arr['last_access'] = '-';
					if ($arr["downloaded"] != 0)
						$ratio = number_format($arr["uploaded"] / $arr["downloaded"], 3);
					else
						$ratio = "---";

					$ratio = "<font color=" . get_ratio_color($ratio) . ">$ratio</font>";
					$uploaded = mksize($arr["uploaded"]);
					$downloaded = mksize($arr["downloaded"]);
					$added = substr($arr['added'], 0, 10);
					$last_access = substr($arr['last_access'], 0, 10);
					if ($uc % 2 == 0)
						$utc = "";
					else
						$utc = " bgcolor=\"ECE9D8\"";

					$peer_row = mysql_num_rows(sql_query("SELECT id FROM peers WHERE ip = " . sqlesc($ras['ip']) . " AND userid = " . $arr['id']));
					print("<tr{$utc}><td align=left>" . get_username($arr['id']) . "</td>" .
							"<td align=center>" . $arr['email'] . "</td>" .
							"<td align=center>$added</td>" .
							"<td align=center>$last_access</td>" .
							"<td align=center>$downloaded</td>" .
							"<td align=center>$uploaded</td>" .
							"<td align=center>$ratio</td>" .
							"<td align=center><a href=\"http://ip138.com/ips138.asp?ip=$arr[ip]\" target=\"_blank\">$arr[ip]</a></td>\n<td align=center>" . ($peer_row ? "是" : "否") . "</td></tr>\n");
					$ip = $arr["ip"];
				}
			}
		}
	}
} else {
	print("<br /><table width=60% border=1 cellspacing=0 cellpadding=9><tr><td align=center>");
	print("<h2>Sorry, Only for Team</h2></table></td></tr>");
}
end_frame();
end_table();
stdfoot();