{

global $cache, $config, $db, $user;

// nothing to cache so exit

if (!$length)

if (!($store = $cache->get('_search_results_' . $search_key)))

{

// add the current keywords to the recent searches in the cache which are listed on the search page

{

$sql = 'SELECT search_time

FROM ' . SEARCH_RESULTS_TABLE . '

$store += $store_ids;

// if the cache is too big

{

// remove everything in front of two blocks in front of the current start index

for ($i = 0, $n = $id_range[0] - 2 * $config['search_block_size']; $i < $n; $i++)

global $db, $cache, $config;

// clear all searches that searched for the specified words

{

$sql_where = '';

foreach ($words as $word)

}

// clear all searches that searched for the specified authors

{

$sql_where = '';

foreach ($authors as $author)

$sql = 'DELETE

FROM ' . SEARCH_RESULTS_TABLE . '

$db->sql_query($sql);

}

}

}

$sql = 'SHOW VARIABLES

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

$mysql_info = array();

}

$this->db->sql_freeresult($result);

return false;

}

$this->split_words = $matches[1];

// We limit the number of allowed keywords to minimize load on the database

{

}

// to allow phrase search, we need to concatenate quoted words

// remove too short or too long words

$text = array_values($text);

{

$text[$i] = trim($text[$i]);

if (utf8_strlen($text[$i]) < $this->config['fulltext_mysql_min_word_len'] || utf8_strlen($text[$i]) > $this->config['fulltext_mysql_max_word_len'])

$sql_select = ($type == 'posts') ? $sql_select . 'p.post_id' : 'DISTINCT ' . $sql_select . 't.topic_id';

$sql_from = ($join_topic) ? TOPICS_TABLE . ' t, ' : '';

$field = ($type == 'posts') ? 'post_id' : 'topic_id';

{

// first one matches post of registered users, second one guests and deleted users

$sql_author = ' AND (' . $this->db->sql_in_set('p.poster_id', array_diff($author_ary, array(ANONYMOUS)), false, true) . ' OR p.post_username ' . $author_name . ')';

}

{

$sql_author = ' AND ' . $this->db->sql_in_set('p.poster_id', $author_ary);

}

$sql_where_options = $sql_sort_join;

$sql_where_options .= ($topic_id) ? ' AND p.topic_id = ' . $topic_id : '';

$sql_where_options .= ($join_topic) ? ' AND t.topic_id = p.topic_id' : '';

$sql_where_options .= ' AND ' . $post_visibility;

$sql_where_options .= $sql_author;

$sql_where_options .= ($sort_days) ? ' AND p.post_time >= ' . (time() - ($sort_days * 86400)) : '';

WHERE MATCH ($sql_match) AGAINST ('" . $this->db->sql_escape(htmlspecialchars_decode($this->search_query)) . "' IN BOOLEAN MODE)

$sql_where_options

ORDER BY $sql_sort";

$result = $this->db->sql_query_limit($sql, $this->config['search_block_size'], $start);

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

$id_ary = array_unique($id_ary);

// if the total result count is not cached yet, retrieve it from the db

{

$sql_found_rows = 'SELECT FOUND_ROWS() as result_count';

$result = $this->db->sql_query($sql_found_rows);

public function author_search($type, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, &$start, $per_page)

{

// No author? No posts

{

return 0;

}

{

$sql_author = $this->db->sql_in_set('p.poster_id', $author_ary);

}

$sql_topic_id = ($topic_id) ? ' AND p.topic_id = ' . (int) $topic_id : '';

$sql_time = ($sort_days) ? ' AND p.post_time >= ' . (time() - ($sort_days * 86400)) : '';

$sql_firstpost = ($firstpost_only) ? ' AND p.post_id = t.topic_first_post_id' : '';

$id_ary = array_unique($id_ary);

}

{

$this->save_ids($search_key, '', $author_ary, $result_count, $id_ary, $start, $sort_dir);

$id_ary = array_slice($id_ary, 0, $per_page);

$words = array_unique(array_merge($split_text, $split_title));

unset($split_text);

unset($split_title);

// destroy too old cached search results

$this->destroy_cache(array());

}

/**

$alter_list[] = $alter_entry;

}

{

}

$this->db->sql_query('TRUNCATE TABLE ' . SEARCH_RESULTS_TABLE);

$alter[] = 'DROP INDEX post_content';

}

{

}

$this->db->sql_query('TRUNCATE TABLE ' . SEARCH_RESULTS_TABLE);

$this->get_stats();

}

}

/**

{

$this->stats['post_subject'] = $row;

}

else if ($row['Key_name'] == 'post_content')

{

$this->stats['post_content'] = $row;

*/

class fulltext_native extends \phpbb\search\base

{

/**

* Associative array holding index stats

* @var array

protected $user;

/**

*

* @param boolean|string &$error is passed by reference and should either be set to false on success or an error message on failure

* @param \phpbb\event\dispatcher_interface $phpbb_dispatcher Event dispatcher object

$this->phpbb_dispatcher = $phpbb_dispatcher;

$this->user = $user;

/**

* Load the UTF tools

*/

if (!function_exists('utf8_decode_ncr'))

{

include($this->phpbb_root_path . 'includes/utf/utf_tools.' . $this->php_ext);

*/

public function split_keywords($keywords, $terms)

{

$keywords = trim($this->cleanup($keywords, $tokens));

$keywords[$i] = '|';

break;

case '*':

{

}

break;

}

}

}

{

$keywords .= ')';

}

);

$keywords = preg_replace($match, $replace, $keywords);

// We limit the number of allowed keywords to minimize load on the database

if ($this->config['max_num_search_keywords'] && $num_keywords > $this->config['max_num_search_keywords'])

$words = array();

preg_match_all('#([^\\s+\\-|()]+)(?:$|[\\s+\\-|()])#u', $keywords, $words);

{

$keywords = '(' . implode('|', $words[1]) . ')';

}

}

