aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorPaul S. Owen <psotfx@users.sourceforge.net>2002-01-25 13:36:50 +0000
committerPaul S. Owen <psotfx@users.sourceforge.net>2002-01-25 13:36:50 +0000
commitcd354884f632469a605f6e238110737c4c0290f9 (patch)
tree81043140eeb7999a2577c6c7ffb8d5e756171525
parentd0a241eaffdea1a49f79fb58afa60972f37af655 (diff)
downloadforums-cd354884f632469a605f6e238110737c4c0290f9.tar
forums-cd354884f632469a605f6e238110737c4c0290f9.tar.gz
forums-cd354884f632469a605f6e238110737c4c0290f9.tar.bz2
forums-cd354884f632469a605f6e238110737c4c0290f9.tar.xz
forums-cd354884f632469a605f6e238110737c4c0290f9.zip
Error with adding search matches, wrong variable being used for insert ... select
git-svn-id: file:///svn/phpbb/trunk@1953 89ea8834-ac86-4346-8a33-228a782c2dd0
-rw-r--r--phpBB/includes/search.php6
1 files changed, 2 insertions, 4 deletions
diff --git a/phpBB/includes/search.php b/phpBB/includes/search.php
index 09efc93ac9..1722ba75e4 100644
--- a/phpBB/includes/search.php
+++ b/phpBB/includes/search.php
@@ -192,12 +192,10 @@ function add_search_words($post_id, $post_text, $post_title = "")
}
}
- $word_sql_in = implode(", ", $match_word);
-
$sql = "INSERT INTO " . SEARCH_MATCH_TABLE . " (post_id, word_id, title_match)
SELECT $post_id, word_id, $title_match
FROM " . SEARCH_WORD_TABLE . "
- WHERE word_text IN ($word_sql_in)";
+ WHERE word_text IN ($word_text_sql)";
$result = $db->sql_query($sql);
if( !$result )
{
@@ -206,7 +204,7 @@ function add_search_words($post_id, $post_text, $post_title = "")
}
}
- remove_common("single", 40, $word_id_list);
+ remove_common("single", 0.4, $word_id_list);
return;
}