<?php

ob_start("ob_gzhandler");

require_once "include/bittorrent.php";

require_once "include/user_functions.php";

require_once "include/pager_functions.php";

require_once "include/html_functions.php";

require_once "include/bbcode_functions.php";

dbconn(false);

loggedinorreturn();

$userid = (int)$_GET["id"];

if (!is_valid_id($userid)) stderr("Error", "Invalid ID");

if ($CURUSER['class']< UC_POWER_USER || ($CURUSER["id"] != $userid && $CURUSER['class'] < UC_MODERATOR))

stderr("Error", "Permission denied");

$page = (isset($_GET['page'])?$_GET["page"]:''); // not used?

$action = (isset($_GET['action'])?$_GET["action"]:'');

//-------- Global variables

$perpage = 25;

//-------- Action: View posts

if ($action == "viewposts")

{

$select_is = "COUNT(DISTINCT p.id)";

$from_is = "posts AS p LEFT JOIN topics as t ON p.topicid = t.id LEFT JOIN forums AS f ON t.forumid = f.id";

$where_is = "p.userid = $userid AND f.minclassread <= " . $CURUSER['class'];

$order_is = "p.id DESC";

$query = "SELECT $select_is FROM $from_is WHERE $where_is";

$res = mysql_query($query) or sqlerr(__FILE__, __LINE__);

$arr = mysql_fetch_row($res) or stderr("Error", "No posts found");

$postcount = $arr[0];

//------ Make page menu

$pager = pager($perpage, $postcount, "userhistory.php?action=viewposts&amp;id=$userid&amp;");

//------ Get user data

$res = mysql_query("SELECT username, donor, warned, enabled FROM users WHERE id=$userid") or sqlerr(__FILE__, __LINE__);

if (mysql_num_rows($res) == 1)

{

$arr = mysql_fetch_assoc($res);

$subject = "<a href='userdetails.php?id=$userid'><b>$arr[username]</b></a>" . get_user_icons($arr, true);

}

else

$subject = "unknown[$userid]";

//------ Get posts

$from_is = "posts AS p LEFT JOIN topics as t ON p.topicid = t.id LEFT JOIN forums AS f ON t.forumid = f.id LEFT JOIN readposts as r ON p.topicid = r.topicid AND p.userid = r.userid";

$select_is = "f.id AS f_id, f.name, t.id AS t_id, t.subject, t.lastpost, r.lastpostread, p.*";

$query = "SELECT $select_is FROM $from_is WHERE $where_is ORDER BY $order_is {$pager['limit']}";

$res = mysql_query($query) or sqlerr(__FILE__, __LINE__);

if (mysql_num_rows($res) == 0) stderr("Error", "No posts found");

stdhead("Posts history");

print("<h1>Post history for $subject</h1>\n");

if ($postcount > $perpage) echo $pager['pagertop'];

//------ Print table

begin_main_frame();

begin_frame();

while ($arr = mysql_fetch_assoc($res))

{

$postid = $arr["id"];

$posterid = $arr["userid"];

$topicid = $arr["t_id"];

$topicname = $arr["subject"];

$forumid = $arr["f_id"];

$forumname = $arr["name"];

$dt = (time() - $READPOST_EXPIRY);

$newposts = 0;

if ($arr['added'] > $dt)

$newposts = ($arr["lastpostread"] < $arr["lastpost"]) && $CURUSER["id"] == $userid;

$added = get_date( $arr['added'],'');

print("<div class='sub'><table border='0' cellspacing='0' cellpadding='0'><tr><td class='embedded'>

$added&nbsp;--&nbsp;<b>Forum:&nbsp;</b>

<a href='forums.php?action=viewforum&amp;forumid=$forumid'>$forumname</a>

&nbsp;--&nbsp;<b>Topic:&nbsp;</b>

<a href='forums.php?action=viewtopic&amp;topicid=$topicid'>$topicname</a>

&nbsp;--&nbsp;<b>Post:&nbsp;</b>

#<a href='forums.php?action=viewtopic&amp;topicid=$topicid&amp;page=p$postid#$postid'>$postid</a>" .

($newposts ? " &nbsp;<b>(<font color='red'>NEW!</font>)</b>" : "") .

"</td></tr></table></div>\n");

begin_table(true);

$body = format_comment($arr["body"]);

if (is_valid_id($arr['editedby']))

{

$subres = mysql_query("SELECT username FROM users WHERE id=$arr[editedby]");

if (mysql_num_rows($subres) == 1)

{

$subrow = mysql_fetch_assoc($subres);

$body .= "<p><font size='1' class='small'>Last edited by <a href='userdetails.php?id=$arr[editedby]'><b>$subrow[username]</b></a> at $arr[editedat] GMT</font></p>\n";

}

}

print("<tr valign='top'><td class='comment'>$body</td></tr>\n");

end_table();

}

end_frame();

end_main_frame();

if ($postcount > $perpage) echo $pager['pagerbottom'];

stdfoot();

die;

}

