/dead/userhistory.php

<?

ob_start("ob_gzhandler");

require "include/bittorrent.php";



dbconn(false);

loggedinorreturn();



$userid = $_GET["id"];



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



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

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



$page = $_GET["page"];



$action = $_GET["action"];



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



$perpage = 25;



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



if ($action == "viewposts")

{

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



	$from_is = "posts AS p JOIN topics as t ON p.topicid = t.id 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 mysql_error();



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



	$postcount = $arr[0];



	//------ Make page menu



	list($pagertop, $pagerbottom, $limit) = pager($perpage, $postcount, $_SERVER["PHP_SELF"] . "?action=viewposts&id=$userid&");



	//------ Get user data



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



	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 JOIN topics as t ON p.topicid = t.id 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 $limit";



	$res = mysql_query($query) or mysql_error();



	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 $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"];



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



	    $added = $arr["added"] . " GMT (" . (get_elapsed_time(sql_timestamp_to_unix_timestamp($arr["added"]))) . " ago)";



	    print("<p 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&forumid=$forumid>$forumname</a>

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

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

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

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

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

	    "</td></tr></table></p>\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 $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 mysql_error();



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



	$commentcount = $arr[0];



	//------ Make page menu



	list($pagertop, $pagerbottom, $limit) = pager($perpage, $commentcount, $_SERVER["PHP_SELF"] . "?action=viewcomments&id=$userid&");



	//------ Get user data



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



	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 $limit";



	$res = mysql_query($query) or mysql_error();



	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 $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 mysql_error();

	  $subrow = mysql_fetch_row($subres);

    $count = $subrow[0];

    $comm_page = floor($count/20);

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



	  $added = $arr["added"] . " GMT (" . (get_elapsed_time(sql_timestamp_to_unix_timestamp($arr["added"]))) . " ago)";



	  print("<p 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&tocomm=1>$torrent</a>"):" [Deleted] ").

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

	  </td></tr></table></p>\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 $pagerbottom;



	stdfoot();



	die;

}



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



if ($action != "")

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



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



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



?>