function showTopic($topicid, $showfull = TRUE)
{
global $conn;
global $userid;
global $limit;
echo breadcrumb($topicid, "P");
if (isset($_GET['page'])) {
$page = $_GET['page'];
} else {
$page = 1;
}
if ($limit == "") {
$limit = 25;
}
$start = ($page - 1) * $limit;
if (isset($_SESSION['user_id'])) {
echo topicReplyBar($topicid, getForumID($topicid), "right");
}
$sql = "SELECT SQL_CALC_FOUND_ROWS " . "p.id, p.subject, p.body, p.date_posted, " . "p.date_updated, u.username as author, u.id as author_id, " . "c.post_count as postcount, " . "p.forum_id as forum_id, f.forum_moderator as mod, " . "p.update_id, u2.username as updated_by " . "FROM forum f " . "JOIN posts p " . "ON f.id = p.forum_id " . "JOIN login u " . "ON u.id = p.author_id " . "LEFT JOIN login u2 " . "ON u2.id = p.update_id " . "LEFT JOIN info c " . "ON u.id = c.user_id " . "WHERE (p.topic_id = {$topicid} OR p.id = {$topicid}) " . "ORDER BY p.topic_id, p.date_posted " . "LIMIT {$start}, {$limit}";
$result = mysql_query($sql, $db) or die(mysql_error() . "<br />" . $sql);
$pagelinks = paginate($limit);
if (mysql_num_rows($result) == 0) {
$msg = "There are currently no posts.Would you like to be the first person to create a thread?";
$title = "No Posts...";
$dest = "./frm_compose.php?forumid=" . $forumid;
$sev = "Info";
$message = msgBox($msg, $title, $dest, $sev);
echo $message;
} else {
echo "<table class='forumtable' cellspacing='0' ";
echo "cellpadding='2'><tr>";
echo "<th class='author'>Author</th>";
echo "<th class='post'>Post</th>";
echo "</tr>";
while ($row = mysql_fetch_array($result)) {
$lastupdate = "";
$editlink = "";
$dellink = "";
$replylink = " ";
$pcount = "";
$pdate = "";
$sig = "";
if ($showfull) {
$body = $row['body'];
if (isset($_SESSION['user_id'])) {
$replylink = "<a href='frm_compose.php?forumid=" . $row['forum_id'] . "&topicid={$topicid}&reid=" . $row['id'] . "' class='buttonlink'>REPLY</a> ";
} else {
$replylink = "";
}
if ($row['update_id'] > 0) {
$lastupdate = "<p class='smallNote'>Last updated: " . $row['date_updated'] . " by " . $row['updated_by'] . "</p>";
}
if ($userid == $row['author_id'] or $userid == $row['mod'] or $_SESSION['access_lvl'] > 1) {
$editlink = "<a href='frm_compose.php?a=edit&post=" . $row['id'] . "' class='buttonlink'>EDIT</a> ";
$dellink = "<a href='frm_transact_affirm.php?action=deletepost&id=" . $row['id'] . "' class='buttonlink'>DELETE</a> ";
}
$pcount = "<br /><span class='textsmall'>Posts: " . ($row['postcount'] == "" ? "0" : $row['postcount']) . "</span>";
$pdate = $row['date_posted'];
$sig = ($row['sig'] != "" ? "<p class='sig'>" . nl2br($row['sig']) : "") . "</p>";
} else {
$body = trimBody($body);
}
$rowclass = $rowclass == "row1" ? "row2" : "row1";
echo "<tr class='{$rowclass}'>";
echo "<td class='author'>" . $row['author'];
echo $pcount;
echo "</td><td class='post'><p>";
if (isset($_SESSION['user_id']) and $_SESSION['last_login'] < $row['date_posted']) {
echo NEWPOST . " ";
}
if (isset($_GET['page'])) {
$pagelink = "&page=" . $_GET['page'];
}
echo "<a name='post" . $row['id'] . "' href='frm_view_topic.php?t=" . $topicid . $pagelink . "#post" . $row['id'] . "'>" . POSTLINK . "</a>";
if (isset($row['subject'])) {
echo " <strong>" . $row['subject'] . "</strong>";
}
echo "</p><p>" . nl2br(htmlspecialchars($body)) . "</p>";
echo $sig;
echo $lastupdate;
echo "</td></tr>";
echo "<tr class='{$rowclass}'><td class='authorfooter'>";
echo $pdate . "</td><td class='threadfooter'>";
echo $replylink;
echo $editlink;
echo $dellink;
echo "</td></tr>\n";
}
echo "</table>";
echo $pagelinks;
echo "<p>" . NEWPOST . " = New Post ";
echo POSTLINK . " = Post link (use to bookmark)</p>";
}
}
$sql = "UNLOCK TABLES";
mysql_query($sql) or die(mysql_error() . "<br />" . $sql);
// die('stop');
$sql = "SELECT SQL_CALC_FOUND_ROWS " . "t.id as topic_id, t.subject as t_subject, " . "u.name as t_author, count(p.id) as numreplies, " . "t.date_posted as t_posted, tmp.postdate as re_posted " . "FROM forum_users u " . "JOIN forum_posts t " . "ON t.author_id = u.id " . "LEFT JOIN tmp " . "ON t.id = tmp.topic_id " . "LEFT JOIN forum_posts p " . "ON p.topic_id = t.id " . "WHERE t.forum_id = {$forumid} " . "AND t.topic_id = 0 " . "GROUP BY t.id " . "ORDER BY re_posted DESC " . "LIMIT {$start}, {$limit}";
$result = mysql_query($sql) or die(mysql_error() . "<br />" . $sql);
$numrows = mysql_num_rows($result);
if ($numrows == 0) {
$msg = "There are currently no posts.Would you like to be the first person to create a thread?";
$title = "Welcome to " . $forum['name'];
$dest = "compose.php?forumid=" . $forumid;
$sev = "Info";
$message = msgBox($msg, $title, $dest, $sev);
echo $message;
} else {
if (isset($_SESSION['user_id'])) {
echo topicReplyBar(0, $_GET['f'], "right");
}
echo "<table class='forumtable' cellspacing='0' cellpadding='2'><tr>";
echo "<th class='thread'>Thread</th>";
echo "<th class='author'>Author</th>";
echo "<th class='replies'>Replies</th>";
echo "<th class='lastpost'>Last Post</th>";
echo "</tr>";
while ($row = mysql_fetch_array($result)) {
$rowclass = $rowclass == "row1" ? "row2" : "row1";
if ($row['re_posted'] == "") {
$lastpost = $row['t_posted'];
} else {
$lastpost = $row['re_posted'];
}
if (isset($_SESSION['user_id']) and $_SESSION['last_login'] < $lastpost) {
