*/

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