$query = "SELECT COUNT(*) FROM {$forum_post_table} WHERE topic_id='{$id}'"; $result = $db->query($query); $row = $result->fetch_assoc(); $numrows = $row['COUNT(*)']; $result->free_result(); if ($numrows == 0) { header("Location: index.php?page=forum&s=list"); exit; } $pg = "forum2"; require "includes/header.php"; $query = "SELECT t1.id, t1.title, t1.post, t1.author, t1.creation_date, t2.creation_post FROM {$forum_post_table} AS t1 JOIN {$forum_topic_table} AS t2 ON t2.id=t1.topic_id WHERE t1.topic_id='{$id}' ORDER BY id LIMIT {$page}, {$limit}"; $result = $db->query($query) or die(mysql_error()); print '<div style="margin-left: 15px; margin-right: 15px;"><div id="forum" class="response-list">'; while ($row = $result->fetch_assoc()) { $date_made = $misc->date_words($row['creation_date']); print '<div class="post"><div class="author"> <h6 class="author"><a name="' . $row['id'] . '"></a><a href="index.php?page=account_profile&uname=' . $row['author'] . '" style="font-size: 14px;">' . $row['author'] . '</a></h6> <span class="date">' . $date_made . ' </span> </div><div class="content"> <h6 class="response-title">' . $row['title'] . '</h6> <div class="body">' . $misc->short_url($misc->swap_bbs_tags($misc->linebreaks($row['post']))) . '</div> <div class="footer">'; if ($uname == $row['author'] || $user->gotpermission('edit_forum_posts')) { echo '<a href="#" onclick="showHide(\'c' . $row['id'] . '\'); return false;">edit</a> |'; } else { echo '<a href="">edit</a> |'; } echo ' <a href="#" onclick="javascript:document.getElementById(\'reply_box\').value=document.getElementById(\'reply_box\').value+\'[quote]' . $row['author'] . ' said:\\r\\n' . str_replace("'", "\\'", str_replace("\r\n", '\\r\\n', str_replace(''', "'", $row['post']))) . '[/quote]\'; return false;">quote</a> '; if ($user->gotpermission('delete_forum_posts') && $row['id'] != $row['creation_post']) { print ' | <a href="index.php?page=forum&s=remove&pid=' . $id . '&cid=' . $row['id'] . '">remove</a><br />';
if ($search != "") { $query = "SELECT t1.id, t1.topic, t1.last_updated, t1.priority, t1.author FROM {$forum_topic_table} AS t1 JOIN {$forum_post_table} AS t2 ON (MATCH(t2.post) AGAINST({$search})>0.5) ORDER BY t1.priority DESC, t1.last_updated DESC LIMIT {$page}, {$limit}"; } else { $query = "SELECT id, topic, last_updated, author, locked, priority FROM {$forum_topic_table} ORDER BY priority DESC, last_updated DESC LIMIT {$page}, {$limit}"; } $result = $db->query($query) or die($db->error()); if ($user->gotpermission('delete_forum_topics') || $user->gotpermission('pin_forum_topics')) { print '<th width="10%">Tools</th>'; } echo '</tr>'; while ($row = $result->fetch_assoc()) { $que = "SELECT COUNT(*) FROM {$forum_post_table} WHERE topic_id='" . $row['id'] . "'"; $res = $db->query($que) or die($db->error()); $ret = $res->fetch_assoc(); $replies = $ret['COUNT(*)'] - 1; $date_now = $misc->date_words($row['last_updated']); $sticky = ""; $locked = ""; if ($row['priority'] == "1") { $sticky = "Sticky: "; } if ($row['locked'] == "1") { $locked = ' <span class="locked-topic">(locked)</span>'; } print '<tr>'; print '<td>' . $sticky . '<a href="?page=forum&s=view&id=' . $row['id'] . '">' . $row['topic'] . '</a>' . $locked . '</td><td>' . $row['author'] . '</td><td>' . $date_now . '</td><td>' . $replies . '</td>'; if ($row['priority'] == 0) { if ($user->gotpermission('pin_forum_topics')) { print '<td><a href="index.php?page=forum&s=edit&pin=1&id=' . $row['id'] . '&pid=' . $page . '">Pin</a> | '; } } else {