$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%'))";
*/
f ( !is_blank( $t_filter['search'] ) ) {
$c_search = db_prepare_string( $t_filter['search'] );
$c_search_int = db_prepare_int( $t_filter['search'] );
$t_textsearch_where_clause = "( MATCH (summary,$t_bug_text_table.description,$t_bug_text_table.steps_to_reproduce,$t_bug_text_table.additional_information) AGAINST ('$c_search' IN BOOLEAN MODE) OR $t_bug_table.id='$c_search_int' )";
$t_textsearch_wherejoin_clause = "( MATCH (summary,$t_bug_text_table.description,$t_bug_text_table.steps_to_reproduce,$t_bug_text_table.additional_information,$t_bugnote_text_table.note) AGAINST ('$c_search' IN BOOLEAN MODE) OR $t_bug_table.id LIKE '%$c_search%' )";
an new Version comes tomorrow...but i hope that is ok...
Last edited by frentmeister on 03 Dec 2006, 20:20, edited 1 time in total.