|
From: Paul S. O. <ps...@us...> - 2002-01-25 13:36:54
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv29559/includes
Modified Files:
search.php
Log Message:
Error with adding search matches, wrong variable being used for insert ... select
Index: search.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/search.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** search.php 2002/01/25 00:48:46 1.3
--- search.php 2002/01/25 13:36:50 1.4
***************
*** 193,202 ****
}
- $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)";
$result = $db->sql_query($sql);
if( !$result )
--- 193,200 ----
}
$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_text_sql)";
$result = $db->sql_query($sql);
if( !$result )
***************
*** 207,211 ****
}
! remove_common("single", 40, $word_id_list);
return;
--- 205,209 ----
}
! remove_common("single", 0.4, $word_id_list);
return;
|