+* This file is part of the phpBB Forum Software package.

+*

+* @copyright (c) phpBB Limited <https://www.phpbb.com>

+* @license GNU General Public License, version 2 (GPL-2.0)

+*

+* For full copyright and license information, please see

+* the docs/CREDITS.txt file.

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

+

+

+ trigger_error('NO_SEARCH_LOAD');

+ trigger_error($user->lang('NO_SEARCH_TIME', (int) ($user->data['user_last_search'] + $interval - time())));

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

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

+

+/**

+* This event allows you to alter the above parameters, such as keywords and submit

+*

+* @event core.search_modify_submit_parameters

+* @var string keywords The search keywords

+* @var string author Specifies the author match, when ANONYMOUS is also a search-match

+* @var int author_id ID of the author to search by

+* @var string search_id Predefined search type name

+* @var bool submit Whether or not the form has been submitted

+* @since 3.1.10-RC1

+*/

+$vars = array(

+ 'keywords',

+ 'author',

+ 'author_id',

+ 'search_id',

+ 'submit',

+);

+extract($phpbb_dispatcher->trigger_event('core.search_modify_submit_parameters', compact($vars)));

+

+ trigger_error($user->lang('TOO_FEW_AUTHOR_CHARS', (int) $config['min_search_author_chars']));

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

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

+ $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)) . "'";

+ // find out in which forums the user is allowed to view posts

+ $m_approve_posts_fid_sql = $phpbb_content_visibility->get_global_visibility_sql('post', $ex_fid_ary, 'p.');

+ $m_approve_topics_fid_sql = $phpbb_content_visibility->get_global_visibility_sql('topic', $ex_fid_ary, 't.');

+ $search_type = $config['search_type'];

+ if (!class_exists($search_type))

+ $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user, $phpbb_dispatcher);

+ $common_words = $search->get_common_words();

+ if (!$correct_query || (!$search->get_search_query() && !sizeof($author_id_ary) && !$search_id))

+ $ignored = (sizeof($common_words)) ? sprintf($user->lang['IGNORED_TERMS_EXPLAIN'], implode(' ', $common_words)) . '<br />' : '';

+ $word_length = $search->get_word_length();

+ if ($word_length)

+ {

+ trigger_error($ignored . $user->lang('NO_KEYWORDS', $user->lang('CHARACTERS', (int) $word_length['min']), $user->lang('CHARACTERS', (int) $word_length['max'])));

+ }

+ else

+ {

+ trigger_error($ignored);

+ }

+ /**

+ * Event to modify the SQL parameters before pre-made searches

+ *

+ * @event core.search_modify_param_before

+ * @var string keywords String of the specified keywords

+ * @var array sort_by_sql Array of SQL sorting instructions

+ * @var array ex_fid_ary Array of excluded forum ids

+ * @var array author_id_ary Array of exclusive author ids

+ * @var string search_id The id of the search request

+ * @var array id_ary Array of post or topic ids for search result

+ * @var string show_results 'posts' or 'topics' type of ids

+ * @since 3.1.3-RC1

+ * @changed 3.1.10-RC1 Added id_ary, show_results

+ */

