";
}
if ($user["ip"] && (get_user_class() >= UC_MODERATOR || $user["id"] == $CURUSER["id"]))
{
$r = sql_query("SELECT snatched.torrent_name as name, snatched.torrentid as id, snatched.torrent_category as category, snatched.uploaded, snatched.downloaded, snatched.completedat, snatched.last_action, torrents.seeders, torrents.leechers FROM snatched JOIN torrents ON torrents.id = snatched.torrentid WHERE snatched.finished='yes' AND userid=$id ORDER BY torrent_name") or sqlerr();
if (mysql_num_rows($r) > 0)
{
$completed = "
\n" .
"
".str16."
".str17."
".str18."
".str19."
".str20."
".str21."
".str22."
".str23."
".str24."
\n";
while ($a = mysql_fetch_assoc($r))
{
$r2 = sql_query("SELECT name, image FROM categories WHERE id=$a[category]") or sqlerr(__FILE__, __LINE__);
$a2 = mysql_fetch_assoc($r2);
if ($a["downloaded"] > 0)
{
$ratio = number_format($a["uploaded"] / $a["downloaded"], 3);
$ratio = "$ratio";
}
else
if ($a["uploaded"] > 0)
$ratio = "Inf.";
else
$ratio = "---";
$uploaded =mksize($a["uploaded"]);
$downloaded = mksize($a["downloaded"]);
$cat = "";
$completed .= "
";
}
$ip = $user["ip"];
$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];
if ($domain == "COM" || $domain == "CO" || $domain == "NET" || $domain == "NE" || $domain == "ORG" || $domain == "OR" )
$l = 2;
else
$l = 1;
$addr = "$ip ($dom)";
}
}
if ($user[added] == "0000-00-00 00:00:00")
$joindate = 'N/A';
else
$joindate = "$user[added] (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($user["added"])) . " ago)";
$lastseen = $user["last_access"];
if ($lastseen == "0000-00-00 00:00:00")
$lastseen = str25;
else
{
$lastseen .= " (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($lastseen)) . " ago)";
}
$res = sql_query("SELECT COUNT(*) FROM comments WHERE user=" . $user[id]) or sqlerr();
$arr3 = mysql_fetch_row($res);
$torrentcomments = $arr3[0];
$res = sql_query("SELECT COUNT(*) FROM posts WHERE userid=" . $user[id]) or sqlerr();
$arr3 = mysql_fetch_row($res);
$forumposts = $arr3[0];
$res = sql_query("SELECT name FROM clientselect WHERE id=$user[clientselect] LIMIT 1") or sqlerr();
if (mysql_num_rows($res) == 1)
{
$arr = mysql_fetch_assoc($res);
$clientselect = "$arr[name]";
}
$res = sql_query("SELECT name,flagpic FROM countries WHERE id=$user[country] LIMIT 1") or sqlerr();
if (mysql_num_rows($res) == 1)
{
$arr = mysql_fetch_assoc($res);
$country = "
";
}
$res = sql_query("SELECT name FROM downloadspeed WHERE id=$user[download] LIMIT 1") or sqlerr();
if (mysql_num_rows($res) == 1)
{
$arr = mysql_fetch_assoc($res);
$download = " $arr[name]";
}
$res = sql_query("SELECT name FROM uploadspeed WHERE id=$user[upload] LIMIT 1") or sqlerr();
if (mysql_num_rows($res) == 1)
{
$arr = mysql_fetch_assoc($res);
$upload = " $arr[name]";
}
if ($user["gender"] == "Male")
$gender = "";
elseif ($user["gender"] == "Female")
$gender = "";
elseif ($user["gender"] == "N/A")
$gender = "";
$res = sql_query("SELECT torrent,added,uploaded,downloaded,torrents.name as torrentname,categories.name as catname,size,image,category,seeders,leechers FROM peers LEFT JOIN torrents ON peers.torrent = torrents.id LEFT JOIN categories ON torrents.category = categories.id WHERE userid=$id AND seeder='no'") or sqlerr();
if (mysql_num_rows($res) > 0)
$leeching = maketable($res);
$res = sql_query("SELECT torrent,added,uploaded,downloaded,torrents.name as torrentname,categories.name as catname,size,image,category,seeders,leechers FROM peers LEFT JOIN torrents ON peers.torrent = torrents.id LEFT JOIN categories ON torrents.category = categories.id WHERE userid=$id AND seeder='yes'") or sqlerr();
if (mysql_num_rows($res) > 0)
$seeding = maketable($res);
stdhead(str31." " . $user["username"]);
$enabled = $user["enabled"] == 'yes';
print("
\n");
elseif ($CURUSER["id"] <> $user["id"])
{
$r = sql_query("SELECT id FROM friends WHERE userid=$CURUSER[id] AND friendid=$id") or sqlerr(__FILE__, __LINE__);
$friend = mysql_num_rows($r);
$r = sql_query("SELECT id FROM blocks WHERE userid=$CURUSER[id] AND blockid=$id") or sqlerr(__FILE__, __LINE__);
$block = mysql_num_rows($r);
if ($friend)
print("
\n");
else
if ($CURUSER[id] != $user[id] || get_user_class() != UC_ADMINISTRATOR)
if ($user["invites"] <= 0)
print("
".str39."
".str40."
\n");
else
print("
".str39."
$user[invites]
\n");
if ($user["invited_by"] > 0) {
$get_inveter_name = sql_query("SELECT username FROM users WHERE id = ".sqlesc($user[invited_by])) or sqlerr(__FILE__, __LINE__);
$inviter_name = mysql_fetch_assoc($get_inveter_name);
print("
\n");
$resip = sql_query("SELECT ip FROM iplog WHERE userid =$id GROUP BY ip") or sqlerr(__FILE__, __LINE__);
$iphistory = mysql_num_rows($resip);
if ($iphistory > 0)
print("
$arr[name]";
}
$res = sql_query("SELECT name FROM uploadspeed WHERE id=$user[upload] LIMIT 1") or sqlerr();
if (mysql_num_rows($res) == 1)
{
$arr = mysql_fetch_assoc($res);
$upload = "
$arr[name]";
}
if ($user["gender"] == "Male")
$gender = "
$user[msn]
$user[aim]
$user[yahoo]
$user[skype]\n");
?>
![\"Show/Hide\"](\"pic/plus.gif\")
[Show/Hide]
");
print("
");
$q = sql_query("SELECT minclasstoedit,maxclasstoedit FROM usergroups WHERE id = $user[class]");
$q = mysql_fetch_assoc($q);
if($q['minclasstoedit'] <= get_user_class() AND $q['maxclasstoedit'] >= get_user_class())
echo "";
print("