}

// Find topic id if user requested a newer or older topic

if ($view && !$post_id)

{

if (!$forum_id)

if ($view == 'unread')

{

$sql = 'SELECT p.post_id, p.topic_id, p.forum_id

FROM (' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . " t)

}

$db->sql_freeresult($result);

$topic_id = $row['topic_id'];

}

else if ($view == 'next' || $view == 'previous')

}

}

// This rather complex gaggle of code handles querying for topics but

// also allows for direct linking to a post (and the calculation of which

// page the post is on and the correct display of viewtopic)

if (!$post_id)

{

$join_sql = "t.topic_id = $topic_id";

if ($user->data['is_registered'])

{

$join_sql_table .= ' LEFT JOIN ' . TOPICS_WATCH_TABLE . ' tw ON (tw.user_id = ' . $user->data['user_id'] . '

AND t.topic_id = tw.topic_id)';

}

// Join to forum table on topic forum_id unless topic forum_id is zero

// whereupon we join on the forum_id passed as a parameter ... this

// is done so navigation, forum name, etc. remain consistent with where

// user clicked to view a global topic

$sql = 'SELECT t.topic_id, t.forum_id, t.topic_title, t.topic_attachment, t.topic_status, t.topic_approved, t.topic_replies_real, t.topic_replies, t.topic_first_post_id, t.topic_last_post_id, t.topic_last_poster_id, t.topic_last_post_time, t.topic_poster, t.topic_time, t.topic_time_limit, t.topic_type, t.topic_bumped, t.topic_bumper, t.poll_max_options, t.poll_start, t.poll_length, t.poll_title, t.poll_vote_change, f.forum_name, f.forum_desc, f.forum_parents, f.parent_id, f.left_id, f.right_id, f.forum_status, f.forum_type, f.forum_id, f.forum_style, f.forum_password, f.forum_rules, f.forum_rules_link, f.forum_rules_flags, f.forum_rules_bbcode_uid, f.forum_rules_bbcode_bitfield' . $extra_fields . '

WHERE $join_sql

AND (f.forum_id = t.forum_id

" . ((!$forum_id) ? '' : 'OR (t.topic_type = ' . POST_GLOBAL . " AND f.forum_id = $forum_id)") . "

trigger_error('NO_TOPIC');

}

//

// Check sticky/announcement time limit

{

$sql = 'UPDATE ' . TOPICS_TABLE . '

SET topic_type = ' . POST_NORMAL . ', topic_time_limit = 0

WHERE topic_id = ' . $topic_id;

$db->sql_query($sql);

}

// Setup look and feel

{

trigger_error('NO_TOPIC');

}

// Forum is passworded ... check whether access has been granted to this

// user this session, if not show login box

{

login_forum_box($topic_data);

}

}

// What is start equal to?

{

}

// Post ordering options

$s_watching_topic['link'] = $s_watching_topic['title'] = '';

if ($config['email_enable'] && $config['allow_topic_notify'] && $user->data['is_registered'])

{

}

// Bookmarks

if ($config['allow_bookmarks'] && $user->data['is_registered'] && request_var('bookmark', 0))

{

{

$sql = 'INSERT INTO ' . BOOKMARKS_TABLE . ' ' . $db->sql_build_array('INSERT', array(

'user_id' => $user->data['user_id'],

$db->sql_query($sql);

// Works because of current order_id selected as bookmark value (please do not change because of simplicity)

$sign = '-';

}

meta_refresh(3, $viewtopic_url);

trigger_error($message);

}

// Grab extensions

$extensions = array();

{

$cache->obtain_attach_extensions($extensions);

}

// Quick mod tools

$topic_mod = '';

$topic_mod .= ($auth->acl_get('m_delete', $forum_id)) ? '<option value="delete_topic">' . $user->lang['DELETE_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_move', $forum_id)) ? '<option value="move">' . $user->lang['MOVE_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_split', $forum_id)) ? '<option value="split">' . $user->lang['SPLIT_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_merge', $forum_id)) ? '<option value="merge">' . $user->lang['MERGE_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_', $forum_id)) ? '<option value="fork">' . $user->lang['FORK_TOPIC'] . '</option>' : '';

$topic_mod .= ($auth->acl_get('m_', $forum_id)) ? '<option value="viewlogs">' . $user->lang['VIEW_TOPIC_LOGS'] . '</option>' : '';

// If we've got a hightlight set pass it on to pagination.

get_moderators($forum_moderators, $forum_id);

// This is only used for print view so ...

// Replace naughty words in title

// Send vars to template

