Code: Select all
#
#-----[ FIND NEAR LINE 283 ]------------------------------------------
#
if ( !strstr($multibyte_charset, $lang['ENCODING']) )
{
$match_word = str_replace('*', '%', $split_search[$i]);
$sql = "SELECT m.post_id
FROM " . SEARCH_WORD_TABLE . " w, " . SEARCH_MATCH_TABLE . " m
WHERE w.word_text LIKE '$match_word'
AND m.word_id = w.word_id
AND w.word_common <> 1
$search_msg_only";
}
#
#-----[ CHANGE TO ]------------------------------------------
#
if ( !strstr($multibyte_charset, $lang['ENCODING']) )
{
$match_word = str_replace('*', '%', $split_search[$i]);
// if (!$search_fields)
// {
// $sql = "SELECT post_id
// FROM " . POSTS_TEXT_TABLE . "
// WHERE MATCH (post_text) AGAINST ('$match_word')";
// }
// else
// {
$sql = "SELECT post_id
FROM " . POSTS_TEXT_TABLE . "
WHERE MATCH (post_subject,post_text) AGAINST ('$match_word')";
// }
# (Notice the commented out lines. That's because I indexed two fields together
# instead of making two different indexes--see the initial SQL statement in this mod)