require_once ("include/functions.php");
require_once ("include/config.php");
dbconn();
standardheader('User Details');
block_begin(USER_DETAILS);
$id=intval(0+$_GET["id"]);
if (!isset($_GET["returnto"])) $_GET["returnto"] = "";
$link=$_GET["returnto"];
if ($CURUSER["view_users"]!="yes")
{
err_msg(ERROR,NOT_AUTHORIZED." ".MEMBERS);
block_end();
stdfoot();
die();
}
if ($id!=0) {
$res=mysql_query("SELECT users.avatar,users.email,users.cip,users.username,users.downloaded,users.uploaded,UNIX_TIMESTAMP(users.joined) as joined,UNIX_TIMESTAMP(users.lastconnect) as lastconnect,users_level.level, users.flag, countries.name, countries.flagpic, users.pid FROM users INNER JOIN users_level ON users_level.id=users.id_level LEFT JOIN countries ON users.flag=countries.id WHERE users.id=$id");
$num=mysql_num_rows($res);
if ($num==0)
{
err_msg(ERROR,BAD_ID);
block_end();
stdfoot();
die();
}
else {
$row=mysql_fetch_array($res);
}
}
else
{
err_msg(ERROR,BAD_ID);
block_end();
stdfoot();
die();
}
$utorrents = max(0,$CURUSER["torrentsperpage"]);
print("
\n");
print("\n\n".unesc($row["username"])."
".image_or_link("$STYLEPATH/pm.png","","PM")." | \n");
if ($row["avatar"] && $row["avatar"]!="")
print(" | ");
print("
");
if ($CURUSER["edit_users"]=="yes" || $CURUSER["admin_access"]=="yes")
{
print("\n\n".$row["email"]." |
\n");
print("\n\n".($row["cip"])." |
\n");
print("\n\n$row[level] |
\n");
$colspan=" colspan=2";
}
else
{
print("\n\n$row[level] |
\n");
$colspan="";
}
print("\n\n".($row["joined"]==0 ? "N/A" : get_date_time($row["joined"]))." |
\n");
print("\n\n".($row["lastconnect"]==0 ? "N/A" : get_date_time($row["lastconnect"]))." |
\n");
// flag hack
print("\n\n".($row["flag"]==0 ? "":$row['name'])."  |
\n");
print("\n\n".makesize($row["downloaded"])." |
\n");
print("\n\n".makesize($row["uploaded"])." |
\n");
if (max(0,$row["downloaded"])>0)
{
$sr = $row["uploaded"]/$row["downloaded"];
if ($sr >= 4)
$s = "images/smilies/thumbsup.gif";
else if ($sr >= 2)
$s = "images/smilies/grin.gif";
else if ($sr >= 1)
$s = "images/smilies/smile1.gif";
else if ($sr >= 0.5)
$s = "images/smilies/noexpression.gif";
else if ($sr >= 0.25)
$s = "images/smilies/sad.gif";
else
$s = "images/smilies/thumbsdown.gif";
$ratio=number_format($sr,2)."
";
}
else
$ratio="oo";
print("\n\n$ratio |
\n");
// Only show if forum is internal
if ( $GLOBALS["FORUMLINK"] == '' || $GLOBALS["FORUMLINK"] == 'internal' )
{
$sql = mysql_query("SELECT * FROM posts INNER JOIN users ON posts.userid = users.id WHERE users.id = " . $id);
$posts = mysql_num_rows($sql);
$memberdays = max(1, round( ( time() - $row['joined'] ) / 86400 ));
$posts_per_day = number_format(round($posts / $memberdays,2),2);
print("\n\n" . $posts . " [" . sprintf(POSTS_PER_DAY, $posts_per_day) . "] |
\n");
}
print("
");
block_begin(UPLOADED." ".MNU_TORRENT);
$resuploaded = mysql_query("SELECT namemap.info_hash FROM namemap INNER JOIN summary ON namemap.info_hash=summary.info_hash WHERE uploader=$id AND namemap.anonymous = \"false\" ORDER BY data DESC");
$numtorrent=mysql_num_rows($resuploaded);
if ($numtorrent>0)
{
list($pagertop, $pagerbottom, $limit) = pager(($utorrents==0?15:$utorrents), $numtorrent, $_SERVER["PHP_SELF"]."?id=$id&");
print("$pagertop");
$resuploaded = mysql_query("SELECT namemap.filename, UNIX_TIMESTAMP(namemap.data) as added, namemap.size, summary.seeds, summary.leechers, summary.finished FROM namemap INNER JOIN summary ON namemap.info_hash=summary.info_hash WHERE uploader=$id AND namemap.anonymous = \"false\" ORDER BY data DESC $limit");
}
?>
if ($resuploaded && mysql_num_rows($resuploaded)>0)
{
while ($rest=mysql_fetch_array($resuploaded))
{
print("\n\n".unesc($rest["filename"])." | ");
print("\n".date("d/m/Y",$rest["added"])." | ");
print("\n".makesize($rest["size"])." | ");
print("\n$rest[seeds] | ");
print("\n$rest[leechers] | ");
print("\n".($rest["finished"]>0?$rest["finished"]:"---")." | \n
");
}
print("\n
");
}
else
{
print("\n".NO_TORR_UP_USER." | \n
\n");
}
block_end(); // end uploaded torrents
// active torrents begin - hack by petr1fied - modified by Lupin 20/10/05
block_begin("Active torrents");
?>
if ($PRIVATE_ANNOUNCE)
$anq=mysql_query("SELECT peers.ip FROM peers INNER JOIN namemap ON namemap.info_hash = peers.infohash INNER JOIN summary ON summary.info_hash = peers.infohash
WHERE peers.pid='".$row["pid"]."'");
else
$anq=mysql_query("SELECT peers.ip FROM peers INNER JOIN namemap ON namemap.info_hash = peers.infohash INNER JOIN summary ON summary.info_hash = peers.infohash
WHERE peers.ip='".($row["cip"])."'");
if (mysql_num_rows($anq)>0)
{
list($pagertop, $pagerbottom, $limit) = pager(($utorrents==0?15:$utorrents), mysql_num_rows($anq), $_SERVER["PHP_SELF"]."?id=$id&",array("pagename" => "activepage"));
if ($PRIVATE_ANNOUNCE)
$anq=mysql_query("SELECT peers.ip, namemap.filename, namemap.size, peers.status, peers.downloaded, peers.uploaded
FROM peers INNER JOIN namemap ON namemap.info_hash = peers.infohash INNER JOIN summary ON summary.info_hash = peers.infohash
WHERE peers.pid='".$row["pid"]."' ORDER BY peers.status DESC $limit");
else
$anq=mysql_query("SELECT peers.ip, namemap.filename, namemap.size, peers.status, peers.downloaded, peers.uploaded
FROM peers INNER JOIN namemap ON namemap.info_hash = peers.infohash INNER JOIN summary ON summary.info_hash = peers.infohash
WHERE peers.ip='".($row["cip"])."' ORDER BY peers.status DESC $limit");
print("$pagertop
");
while ($torlist = mysql_fetch_object($anq))
{
if ($torlist->ip !="")
{
print("\n\n".unesc($torlist->filename)." | ");
print("\n".makesize($torlist->size)." | ");
print("\n".unesc($torlist->status)." | ");
print("\n".makesize($torlist->downloaded)." | ");
print("\n".makesize($torlist->uploaded)." | ");
if ($torlist->downloaded>0)
$peerratio=number_format($torlist->uploaded/$torlist->downloaded,2);
else
$peerratio="oo";
print("\n".unesc($peerratio)." | \n
");
}
}
print("\n
");
} else print("\nno Active torrents for this user | \n
\n");
block_end(); // end active torrents
// history - completed torrents by this user
block_begin("History (snatched torrents)");
?>
mysql_free_result($anq);
$anq=mysql_query("SELECT history.uid FROM history INNER JOIN namemap ON history.infohash=namemap.info_hash WHERE history.uid=$id ORDER BY date DESC");
if (mysql_num_rows($anq)>0)
{
list($pagertop, $pagerbottom, $limit) = pager(($utorrents==0?15:$utorrents), mysql_num_rows($anq), $_SERVER["PHP_SELF"]."?id=$id&",array("pagename" => "historypage"));
$anq=mysql_query("SELECT namemap.filename, namemap.size, history.active, history.agent, history.downloaded, history.uploaded FROM history INNER JOIN namemap ON history.infohash=namemap.info_hash WHERE history.uid=$id ORDER BY date DESC $limit");
print("$pagertop
");
while ($torlist = mysql_fetch_object($anq))
{
print("\n\n".unesc($torlist->filename)." | ");
print("\n".makesize($torlist->size)." | ");
print("\n".htmlspecialchars($torlist->agent)." | ");
print("\n".($torlist->active=='yes'?ACTIVATED:'Stopped')." | ");
print("\n".makesize($torlist->downloaded)." | ");
print("\n".makesize($torlist->uploaded)." | ");
if ($torlist->downloaded>0)
$peerratio=number_format($torlist->uploaded/$torlist->downloaded,2);
else
$peerratio="oo";
print("\n".unesc($peerratio)." | \n
");
}
print("\n
");
} else print("\nno history for this user | \n
\n");
block_end(); // end history
print("
".BACK."
\n");
block_end();
stdfoot();
?>