- // Post ordering options

- $previous_days = array(0 => $user->lang['ALL_POSTS'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 364 => $user->lang['1_YEAR']);

- $sort_by_text = array('a' => $user->lang['AUTHOR'], 't' => $user->lang['POST_TIME'], 's' => $user->lang['SUBJECT']);

- $sort_by = array('a' => 'u.username', 't' => 'p.post_id', 's' => 'p.post_subject');

-

- $sort_days = (!empty($_REQUEST['sort_days'])) ? max(intval($_REQUEST['sort_days']), 0) : 0;

- $sort_key = (!empty($_REQUEST['sort_key']) && preg_match('/^(a|t|s)$/', $_REQUEST['sort_key'])) ? $_REQUEST['sort_key'] : 't';

- $sort_dir = (!empty($_REQUEST['sort_dir']) && preg_match('/^(a|d)$/', $_REQUEST['sort_dir'])) ? $_REQUEST['sort_dir'] : 'a';

- $sort_order = $sort_by[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

-

- $limit_posts_time = '';

- $total_posts = $topic_info['topic_replies'] + 1;

-

- $select_sort_days = '<select name="sort_days">';

- foreach ($previous_days as $day => $text)

- {

- $selected = ($sort_days == $day) ? ' selected="selected"' : '';

- $select_sort_days .= '<option value="' . $day . '"' . $selected . '>' . $text . '</option>';

- }

- $select_sort_days .= '</select>';

-

- $select_sort = '<select name="sort_key">';

- foreach ($sort_by_text as $key => $text)

- {

- $selected = ($sort_key == $key) ? ' selected="selected"' : '';

- $select_sort .= '<option value="' . $key . '"' . $selected . '>' . $text . '</option>';

- }

- $select_sort .= '</select>';

- $select_sort_dir = '<select name="sort_dir">';

- $select_sort_dir .= ($sort_dir == 'a') ? '<option value="a" selected="selected">' . $user->lang['ASCENDING'] . '</option><option value="d">' . $user->lang['DESCENDING'] . '</option>' : '<option value="a">' . $user->lang['ASCENDING'] . '</option><option value="d" selected="selected">' . $user->lang['DESCENDING'] . '</option>';

- $select_sort_dir .= '</select>';

-

- $select_post_days = '<select name="postdays">';

- for($i = 0; $i < count($previous_days); $i++)

- {

- $selected = ($post_days == $previous_days[$i]) ? ' selected="selected"' : '';

- $select_post_days .= '<option value="' . $previous_days[$i] . '"' . $selected . '>' . $previous_days_text[$i] . '</option>';

- }

- $select_post_days .= '</select>';

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

- 'S_SELECT_SORT_DIR' => $select_sort_dir,

- 'S_SELECT_SORT_KEY' => $select_sort,

- 'S_SELECT_SORT_DAYS'=> $select_sort_days,

- 'PAGINATION' => (!$posts_per_page) ? '' : generate_pagination("$mcp_url&amp;mode=$mode&amp;posts_per_page=$posts_per_page&amp;sort_key=$sort_key&amp;sort_dir=$sort_dir&amp;sort_days=$sort_days", $total_posts, $posts_per_page, $start)

- 'PAGE_NUMBER' => sprintf($user->lang['PAGE_OF'], (floor($start / $config['topics_per_page']) + 1), ceil($forum_info ['forum_topics'] / $config['topics_per_page']))

- ));

-$forum_id = (!empty($_GET['f'])) ? intval($_GET['f']) : 0;

-$start = (isset($_GET['start'])) ? intval($_GET['start']) : 0;

-$sort_days = (!empty($_REQUEST['sort_days'])) ? intval($_REQUEST['sort_days']) : 0;

-$sort_key = (!empty($_REQUEST['sort_key'])) ? $_REQUEST['sort_key'] : 't';

-$sort_dir = (!empty($_REQUEST['sort_dir'])) ? $_REQUEST['sort_dir'] : 'd';

- $sort_by_sql = array('a' => 't.topic_last_poster_name', 't' => 't.topic_last_post_id', 'r' => 't.topic_replies', 's' => 't.topic_title', 'v' => 't.topic_views');

-

- gen_sort_selects($limit_days, $sort_by_text, $s_limit_days, $s_sort_key, $s_sort_dir);

- $topic_days = '';

- if (isset($_REQUEST['sort']))

