diff options
Diffstat (limited to 'phpBB/includes/search/fulltext_mysql.php')
| -rw-r--r-- | phpBB/includes/search/fulltext_mysql.php | 189 |
1 files changed, 189 insertions, 0 deletions
diff --git a/phpBB/includes/search/fulltext_mysql.php b/phpBB/includes/search/fulltext_mysql.php new file mode 100644 index 0000000000..fcec47a816 --- /dev/null +++ b/phpBB/includes/search/fulltext_mysql.php @@ -0,0 +1,189 @@ +<?php +// ------------------------------------------------------------- +// +// $Id$ +// +// FILENAME : mysql.php +// STARTED : Fri Nov 19, 2004 +// COPYRIGHT : © 2004 phpBB Group +// WWW : http://www.phpbb.com/ +// LICENCE : GPL vs2.0 [ see /docs/COPYING ] +// +// ------------------------------------------------------------- + +class fulltext_mysql +{ + var $version = 4; + + function fulltext_mysql(&$error) + { + global $db; + + $result = $db->sql_query('SELECT VERSION() AS mysql_version'); + $version = ($row = $db->sql_fetchrow($result)) ? $row['mysql_version'] : ''; + $db->sql_freeresult($result); + + // Need to check for fulltext indexes ... maybe all of thise is best left in acp? + + $error = (!preg_match('#^4|5|6#s', $version)) ? true : false; + } + function search($type, &$fields, &$fid_ary, &$keywords, &$author, &$pid_ary) + { + global $phpbb_root_path, $phpEx, $config, $db, $user, $SID; + + // Are we looking for words + if ($keywords) + { + $author = ($author) ? ' AND ' . $author : ''; + + $split_words = $stopped_words = $smllrg_words = array(); + $drop_char_match = array('^', '$', ';', '#', '&', '(', ')', '<', '>', '`', '\'', '"', '|', ',', '@', '_', '?', '%', '~', '.', '[', ']', '{', '}', ':', '\\', '/', '=', '\'', '!', '*'); + $drop_char_replace = array(' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '', '', ' ', ' ', ' ', ' ', '', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ', '' , ' ', ' ', ' ', ' ', ' '); + + if ($fp = @fopen($user->lang_path . '/search_stopwords.txt', 'rb')) + { + $stopwords = explode("\n", str_replace("\r\n", "\n", fread($fp, filesize($user->lang_path . '/search_stopwords.txt')))); + } + fclose($fp); + + if ($fp = @fopen($user->lang_path . '/search_synonyms.txt', 'rb')) + { + preg_match_all('#^(.*?) (.*?)$#ms', fread($fp, filesize($user->lang_path . '/search_synonyms.txt')), $match); + $replace_synonym = &$match[1]; + $match_synonym = &$match[2]; + } + fclose($fp); + + $match = array('#\sand\s#i', '#\sor\s#i', '#\snot\s#i', '#\+#', '#-#', '#\|#'); + $replace = array(' +', ' |', ' -', ' +', ' -', ' |'); + + $keywords = preg_replace($match, $replace, $keywords); + + $match = array(); + // Comments for hardcoded bbcode elements (urls, smilies, html) + $match[] = '#<!\-\- .* \-\->(.*?)<!\-\- .* \-\->#is'; + // New lines, carriage returns + $match[] = "#[\n\r]+#"; + // NCRs like etc. + $match[] = '#(&|&)[\#a-z0-9]+?;#i'; + // BBcode + $match[] = '#\[\/?[a-z\*\+\-]+(=.*)?(\:?[0-9a-z]{5,})\]#'; + + // Filter out as above + $keywords = preg_replace($match, ' ', strtolower(trim($keywords))); + $keywords = str_replace($drop_char_match, $drop_char_replace, $keywords); + + // Split words + $split_words = explode(' ', preg_replace('#\s+#', ' ', $keywords)); + + if (sizeof($stopwords)) + { + $stopped_words = array_intersect($split_words, $stopwords); + $split_words = array_diff($split_words, $stopwords); + } + + if (sizeof($replace_synonym)) + { + $split_words = str_replace($replace_synonym, $match_synonym, $split_words); + } + } + + if (isset($old_split_words) && sizeof($old_split_words)) + { + $split_words = (sizeof($split_words)) ? array_diff($split_words, $old_split_words) : $old_split_words; + } + + if (sizeof($split_words)) + { + // Build some display specific variable strings + $sql_select = ($type == 'posts') ? 'p.post_id' : 'DISTINCT t.topic_id'; + $sql_from = ($type == 'posts') ? '' : TOPICS_TABLE . ' t, '; + + switch ($fields) + { + case 'titleonly': + $sql_match = 'p.post_subject'; + break; + case 'msgonly': + $sql_match = 'p.post_text'; + break; + default: + $sql_match = 'p.post_text,p.post_subject'; + } + + $sql_topic = ($type == 'posts') ? '' : 'AND t.topic_id = p.topic_id'; + // Are we searching within an existing search set? Yes, then include the old ids + $sql_find_in = (sizeof($pid_ary)) ? 'AND ' . (($type == 'topics') ? 't.topic_id' : 'p.post_id') . ' IN (' . implode(', ', $pid_ary) . ')' : ''; + $sql_fora = (sizeof($fid_ary)) ? ' AND p.forum_id IN (' . implode(',', $fid_ary) . ')' : ''; + $sql_author = ($author) ? 'AND p.poster_id = ' . $author : ''; + $sql_time = ($sort_days) ? 'AND p.post_time >= ' . ($current_time - ($sort_days * 86400)) : ''; + + $sql = "SELECT $sql_select + FROM $sql_from" . POSTS_TABLE . " p + WHERE MATCH ($sql_match) AGAINST ('+" . implode(' ', $split_words) . "' IN BOOLEAN MODE) + $sql_topic + $sql_find_in + $sql_fora + $sql_author + $sql_time + LIMIT 1000"; + $result = $db->sql_query($sql); + + if ($db->sql_numrows() > 999) + { + trigger_error($user->lang['TOO_MANY_SEARCH_RESULTS']); + } + + $pid_ary = array(); + while ($row = $db->sql_fetchrow($result)) + { + $pid_ary[] = ($type == 'topics') ? $row['topic_id'] : $row['post_id']; + } + $db->sql_freeresult($result); + + $pid_ary = array_unique($pid_ary); + + if (!sizeof($pid_ary)) + { + trigger_error($user->lang['NO_SEARCH_RESULTS']); + } + } + else if ($author) + { + $sql_author = ($author) ? 'p.poster_id = ' . $author : ''; + $sql_fora = (sizeof($fid_ary)) ? ' AND p.forum_id IN (' . implode(',', $fid_ary) . ')' : ''; + + if ($type == 'posts') + { + $sql = 'SELECT p.post_id + FROM ' . POSTS_TABLE . " p + WHERE $sql_author + $sql_fora + LIMIT 1000"; + $field = 'post_id'; + } + else + { + $sql = 'SELECT t.topic_id + FROM ' . TOPICS_TABLE . ' t, ' . POSTS_TABLE . " p + WHERE $sql_author + $sql_fora + AND t.topic_id = p.topic_id + GROUP BY t.topic_id + LIMIT 1000"; + $field = 'topic_id'; + } + $result = $db->sql_query($sql); + + while ($row = $db->sql_fetchrow($result)) + { + $pid_ary[] = $row[$field]; + } + $db->sql_freeresult($result); + } + + return false; + } +} + +?>
\ No newline at end of file |