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

$engine === 'MyISAM' ||

// FULLTEXT is supported on InnoDB since MySQL 5.6.4 according to

// http://dev.mysql.com/doc/refman/5.6/en/innodb-storage-engine.html

$engine === 'InnoDB' &&

if (!$fulltext_supported)

{

}

$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

foreach ($this->split_words as $i => $word)

{

$clean_word = preg_replace('#^[+\-|"]#', '', $word);

// check word length

// 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'])

}

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

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

}

// 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)

{

{

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

$m_approve_fid_sql = ' AND ' . $post_visibility;

// If the cache was completely empty count the results

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

$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 ($this->db->get_sql_layer() == 'mysqli' || version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

{

}

else

{

}

}

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

{

if ($this->db->get_sql_layer() == 'mysqli' || version_compare($this->db->sql_server_info(true), '4.1.3', '>='))

{

}

else

{

}

}

{

}

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