$user->setup('search');

// Define initial vars

$show_results = ($show_results == 'posts') ? 'posts' : 'topics';

// We put login boxes for the case if search_id is newposts, egosearch or unreadposts

// because a guest should be able to log in even if guests search is not permitted

$s_limit_days = $s_sort_key = $s_sort_dir = $u_sort_param = '';

gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

$pagination = $phpbb_container->get('pagination');

/**

$sql_author_match = (strpos($author, '*') !== false) ? ' ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), utf8_clean_string($author))) : " = '" . $db->sql_escape(utf8_clean_string($author)) . "'";

}

{

trigger_error('NO_SEARCH_RESULTS');

}

}

// Which forums should not be searched? Author searches are also carried out in unindexed forums

{

$ex_fid_ary = array_keys($auth->acl_getf('!f_read', true));

}

$ex_fid_ary = array_unique(array_merge(array_keys($auth->acl_getf('!f_read', true)), array_keys($auth->acl_getf('!f_search', true))));

}

$sql = 'SELECT f.forum_id, f.forum_name, f.parent_id, f.forum_type, f.right_id, f.forum_password, f.forum_flags, fa.user_id

FROM ' . FORUMS_TABLE . ' f

continue;

}

{

if ($search_child)

{

{

$correct_query = $search->split_keywords($keywords, $search_terms);

$common_words = $search->get_common_words();

{

$word_length = $search->get_word_length();

if ($word_length)

{

}

}

{

// if it is an author search we want to show topics by default

$show_results = ($show_results == 'posts') ? 'posts' : 'topics';

}

$show_results = 'topics';

$sort_key = 't';

$sort_dir = 'd';

$sort_by_sql['t'] = 't.topic_last_post_time';

gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

WHERE t.topic_moved_id = 0

$last_post_time_sql

AND " . $m_approve_topics_fid_sql . '

ORDER BY t.topic_last_post_time DESC';

$field = 'topic_id';

break;

case 'unanswered':

$l_search_title = $user->lang['SEARCH_UNANSWERED'];

$show_results = ($show_results == 'posts') ? 'posts' : 'topics';

$sort_by_sql['t'] = ($show_results == 'posts') ? 'p.post_time' : 't.topic_last_post_time';

$sort_by_sql['s'] = ($show_results == 'posts') ? 'p.post_subject' : 't.topic_title';

AND p.topic_id = t.topic_id

$last_post_time

AND $m_approve_posts_fid_sql

$sql_sort";

$field = 'post_id';

}

AND p.topic_id = t.topic_id

$last_post_time

AND $m_approve_topics_fid_sql

$sql_sort";

$field = 'topic_id';

}

$sql_where = 'AND t.topic_moved_id = 0

AND ' . $m_approve_topics_fid_sql . '

gen_sort_selects($limit_days, $sort_by_text, $sort_days, $sort_key, $sort_dir, $s_limit_days, $s_sort_key, $s_sort_dir, $u_sort_param);

$s_sort_key = $s_sort_dir = $u_sort_param = $s_limit_days = '';

case 'newposts':

$l_search_title = $user->lang['SEARCH_NEW'];

// force sorting

$sort_key = 't';

$sort_dir = 'd';

$sort_by_sql['t'] = ($show_results == 'posts') ? 'p.post_time' : 't.topic_last_post_time';

FROM ' . POSTS_TABLE . ' p

WHERE p.post_time > ' . $user->data['user_lastvisit'] . '

AND ' . $m_approve_posts_fid_sql . '

$sql_sort";

$field = 'post_id';

}

WHERE t.topic_last_post_time > ' . $user->data['user_lastvisit'] . '

AND t.topic_moved_id = 0

AND ' . $m_approve_topics_fid_sql . '

$sql_sort";

/*

[Fix] queued replies missing from "view new posts" (Bug #42705 - Patch by Paul)

$search_id = '';

}

if ($total_match_count)

{

// Limit the number to $total_matches_limit for pre-made searches

{

$total_match_count = $search->keyword_search($show_results, $search_fields, $search_terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_posts_fid_sql, $topic_id, $author_id_ary, $sql_author_match, $id_ary, $start, $per_page);

}

{

$firstpost_only = ($search_fields === 'firstpost' || $search_fields == 'titleonly') ? true : false;

$total_match_count = $search->author_search($show_results, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $m_approve_posts_fid_sql, $topic_id, $author_id_ary, $sql_author_match, $id_ary, $start, $per_page);

$sql_where = '';

{

$sql_where .= $db->sql_in_set(($show_results == 'posts') ? 'p.post_id' : 't.topic_id', $id_ary);

$sql_where .= ' AND ' . (($show_results == 'posts') ? $m_approve_posts_fid_sql : $m_approve_topics_fid_sql);

}

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

$result_topic_id = 0;

if ($show_results == 'topics')

{

$db->sql_freeresult($result);

// If we have some shadow topics, update the rowset to reflect their topic information

{

$sql = 'SELECT *

FROM ' . TOPICS_TABLE . '

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

{

// We pre-process some variables here for later usage

$row['post_text'] = censor_text($row['post_text']);

unset($text_only_message);

// Pull attachment data

{

$use_attach_list = $attach_list;

$attach_list = array();

}

}

{

$sql = 'SELECT *

FROM ' . ATTACHMENTS_TABLE . '

'TOPIC_AUTHOR_COLOUR' => get_username_string('colour', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

'TOPIC_AUTHOR_FULL' => get_username_string('full', $row['topic_poster'], $row['topic_first_poster_name'], $row['topic_first_poster_colour']),

'FIRST_POST_TIME' => $user->format_date($row['topic_time']),

'LAST_POST_SUBJECT' => $row['topic_last_post_subject'],

'LAST_POST_TIME' => $user->format_date($row['topic_last_post_time']),

'LAST_VIEW_TIME' => $user->format_date($row['topic_last_view_time']),

'LAST_POST_AUTHOR' => get_username_string('username', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),

'LAST_POST_AUTHOR_COLOUR' => get_username_string('colour', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),

'LAST_POST_AUTHOR_FULL' => get_username_string('full', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),

ORDER BY search_time DESC';

break;

case 'mssql_odbc':

case 'mssqlnative':

$sql = 'SELECT search_time, search_keywords