}

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

return false;

}

// destroy too old cached search results

$this->destroy_cache(array());

}

/**

*/

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

/**

* Load the UTF tools

*/

if (!function_exists('utf8_decode_ncr'))

{

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

$this->must_not_contain_ids = array();

$this->must_exclude_one_ids = array();

foreach ($query as $word)

{

if (empty($word))

$id_ary = array();

$sql_where = array();

$m_num = 0;

$w_num = 0;

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

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

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

{

return;

}

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

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

}

}

/**

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

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

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

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

if (sizeof($author_ary) && $author_name)

{

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

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

}

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

if (!$result_count)

// destroy too old cached search results

$this->destroy_cache(array());

}

/**

/**

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

}

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

if (!strlen($this->search_query) && !sizeof($author_ary))

{

$id_ary = array();

// Sorting

if ($type == 'topics')

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

{

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

{

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

*/

public function tidy($create = false)

{

}

/**