Home › Forums › Product Support Forums › Ajax Search Pro for WordPress Support › Settings › Reply To: Settings
April 3, 2019 at 1:33 pm
#21986
Keymaster
Okay, so for the first modification, open up the wp-content/plugins/ajax-search-pro/includes/classes/search/class-asp-search-terms.php file, and look for these lines (around line 110):
if ( $args['taxonomy_terms_search_term_meta'] == 1 ) {
if ( $termmeta_join == '' )
$termmeta_join = " LEFT JOIN $wpdb->termmeta tm ON tm.term_id = $wpdb->terms.term_id";
if ( $kw_logic == 'or' || $kw_logic == 'and' || $is_exact ) {
$parts[] = "( " . $pre_field . "tm.meta_value" . $suf_field . " LIKE $pre_like'$wcl" . $word . "$wcr'$suf_like )";
} else {
$parts[] = "
(" . $pre_field . "tm.meta_value" . $suf_field . " LIKE $pre_like'% " . $word . " %'$suf_like
OR " . $pre_field . "tm.meta_value" . $suf_field . " LIKE $pre_like'" . $word . " %'$suf_like
OR " . $pre_field . "tm.meta_value" . $suf_field . " LIKE $pre_like'% " . $word . "'$suf_like
OR " . $pre_field . "tm.meta_value" . $suf_field . " = '" . $word . "')";
}
}
..and replace them with these:
if ( $args['taxonomy_terms_search_term_meta'] == 1 ) {
if ( $termmeta_join == '' )
$termmeta_join = " LEFT JOIN $wpdb->termmeta tm ON tm.term_id = $wpdb->terms.term_id";
if ( $kw_logic == 'or' || $kw_logic == 'and' || $is_exact ) {
$parts[] = "(tm.meta_key NOT LIKE 'cat_seo_text' AND " . $pre_field . "tm.meta_value" . $suf_field . " LIKE $pre_like'$wcl" . $word . "$wcr'$suf_like )";
} else {
$parts[] = "( tm.meta_key NOT LIKE 'cat_seo_text' AND
(" . $pre_field . "tm.meta_value" . $suf_field . " LIKE $pre_like'% " . $word . " %'$suf_like
OR " . $pre_field . "tm.meta_value" . $suf_field . " LIKE $pre_like'" . $word . " %'$suf_like
OR " . $pre_field . "tm.meta_value" . $suf_field . " LIKE $pre_like'% " . $word . "'$suf_like
OR " . $pre_field . "tm.meta_value" . $suf_field . " = '" . $word . "') )";
}
}
Let me know if you can’t change this, and I will do it via FTP.