Simple Text Search Extension

Hi,
Some of my mantis users asked for a search of multiple words
in a google like
fashion, so I extended the "Simple Text Search by Alan
Knowles" and did a loop
through the search words (seperated by blank).
Regards Matthias

patch for mantis 1.0.3 core/filter_api.php
693,707c693,712
< 			$c_search = db_prepare_string( $t_filter['search']
);
< 			$c_search_int = db_prepare_int(
$t_filter['search'] );
< 			$t_textsearch_where_clause = "((summary LIKE
'%$c_search%')
< 							 OR
($t_bug_text_table.description LIKE '%$c_search%')
< 							 OR
($t_bug_text_table.steps_to_reproduce LIKE '%$c_search%')
< 							 OR
($t_bug_text_table.additional_information LIKE
'%$c_search%')
< 							 OR ($t_bug_table.id =
'$c_search_int'))";
< 
< 			$t_textsearch_wherejoin_clause = "((summary
LIKE
'%$c_search%')
< 							 OR
($t_bug_text_table.description LIKE '%$c_search%')
< 							 OR
($t_bug_text_table.steps_to_reproduce LIKE '%$c_search%')
< 							 OR
($t_bug_text_table.additional_information LIKE
'%$c_search%')
< 							 OR ($t_bug_table.id
LIKE '%$c_search%')
< 							 OR
($t_bugnote_text_table.note LIKE '%$c_search%'))";
< 
---
> 			$c_search = split(" ",
db_prepare_string(
$t_filter['search'] ));
> 			$c_search_int = split(" ",
db_prepare_int(
$t_filter['search'] ));
> 			if ( $c_search ) {
> 				for( $i = 0; $i < count($c_search); $i++ ){
> 					$t_textsearch_where_clause .= " AND
((summary LIKE '%$c_search[$i]%')
> 							 OR
($t_bug_text_table.description LIKE '%$c_search[$i]%')
> 							 OR
($t_bug_text_table.steps_to_reproduce LIKE
'%$c_search[$i]%')
> 							 OR
($t_bug_text_table.additional_information LIKE
'%$c_search[$i]%')
> 							 OR ($t_bug_table.id =
'$c_search_int[$i]'))";
> 
> 					$t_textsearch_wherejoin_clause .= " AND
((summary LIKE '%$c_search[$i]%')
> 							 OR
($t_bug_text_table.description LIKE '%$c_search[$i]%')
> 							 OR
($t_bug_text_table.steps_to_reproduce LIKE
'%$c_search[$i]%')
> 							 OR
($t_bug_text_table.additional_information LIKE
'%$c_search[$i]%')
> 							 OR ($t_bug_table.id
LIKE '%$c_search[$i]%')
> 							 OR
($t_bugnote_text_table.note LIKE
'%$c_search[$i]%'))";
> 				}
> 				$t_textsearch_where_clause =
substr($t_textsearch_where_clause, 5);
> 				$t_textsearch_wherejoin_clause =
substr($t_textsearch_wherejoin_clause, 5);
> 			}

Using Tomcat but need to do more? Need to support web
services, security?
Get stuff done quickly with pre-integrated technology to
make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on
Apache Geronimo
http://sel.as-us.falkag.net/
sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Mantisbt-dev mailing list
Mantisbt-devlists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mantisbt-d
ev