+* @license http://opensource.org/licenses/gpl-2.0.php GNU General Public License v2

+class phpbb_search_fulltext_native extends phpbb_search_base

+ protected $stats = array();

+ protected $word_length = array();

+ protected $search_query;

+ protected $common_words = array();

+

+ protected $must_contain_ids = array();

+ protected $must_not_contain_ids = array();

+ protected $must_exclude_one_ids = array();

+ protected $phpbb_root_path;

+ protected $php_ext;

+ protected $config;

+ protected $db;

+ protected $user;

+ public function __construct(&$error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user)

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

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

+ * Returns the name of this search backend to be displayed to administrators

+ *

+ * @return string Name

+ */

+ public function get_name()

+ {

+ return 'phpBB Native Fulltext';

+ }

+

+ /**

+ * Returns the search_query

+ *

+ * @return string search query

+ */

+ public function get_search_query()

+ {

+ return $this->search_query;

+ }

+

+ /**

+ * Returns the common_words array

+ *

+ * @return array common words that are ignored by search backend

+ */

+ public function get_common_words()

+ {

+ return $this->common_words;

+ }

+

+ /**

+ * Returns the word_length array

+ *

+ * @return array min and max word length for searching

+ */

+ public function get_word_length()

+ {

+ return $this->word_length;

+ }

+