+ $vars = array(

+ 'keywords',

+ 'sort_by_sql',

+ 'ex_fid_ary',

+ 'author_id_ary',

+ 'search_id',

+ 'id_ary',

+ 'show_results',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.search_modify_param_before', compact($vars)));

+

+ AND " . $m_approve_topics_fid_sql . '

+ WHERE t.topic_posts_approved = 1

+ AND $m_approve_posts_fid_sql

+ WHERE t.topic_posts_approved = 1

+ AND $m_approve_topics_fid_sql

+ AND ' . $m_approve_topics_fid_sql . '

+

+ $template->assign_var('U_MARK_ALL_READ', ($user->data['is_registered'] || $config['load_anon_lastread']) ? append_sid("{$phpbb_root_path}index.$phpEx", 'hash=' . generate_link_hash('global') . '&amp;mark=forums&amp;mark_time=' . time()) : '');

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

+ AND ' . $m_approve_posts_fid_sql . '

+ ' . ((sizeof($ex_fid_ary)) ? ' AND ' . $db->sql_in_set('p.forum_id', $ex_fid_ary, true) : '') . "

+ AND ' . $m_approve_topics_fid_sql . '

+ AND ' . $m_approve_topics_fid_sql . "

+ /**

+ * Event to modify data after pre-made searches

+ *

+ * @event core.search_modify_param_after

+ * @var string l_search_title The title of the search page

+ * @var string search_id Predefined search type name

+ * @var string show_results Display topics or posts

+ * @var string sql SQL query corresponding to the pre-made search id

+ * @since 3.1.7-RC1

+ */

+ $vars = array(

+ 'l_search_title',

+ 'search_id',

+ 'show_results',

+ 'sql',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.search_modify_param_after', compact($vars)));

+

+ $start = $pagination->validate_start($start, $per_page, $total_match_count);

+ if ($search->get_search_query())

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

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

+ /**

+ * Event to search otherwise than by keywords or author

+ *

+ * @event core.search_backend_search_after

+ * @var string show_results 'posts' or 'topics' type of ids

+ * @var string search_fields The data fields to search in

+ * @var string search_terms Is either 'all' (use query as entered, words without prefix should default to "have to be in field") or 'any' (ignore search query parts and just return all posts that contain any of the specified words)

+ * @var array sort_by_sql Array of SQL sorting instructions

+ * @var string sort_key The sort key

+ * @var string sort_dir The sort direction

+ * @var int sort_days Limit the age of results

+ * @var array ex_fid_ary Array of excluded forum ids

+ * @var string m_approve_posts_fid_sql Specifies which types of posts the user can view in which forums

+ * @var int topic_id is set to 0 or a topic id, if it is not 0 then only posts in this topic should be searched

+ * @var array author_id_ary Array of exclusive author ids

+ * @var string sql_author_match Specifies the author match, when ANONYMOUS is also a search-match

+ * @var array id_ary Array of post or topic ids for search result

+ * @var int start The starting id of the results

+ * @var int per_page Number of ids each page is supposed to contain

+ * @var int total_match_count The total number of search matches

+ * @since 3.1.10-RC1

+ */

+ $vars = array(

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

+ 'total_match_count',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.search_backend_search_after', compact($vars)));

+

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

+ /**

+ * Event to add or modify search URL parameters

+ *

+ * @event core.search_modify_url_parameters

+ * @var string u_search Search URL parameters string

+ * @var string search_id Predefined search type name

+ * @var string show_results String indicating the show results mode

+ * @var string sql_where The SQL WHERE string used by search to get topic data

+ * @var int total_match_count The total number of search matches

+ * @var array ex_fid_ary Array of excluded forum ids

+ * @since 3.1.7-RC1

+ * @changed 3.1.10-RC1 Added show_results, sql_where, total_match_count

+ * @changed 3.1.11-RC1 Added ex_fid_ary

+ */

+ $vars = array(

+ 'u_search',

+ 'search_id',

+ 'show_results',

+ 'sql_where',

+ 'total_match_count',

+ 'ex_fid_ary',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.search_modify_url_parameters', compact($vars)));

+ $sql_array = array(

+ 'SELECT' => 'p.*, f.forum_id, f.forum_name, t.*, u.username, u.username_clean, u.user_sig, u.user_sig_bbcode_uid, u.user_colour',

+ 'FROM' => array(

+ POSTS_TABLE => 'p',

+ ),

+ 'LEFT_JOIN' => array(

+ array(

+ 'FROM' => array(TOPICS_TABLE => 't'),

+ 'ON' => 'p.topic_id = t.topic_id',

+ ),

+ array(

+ 'FROM' => array(FORUMS_TABLE => 'f'),

+ 'ON' => 'p.forum_id = f.forum_id',

+ ),

+ array(

+ 'FROM' => array(USERS_TABLE => 'u'),

+ 'ON' => 'p.poster_id = u.user_id',

+ ),

+ ),

+ 'WHERE' => $sql_where,

+ 'ORDER_BY' => $sort_by_sql[$sort_key] . ' ' . (($sort_dir == 'd') ? 'DESC' : 'ASC'),

+ );

+

+ /**

+ * Event to modify the SQL query before the posts data is retrieved

+ *

+ * @event core.search_get_posts_data

+ * @var array sql_array The SQL array

+ * @var array zebra Array of zebra data for the current user

+ * @var int total_match_count The total number of search matches

+ * @var string keywords String of the specified keywords

+ * @var array sort_by_sql Array of SQL sorting instructions

+ * @var string s_sort_dir The sort direction

+ * @var string s_sort_key The sort key

+ * @var string s_limit_days Limit the age of results

+ * @var array ex_fid_ary Array of excluded forum ids

+ * @var array author_id_ary Array of exclusive author ids

+ * @var string search_fields The data fields to search in

+ * @var int search_id The id of the search request

+ * @var int start The starting id of the results

+ * @since 3.1.0-b3

+ */

+ $vars = array(

+ 'sql_array',

+ 'zebra',

+ 'total_match_count',

+ 'keywords',

+ 'sort_by_sql',

+ 's_sort_dir',

+ 's_sort_key',

+ 's_limit_days',

+ 'ex_fid_ary',

+ 'author_id_ary',

+ 'search_fields',

+ 'search_id',

+ 'start',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.search_get_posts_data', compact($vars)));

+

+ $sql = $db->sql_build_query('SELECT', $sql_array);

+ $tracking_topics = $request->variable($config['cookie_name'] . '_track', '', true, \phpbb\request\request_interface::COOKIE);

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

+

+ /**

+ * Event to modify the SQL query before the topic data is retrieved

+ *

+ * @event core.search_get_topic_data

+ * @var string sql_select The SQL SELECT string used by search to get topic data

+ * @var string sql_from The SQL FROM string used by search to get topic data

+ * @var string sql_where The SQL WHERE string used by search to get topic data

+ * @var int total_match_count The total number of search matches

+ * @var array sort_by_sql Array of SQL sorting instructions

+ * @var string sort_dir The sorting direction

+ * @var string sort_key The sorting key

+ * @var string sql_order_by The SQL ORDER BY string used by search to get topic data

+ * @since 3.1.0-a1

+ * @changed 3.1.0-RC5 Added total_match_count

+ * @changed 3.1.7-RC1 Added sort_by_sql, sort_dir, sort_key, sql_order_by

+ */

+ $vars = array(

+ 'sql_select',

+ 'sql_from',

+ 'sql_where',

+ 'total_match_count',

+ 'sort_by_sql',

+ 'sort_dir',

+ 'sort_key',

+ 'sql_order_by',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.search_get_topic_data', compact($vars)));

+

+ WHERE $sql_where

+ ORDER BY $sql_order_by";

+ $topic_tracking_info[$forum_id] = get_topic_tracking($forum_id, $forum['topic_list'], $forum['rowset'], array($forum_id => $forum['mark_time']));

+ $topic_tracking_info[$forum_id] = get_complete_topic_tracking($forum_id, $forum['topic_list']);

+ $text_only_message = '';

+ /**

+ * Modify the rowset data

+ *

+ * @event core.search_modify_rowset

+ * @var array attachments Array with posts attachments data

+ * @var string hilit String to highlight

+ * @var array rowset Array with the search results data

+ * @var string show_results String indicating the show results mode

+ * @var array topic_tracking_info Array with the topics tracking data

+ * @var string u_hilit Highlight string to be injected into URL

+ * @var string view Search results view mode

+ * @var array zebra Array with zebra data for the current user

+ * @since 3.1.0-b4

+ * @changed 3.1.0-b5 Added var show_results

+ */

+ $vars = array(

+ 'attachments',

+ 'hilit',

+ 'rowset',

+ 'show_results',

+ 'topic_tracking_info',

+ 'u_hilit',

+ 'view',

+ 'zebra',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.search_modify_rowset', compact($vars)));

+

+ $replies = $phpbb_content_visibility->get_count('topic_posts', $row, $forum_id) - 1;

+ $view_topic_url_params = "f=$forum_id&amp;t=$result_topic_id" . (($u_hilit) ? "&amp;hilit=$u_hilit" : '');

+ $topic_unapproved = (($row['topic_visibility'] == ITEM_UNAPPROVED || $row['topic_visibility'] == ITEM_REAPPROVE) && $auth->acl_get('m_approve', $forum_id)) ? true : false;

+ $posts_unapproved = ($row['topic_visibility'] == ITEM_APPROVED && $row['topic_posts_unapproved'] && $auth->acl_get('m_approve', $forum_id)) ? true : false;

+ $topic_deleted = $row['topic_visibility'] == ITEM_DELETED;

+ $u_mcp_queue = (!$u_mcp_queue && $topic_deleted) ? append_sid("{$phpbb_root_path}mcp.$phpEx", "i=queue&amp;mode=deleted_topics&amp;t=$result_topic_id", true, $user->session_id) : $u_mcp_queue;

+ $row['topic_title'] = preg_replace('#(?!<.*)(?<!\w)(' . $hilit . ')(?!\w|[^<>]*(?:</s(?:cript|tyle))?>)#isu', '<span class="posthilit">$1</span>', $row['topic_title']);

+ 'TOPIC_IMG_STYLE' => $folder_img,

+ 'S_TOPIC_DELETED' => $topic_deleted,

+ 'S_HAS_POLL' => ($row['poll_start']) ? true : false,

+ $parse_flags = ($row['bbcode_bitfield'] ? OPTION_FLAG_BBCODE : 0) | OPTION_FLAG_SMILIES;

+ $row['post_text'] = generate_text_for_display($row['post_text'], $row['bbcode_uid'], $row['bbcode_bitfield'], $parse_flags, false);

+ $row['post_text'] = preg_replace('#(?!<.*)(?<!\w)(' . $hilit . ')(?!\w|[^<>]*(?:</s(?:cript|tyle))?>)#isu', '<span class="posthilit">$1</span>', $row['post_text']);

+ $row['post_subject'] = preg_replace('#(?!<.*)(?<!\w)(' . $hilit . ')(?!\w|[^<>]*(?:</s(?:cript|tyle))?>)#isu', '<span class="posthilit">$1</span>', $row['post_subject']);

+ $tpl_ary = array_merge($tpl_ary, array(

+ 'U_VIEW_POST' => (!empty($row['post_id'])) ? append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f=$forum_id&amp;t=" . $row['topic_id'] . '&amp;p=' . $row['post_id'] . (($u_hilit) ? '&amp;hilit=' . $u_hilit : '')) . '#p' . $row['post_id'] : '',

+

+ /**

+ * Modify the topic data before it is assigned to the template

+ *

+ * @event core.search_modify_tpl_ary

+ * @var array row Array with topic data

+ * @var array tpl_ary Template block array with topic data

+ * @var string show_results Display topics or posts

+ * @var string topic_title Cleaned topic title

+ * @var int replies The number of topic replies

+ * @var string view_topic_url The URL to the topic

+ * @var string folder_img The folder image of the topic

+ * @var string folder_alt The alt attribute of the topic folder img

+ * @var int topic_type The topic type

+ * @var bool unread_topic Whether the topic has unread posts

+ * @var bool topic_unapproved Whether the topic is unapproved

+ * @var int posts_unapproved The number of unapproved posts

+ * @var bool topic_deleted Whether the topic has been deleted

+ * @var string u_mcp_queue The URL to the corresponding MCP queue page

+ * @var array zebra The zebra data of the current user

+ * @var array attachments All the attachments of the search results

+ * @since 3.1.0-a1

+ * @changed 3.1.0-b3 Added vars show_results, topic_title, replies,

+ * view_topic_url, folder_img, folder_alt, topic_type, unread_topic,

+ * topic_unapproved, posts_unapproved, topic_deleted, u_mcp_queue,

+ * zebra, attachments

+ */

+ $vars = array(

+ 'row',

+ 'tpl_ary',

+ 'show_results',

+ 'topic_title',

+ 'replies',

+ 'view_topic_url',

+ 'folder_img',

+ 'folder_alt',

+ 'topic_type',

+ 'unread_topic',

+ 'topic_unapproved',

+ 'posts_unapproved',

+ 'topic_deleted',

+ 'u_mcp_queue',

+ 'zebra',

+ 'attachments',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.search_modify_tpl_ary', compact($vars)));

+

+ $template->assign_block_vars('searchresults', $tpl_ary);

+

+ if ($show_results == 'topics')

+ {

+ $pagination->generate_template_pagination($view_topic_url, 'searchresults.pagination', 'start', $replies + 1, $config['posts_per_page'], 1, true, true);

+ }

+ 'L_RETURN_TO_TOPIC' => $user->lang('RETURN_TO', $topic_title),

+ // Output header

+ if ($found_more_search_matches)

+ {

+ $l_search_matches = $user->lang('FOUND_MORE_SEARCH_MATCHES', (int) $total_match_count);

+ }

+ else

+ {

+ $l_search_matches = $user->lang('FOUND_SEARCH_MATCHES', (int) $total_match_count);

+ }

+

+ // Check if search backend supports phrase search or not

+ $phrase_search_disabled = '';

+ if (strpos(html_entity_decode($keywords), '"') !== false && method_exists($search, 'supports_phrase_search'))

+ {

+ $phrase_search_disabled = $search->supports_phrase_search() ? false : true;

+ }

+

+ $pagination->generate_template_pagination($u_search, 'pagination', 'start', $total_match_count, $per_page, $start);

+

+ $template->assign_vars(array(

+ 'SEARCH_TITLE' => $l_search_title,

+ 'SEARCH_MATCHES' => $l_search_matches,

+ 'SEARCH_WORDS' => $keywords,

+ 'SEARCHED_QUERY' => $search->get_search_query(),

+ 'IGNORED_WORDS' => (!empty($common_words)) ? implode(' ', $common_words) : '',

+

+ 'PHRASE_SEARCH_DISABLED' => $phrase_search_disabled,

+

+ 'TOTAL_MATCHES' => $total_match_count,

+ 'SEARCH_IN_RESULTS' => ($search_id) ? false : true,

+

+ 'S_SELECT_SORT_DIR' => $s_sort_dir,

+ 'S_SELECT_SORT_KEY' => $s_sort_key,

+ 'S_SELECT_SORT_DAYS' => $s_limit_days,

+ 'S_SEARCH_ACTION' => $u_search,

+ 'S_SHOW_TOPICS' => ($show_results == 'posts') ? false : true,

+

+ 'GOTO_PAGE_IMG' => $user->img('icon_post_target', 'GOTO_PAGE'),

+ 'NEWEST_POST_IMG' => $user->img('icon_topic_newest', 'VIEW_NEWEST_POST'),

+ 'REPORTED_IMG' => $user->img('icon_topic_reported', 'TOPIC_REPORTED'),

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

+ 'DELETED_IMG' => $user->img('icon_topic_deleted', 'TOPIC_DELETED'),

+ 'POLL_IMG' => $user->img('icon_topic_poll', 'TOPIC_POLL'),

+ 'LAST_POST_IMG' => $user->img('icon_topic_latest', 'VIEW_LATEST_POST'),

+

+ 'U_SEARCH_WORDS' => $u_search,

+ ));

+

+ /**

+ * Modify the title and/or load data for the search results page

+ *

+ * @event core.search_results_modify_search_title

+ * @var int author_id ID of the author to search by

+ * @var string l_search_title The title of the search page

+ * @var string search_id Predefined search type name

+ * @var string show_results Search results output mode - topics or posts

+ * @var int start The starting id of the results

+ * @var int total_match_count The count of search results

+ * @var string keywords The search keywords

+ * @since 3.1.0-RC4

+ * @changed 3.1.6-RC1 Added total_match_count and keywords

+ */

+ $vars = array(

+ 'author_id',

+ 'l_search_title',

+ 'search_id',

+ 'show_results',

+ 'start',

+ 'total_match_count',

+ 'keywords',

+ );

+ extract($phpbb_dispatcher->trigger_event('core.search_results_modify_search_title', compact($vars)));

+

+$rowset = array();

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

+{

+ $rowset[(int) $row['forum_id']] = $row;

+}

+$db->sql_freeresult($result);

+

+/**

+* Modify the forum select list for advanced search page

+*

+* @event core.search_modify_forum_select_list

+* @var array rowset Array with the forums list data

+* @since 3.1.10-RC1

+*/

+$vars = array('rowset');

+extract($phpbb_dispatcher->trigger_event('core.search_modify_forum_select_list', compact($vars)));

+

+foreach ($rowset as $row)

+unset($rowset);

+for ($i = 100; $i <= 1000; $i += 100)

+ switch ($db->get_sql_layer())