If I remember well, the problem was only concerning the UTF-8 topic keywords, as you where not able to properly filter words from the search tables according to their size.
So, you could just work with a longer search_stopwords.txt, including one and two letters words, or just disable the keywords for topics, but leave everything else as his for a normal install.
You should just find and delete :
- Code: Select all
$sql = "SELECT w.word_text
FROM " . TOPICS_TABLE . " t, " . SEARCH_MATCH_TABLE . " m, " . SEARCH_WORD_TABLE . " w
WHERE t.topic_first_post_id = m.post_id
AND m.word_id = w.word_id
AND t.topic_id = $meta_topic_id LIMIT 20";
if( ($result = $db->sql_query($sql)) ) {
$keywords = '';
while ( $meta_row = $db->sql_fetchrow($result) ) {
$keywords .= ($keywords == '') ? $meta_row['word_text'] : ',' . $meta_row['word_text'];
}
In the mod's code (page_header.php) and eventually, to prevent empty keywords tags to be outputted find :
- Code: Select all
$phpbb_meta .= '<meta name="keywords" content="' . $keywords .'" />' . "\n";
And replace with :
- Code: Select all
$phpbb_meta .= isset($meta_topic_id) ? '<meta name="keywords" content="' . $keywords .'" />' . "\n" : '';
++