+$order_sql = (!isset($post_id)) ? "" : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC";

+$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . "

+// Is user watching this thread? This could potentially

+ $sql = "SELECT notify_status

+ FROM " . TOPICS_WATCH_TABLE . "

+ WHERE topic_id = $topic_id

+ $sql = "DELETE $sql_priority FROM " . TOPICS_WATCH_TABLE . "

+ WHERE topic_id = $topic_id

+ $sql = "UPDATE $sql_priority " . TOPICS_WATCH_TABLE . "

+ SET notify_status = 0

+ WHERE topic_id = $topic_id

+ $sql = "INSERT $sql_priority INTO " . TOPICS_WATCH_TABLE . " (user_id, topic_id, notify_status)

+

+ $total_replies = ( $row = $db->sql_fetchrow($result) ) ? $row['num_posts'] : 0;

+$orig_word = array();

+$replacement_word = array();

+obtain_word_list($orig_word, $replacement_word);

+ "L_DISPLAY_POSTS" => $lang['Display_posts'],

+ "L_RETURN_TO_TOP" => $lang['Return_to_top'],

+// Does this topic contain a voting element?

+//

+if( !empty($forum_row['topic_vote']) )

+{

+ $sql = "SELECT vd.vote_id, vd.vote_text, vd.vote_start, vd.vote_length, vr.vote_option_id, vr.vote_option_text, vr.vote_result

+ FROM " . VOTE_DESC_TABLE . " vd, " . VOTE_RESULTS_TABLE . " vr

+ WHERE vd.topic_id = $topic_id

+ AND vr.vote_id = vd.vote_id

+ ORDER BY vr.vote_option_id ASC";

+ if( !$result = $db->sql_query($sql) )

+ {

+ message_die(GENERAL_ERROR, "Couldn't obtain vote data for this topic", "", __LINE__, __FILE__, $sql);

+ }

+

+ if( $vote_options = $db->sql_numrows($result) )

+ {

+ $vote_info = $db->sql_fetchrowset($result);

+

+ $vote_id = $vote_info[0]['vote_id'];

+ $vote_title = $vote_info[0]['vote_text'];

+

+ $sql = "SELECT vote_id

+ FROM " . VOTE_USERS_TABLE . "

+ WHERE vote_id = $vote_id

+ AND vote_user_id = " . $userdata['user_id'];

+ if( !$result = $db->sql_query($sql) )

+ {

+ message_die(GENERAL_ERROR, "Couldn't obtain user vote data for this topic", "", __LINE__, __FILE__, $sql);

+ }

+

+ $user_voted = ( $db->sql_numrows($result) ) ? TRUE : 0;

+

+ if( isset($HTTP_GET_VARS['vote']) || isset($HTTP_POST_VARS['vote']) )

+ {

+ $view_result = ( ( ( isset($HTTP_GET_VARS['vote']) ) ? $HTTP_GET_VARS['vote'] : $HTTP_POST_VARS['vote'] ) == "viewresult" ) ? TRUE : 0;

+ }

+ else

+ {

+ $view_result = 0;

+ }

+

+ $poll_expired = ( $vote_info[0]['vote_length'] ) ? ( ( $vote_info[0]['vote_start'] + $vote_info[0]['vote_length'] < time() ) ? TRUE : 0 ) : 0;

+

+ if( $user_voted || $view_result || $poll_expired || !$is_auth['auth_vote'] )

+ {

+

+ $template->set_filenames(array(

+ "pollbox" => "viewtopic_poll_result.tpl")

+ );

+

+ $vote_results_sum = 0;

+

+ for($i = 0; $i < $vote_options; $i++)

+ {

+ $vote_results_sum += $vote_info[$i]['vote_result'];

+ }

+

+ $vote_graphic = 0;

+ $vote_graphic_max = count($images['voting_graphic']);

+

+ for($i = 0; $i < $vote_options; $i++)

+ {

+ $vote_percent = ( $vote_results_sum > 0 ) ? $vote_info[$i]['vote_result'] / $vote_results_sum : 0;

+ $vote_graphic_length = round($vote_percent * $board_config['vote_graphic_length']);

+

+ $vote_graphic_img = $images['voting_graphic'][$vote_graphic];

+ $vote_graphic = ($vote_graphic < $vote_graphic_max - 1) ? $vote_graphic + 1 : 0;

+

+ $template->assign_block_vars("poll_option", array(

+ "POLL_OPTION_CAPTION" => $vote_info[$i]['vote_option_text'],

+ "POLL_OPTION_RESULT" => $vote_info[$i]['vote_result'],

+ "POLL_OPTION_PERCENT" => sprintf("%.1d%%", ($vote_percent * 100)),

+

+ "POLL_OPTION_IMG" => $vote_graphic_img,

+ "POLL_OPTION_IMG_WIDTH" => $vote_graphic_length)

+ );

+ }

+

+ $template->assign_vars(array(

+ "TOTAL_VOTES" => $vote_results_sum)

+ );

+

+ }

+ else

+ {

+ $template->set_filenames(array(

+ "pollbox" => "viewtopic_poll_ballot.tpl")

+ );

+

+ for($i = 0; $i < $vote_options; $i++)

+ {

+ $template->assign_block_vars("poll_option", array(

+ "POLL_OPTION_ID" => $vote_info[$i]['vote_option_id'],

+ "POLL_OPTION_CAPTION" => $vote_info[$i]['vote_option_text'])

+ );

+ }

+

+ $template->assign_vars(array(

+ "L_SUBMIT_VOTE" => $lang['Submit_vote'],

+ "L_VIEW_RESULTS" => $lang['View_results'],

+

+ "U_VIEW_RESULTS" => append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&amp;postdays=$post_days&amp;postorder=$post_order&amp;vote=viewresult"))

+ );

+

+ $s_hidden_fields = '<input type="hidden" name="topic_id" value="' . $topic_id . '"><input type="hidden" name="mode" value="vote">';

+ }

+

+ $template->assign_vars(array(

+ "POLL_QUESTION" => $vote_title,

+

+ "S_HIDDEN_FIELDS" => $s_hidden_fields,

+ "S_VOTE_ACTION" => append_sid("posting.$phpEx?" . POST_TOPIC_URL . "=$topic_id"))

+ );

+

+ $template->assign_var_from_handle("POLL_DISPLAY", "pollbox");

+

+ }

+}

+

+//

+ $poster = $postrow[$i]['username'];

+ $poster_from = ($postrow[$i]['user_from'] && $postrow[$i]['user_id'] != ANONYMOUS) ? $lang['From'] . ": " . $postrow[$i]['user_from'] : "";

+ $poster_avatar = (eregi("http", $postrow[$i]['user_avatar']) && $board_config['allow_avatar_remote']) ? "<br /><img src=\"" . $postrow[$i]['user_avatar'] . "\"><br />" : "<br /><img src=\"" . $board_config['avatar_path'] . "/" . $postrow[$i]['user_avatar'] . "\" alt=\"\" /><br />";

+ $poster_rank = $ranksrow[$j]['rank_title'];

+ $rank_image = ($ranksrow[$j]['rank_image']) ? "<img src=\"" . $ranksrow[$j]['rank_image'] . "\"><br />" : "";

+ $poster_rank = $ranksrow[$j]['rank_title'];

+ $rank_image = ($ranksrow[$j]['rank_image']) ? "<img src=\"" . $ranksrow[$j]['rank_image'] . "\"><br />" : "";

+ $poster = $postrow[$i]['post_username'];

+ $email_addr = str_replace("@", " at ", $postrow[$i]['user_email']);

+ $www_img = ($postrow[$i]['user_website']) ? "<a href=\"" . $postrow[$i]['user_website'] . "\" target=\"_userwww\"><img src=\"" . $images['icon_www'] . "\" alt=\"" . $lang['Visit_website'] . "\" border=\"0\" /></a>" : "";

+ $icq_status_img = "<a href=\"http://wwp.icq.com/" . $postrow[$i]['user_icq'] . "#pager\"><img src=\"http://online.mirabilis.com/scripts/online.dll?icq=" . $postrow[$i]['user_icq'] . "&amp;img=5\" border=\"0\" /></a>";

+ $icq_add_img = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=" . $postrow[$i]['user_icq'] . "\"><img src=\"" . $images['icon_icq'] . "\" alt=\"" . $lang['ICQ'] . "\" border=\"0\" /></a>";

+ $yim_img = ($postrow[$i]['user_yim']) ? "<a href=\"http://edit.yahoo.com/config/send_webmesg?.target=" . $postrow[$i]['user_yim'] . "&amp;.src=pg\"><img src=\"" . $images['icon_yim'] . "\" border=\"0\" alt=\"" . $lang['YIM'] . "\" /></a>" : "";

+ $quote_img = "<a href=\"" . append_sid("posting.$phpEx?mode=quote&amp;" . POST_POST_URL . "=" . $postrow[$i]['post_id']) . "\"><img src=\"" . $images['icon_quote'] . "\" alt=\"" . $lang['Reply_with_quote'] ."\" border=\"0\" /></a>";

+ $search_img = "<a href=\"" . append_sid("search.$phpEx?a=" . urlencode($poster) . "&amp;f=all&amp;b=0&amp;d=DESC&amp;c=100&amp;dosearch=1") . "\"><img src=\"" . $images['icon_search'] . "\" border=\"0\" /></a>";

+ if( ( $userdata['user_id'] == $poster_id && $is_auth['auth_edit'] ) || $is_auth['auth_mod'] )

+ {

+ $edit_img = "<a href=\"" . append_sid("posting.$phpEx?mode=editpost&amp;" . POST_POST_URL . "=" . $postrow[$i]['post_id']) . "\"><img src=\"" . $images['icon_edit'] . "\" alt=\"" . $lang['Edit_delete_post'] . "\" border=\"0\" /></a>";

+ }

+ else

+ {

+ $edit_img = "";

+ }

+ $ip_img = "<a href=\"" . append_sid("modcp.$phpEx?mode=viewip&amp;" . POST_POST_URL . "=" . $post_id) . "\"><img src=\"" . $images['icon_ip'] . "\" alt=\"" . $lang['View_IP'] . "\" border=\"0\" /></a>";

+ else

+ {

+ $ip_img = "";

+ $delpost_img = "";

+ }

+

+ $message = $postrow[$i]['post_text'];

+ $post_subject = ( $postrow[$i]['post_subject'] != "" ) ? $postrow[$i]['post_subject'] : $topic_title;

+ $user_sig = $postrow[$i]['user_sig'];

+ //

+ // If the board has HTML off but the post has HTML

+ // on then we process it, else leave it alone

+ //

+ if( !$board_config['allow_html'] )

+ $user_sig = preg_replace("#(<)([\/]?.*?)(>)#is", "&lt;\\2&gt;", $user_sig);

+ }

+

+ if( $postrow[$i]['enable_html'] )

+ {

+ $message = preg_replace("#(<)([\/]?.*?)(>)#is", "&lt;\\2&gt;", $message);

+ if( $board_config['allow_bbcode'] && $bbcode_uid != "" )

+ else if( !$board_config['allow_bbcode'] && $bbcode != "" )

+ "S_AUTH_LIST" => $s_auth_can,

+ "S_AUTH_READ_IMG" => $s_auth_read_img,

+ "S_AUTH_POST_IMG" => $s_auth_post_img,

+ "S_AUTH_REPLY_IMG" => $s_auth_reply_img,

+ "S_AUTH_EDIT_IMG" => $s_auth_edit_img,

+ "S_TOPIC_ADMIN" => $topic_mod,

+ "S_WATCH_TOPIC" => $s_watching_topic,

+ "S_WATCH_TOPIC_IMG" => $s_watching_topic_img,