$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 = ($topic_id) ? 'posts' : $request->variable('sr', ($search_id == 'egosearch') ? 'topics' : 'posts');

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;

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 = '';

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);

}

$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 . '