ipcheck.php - add pager function, how?
Hi!
How to add pager function at the ipcheck.php? Thanks!
Code:
require "include/bittorrent.php";
dbconn();
loggedinorreturn();
stdhead("Duplicate IP users");
begin_frame("Duplicate IP users:", true);
begin_table();
if (get_user_class() >= UC_MODERATOR)
{
$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(__FILE__, __LINE__);
print("User |
Email |
Registered |
Last access |
Downloaded |
Uploaded |
Ratio |
IP |
Peer | \n");
$uc = 0;
while($ras = mysql_fetch_assoc($res)) {
if ($ras["dupl"] <= 1)
break;
if ($ip <> $ras['ip']) {
$ros = sql_query("SELECT id, username, class, email, added, last_access, downloaded, uploaded, ip, warned, donor, enabled, (SELECT COUNT(*) FROM peers AS p WHERE p.ip = u.ip AND u.id = p.userid) AS peer_count FROM users AS u WHERE ip='".$ras['ip']."' ORDER BY id") or sqlerr(__FILE__, __LINE__);
$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'] = '-';
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 = "$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_user_class_color($arr['class'], $arr['username'])."" . get_user_icons($arr) . " |
$arr[email] |
$added |
$last_access |
$downloaded |
$uploaded |
$ratio |
$arr[ip] | \n" .
($arr['peer_count'] > 0 ? "Yes" : "No") . " | \n");
$ip = $arr["ip"];
}
}
}
}
} else {
print("
");
print("Error, only for Team |
|