$template->assign_vars(array(

'FORUM_ID' => $forum_id,

'TOPIC_ID' => $topic_id,

'PAGINATION' => $pagination,

'PAGE_NUMBER' => on_page($total_posts, $config['posts_per_page'], $start),

'TOTAL_POSTS' => ($total_posts == 1) ? $user->lang['VIEW_TOPIC_POST'] : sprintf($user->lang['VIEW_TOPIC_POSTS'], $total_posts),

'MODERATORS' => (isset($forum_moderators[$forum_id]) && sizeof($forum_moderators[$forum_id])) ? implode(', ', $forum_moderators[$forum_id]) : '',

'QUOTE_IMG' => $user->img('btn_quote', 'REPLY_WITH_QUOTE'),

'EDIT_IMG' => $user->img('btn_edit', 'EDIT_POST'),

'DELETE_IMG' => $user->img('btn_delete', 'DELETE_POST'),

'INFO_IMG' => $user->img('btn_info', 'VIEW_INFO'),

'S_SELECT_SORT_DIR' => $s_sort_dir,

'S_SELECT_SORT_KEY' => $s_sort_key,

'S_SELECT_SORT_DAYS' => $s_limit_days,

'S_TOPIC_MOD' => ($topic_mod != '') ? '<select name="mode">' . $topic_mod . '</select>' : '',

'S_DISPLAY_SEARCHBOX' => ($auth->acl_get('f_search', $forum_id)) ? true : false,

'U_TOPIC' => "{$server_path}viewtopic.$phpEx?f=$forum_id&amp;t=$topic_id",

'U_FORUM' => $server_path,

'U_VIEW_TOPIC' => $viewtopic_url,

'U_PRINT_TOPIC' => ($auth->acl_get('f_print', $forum_id)) ? $viewtopic_url . '&amp;view=print' : '',

'U_WATCH_TOPIC' => $s_watching_topic['link'],

'L_WATCH_TOPIC' => $s_watching_topic['title'],

'U_BOOKMARK_TOPIC' => ($user->data['is_registered'] && $config['allow_bookmarks']) ? $viewtopic_url . '&amp;bookmark=1' : '',

);

// Does this topic contain a poll?

$sql = 'SELECT o.*, p.bbcode_bitfield, p.bbcode_uid

FROM ' . POLL_OPTIONS_TABLE . ' o, ' . POSTS_TABLE . " p

WHERE o.topic_id = $topic_id

AND p.topic_id = o.topic_id

ORDER BY o.poll_option_id";

$result = $db->sql_query($sql);

}

$s_can_vote = (((!sizeof($cur_voted_id) && $auth->acl_get('f_vote', $forum_id)) ||

$s_display_results = (!$s_can_vote || ($s_can_vote && sizeof($cur_voted_id)) || $view == 'viewpoll') ? true : false;

if ($update && $s_can_vote)

}

// If the user is trying to reach the second half of the topic, fetch it starting from the end

$sql_limit = $config['posts_per_page'];

if ($start > $total_posts / 2)

{

if ($start + $config['posts_per_page'] > $total_posts)

{

}

$db->sql_freeresult($result);

{

trigger_error($user->lang['NO_TOPIC']);

}

$sql = 'SELECT u.username, u.user_id, u.user_colour, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_jabber, u.user_regdate, u.user_msnm, u.user_allow_viewemail, u.user_allow_viewonline, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_sig_bbcode_bitfield, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, z.friend, z.foe, p.*

FROM (' . POSTS_TABLE . ' p

LEFT JOIN ' . ZEBRA_TABLE . ' z ON (z.user_id = ' . $user->data['user_id'] . ' AND z.zebra_id = p.poster_id)), ' . USERS_TABLE . ' u

// and the global bbcode_bitfield are built

while ($row = $db->sql_fetchrow($result))

{

$poster_id = $row['poster_id'];

$poster = ($poster_id == ANONYMOUS) ? ((!empty($row['post_username'])) ? $row['post_username'] : $user->lang['GUEST']) : $row['username'];

if ($row['post_approved'])

{

}

}

'online' => false,

'profile' => "{$phpbb_root_path}memberlist.$phpEx$SID&amp;mode=viewprofile&amp;u=$poster_id",

'www' => $row['user_website'],

'yim' => ($row['user_yim']) ? 'http://edit.yahoo.com/config/send_webmesg?.target=' . $row['user_yim'] . '&.src=pg' : '',

'username' => ($row['user_colour']) ? '<span style="color:#' . $row['user_colour'] . '">' . $poster . '</span>' : $poster

);

if (!empty($row['user_icq']))

{

$user_cache[$poster_id]['icq_status_img'] = '<img src="http://web.icq.com/whitepages/online?icq=' . $row['user_icq'] . '&amp;img=5" width="18" height="18" border="0" />';

}

else

);

// Output the posts

for ($i = 0, $end = sizeof($post_list); $i < $end; ++$i)

{

$row =& $rowset[$post_list[$i]];

}

// Bump information

{

// It is safe to grab the username from the user cache array, we are at the last

// post and only the topic poster and last poster are allowed to bump

}

else

{

$cp_row = (isset($profile_fields_cache[$poster_id])) ? $cp->generate_profile_fields_template('show', false, $profile_fields_cache[$poster_id]) : array();

}

//

$postrow = array(

'POSTER_NAME' => $row['poster'],

'EDIT_REASON' => $row['post_edit_reason'],

'BUMPED_MESSAGE'=> $l_bumped_by,

'POST_ICON_IMG' => (!empty($row['icon_id'])) ? $icons[$row['icon_id']]['img'] : '',

'POST_ICON_IMG_WIDTH' => (!empty($row['icon_id'])) ? $icons[$row['icon_id']]['width'] : '',

'POST_ICON_IMG_HEIGHT' => (!empty($row['icon_id'])) ? $icons[$row['icon_id']]['height'] : '',

'U_YIM' => $user_cache[$poster_id]['yim'],

'U_JABBER' => $user_cache[$poster_id]['jabber'],

'U_NEXT_POST_ID' => ($i < $i_total && isset($rowset[$i + 1])) ? $rowset[$i + 1]['post_id'] : '',

'U_PREV_POST_ID' => $prev_post_id,

'S_POST_REPORTED' => ($row['post_reported'] && $auth->acl_get('m_', $forum_id)) ? TRUE : FALSE,

'S_DISPLAY_NOTICE' => $display_notice && $row['post_attachment'],

'S_FRIEND' => ($row['friend']) ? true : false,

'S_CUSTOM_FIELDS' => (isset($cp_row['row']) && sizeof($cp_row['row'])) ? true : false

);

}

}

// Change encoding if appropriate

if ($force_encoding != '')

}

// Output the page

$template->set_filenames(array(

'body' => ($view == 'print') ? 'viewtopic_print.html' : 'viewtopic_body.html')

page_footer();

?> \ No newline at end of file