|
From: Paul S. O. <ps...@us...> - 2002-03-19 00:46:26
|
Update of /cvsroot/phpbb/phpBB2/includes
In directory usw-pr-cvs1:/tmp/cvs-serv3065/includes
Modified Files:
functions_search.php
Log Message:
Allow a a comma delimited set of post id's to be sent to remove words function ... for modcp et al
Index: functions_search.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/includes/functions_search.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -r1.4 -r1.5
*** functions_search.php 18 Mar 2002 23:53:12 -0000 1.4
--- functions_search.php 19 Mar 2002 00:46:22 -0000 1.5
***************
*** 348,352 ****
}
! function remove_search_post($post_id)
{
global $db;
--- 348,352 ----
}
! function remove_search_post($post_id_sql)
{
global $db;
***************
*** 360,364 ****
$sql = "SELECT word_id
FROM " . SEARCH_MATCH_TABLE . "
! WHERE post_id = $post_id";
if ( $result = $db->sql_query($sql) )
{
--- 360,365 ----
$sql = "SELECT word_id
FROM " . SEARCH_MATCH_TABLE . "
! WHERE post_id IN ($post_id_sql)
! GROUP BY word_id";
if ( $result = $db->sql_query($sql) )
{
***************
*** 405,409 ****
SELECT word_id
FROM " . SEARCH_MATCH_TABLE . "
! WHERE post_id = $post_id
)
GROUP BY word_id
--- 406,411 ----
SELECT word_id
FROM " . SEARCH_MATCH_TABLE . "
! WHERE post_id IN ($post_id_sql)
! GROUP BY word_id
)
GROUP BY word_id
***************
*** 421,425 ****
$sql = "DELETE FROM " . SEARCH_MATCH_TABLE . "
! WHERE post_id = $post_id";
if ( !($db->sql_query($sql)) )
{
--- 423,427 ----
$sql = "DELETE FROM " . SEARCH_MATCH_TABLE . "
! WHERE post_id IN ($post_id_sql)";
if ( !($db->sql_query($sql)) )
{
|