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

if (isset($_GET['view']) && !$post_id)

{

if ($_GET['view'] == 'unread')

$message = $user->lang['NO_UNREAD_POSTS'] . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], "<a href=\"viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id\">", '</a>');

trigger_error($message);

}

}

}

else if ($_GET['view'] == 'next' || $_GET['view'] == 'previous')

{

$sql_condition = ($_GET['view'] == 'next') ? '>' : '<';

$sql_ordering = ($_GET['view'] == 'next') ? 'ASC' : 'DESC';

WHERE t2.topic_id = $topic_id

AND t.forum_id = t2.forum_id

AND t.topic_last_post_time $sql_condition t2.topic_last_post_time

ORDER BY t.topic_last_post_time $sql_ordering";

$result = $db->sql_query_limit($sql, 1);

if (!$forum_id)

{

$forum_id = 2;

}

$sql = 'SELECT t.topic_id, t.forum_id AS real_forum_id, t.topic_title, t.topic_attachment, t.topic_status, ' . (($auth->acl_get('m_approve')) ? 't.topic_replies_real AS topic_replies' : 't.topic_replies') . ', t.topic_last_post_id, t.topic_time, t.topic_type, t.poll_max_options, t.poll_start, t.poll_length, t.poll_title, f.forum_name, f.forum_desc, f.forum_parents, f.parent_id, f.left_id, f.right_id, f.forum_status, f.forum_id, f.forum_style, f.forum_password' . $extra_fields . '

FROM ' . TOPICS_TABLE . ' t, ' . FORUMS_TABLE . ' f' . $join_sql_table . "

WHERE $join_sql

$start = floor(($prev_posts - 1) / $config['posts_per_page']) * $config['posts_per_page'];

}

// Fill extension informations, if this topic has attachments

$extensions = array();

if ($topic_attachment)

{

obtain_attach_extensions($extensions);

}

// Are we watching this topic?

// Post ordering options

'MCP' => ($auth->acl_get('m_', $forum_id)) ? sprintf($user->lang['MCP'], "<a href=\"mcp.$phpEx?sid=" . $user->session_id . "&amp;f=$forum_id&amp;t=$topic_id&amp;start=$start&amp;$u_sort_param&amp;posts_per_page=" . $config['posts_per_page'] . '">', '</a>') : '',

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

'REPORTED_IMG' => $user->img('icon_reported', $user->lang['POST_BEEN_REPORTED']),

'UNAPPROVED_IMG' => $user->img('icon_unapproved', $user->lang['POST_NOT_BEEN_APPROVED']),

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

'U_FORUM' => $server_path,

'U_VIEW_TOPIC' => "viewtopic.$phpEx$SID&amp;f=$forum_id&amp;t=$topic_id&amp;start=$start&amp;$u_sort_param&amp;hilit=$highlight",

'U_VIEW_FORUM' => $view_forum_url,

'U_VIEW_OLDER_TOPIC' => $view_prev_topic_url,

'U_POST_REPLY_TOPIC' => $reply_topic_url)

);

// Does this topic contain a poll?

if (!empty($poll_start))

{

WHERE topic_id = $topic_id

ORDER BY poll_option_id";

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

if ($user->data['user_id'] != ANONYMOUS)

{

WHERE topic_id = $topic_id

AND vote_user_id = " . $user->data['user_id'];

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

'POLL_LEFT_CAP_IMG' => $user->img('poll_left'),

'POLL_RIGHT_CAP_IMG'=> $user->img('poll_right'),

'S_HAS_POLL' => true,

'S_CAN_VOTE' => $s_can_vote,

'S_IS_MULTI_CHOICE' => ($poll_max_options > 1) ? true : false,

'S_POLL_ACTION' => "viewtopic.$phpEx$SID&amp;t=$topic_id&amp;$u_sort_param",

);

unset($poll_info);

$bbcode_bitfield = $i = 0;

// Go ahead and pull all data for this topic

FROM " . POSTS_TABLE . " p, " . USERS_TABLE . " u

WHERE p.topic_id = $topic_id

" . (($auth->acl_get('m_approve', $forum_id)) ? '' : 'AND p.post_approved = 1') . "

'rank_image' => '',

'sig' => '',

'posts' => '',

'profile' => '',

'pm' => '',

'email' => '',

'www' => '',

'icq_status_img'=> '',

'icq' => '',

'aim' => '',

'msn' => '',

'search' => ''

);

}

$user_sig = ($row['user_allowsmile'] || $config['enable_smilies']) ? preg_replace('#<!\-\- s(.*?) \-\-><img src="\{SMILE_PATH\}\/.*? \/><!\-\- s\1 \-\->#', '\1', $user_sig) : str_replace('<img src="{SMILE_PATH}', '<img src="' . $config['smilies_path'], $user_sig);

}

$user_cache[$poster_id] = array(

);

{

switch ($row['user_avatar_type'])

{

if ((!empty($row['user_allow_viewemail']) || $auth->acl_get('m_', $forum_id)) && $config['email_enable'])

{

}

else

{

$user_cache[$poster_id]['email'] = '';

}

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

{

}

else

{

$user_cache[$poster_id]['icq_status_img'] = '';

$user_cache[$poster_id]['icq'] = '';

}

}

$user_cache[$poster_id]['sig_parsed'] = TRUE;

}

// Parse the message and subject

$message = $row['post_text'];

}

// Dump vars into template

$template->assign_block_vars('postrow', array(

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

'RATING' => $rating,

'S_ROW_COUNT' => $i++,

'S_HAS_ATTACHMENTS' => (!empty($attachments[$row['post_id']])) ? TRUE : FALSE,

'S_POST_UNAPPROVED' => ($row['post_approved']) ? FALSE : TRUE,

);

// Process Attachments for this post

if (sizeof($attachments[$row['post_id']]))

{

{

$display_cat = NONE_CAT;

{

{

list($width, $height) = image_getdimension($filename);

}

}

else

// if this is the first 'page view'

if (!preg_match("#&t=$topic_id#", $user->data['session_page']))

{

SET topic_views = topic_views + 1

WHERE topic_id = $topic_id";

$db->sql_query($sql);

// Update the attachment download counts

if (count($update_count))

{

SET download_count = download_count + 1

$db->sql_query($sql);

}

}