//-------- Action: View comments

if ($action == "viewcomments")

{

$select_is = "COUNT(*)";

// LEFT due to orphan comments

$from_is = "comments AS c LEFT JOIN torrents as t

ON c.torrent = t.id";

$where_is = "c.user = $userid";

$order_is = "c.id DESC";

$query = "SELECT $select_is FROM $from_is WHERE $where_is ORDER BY $order_is";

$res = mysql_query($query) or sqlerr(__FILE__, __LINE__);

$arr = mysql_fetch_row($res) or stderr("Error", "No comments found");

$commentcount = $arr[0];

//------ Make page menu

$pager = pager($perpage, $commentcount, "userhistory.php?action=viewcomments&amp;id=$userid&amp;");

//------ Get user data

$res = mysql_query("SELECT username, donor, warned, enabled FROM users WHERE id=$userid") or sqlerr(__FILE__, __LINE__);

if (mysql_num_rows($res) == 1)

{

$arr = mysql_fetch_assoc($res);

$subject = "<a href='userdetails.php?id=$userid'><b>$arr[username]</b></a>" . get_user_icons($arr, true);

}

else

$subject = "unknown[$userid]";

//------ Get comments

$select_is = "t.name, c.torrent AS t_id, c.id, c.added, c.text";

$query = "SELECT $select_is FROM $from_is WHERE $where_is ORDER BY $order_is {$pager['limit']}";

$res = mysql_query($query) or sqlerr(__FILE__, __LINE__);

if (mysql_num_rows($res) == 0) stderr("Error", "No comments found");

stdhead("Comments history");

print("<h1>Comments history for $subject</h1>\n");

if ($commentcount > $perpage) echo $pager['pagertop'];

//------ Print table

begin_main_frame();

begin_frame();

while ($arr = mysql_fetch_assoc($res))

{

$commentid = $arr["id"];

$torrent = $arr["name"];

// make sure the line doesn't wrap

if (strlen($torrent) > 55) $torrent = substr($torrent,0,52) . "...";

$torrentid = $arr["t_id"];

//find the page; this code should probably be in details.php instead

$subres = mysql_query("SELECT COUNT(*) FROM comments WHERE torrent = $torrentid AND id < $commentid")

or sqlerr(__FILE__, __LINE__);

$subrow = mysql_fetch_row($subres);

$count = $subrow[0];

$comm_page = floor($count/20);

$page_url = $comm_page?"&amp;page=$comm_page":"";

$added = get_date( $arr['added'],'') . " (" . get_date( $arr['added'],'',0,1) . ")";

print("<div class='sub'><table border='0' cellspacing='0' cellpadding='0'><tr><td class='embedded'>".

"$added&nbsp;---&nbsp;<b>Torrent:&nbsp;</b>".

($torrent?("<a href='details.php?id=$torrentid&amp;tocomm=1'>$torrent</a>"):" [Deleted] ").

"&nbsp;---&nbsp;<b>Comment:&nbsp;</b>#<a href='details.php?id=$torrentid&amp;tocomm=1$page_url'>$commentid</a>

</td></tr></table></div>\n");

begin_table(true);

$body = format_comment($arr["text"]);

print("<tr valign='top'><td class='comment'>$body</td></tr>\n");

end_table();

}

end_frame();

end_main_frame();

if ($commentcount > $perpage) echo $pager['pagerbottom'];

stdfoot();

die;

}

//-------- Handle unknown action

if ($action != "")

stderr("History Error", "Unknown action.");

//-------- Any other case

stderr("History Error", "Invalid or no query.");

?>