'.$title.'';
//print '';
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("| User |
Email |
Registered |
Last access |
Downloaded |
Uploaded |
Ratio |
IP |
Peer |
\n");
$uc = 0;
$ip = '';
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();
$num2 = mysql_num_rows($ros);
if ($num2 > 1)
{
$uc++;
while($arr = mysql_fetch_assoc($ros))
{
if ($arr['added'] == '0000-00-00 00:00:00' || $arr['added'] == null)
$arr['added'] = '-';
if ($arr['last_access'] == '0000-00-00 00:00:00' || $arr['last_access'] == null)
$arr['last_access'] = '-';
if($arr["downloaded"] != 0)
$ratio = number_format($arr["uploaded"] / $arr["downloaded"], 3);
else
$ratio="---";
$ratio = "$ratio";
$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_res = sql_query("SELECT count(*) FROM peers WHERE ip = " . sqlesc($ras['ip']) . " AND userid = " . $arr['id']);
$peer_row = mysql_fetch_row($peer_res);
print("" . get_username($arr["id"])." |
$arr[email] |
$added |
$last_access |
$downloaded |
$uploaded |
$ratio |
$arr[ip] | \n" .
($peer_row[0] ? "ja" : "nein") . " | \n");
$ip = $arr["ip"];
}
}
}
}
}
else
{
print("
");
print("Sorry, only for Team |
");
}
end_frame();
end_table();
stdfoot();
?>