print "<td class=bottom width=50%> </td></tr></table>\n"; } if (isset($friends)) { print $friends; } print "</td></tr></table>\n"; print "</td></tr></table>\n"; print "<h1>Comments for <a href=userdetails.php?id={$userid}>" . $user["username"] . "</a></h1>\n"; print "<p><a name=\"startcomments\"></a></p>\n"; $commentbar = "<p align=center><a class=index href=usercomment.php?action=add&userid={$userid}>Add a comment</a></p>\n"; $subres = mysql_query("SELECT COUNT(*) FROM usercomments WHERE userid = {$userid}"); $subrow = mysql_fetch_array($subres, MYSQL_NUM); $count = $subrow[0]; if (!$count) { print "<h2>No comments yet</h2>\n"; } else { $pager = pager(20, $count, "userfriends.php?id={$userid}&", array('lastpagedefault' => 1)); $subres = mysql_query("SELECT usercomments.id, text, user, usercomments.added, editedby, editedat, avatar, warned, " . "username, title, class, donor FROM usercomments LEFT JOIN users ON usercomments.user = users.id WHERE userid = " . "{$userid} ORDER BY usercomments.id " . $pager['limit']) or sqlerr(__FILE__, __LINE__); $allrows = array(); while ($subrow = mysql_fetch_assoc($subres)) { $allrows[] = $subrow; } print $commentbar; print $pager['pagertop']; usercommenttable($allrows); print $pager['pagerbottom']; } print $commentbar; print "<p><a href=users.php><b>Find User/Browse User List</b></a></p>"; end_frame(); stdfoot();
$htmlout .= "</table>"; } $htmlout .= end_frame(); $htmlout .= "</td></tr></table>"; return $htmlout; } //==Usercomments - pdq $HTMLOUT .= "<h1>{$lang['userdetails_comm_left']}<a href='userdetails.php?id={$id}'>" . htmlsafechars($user['username']) . "</a></h1>\n <a name='startcomments'></a>"; $commentbar = "<a href='usercomment.php?action=add&userid={$id}'>Add a comment</a>\n"; $subres = sql_query("SELECT COUNT(id) FROM usercomments WHERE userid = " . sqlesc($id)); $subrow = mysqli_fetch_array($subres, MYSQLI_NUM); $count = $subrow[0]; if (!$count) { $HTMLOUT .= "<h2>{$lang['userdetails_comm_yet']}</h2>\n"; } else { require_once INCL_DIR . 'pager_functions.php'; $pager = pager(5, $count, "userdetails.php?id={$id}&", array('lastpagedefault' => 1)); $subres = sql_query("SELECT usercomments.id, text, user, usercomments.added, editedby, editedat, edit_name, avatar, warned, username, title, class, leechwarn, chatpost, pirate, king, donor FROM usercomments LEFT JOIN users ON usercomments.user = users.id WHERE userid = {$id} ORDER BY usercomments.id {$pager['limit']}") or sqlerr(__FILE__, __LINE__); $allrows = array(); while ($subrow = mysqli_fetch_assoc($subres)) { $allrows[] = $subrow; } $HTMLOUT .= $commentbar; $HTMLOUT .= $pager['pagertop']; $HTMLOUT .= usercommenttable($allrows); $HTMLOUT .= $pager['pagerbottom']; } $HTMLOUT .= $commentbar; //==end // End Class // End File