*/

class phpbb_search_fulltext_mysql extends phpbb_search_base

{

{

$error = false;

}

}

/**

* Checks for correct MySQL version and stores min/max word length in the config

*/

{

{

}

$engine = '';

if (isset($info['Engine']))

if ($engine != 'MyISAM')

{

}

$sql = 'SHOW VARIABLES

LIKE \'ft\_%\'';

$mysql_info = array();

{

$mysql_info[$row['Variable_name']] = $row['Value'];

}

set_config('fulltext_mysql_max_word_len', $mysql_info['ft_max_word_len']);

set_config('fulltext_mysql_min_word_len', $mysql_info['ft_min_word_len']);

* @param string $terms is either 'all' or 'any'

* @return bool false if no valid keywords were found and otherwise true

*/

{

if ($terms == 'all')

{

$match = array('#\sand\s#iu', '#\sor\s#iu', '#\snot\s#iu', '#(^|\s)\+#', '#(^|\s)-#', '#(^|\s)\|#');

$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

// check word length

$clean_len = utf8_strlen(str_replace('*', '', $clean_word));

{

$this->common_words[] = $word;

unset($this->split_words[$i]);

/**

* Turns text into an array of words

*/

{

// Split words

$text = preg_replace('#([^\p{L}\p{N}\'*])#u', '$1$1', str_replace('\'\'', '\' \'', trim($text)));

$matches = array();

for ($i = 0, $n = sizeof($text); $i < $n; $i++)

{

$text[$i] = trim($text[$i]);

{

unset($text[$i]);

}

}

/**

*

* @param string $type contains either posts or topics depending on what should be searched for

* @param string $fields contains either titleonly (topic titles should be searched), msgonly (only message bodies should be searched), firstpost (only subject and body of the first post should be searched) or all (all post bodies and subjects should be searched)

* @param int $start indicates the first index of the page

* @param int $per_page number of ids each page is supposed to contain

* @return boolean|int total number of results

*/

{

if (!$this->search_query)

{

return false;

}

else

{

}

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

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

{

// first one matches post of registered users, second one guests and deleted users

}

else if (sizeof($author_ary))

{

}

else

{

$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 .= $m_approve_fid_sql;

$sql_where_options .= $sql_author;

$sql_where_options .= ($sort_days) ? ' AND p.post_time >= ' . (time() - ($sort_days * 86400)) : '';

$sql = "SELECT $sql_select

FROM $sql_from$sql_sort_table" . POSTS_TABLE . " p

$sql_where_options

ORDER BY $sql_sort";

{

$id_ary[] = (int) $row[$field];

}

$id_ary = array_unique($id_ary);

if (!$result_count)

{

$sql = 'SELECT FOUND_ROWS() as result_count';

if (!$result_count)

{

* @param int $start indicates the first index of the page

* @param int $per_page number of ids each page is supposed to contain

* @return boolean|int total number of results

*/

{

if (!sizeof($author_ary))

{

return 0;

if ($author_name)

{

// first one matches post of registered users, second one guests and deleted users

}

else

{

}

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

}

else

{

}

// If the cache was completely empty count the results

}

// Only read one block of posts from the db and then cache it

{

$id_ary[] = (int) $row[$field];

}

// retrieve the total result count if needed

if (!$result_count)

{

$sql = 'SELECT FOUND_ROWS() as result_count';

if (!$result_count)

{

}

/**

*

*/

{

// Split old and new post/subject to obtain array of words

$split_text = $this->split_message($message);

$split_title = ($subject) ? $this->split_message($subject) : array();

/**

* Destroy cached results, that might be outdated after deleting a post

*/

{

$this->destroy_cache(array(), array_unique($author_ids));

}

/**

* Destroy old cache entries

*/

{

// destroy too old cached search results

$this->destroy_cache(array());

/**

* Create fulltext index

*/

{

// Make sure we can actually use MySQL with fulltext indexes

if ($error = $this->init())

{

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

{

{

$alter[] = 'MODIFY post_subject varchar(255) COLLATE utf8_unicode_ci DEFAULT \'\' NOT NULL';

}

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

{

{

$alter[] = 'MODIFY post_text mediumtext COLLATE utf8_unicode_ci NOT NULL';

}

if (sizeof($alter))

{

}

return false;

}

/**

* Drop fulltext index

*/

{

// Make sure we can actually use MySQL with fulltext indexes

if ($error = $this->init())

{

if (sizeof($alter))

{

}

return false;

}

/**

* Returns true if both FULLTEXT indexes exist

*/

{

if (empty($this->stats))

{

/**

* Returns an associative array containing information about the indexes

*/

{

if (empty($this->stats))

{

$this->get_stats();

}

return array(

);

}

{

{

$this->stats = array();

return;

$sql = 'SHOW INDEX

FROM ' . POSTS_TABLE;

{

// deal with older MySQL versions which didn't use Index_type

$index_type = (isset($row['Index_type'])) ? $row['Index_type'] : $row['Comment'];

}

}

}

}

/**

* Display a note, that UTF-8 support is not available with certain versions of PHP

*/

{

$tpl = '

<dl>

</dl>

<dl>

</dl>

';