// set the search_query which is shown to the user

$this->search_query = $keywords;

$common_ids = $words = array();

{

$sql = 'SELECT word_id, word_text, word_common

FROM ' . SEARCH_WORDLIST_TABLE . '

$this->must_not_contain_ids = array();

$this->must_exclude_one_ids = array();

foreach ($query as $word)

{

if (empty($word))

{

if (strpos($word_part, '*') !== false)

{

}

else if (isset($words[$word_part]))

{

}

}

}

{

sort($id_words);

{

$this->{$mode . '_ids'}[] = $id_words;

}

}

}

// throw an error if we shall not ignore unexistant words

{

trigger_error(sprintf($this->user->lang['WORDS_IN_NO_POST'], implode($this->user->lang['COMMA_SEPARATOR'], $non_common_words)));

}

}

// Return true if all words are not common words

{

return true;

}

$id_ary = array();

$sql_where = array();

$m_num = 0;

$w_num = 0;

}

}

{

$sql_array['LEFT_JOIN'][] = array(

'FROM' => array(SEARCH_WORDMATCH_TABLE => 'm' . $m_num),

$sql_where[] = 'p.topic_id = ' . $topic_id;

}

{

if ($author_name)

{

$sql_where[] = $sql_author;

}

{

$sql_where[] = $this->db->sql_in_set('p.forum_id', $ex_fid_ary, true);

}

break;

case 'sqlite3':

$sql_array_count['SELECT'] = ($type == 'posts') ? 'DISTINCT p.post_id' : 'DISTINCT p.topic_id';

$sql = 'SELECT COUNT(' . (($type == 'posts') ? 'post_id' : 'topic_id') . ') as total_results

public function author_search($type, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, &$start, $per_page)

{

// No author? No posts

{

return 0;

}

{

$sql_author = $this->db->sql_in_set('p.poster_id', $author_ary);

}

$sql_time = ($sort_days) ? ' AND p.post_time >= ' . (time() - ($sort_days * 86400)) : '';

$sql_topic_id = ($topic_id) ? ' AND p.topic_id = ' . (int) $topic_id : '';

$sql_firstpost = ($firstpost_only) ? ' AND p.post_id = t.topic_first_post_id' : '';

}

else

{

{

$sql = 'SELECT COUNT(topic_id) as total_results

FROM (SELECT DISTINCT t.topic_id';

$post_visibility

$sql_fora

AND t.topic_id = p.topic_id

}

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

$this->db->sql_freeresult($result);

}

{

$this->save_ids($search_key, '', $author_ary, $total_results, $id_ary, $start, $sort_dir);

$id_ary = array_slice($id_ary, 0, $per_page);

$match[] = '#\[\/?[a-z0-9\*\+\-]+(?:=.*?)?(?::[a-z])?(\:?[0-9a-z]{5,})\]#';

$min = $this->word_length['min'];

$isset_min = $min - 1;

* Note: this could be optimized. If the codepoint is lower than Hangul's range

* we know that it will also be lower than CJK ranges

*/

{

$word = strtok(' ');

continue;

$words['del']['post'] = array();

$words['del']['title'] = array();

}

unset($split_text);

unset($split_title);

// individual arrays of added and removed words for text and title. What

// we need to do now is add the new words (if they don't already exist)

// and then add (or remove) matches between the words and this post

{

$sql = 'SELECT word_id, word_text

FROM ' . SEARCH_WORDLIST_TABLE . '

$new_words = array_diff($unique_add_words, array_keys($word_ids));

$this->db->sql_transaction('begin');

{

$sql_ary = array();

{

$title_match = ($word_in == 'title') ? 1 : 0;

{

$sql_in = array();

foreach ($word_ary as $word)

{

$title_match = ($word_in == 'title') ? 1 : 0;

{

$sql = 'INSERT INTO ' . SEARCH_WORDMATCH_TABLE . ' (post_id, word_id, title_match)

SELECT ' . (int) $post_id . ', word_id, ' . (int) $title_match . '

*/

public function index_remove($post_ids, $author_ids, $forum_ids)

{

{

$sql = 'SELECT w.word_id, w.word_text, m.title_match

FROM ' . SEARCH_WORDMATCH_TABLE . ' m, ' . SEARCH_WORDLIST_TABLE . ' w

}

$this->db->sql_freeresult($result);

{

$sql = 'UPDATE ' . SEARCH_WORDLIST_TABLE . '

SET word_count = word_count - 1

$this->db->sql_query($sql);

}

{

$sql = 'UPDATE ' . SEARCH_WORDLIST_TABLE . '

SET word_count = word_count - 1

// carry on ... it's okay ... I know when I'm not wanted boo hoo

if (!$this->config['fulltext_native_load_upd'])

{

return;

}

}

$this->db->sql_freeresult($result);

{

// Flag the words

$sql = 'UPDATE ' . SEARCH_WORDLIST_TABLE . '

// by setting search_last_gc to the new time here we make sure that if a user reloads because the

// following query takes too long, he won't run into it again

// Delete the matches

$sql = 'DELETE FROM ' . SEARCH_WORDMATCH_TABLE . '

unset($sql_in);

}

{

// destroy cached search results containing any of the words that are now common or were removed

$this->destroy_cache(array_unique($destroy_cache_words));

}

}

/**

*/

public function delete_index($acp_module, $u_action)

{

switch ($this->db->get_sql_layer())

{

case 'sqlite3':

break;

default:

break;

}

}

/**

*/

public function index_created()

{

{

$this->get_stats();

}

*/

public function index_stats()

{

{

$this->get_stats();

}

* @param string $allowed_chars String of special chars to allow

* @param string $encoding Text encoding

* @return string Cleaned up text, only alphanumeric chars are left

*/

protected function cleanup($text, $allowed_chars = null, $encoding = 'utf-8')

{

static $conv = array(), $conv_loaded = array();

// Convert the text to UTF-8

$encoding = strtolower($encoding);

$text = htmlspecialchars_decode(utf8_decode_ncr($text), ENT_QUOTES);

/**

*/

/**

* The first thing we do is:

$utf_char = substr($text, $pos, $utf_len);

$pos += $utf_len;

{

/**

* All characters within these ranges are valid

// remove too short or too long words

$text = array_values($text);

{

$text[$i] = trim($text[$i]);

if (utf8_strlen($text[$i]) < $this->config['fulltext_postgres_min_word_len'] || utf8_strlen($text[$i]) > $this->config['fulltext_postgres_max_word_len'])

);

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

$sql_from = ($join_topic) ? TOPICS_TABLE . ' t, ' : '';

$field = ($type == 'posts') ? 'post_id' : 'topic_id';

{

// first one matches post of registered users, second one guests and deleted users

$sql_author = '(' . $this->db->sql_in_set('p.poster_id', array_diff($author_ary, array(ANONYMOUS)), false, true) . ' OR p.post_username ' . $author_name . ')';

}

{

$sql_author = ' AND ' . $this->db->sql_in_set('p.poster_id', $author_ary);

}

$sql_where_options = $sql_sort_join;

$sql_where_options .= ($topic_id) ? ' AND p.topic_id = ' . $topic_id : '';

$sql_where_options .= ($join_topic) ? ' AND t.topic_id = p.topic_id' : '';

$sql_where_options .= ' AND ' . $post_visibility;

$sql_where_options .= $sql_author;

$sql_where_options .= ($sort_days) ? ' AND p.post_time >= ' . (time() - ($sort_days * 86400)) : '';

$sql_where_options .= $sql_match_where;

$sql_match = str_replace(',', " || ' ' ||", $sql_match);

$tmp_sql_match = "to_tsvector ('" . $this->db->sql_escape($this->config['fulltext_postgres_ts_name']) . "', " . $sql_match . ") @@ to_tsquery ('" . $this->db->sql_escape($this->config['fulltext_postgres_ts_name']) . "', '" . $this->db->sql_escape($this->tsearch_query) . "')";

public function author_search($type, $firstpost_only, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, &$start, $per_page)

{

// No author? No posts

{

return 0;

}

{

$sql_author = $this->db->sql_in_set('p.poster_id', $author_ary);

}

$sql_topic_id = ($topic_id) ? ' AND p.topic_id = ' . (int) $topic_id : '';

$sql_time = ($sort_days) ? ' AND p.post_time >= ' . (time() - ($sort_days * 86400)) : '';

$sql_firstpost = ($firstpost_only) ? ' AND p.post_id = t.topic_first_post_id' : '';

GROUP BY t.topic_id, $sort_by_sql[$sort_key]";

}

$result_count = (int) $this->db->sql_fetchfield('result_count');

if (!$result_count)

$id_ary = array_unique($id_ary);

}

{

$this->save_ids($search_key, '', $author_ary, $result_count, $id_ary, $start, $sort_dir);

$id_ary = array_slice($id_ary, 0, $per_page);

$words = array_unique(array_merge($split_text, $split_title));

unset($split_text);

unset($split_title);

// destroy too old cached search results

$this->destroy_cache(array());

}

/**

$this->get_stats();

}

if (!isset($this->stats['post_subject']))

{

}

if (!isset($this->stats['post_content']))

{

}

$this->db->sql_query('TRUNCATE TABLE ' . SEARCH_RESULTS_TABLE);

$this->get_stats();

}

if (isset($this->stats['post_subject']))

{

}

if (isset($this->stats['post_content']))

{

}

$this->db->sql_query('TRUNCATE TABLE ' . SEARCH_RESULTS_TABLE);

/**

* Database Tools object

*/

protected $db_tools;

$this->db = $db;

$this->auth = $auth;

if (!$this->config['fulltext_sphinx_id'])

{

}

$this->id = $this->config['fulltext_sphinx_id'];

$this->indexes = 'index_phpbb_' . $this->id . '_delta;index_phpbb_' . $this->id . '_main';

}

// Move delta to main index each hour

return false;

}

AND p.post_id >= $start AND p.post_id <= $end'),

array('sql_query_post', ''),

array('sql_query_post_index', 'UPDATE ' . SPHINX_TABLE . ' SET max_doc_id = $maxid WHERE counter_id = 1'),

array('sql_attr_uint', 'forum_id'),

array('sql_attr_uint', 'topic_id'),

array('sql_attr_uint', 'poster_id'),

array('sql_attr_string', 'post_subject'),

),

'source source_phpbb_' . $this->id . '_delta : source_phpbb_' . $this->id . '_main' => array(

array('sql_query_range', ''),

array('sql_range_step', ''),

array('sql_query', 'SELECT

WHERE

p.topic_id = t.topic_id

AND p.post_id >= ( SELECT max_doc_id FROM ' . SPHINX_TABLE . ' WHERE counter_id=1 )'),

),

'index index_phpbb_' . $this->id . '_main' => array(

array('path', $this->config['fulltext_sphinx_data_path'] . 'index_phpbb_' . $this->id . '_main'),

array('morphology', 'none'),

array('stopwords', ''),

array('min_word_len', '2'),

array('charset_table', 'U+FF10..U+FF19->0..9, 0..9, U+FF41..U+FF5A->a..z, U+FF21..U+FF3A->a..z, A..Z->a..z, a..z, U+0149, U+017F, U+0138, U+00DF, U+00FF, U+00C0..U+00D6->U+00E0..U+00F6, U+00E0..U+00F6, U+00D8..U+00DE->U+00F8..U+00FE, U+00F8..U+00FE, U+0100->U+0101, U+0101, U+0102->U+0103, U+0103, U+0104->U+0105, U+0105, U+0106->U+0107, U+0107, U+0108->U+0109, U+0109, U+010A->U+010B, U+010B, U+010C->U+010D, U+010D, U+010E->U+010F, U+010F, U+0110->U+0111, U+0111, U+0112->U+0113, U+0113, U+0114->U+0115, U+0115, U+0116->U+0117, U+0117, U+0118->U+0119, U+0119, U+011A->U+011B, U+011B, U+011C->U+011D, U+011D, U+011E->U+011F, U+011F, U+0130->U+0131, U+0131, U+0132->U+0133, U+0133, U+0134->U+0135, U+0135, U+0136->U+0137, U+0137, U+0139->U+013A, U+013A, U+013B->U+013C, U+013C, U+013D->U+013E, U+013E, U+013F->U+0140, U+0140, U+0141->U+0142, U+0142, U+0143->U+0144, U+0144, U+0145->U+0146, U+0146, U+0147->U+0148, U+0148, U+014A->U+014B, U+014B, U+014C->U+014D, U+014D, U+014E->U+014F, U+014F, U+0150->U+0151, U+0151, U+0152->U+0153, U+0153, U+0154->U+0155, U+0155, U+0156->U+0157, U+0157, U+0158->U+0159, U+0159, U+015A->U+015B, U+015B, U+015C->U+015D, U+015D, U+015E->U+015F, U+015F, U+0160->U+0161, U+0161, U+0162->U+0163, U+0163, U+0164->U+0165, U+0165, U+0166->U+0167, U+0167, U+0168->U+0169, U+0169, U+016A->U+016B, U+016B, U+016C->U+016D, U+016D, U+016E->U+016F, U+016F, U+0170->U+0171, U+0171, U+0172->U+0173, U+0173, U+0174->U+0175, U+0175, U+0176->U+0177, U+0177, U+0178->U+00FF, U+00FF, U+0179->U+017A, U+017A, U+017B->U+017C, U+017C, U+017D->U+017E, U+017E, U+0410..U+042F->U+0430..U+044F, U+0430..U+044F, U+4E00..U+9FFF'),

array('min_prefix_len', '0'),

array('min_infix_len', '0'),

),

'index index_phpbb_' . $this->id . '_delta : index_phpbb_' . $this->id . '_main' => array(

array('path', $this->config['fulltext_sphinx_data_path'] . 'index_phpbb_' . $this->id . '_delta'),

array('mem_limit', $this->config['fulltext_sphinx_indexer_mem_limit'] . 'M'),

),

'searchd' => array(

array('listen' , ($this->config['fulltext_sphinx_host'] ? $this->config['fulltext_sphinx_host'] : 'localhost') . ':' . ($this->config['fulltext_sphinx_port'] ? $this->config['fulltext_sphinx_port'] : '9312')),

array('log', $this->config['fulltext_sphinx_data_path'] . 'log/searchd.log'),

array('query_log', $this->config['fulltext_sphinx_data_path'] . 'log/sphinx-query.log'),

array('read_timeout', '5'),

array('max_children', '30'),

array('pid_file', $this->config['fulltext_sphinx_data_path'] . 'searchd.pid'),

array('binlog_path', $this->config['fulltext_sphinx_data_path']),

),

);

$variable = $section->get_variable_by_name($key);

if (!$variable)

{

}

else

{

}

else

{

}

}

}

$match = array('#\sand\s#i', '#\sor\s#i', '#\snot\s#i', '#\+#', '#-#', '#\|#', '#@#');

$replace = array(' & ', ' | ', ' - ', ' +', ' -', ' |', '');

$keywords = preg_replace($match, $replace, $keywords);

$this->sphinx->SetMatchMode(SPH_MATCH_EXTENDED);

}

*/

public function keyword_search($type, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_fid_ary, $post_visibility, $topic_id, $author_ary, $author_name, &$id_ary, &$start, $per_page)

{

// No keywords? No posts.

{

return false;

}

$id_ary = array();

// Sorting

if ($type == 'topics')

break;

}

{

$this->sphinx->SetFilter('poster_id', $author_ary);

}

// but at least it will also cause the same for normal users.

$this->sphinx->SetFilter('post_visibility', array(ITEM_APPROVED));

{

// All forums that a user is allowed to access

$fid_ary = array_unique(array_intersect(array_keys($this->auth->acl_getf('f_read', true)), array_keys($this->auth->acl_getf('f_search', true))));

// All forums that the user wants to and can search in

$search_forums = array_diff($fid_ary, $ex_fid_ary);

{

$this->sphinx->SetFilter('forum_id', $search_forums);

}

$this->sphinx->SetFilter('deleted', array(0));

// Could be connection to localhost:9312 failed (errno=111,

// msg=Connection refused) during rotate, retry if so

while (!$result && (strpos($this->sphinx->GetLastError(), "errno=111,") !== false) && $retries--)

{

usleep(SPHINX_CONNECT_WAIT_TIME);

}

if ($this->sphinx->GetLastError())

{

if ($this->auth->acl_get('a_'))

{

trigger_error($this->user->lang('SPHINX_SEARCH_FAILED', $this->sphinx->GetLastError()));

{

$start = floor(($result_count - 1) / $per_page) * $per_page;

// Could be connection to localhost:9312 failed (errno=111,

// msg=Connection refused) during rotate, retry if so

while (!$result && (strpos($this->sphinx->GetLastError(), "errno=111,") !== false) && $retries--)

{

usleep(SPHINX_CONNECT_WAIT_TIME);

}

}

*/

public function index($mode, $post_id, &$message, &$subject, $poster_id, $forum_id)

{

if ($mode == 'edit')

{

$this->sphinx->UpdateAttributes($this->indexes, array('forum_id', 'poster_id'), array((int) $post_id => array((int) $forum_id, (int) $poster_id)));

}

$this->db->sql_freeresult($result);

{

$this->sphinx->UpdateAttributes($this->indexes, array('topic_last_post_time'), $post_updates);

}

*/

public function tidy($create = false)

{

}

/**

*/

function get_section_by_name($name)

{

{

// Make sure this is really a section object and not a comment

if (($this->sections[$i] instanceof \phpbb\search\sphinx\config_section) && $this->sections[$i]->get_name() == $name)

function add_section($name)

{

$this->sections[] = new \phpbb\search\sphinx\config_section($name, '');

}

/**

*/

function get_variable_by_name($name)

{

{

// Make sure this is a variable object and not a comment

if (($this->variables[$i] instanceof \phpbb\search\sphinx\config_variable) && $this->variables[$i]->get_name() == $name)

*/

function delete_variables_by_name($name)

{

{

// Make sure this is a variable object and not a comment

if (($this->variables[$i] instanceof \phpbb\search\sphinx\config_variable) && $this->variables[$i]->get_name() == $name)

function create_variable($name, $value)

{

$this->variables[] = new \phpbb\search\sphinx\config_variable($name, $value, '');

}

/**