<?php

/**

*

*

*/

$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

if ($user->load && $config['limit_search_load'] && ($user->load > doubleval($config['limit_search_load'])))

{

$template->assign_var('S_NO_SEARCH', true);

}

// It is applicable if the configuration setting is non-zero, and the user cannot

if ($user->data['user_last_search'] > time() - $interval)

{

$template->assign_var('S_NO_SEARCH', true);

}

}

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

if ($keywords || $author || $author_id || $search_id || $submit)

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

}

$sql = 'SELECT user_id

FROM ' . USERS_TABLE . "

}

$db->sql_freeresult($result);

$sql = 'SELECT 1 as guest_post

FROM ' . POSTS_TABLE . "

if ($found_guest_post)

{

$author_id_ary[] = ANONYMOUS;

}

if (!sizeof($author_id_ary))

}

// We do some additional checks in the module to ensure it can actually be utilised

$error = false;

if ($error)

{

trigger_error($error);

}

// let the search module split up the keywords

if ($keywords)

{

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

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 />' : '';

if (!$keywords && sizeof($author_id_ary))

{

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

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

}

// define some variables needed for retrieving post_id/topic_id information

$sort_by_sql = array('a' => 'u.username_clean', 't' => (($show_results == 'posts') ? 'p.post_time' : 't.topic_last_post_time'), 'f' => 'f.forum_id', 'i' => 't.topic_title', 's' => (($show_results == 'posts') ? 'p.post_subject' : 't.topic_title'));

// pre-made searches

$sql = $field = $l_search_title = '';

if ($search_id)

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

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

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

break;

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

}

}

// show_results should not change after this

$per_page = ($show_results == 'posts') ? $config['posts_per_page'] : $config['topics_per_page'];

$total_match_count = 0;

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

if (sizeof($id_ary))

// Grab icons

$icons = $cache->obtain_icons();

// define some vars for urls

$u_hilit = urlencode(htmlspecialchars_decode(str_replace('|', ' ', $hilit)));

$u_show_results = '&amp;sr=' . $show_results;

$u_search .= ($search_fields != 'all') ? '&amp;sf=' . $search_fields : '';

$u_search .= ($return_chars != 300) ? '&amp;ch=' . $return_chars : '';

if ($sql_where)

{

}

$db->sql_freeresult($result);

}

else

{

$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

}

/**

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

*

* @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

*/

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

$sql = "SELECT $sql_select

FROM $sql_from

}

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

$result_topic_id = 0;

if ($show_results == 'topics')

{

}

else

{

$attach_list = array();

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

if ($return_chars == -1 || utf8_strlen($text_only_message) < ($return_chars + 3))

{

$row['display_text_only'] = false;

// Does this post have an attachment? If so, add it to the list

if ($row['post_attachment'] && $config['allow_attachments'])

unset($text_only_message);

// Pull attachment data

if (sizeof($attach_list))

{

$hilit_array = array_filter(explode('|', $hilit), 'strlen');

foreach ($hilit_array as $key => $value)

{

$hilit_array[$key] = preg_replace('#(^|\s)\\\\w\*\?(\s|$)#', '$1\w+?$2', $hilit_array[$key]);

}

$hilit = implode('|', $hilit_array);

}

foreach ($rowset as $row)

{

$forum_id = $row['forum_id'];

$unread_topic = (isset($topic_tracking_info[$forum_id][$row['topic_id']]) && $row['topic_last_post_time'] > $topic_tracking_info[$forum_id][$row['topic_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 = ($topic_unapproved || $posts_unapproved) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue&amp;mode=' . (($topic_unapproved) ? 'approve_details' : 'unapproved_posts') . "&amp;t=$result_topic_id", true, $user->session_id) : '';

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

'S_TOPIC_UNAPPROVED' => $topic_unapproved,

'S_POSTS_UNAPPROVED' => $posts_unapproved,

'S_TOPIC_DELETED' => $topic_deleted,

'U_LAST_POST' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", $view_topic_url_params . '&amp;p=' . $row['topic_last_post_id']) . '#p' . $row['topic_last_post_id'],

'U_LAST_POST_AUTHOR' => get_username_string('profile', $row['topic_last_poster_id'], $row['topic_last_poster_name'], $row['topic_last_poster_colour']),

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

*

* @event core.search_modify_tpl_ary

*/

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

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

{

$template->assign_vars(array(

'SEARCH_TOPIC' => $topic_title,

'U_SEARCH_TOPIC' => $view_topic_url

));

}

}

unset($rowset);

page_header(($l_search_title) ? $l_search_title : $user->lang['SEARCH']);

$template->set_filenames(array(

$s_characters .= '<option value="25">25</option>';

$s_characters .= '<option value="50">50</option>';

{

$selected = ($i == 300) ? ' selected="selected"' : '';

$s_characters .= '<option value="' . $i . '"' . $selected . '>' . $i . '</option>';

if ($auth->acl_get('a_search'))

{

// Handle large objects differently for Oracle and MSSQL

{

case 'oracle':

$sql = 'SELECT search_time, search_keywords