require "include/bittorrent.php";

dbconn(false);

loggedinorreturn();

function bark($msg)
{
stdhead();
stdmsg("Error", $msg);
stdfoot();
exit;
}

function maketable($res)
{
$ret = "" .
"TypeNameTTLSizeSe.Le.Upl.\n" .
"\"$catname\"\n" .
"

Downl.Ratio\n"; while ($arr = mysql_fetch_assoc($res)) { if ($arr["downloaded"] > 0) { $ratio = number_format($arr["uploaded"] / $arr["downloaded"], 3); $ratio = "$ratio"; } else if ($arr["uploaded"] > 0) $ratio = "Inf."; else $ratio = "---"; $catimage = htmlspecialchars($arr["image"]); $catname = htmlspecialchars($arr["catname"]); $ttl = (28*24) - floor((gmtime() - sql_timestamp_to_unix_timestamp($arr["added"])) / 3600); if ($ttl == 1) $ttl .= " hour"; else $ttl .= " hours"; $size = str_replace(" ", " ", mksize($arr["size"])); $uploaded = str_replace(" ", " ", mksize($arr["uploaded"])); $downloaded = str_replace(" ", " ", mksize($arr["downloaded"])); $seeders = number_format($arr["seeders"]); $leechers = number_format($arr["leechers"]); $ret .= "

" . htmlspecialchars($arr["torrentname"]) . "$ttl$size$seeders$leechers$uploaded\n" . "

$downloaded$ratio\n"; } $ret .= "

\n";
return $ret;
}

$id = 0 + $_GET["id"];

if (!is_valid_id($id))
bark("Bad ID $id.");

$r = @mysql_query("SELECT * FROM users WHERE id=$id") or sqlerr();
$user = mysql_fetch_array($r) or bark("No user with ID $id.");
if ($user["status"] == "pending") die;
if($user["anonymous"] == "no")
$viewprof = 1;
elseif($CURUSER["id"] == '$id' OR get_user_class() >= UC_MODERATOR)
$viewprof = 1;
if($viewprof == 1){
$r = mysql_query("SELECT id, name, seeders, leechers, category FROM torrents WHERE owner=$id ORDER BY name") or sqlerr();
if (mysql_num_rows($r) > 0)
{
$torrents = "\n" .
"TypeName Seeders

class=colhead>Leechers\n";
while ($a = mysql_fetch_assoc($r))
{
$r2 = mysql_query("SELECT name, image FROM categories WHERE id=$a[category]") or sqlerr(__FILE__, __LINE__);
$a2 = mysql_fetch_assoc($r2);
$cat = "";
$torrents .= "$cat" .

htmlspecialchars($a["name"]) . "" .
"

$a[seeders]$a[leechers]\n"; } $torrents .= "

";
}
}

if ($user["ip"] && (get_user_class() >= UC_MODERATOR || $user["id"] == $CURUSER["id"]))
{
$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 = "never";
else
{
$lastseen .= " (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($lastseen)) . " ago)";
}
$res = mysql_query("SELECT COUNT(*) FROM comments WHERE user=" . $user[id]) or sqlerr();
$arr3 = mysql_fetch_row($res);
$torrentcomments = $arr3[0];
$res = mysql_query("SELECT COUNT(*) FROM posts WHERE userid=" . $user[id]) or sqlerr();
$arr3 = mysql_fetch_row($res);
$forumposts = $arr3[0];

//if ($user['donated'] > 0)
// $don = "";

$res = mysql_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 = "