- if ($sort_days)

- {

- $min_topic_time = time() - ($sort_days * 86400);

-

- // ref type on as rows as topics ... also not great

- $sql = "SELECT COUNT(topic_id) AS forum_topics

- FROM " . TOPICS_TABLE . "

- WHERE forum_id = $forum_id

- AND topic_last_post_time >= $min_topic_time";

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

-

- $start = 0;

- $topics_count = ($row = $db->sql_fetchrow($result)) ? $row['forum_topics'] : 0;

- $limit_topics_time = "AND t.topic_last_post_time >= $min_topic_time";

- }

- else

- {

- $topics_count = ($forum_data['forum_topics']) ? $forum_data['forum_topics'] : 1;

- }

- $limit_topics_time = '';

- 'PAGINATION' => generate_pagination("viewforum.$phpEx$SID&amp;f=$forum_id", $topics_count, $config['topics_per_page'], $start),

-$topic_id = (isset($_GET['t'])) ? intval($_GET['t']) : 0;

-$post_id = (isset($_GET['p'])) ? intval($_GET['p']) : 0;

-$start = (isset($_GET['start'])) ? intval($_GET['start']) : 0;

-$sort_days = (!empty($_REQUEST['sort_days'])) ? intval($_REQUEST['sort_days']) : 0;

-$sort_key = (!empty($_REQUEST['sort_key'])) ? $_REQUEST['sort_key'] : 't';

-$sort_dir = (!empty($_REQUEST['sort_dir'])) ? $_REQUEST['sort_dir'] : 'a';

- AND f.forum_id = t.forum_id

-$forum_id = intval($forum_id);

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

-gen_sort_selects($limit_days, $sort_by_text, $s_limit_days, $s_sort_key, $s_sort_dir);

-$sort_days = (!empty($_REQUEST['sort_days'])) ? max(intval($_REQUEST['sort_days']), 0) : 0;

-$sort_key = (!empty($_REQUEST['sort_key']) && preg_match('/^(a|t|s)$/', $_REQUEST['sort_key'])) ? $_REQUEST['sort_key'] : 't';

-$sort_dir = (!empty($_REQUEST['sort_dir']) && preg_match('/^(a|d)$/', $_REQUEST['sort_dir'])) ? $_REQUEST['sort_dir'] : 'a';

-$sort_order = $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC');

-

-$select_sort_days = '<select name="sort_days">';

-foreach ($previous_days as $day => $text)

-{

- $selected = ($sort_days == $day) ? ' selected="selected"' : '';

- $select_sort_days .= '<option value="' . $day . '"' . $selected . '>' . $text . '</option>';

-}

-$select_sort_days .= '</select>';

-

-$select_sort = '<select name="sort_key">';

-foreach ($sort_by_text as $key => $text)

-{

- $selected = ($sort_key == $key) ? ' selected="selected"' : '';

- $select_sort .= '<option value="' . $key . '"' . $selected . '>' . $text . '</option>';

-}

-$select_sort .= '</select>';

-

-$select_sort_dir = '<select name="sort_dir">';

-$select_sort_dir .= ($sort_dir == 'a') ? '<option value="a" selected="selected">' . $user->lang['ASCENDING'] . '</option><option value="d">' . $user->lang['DESCENDING'] . '</option>' : '<option value="a">' . $user->lang['ASCENDING'] . '</option><option value="d" selected="selected">' . $user->lang['DESCENDING'] . '</option>';

-$select_sort_dir .= '</select>';

-

-$select_post_days = '<select name="postdays">';

-for($i = 0; $i < count($previous_days); $i++)

-{

- $selected = ($post_days == $previous_days[$i]) ? ' selected="selected"' : '';

- $select_post_days .= '<option value="' . $previous_days[$i] . '"' . $selected . '>' . $previous_days_text[$i] . '</option>';

-}

-$select_post_days .= '</select>';

-

-if (isset($_GET['highlight']))

- $words = explode(' ', trim(htmlspecialchars(urldecode($_GET['highlight']))));

- $highlight = urlencode($_GET['highlight']);

-$pagination_url = "viewtopic.$phpEx$SID&amp;t=$topic_id&amp;sort_days=$sort_days&amp;sort_key=$sort_key&amp;sort_dir=$sort_dir" . (($highlight_match) ? "&amp;highlight=$highlight" : '');

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