LEFT JOIN ' . TOPICS_TABLE . " t2 ON (t2.topic_id = $topic_id AND t.forum_id = t2.forum_id)

WHERE t.topic_last_post_time $sql_condition t2.topic_last_post_time

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

ORDER BY t.topic_last_post_time $sql_ordering";

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

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

if ($config['allow_bookmarks'])

{

$sql_array['LEFT_JOIN'][] = array(

'FROM' => array(BOOKMARKS_TABLE => 'bm'),

'ON' => 'bm.user_id = ' . $user->data['user_id'] . ' AND t.topic_id = bm.topic_id'

if ($sort_dir == $check_sort)

{

}

else

{

}

}

else

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

$db->sql_freeresult($result);

}

}

// What is start equal to?

if ($post_id)

{

}

// Get topic tracking info

{

if (trim($word))

{

}

}

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

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

'topic_id' => $topic_id,

$db->sql_query($sql);

}

else

{

WHERE user_id = {$user->data['user_id']}

AND topic_id = $topic_id";

$db->sql_query($sql);

}

meta_refresh(3, $viewtopic_url);

$message = (($topic_data['bookmarked']) ? $user->lang['BOOKMARK_REMOVED'] : $user->lang['BOOKMARK_ADDED']) . '<br /><br />' . sprintf($user->lang['RETURN_TOPIC'], '<a href="' . $viewtopic_url . '">', '</a>');

$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) && $topic_data['topic_status'] != ITEM_MOVED) ? '<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_move', $forum_id)) ? '<option value="fork">' . $user->lang['FORK_TOPIC'] . '</option>' : '';

$topic_mod .= ($allow_change_type && $auth->acl_gets('f_sticky', 'f_announce', $forum_id) && $topic_data['topic_type'] != POST_NORMAL) ? '<option value="make_normal">' . $user->lang['MAKE_NORMAL'] . '</option>' : '';

$topic_mod .= ($allow_change_type && $auth->acl_get('f_sticky', $forum_id) && $topic_data['topic_type'] != POST_STICKY) ? '<option value="make_sticky">' . $user->lang['MAKE_STICKY'] . '</option>' : '';

'FORUM_DESC' => generate_text_for_display($topic_data['forum_desc'], $topic_data['forum_desc_uid'], $topic_data['forum_desc_bitfield'], $topic_data['forum_desc_options']),

'TOPIC_ID' => $topic_id,

'TOPIC_TITLE' => $topic_data['topic_title'],

'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),

'UNAPPROVED_IMG' => $user->img('icon_topic_unapproved', 'POST_UNAPPROVED'),

'WARN_IMG' => $user->img('icon_user_warn', 'WARN_USER'),

'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="action">' . $topic_mod . '</select>' : '',

'S_MOD_ACTION' => append_sid("{$phpbb_root_path}mcp.$phpEx", "t=$topic_id&amp;f=$forum_id&amp;quickmod=1&amp;redirect=" . urlencode(str_replace('&amp;', '&', $viewtopic_url)), true, $user->session_id),

'S_SEARCHBOX_ACTION' => append_sid("{$phpbb_root_path}search.$phpEx", 't=' . $topic_id),

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

{

$user_sig = '';

{

$user_sig = $row['user_sig'];

}

'viewonline' => $row['user_allow_viewonline'],

'allow_pm' => $row['user_allow_pm'],

'age' => '',

'rank_title' => '',

'online' => false,

'profile' => append_sid("{$phpbb_root_path}memberlist.$phpEx", "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'] . '&amp;.src=pg' : '',

'search' => ($auth->acl_get('u_search')) ? append_sid("{$phpbb_root_path}search.$phpEx", 'search_author=' . urlencode($row['username']) .'&amp;showresults=posts') : '',

);

get_user_rank($row['user_rank'], $row['user_posts'], $user_cache[$poster_id]['rank_title'], $user_cache[$poster_id]['rank_image'], $user_cache[$poster_id]['rank_image_src']);

if (!empty($row['user_allow_viewemail']) || $auth->acl_get('a_email'))

$first_unread = $post_unread = false;

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

{

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

$poster_id = $row['user_id'];

// End signature parsing, only if needed

{

$user_cache[$poster_id]['sig'] = censor_text($user_cache[$poster_id]['sig']);

$user_cache[$poster_id]['sig'] = str_replace("\n", '<br />', $user_cache[$poster_id]['sig']);

if ($topic_data['topic_bumped'] && $row['post_id'] == $topic_data['topic_last_post_id'] && isset($user_cache[$topic_data['topic_bumper']]) )

{

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

$l_bumped_by = '<br /><br />' . sprintf($user->lang['BUMPED_BY'], $user_cache[$topic_data['topic_bumper']]['username'], $user->format_date($topic_data['topic_last_post_time']));

}

else

'BUMPED_MESSAGE' => $l_bumped_by,

'MINI_POST_IMG' => ($post_unread) ? $user->img('icon_post_target_unread', 'NEW_POST') : $user->img('icon_post_target', 'POST'),

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

'ONLINE_IMG' => ($poster_id == ANONYMOUS || !$config['load_onlinetrack']) ? '' : (($user_cache[$poster_id]['online']) ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')),

'S_ONLINE' => ($poster_id == ANONYMOUS || !$config['load_onlinetrack']) ? false : (($user_cache[$poster_id]['online']) ? true : false),

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

'U_PREV_POST_ID' => $prev_post_id,

'U_NOTES' => ($auth->acl_getf_global('m_')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=notes&amp;mode=user_notes&amp;u=' . $poster_id, true, $user->session_id) : '',

'POST_ID' => $row['post_id'],

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

'S_POST_UNAPPROVED' => ($row['post_approved']) ? false : true,

'S_UNREAD_POST' => $post_unread,

'S_FIRST_UNREAD' => $s_first_unread,

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

'S_IGNORE_POST' => ($row['hide_post']) ? true : false,

'L_IGNORE_POST' => ($row['hide_post']) ? sprintf($user->lang['POST_BY_FOE'], get_username_string('full', $poster_id, $row['username'], $row['user_colour'], $row['post_username']), '<a href="' . $viewtopic_url . "&amp;p={$row['post_id']}&amp;view=show#p{$row['post_id']}" . '">', '</a>') : '',

}

}

{

markread('topic', $forum_id, $topic_id, $max_post_time);

}

// If there are absolutely no more unread posts in this forum and unread posts shown, we can savely show the #unread link

{

}

else if (!$all_marked_read)

{