bp_search_cpt :: sql（$ search_term.那$ toung_totalrow_count.=错误的的）

公共功能SQL（$ search_term，$ tonly_totalrow_count = false）{global $ wpdb;$ bp_prefix = bp_core_get_table_prefix（）;$ query_placeholder = array（）;$ sql =“选择”;if（$ tonly_totalrow_count）{$ sql。=“count（distinct ID）”;} else {$ sql。=“distinct id，％s为类型，post_title，如'%%% s %%'，作为相关性，post_date作为entry_date”;$ query_placeholder [] = $ this-> search_type;$ query_placeholder [] = $ search_term;$ sql。=“来自{$ wpdb->前缀} post p”;$ tax = array（）; $taxonomies = get_object_taxonomies( $this->cpt_name ); foreach ( $taxonomies as $taxonomy ) { if ( bp_is_search_post_type_taxonomy_enable( $taxonomy, $this->cpt_name ) ) { $tax[] = $taxonomy; } } //Tax query left join if ( ! empty( $tax ) ) { $sql .= " LEFT JOIN {$wpdb->term_relationships} r ON p.ID = r.object_id "; } $sql .= " WHERE 1=1 AND ( p.post_title LIKE %s OR {$bp_prefix}bp_strip_tags(p.post_content) LIKE %s "; $query_placeholder[] = '%'.$search_term.'%'; $query_placeholder[] = '%'.$search_term.'%'; //Tax query if ( ! empty( $tax ) ) { $tax_in_arr = array_map( function( $t_name ) { return "'" . $t_name . "'"; }, $tax ); $tax_in = implode( ', ', $tax_in_arr ); $sql .= " OR r.term_taxonomy_id IN (SELECT tt.term_taxonomy_id FROM {$wpdb->term_taxonomy} tt INNER JOIN {$wpdb->terms} t ON t.term_id = tt.term_id WHERE ( t.slug LIKE %s OR t.name LIKE %s ) AND tt.taxonomy IN ({$tax_in}) )"; $query_placeholder[] = '%'. $search_term .'%'; $query_placeholder[] = '%'. $search_term .'%'; } //Post should be publish $sql .= " ) AND p.post_type = %s AND p.post_status = 'publish'"; $query_placeholder[] = $this->cpt_name; $sql = $wpdb->prepare( $sql, $query_placeholder ); return apply_filters( 'BP_Search_CPT_sql', $sql, array( 'post_type' => $this->cpt_name, 'search_term' => $search_term, 'only_totalrow_count' => $only_totalrow_count, ) ); }