+ /**

+ public function split_keywords($keywords, $terms)

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

+ trigger_error($this->user->lang('MAX_NUM_SEARCH_KEYWORDS_REFINE', $this->config['max_num_search_keywords'], $num_keywords));

+ WHERE ' . $this->db->sql_in_set('word_text', $exact_words) . '

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

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

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

+ $id_words[] = '\'' . $this->db->sql_escape(str_replace('*', '%', $word_part)) . '\'';

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

+ $this->{$mode . '_ids'}[] = '\'' . $this->db->sql_escape(str_replace('*', '%', $word)) . '\'';

+ trigger_error(sprintf($this->user->lang['WORD_IN_NO_POST'], $word));

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

+ $sql_where[] = $this->db->sql_in_set("m$m_num.word_id", $word_ids);

+ 'ON' => $this->db->sql_in_set("m$m_num.word_id", $this->must_not_contain_ids) . (($title_match) ? " AND m$m_num.$title_match" : '') . " AND m$m_num.post_id = m0.post_id"

+ $sql_where[] = '(p.post_approved = 1 OR ' . $this->db->sql_in_set('p.forum_id', $m_approve_fid_ary, true) . ')';

+ $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 = $this->db->sql_in_set('p.poster_id', $author_ary);

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

+ switch ($this->db->sql_layer)

+ FROM (' . $this->db->sql_build_query('SELECT', $sql_array_count) . ')';

+ $sql = (!$sql) ? $this->db->sql_build_query('SELECT', $sql_array_count) : $sql;

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

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

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

+ $sql = $this->db->sql_build_query('SELECT', $sql_array);

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

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

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

+ $sql = $this->db->sql_build_query('SELECT', $sql_array_copy);

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

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

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

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

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

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

+ $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 = $this->db->sql_in_set('p.poster_id', $author_ary);

+ $sql_fora = (sizeof($ex_fid_ary)) ? ' AND ' . $this->db->sql_in_set('p.forum_id', $ex_fid_ary, true) : '';

+ $m_approve_fid_sql = ' AND (p.post_approved = 1 OR ' . $this->db->sql_in_set('p.forum_id', $m_approve_fid_ary, true) . ')';

+ switch ($this->db->sql_layer)

+ if ($this->db->sql_layer == 'sqlite')

+ $sql_time" . (($this->db->sql_layer == 'sqlite') ? ')' : '');

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

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

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

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

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

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

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

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

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

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

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

+ public function split_message($text)

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

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

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

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

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

+ WHERE ' . $this->db->sql_in_set('word_text', $unique_add_words);

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

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

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

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

+ $this->db->sql_return_on_error(true);

+ $this->db->sql_multi_insert(SEARCH_WORDLIST_TABLE, $sql_ary);

+ $this->db->sql_return_on_error(false);

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

+ WHERE ' . $this->db->sql_in_set('word_id', $sql_in) . '

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

+ WHERE ' . $this->db->sql_in_set('word_id', $sql_in) . '

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

+ $this->db->sql_return_on_error(true);

+ WHERE ' . $this->db->sql_in_set('word_text', $word_ary);

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

+ WHERE ' . $this->db->sql_in_set('word_text', $word_ary);

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

+ $this->db->sql_return_on_error(false);

+ $this->db->sql_transaction('commit');

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

+ WHERE ' . $this->db->sql_in_set('m.post_id', $post_ids) . '

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

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

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

+ WHERE ' . $this->db->sql_in_set('word_id', $title_word_ids) . '

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

+ WHERE ' . $this->db->sql_in_set('word_id', $message_word_ids) . '

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

+ WHERE ' . $this->db->sql_in_set('post_id', $post_ids);

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

+ public function tidy()

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

+ if ($this->config['num_posts'] >= 100 && $this->config['fulltext_native_common_thres'])

+ $common_threshold = ((double) $this->config['fulltext_native_common_thres']) / 100.0;

+ WHERE word_count > ' . floor($this->config['num_posts'] * $common_threshold) . '

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

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

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

+ WHERE ' . $this->db->sql_in_set('word_id', $sql_in);

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

+ WHERE ' . $this->db->sql_in_set('word_id', $sql_in);

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

+ public function delete_index($acp_module, $u_action)

+ switch ($this->db->sql_layer)

+ $this->db->sql_query('DELETE FROM ' . SEARCH_WORDLIST_TABLE);

+ $this->db->sql_query('DELETE FROM ' . SEARCH_WORDMATCH_TABLE);

+ $this->db->sql_query('DELETE FROM ' . SEARCH_RESULTS_TABLE);

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

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

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

+ public function index_created()

+ public function index_stats()

+ $this->user->lang['TOTAL_WORDS'] => $this->stats['total_words'],

+ $this->user->lang['TOTAL_MATCHES'] => $this->stats['total_matches']);

+ protected function get_stats()

+ $this->stats['total_words'] = $this->db->get_estimated_row_count(SEARCH_WORDLIST_TABLE);

+ $this->stats['total_matches'] = $this->db->get_estimated_row_count(SEARCH_WORDMATCH_TABLE);

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

+ $file = $this->phpbb_root_path . 'includes/utf/data/search_indexer_' . $idx . '.' . $this->php_ext;

+ public function acp()

+ <dt><label for="fulltext_native_load_upd">' . $this->user->lang['YES_SEARCH_UPDATE'] . ':</label><br /><span>' . $this->user->lang['YES_SEARCH_UPDATE_EXPLAIN'] . '</span></dt>

+ <dd><label><input type="radio" id="fulltext_native_load_upd" name="config[fulltext_native_load_upd]" value="1"' . (($this->config['fulltext_native_load_upd']) ? ' checked="checked"' : '') . ' class="radio" /> ' . $this->user->lang['YES'] . '</label><label><input type="radio" name="config[fulltext_native_load_upd]" value="0"' . ((!$this->config['fulltext_native_load_upd']) ? ' checked="checked"' : '') . ' class="radio" /> ' . $this->user->lang['NO'] . '</label></dd>

+ <dt><label for="fulltext_native_min_chars">' . $this->user->lang['MIN_SEARCH_CHARS'] . ':</label><br /><span>' . $this->user->lang['MIN_SEARCH_CHARS_EXPLAIN'] . '</span></dt>

+ <dd><input id="fulltext_native_min_chars" type="text" size="3" maxlength="3" name="config[fulltext_native_min_chars]" value="' . (int) $this->config['fulltext_native_min_chars'] . '" /></dd>

+ <dt><label for="fulltext_native_max_chars">' . $this->user->lang['MAX_SEARCH_CHARS'] . ':</label><br /><span>' . $this->user->lang['MAX_SEARCH_CHARS_EXPLAIN'] . '</span></dt>

+ <dd><input id="fulltext_native_max_chars" type="text" size="3" maxlength="3" name="config[fulltext_native_max_chars]" value="' . (int) $this->config['fulltext_native_max_chars'] . '" /></dd>

+ <dt><label for="fulltext_native_common_thres">' . $this->user->lang['COMMON_WORD_THRESHOLD'] . ':</label><br /><span>' . $this->user->lang['COMMON_WORD_THRESHOLD_EXPLAIN'] . '</span></dt>

+ <dd><input id="fulltext_native_common_thres" type="text" size="3" maxlength="3" name="config[fulltext_native_common_thres]" value="' . (double) $this->config['fulltext_native_common_thres'] . '" /> %</dd>