if ( $session_id )

{

LIMIT 1";

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

AND p2.post_id = t2.topic_last_post_id

AND t.forum_id = t2.forum_id

AND p.post_id = t.topic_last_post_id

AND p.post_time $sql_condition p2.post_time

AND p.topic_id = t.topic_id

ORDER BY p.post_time $sql_ordering

if ( $userdata['user_id'] != ANONYMOUS && isset($HTTP_POST_VARS['rating']) )

{

$sql = "SELECT rating

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

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

$join_sql_table = ( !$post_id ) ? '' : ', ' . POSTS_TABLE . ' p, ' . POSTS_TABLE . ' p2 ';

$join_sql = ( !$post_id ) ? "t.topic_id = $topic_id" : "p.post_id = $post_id AND p.post_approved = " . TRUE . " AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_approved = " . TRUE . " AND p2.post_id <= $post_id";

$count_sql = ( !$post_id ) ? '' : ", COUNT(p2.post_id) AS prev_posts";

WHERE $join_sql

$order_sql";

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

//

// Configure style, language, etc.

//

$session->configure($userdata);

//

// Start auth check

{

if ( $userdata['user_id'] != ANONYMOUS )

{

$redirect .= ( isset($start) ) ? "&start=$start" : '';

$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';

header($header_location . 'login.' . $phpEx . $SID . '&redirect=viewtopic.' . $phpEx . '&' . $redirect);

$sql = "SELECT COUNT(post_id) AS num_posts

FROM " . POSTS_TABLE . "

WHERE topic_id = $topic_id

AND post_approved = " . TRUE;

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

}

else

{

$limit_posts_time = '';

$sort_days = 0;

{

$rating_text = array(-5 => $lang['Very_poor'], -2 => $lang['Quite_poor'], 0 => $lang['Unrated'], 2 => $lang['Quite_good'], 5 => $lang['Very_good']);

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

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

//

// Output page header

$page_title = $lang['View_topic'] .' - ' . $topic_title;

include($phpbb_root_path . 'includes/page_header.'.$phpEx);

'TOPIC_ID' => $topic_id,

'TOPIC_TITLE' => $topic_title,

'PAGINATION' => $pagination,

'POST_IMG' => $post_img,

'REPLY_IMG' => $reply_img,

'L_AUTHOR' => $lang['Author'],

'L_MESSAGE' => $lang['Message'],

'L_POST_SUBJECT' => $lang['Post_subject'],

'L_VIEW_NEXT_TOPIC' => $lang['View_next_topic'],

'L_VIEW_PREVIOUS_TOPIC' => $lang['View_previous_topic'],

'L_BACK_TO_TOP' => $lang['Back_to_top'],

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

'S_SELECT_SORT_DAYS' => $select_sort_days,

'S_AUTH_LIST' => $s_forum_rules,

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

'S_WATCH_TOPIC' => $s_watching_topic,

'U_VIEW_FORUM' => $view_forum_url,

'U_VIEW_OLDER_TOPIC' => $view_prev_topic_url,

'U_VIEW_NEWER_TOPIC' => $view_next_topic_url,

);

//

//

if ( !empty($poll_start) )

{

}

$template->assign_vars(array(

'L_TOTAL_VOTES' => $lang['Total_votes'],

'TOTAL_VOTES' => $vote_results_sum)

}

$template->assign_vars(array(

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

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

//

$sql = "SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid

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

$limit_posts_time

AND pt.post_id = p.post_id

AND u.user_id = p.poster_id

LIMIT $start, " . $board_config['posts_per_page'];

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

}

if ( !isset($poster_details[$poster_id]['profile']) && $poster_id != ANONYMOUS )

$temp_url = "profile.$phpEx$SID&amp;mode=viewprofile&amp;u=$poster_id";

$poster_details[$poster_id]['profile_img'] = '<a href="' . $temp_url . '">' . create_img($theme['icon_profile'], $lang['Read_profile']) . '</a>';

$poster_details[$poster_id]['profile'] = '<a href="' . $temp_url . '">' . $lang['Read_profile'] . '</a>';

}

}

{

$poster_details[$poster_id]['profile_img'] = '';

$poster_details[$poster_id]['profile'] = '';

$message = ( $acl->get_acl($forum_id, 'forum', 'bbcode') ) ? bbencode_second_pass($message, $bbcode_uid, $acl->get_acl($forum_id, 'forum', 'img')) : preg_replace('/\:[0-9a-z\:]+\]/si', ']', $message);

}

{

$message = make_clickable($message);

}

if ( $row['post_edit_count'] )

{

$l_edit_time_total = ( $row['post_edit_count'] == 1 ) ? $lang['Edited_time_total'] : $lang['Edited_times_total'];

$l_edited_by = '<br /><br />' . sprintf($l_edit_time_total, $poster, create_date($board_config['default_dateformat'], $row['post_edit_time'], $board_config['board_timezone']), $row['post_edit_count']);

}

else

'POST_DATE' => $post_date,

'POST_SUBJECT' => $post_subject,

'EDIT_IMG' => $edit_img,

'EDIT' => $edit,

'QUOTE_IMG' => $quote_img,

'QUOTE' => $quote,

'SEARCH_IMG' => $poster_details[$poster_id]['search_img'],

'SEARCH' => $poster_details[$poster_id]['search'],

'PM_IMG' => $poster_details[$poster_id]['pm_img'],

'WWW_IMG' => $poster_details[$poster_id]['www_img'],

'WWW' => $poster_details[$poster_id]['www'],

'ICQ_STATUS_IMG' => $poster_details[$poster_id]['icq_status_img'],

'AIM_IMG' => $poster_details[$poster_id]['aim_img'],

'AIM' => $poster_details[$poster_id]['aim'],

'MSN_IMG' => $poster_details[$poster_id]['msn_img'],

'YIM_IMG' => $poster_details[$poster_id]['yim_img'],

'YIM' => $poster_details[$poster_id]['yim'],

'U_MINI_POST' => $mini_post_url,

'U_POST_ID' => $row['post_id'])