protected $db;

/**

* User object

* @var \phpbb\user

*/

* @param \phpbb\config\config $config Config object

* @param \phpbb\db\driver\driver_interface Database object

* @param \phpbb\user $user User object

*/

{

$this->config = $config;

$this->db = $db;

$this->user = $user;

$this->word_length = array('min' => $this->config['fulltext_mysql_min_word_len'], 'max' => $this->config['fulltext_mysql_max_word_len']);

}

// generate a search_key from all the options to identify the results

implode(', ', $this->split_words),

$type,

$fields,

implode(',', $ex_fid_ary),

$post_visibility,

implode(',', $author_ary)

if ($start < 0)

{

break;

}

$sql_select = (!$result_count) ? 'SQL_CALC_FOUND_ROWS ' : '';

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

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

}

// generate a search_key from all the options to identify the results

'',

$type,

($firstpost_only) ? 'firstpost' : '',

$post_visibility,

implode(',', $author_ary),

$author_name,

if ($start < 0)

{

$m_approve_fid_sql = ' AND ' . $post_visibility;

// If the cache was completely empty count the results

$calc_results = ($result_count) ? '' : 'SQL_CALC_FOUND_ROWS ';

protected $must_not_contain_ids = array();

/**

* @var array

*/

protected $must_exclude_one_ids = array();

protected $db;

/**

* User object

* @var \phpbb\user

*/

* Initialises the fulltext_native search backend with min/max word length and makes sure the UTF-8 normalizer is loaded

*

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

*/

{

$this->phpbb_root_path = $phpbb_root_path;

$this->php_ext = $phpEx;

$this->config = $config;

$this->db = $db;

$this->user = $user;

$this->word_length = array('min' => $this->config['fulltext_native_min_chars'], 'max' => $this->config['fulltext_native_max_chars']);

sort($must_exclude_one_ids);

// generate a search_key from all the options to identify the results

serialize($must_contain_ids),

serialize($must_not_contain_ids),

serialize($must_exclude_one_ids),

$post_visibility,

implode(',', $author_ary),

$author_name,

// try reading the results from cache

$total_results = 0;

$sql_where[] = $post_visibility;

if ($topic_id)

{

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

}

// generate a search_key from all the options to identify the results

'',

$type,

($firstpost_only) ? 'firstpost' : '',

$post_visibility,

implode(',', $author_ary),

$author_name,

// try reading the results from cache

$total_results = 0;

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

$is_mysql = false;

// If the cache was completely empty count the results

if (!$total_results)

{

// Count rows for the executed queries. Replace $select within $sql with SQL_CALC_FOUND_ROWS, and run it.

$sql_calc = str_replace('SELECT ' . $select, 'SELECT DISTINCT SQL_CALC_FOUND_ROWS p.post_id', $sql);

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

$sql_count = 'SELECT FOUND_ROWS() as total_results';

protected $db;

/**

* User object

* @var \phpbb\user

*/

* @param \phpbb\config\config $config Config object

* @param \phpbb\db\driver\driver_interface Database object

* @param \phpbb\user $user User object

*/

{

$this->config = $config;

$this->db = $db;

$this->user = $user;

$this->word_length = array('min' => $this->config['fulltext_postgres_min_word_len'], 'max' => $this->config['fulltext_postgres_max_word_len']);

}

// generate a search_key from all the options to identify the results

implode(', ', $this->split_words),

$type,

$fields,

implode(',', $ex_fid_ary),

$post_visibility,

implode(',', $author_ary)

if ($start < 0)

{

break;

}

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

}

// generate a search_key from all the options to identify the results

'',

$type,

($firstpost_only) ? 'firstpost' : '',

$post_visibility,

implode(',', $author_ary),

$author_name,

if ($start < 0)

{

$m_approve_fid_sql = ' AND ' . $post_visibility;

// Build the query for really selecting the post_ids

if ($type == 'posts')

{

protected $dbtype;

/**

* User object

* @var \phpbb\user

*/

* @param \phpbb\config\config $config Config object

* @param \phpbb\db\driver\driver_interface Database object

* @param \phpbb\user $user User object

*/

{

$this->phpbb_root_path = $phpbb_root_path;

$this->php_ext = $phpEx;

$this->config = $config;

$this->user = $user;

$this->db = $db;

$this->auth = $auth;

// Initialize \phpbb\db\tools object

$this->db_tools = new \phpbb\db\tools($this->db);

{

set_config('fulltext_sphinx_id', unique_id());

}

$non_unique = array('sql_query_pre' => true, 'sql_attr_uint' => true, 'sql_attr_timestamp' => true, 'sql_attr_str2ordinal' => true, 'sql_attr_bool' => true);

$delete = array('sql_group_column' => true, 'sql_date_column' => true, 'sql_str2ordinal_column' => true);

foreach ($config_data as $section_name => $section_data)

{

$section = $config_object->get_section_by_name($section_name);

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

}

$search_query_prefix = '';

switch ($fields)