![\"Donor\"](\"".$GLOBALS['pic_base_url']."/starbig.gif\" "\\"Donor\\"")
', '' ) as donor_img,
IF( users.warned = 'yes', '![\"Warned\"](\"".$GLOBALS['pic_base_url']."/warnedbig.gif\" "\\"Warned\\"")
', '' ) as warned_img,
UNIX_TIMESTAMP(added) as utadded,
UNIX_TIMESTAMP(last_access) as utlast_access,
UNIX_TIMESTAMP(last_check) as utlast_check
FROM users
LEFT JOIN countries ON countries.id = users.country
WHERE users.id=".$id) or sqlerr();
$user = mysql_fetch_array($r) or bark("No user with ID");
if ($user["status"] == "pending")
bark("Still pending.");
if ($user["ip"] && (get_user_class() >= UC_MODERATOR || $user["uid"] == $CURUSER["id"]))
{
$ip = $user["ip"];
$addr = $ip;
//Like i care about there reverse DNS, commented out.
/*
$dom = @gethostbyaddr($user["ip"]);
if ($dom == $user["ip"] || @gethostbyname($dom) != $user["ip"])
$addr = $ip;
else
{
$dom = strtoupper($dom);
$domparts = explode(".", $dom);
$domain = $domparts[count($domparts) - 2];
$addr = $ip.' ('.$dom.')';
}
*/
if( $GLOBALS['settings']['mod_snatched'] )
{
$r = mysql_query("SELECT
snatched.torrent_name as name,
snatched.torrentid as id,
snatched.torrent_category as category,
snatched.uploaded,
snatched.downloaded,
IF( snatched.downloaded > 0, ROUND(snatched.uploaded / snatched.downloaded, 3), '---') as snatched_ratio,
snatched.completedat,
snatched.last_action,
torrents.seeders,
torrents.leechers,
categories.name as categories_name,
categories.image as categories_image
FROM snatched
LEFT JOIN torrents ON torrents.id = snatched.torrentid
LEFT JOIN categories ON categories.id = snatched.torrent_category
WHERE
snatched.finished='yes'
AND
userid=".$id."
ORDER BY torrent_name") or sqlerr();
if (mysql_num_rows($r) > 0)
{
$completed = "| "._('Type')." | "._('Name')." | "._('Seeders')." | "._('Leechers')." | "._('Uploaded')." | "._('Downloaded')." | "._('Ratio')." | "._('When Completed')." | "._('Last Action')." |
| $cat | " . htmlspecialchars($a["name"]) . " | " . "$a[seeders] | $a[leechers] | $uploaded | $downloaded | $ratio | $a[completedat] | $a[last_action] | \n"; } $completed .= "
'.$user['username']. $user['donor_img'].$user['warned_img'] . ' | '.$country.'
This account has been disabled
'; elseif ($CURUSER["id"] <> $user["uid"]) { $r = do_mysql_query('SELECT id FROM friends WHERE userid='.$CURUSER['id'].' AND friendid='.$id) or sqlerr(__FILE__, __LINE__); $friend = mysql_num_rows($r); $r = do_mysql_query('SELECT id FROM blocks WHERE userid='.$CURUSER['id'].' AND blockid='.$id) or sqlerr(__FILE__, __LINE__); $block = mysql_num_rows($r); if ($friend > 0) echo ''; elseif($block > 0) echo ''; else { echo '(add to friends)'; echo ' - (add to blocks)
'; } } if ($_GET["delete"]) { if (get_user_class() >= UC_MODERATOR && $user['invites'] > 0 || $user["uid"] == $CURUSER["id"]) { $deleted = (int) $_GET["delete"]; if (!is_valid_id($deleted)) bark("Bad ID $deleted."); do_mysql_query("DELETE FROM users WHERE id = $deleted AND status = 'pending' AND invited_by = " . $user["uid"] . ""); $invites = $user["invites"] +1; do_mysql_query("UPDATE users SET invites='$invites' WHERE id = " . $user["uid"] . ""); } } $invitees = do_mysql_query("SELECT id, username, email, uploaded, downloaded, added, status, IF( users.downloaded > 0, ROUND(users.uploaded / users.downloaded, 3), '---') as ratio FROM users WHERE invited_by=" . $user["uid"] . " ORDER BY status DESC") or sqlerr(__FILE__, __LINE__); $numbinvitees = mysql_num_rows($invitees); begin_main_frame(); ?>| Join date | |||||
| Last seen | |||||
| Last checked | |||||
| '.$user['email'].' | |||||
| Address | '.$addr.' | ||||
| Passkey | '.$user['passkey'].' | ||||
| Max. Torrents | '.$user['maxtorrents'].' | ||||
| Invited by | '.$invited_by2['username'].' | ||||
| Added | User | Ratio | Uploaded | Downloaded | |
| " . $subrow["email"] . " | " . $subrow["added"] . " | " . $subrow["username"] . " | " . $subrow['ratio'] . " | " . mksize($subrow["uploaded"]) . " | " . mksize($subrow["downloaded"]) . " |
| " . $subrow["email"] . " | " . $subrow["added"] . " | [Delete] | |||
| ' . number_format($sr, 3) . ' |  |
| Type | Name | Seeders | Leechers |
| $cat | " . htmlspecialchars($a["name"]) . " | " . "$a[seeders] | $a[leechers] |