[Phpbb-checkins] CVS: phpBB2/includes search.php,1.3,1.4

[Paul S. O. <ps...@us...>]

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;