Bp_Search_bbPress::sql( $search_term, $only_totalrow_count = false )
Description
Source
File: bp-search/classes/class-bp-search-bbpress.php
function sql( $search_term, $only_totalrow_count=false ){ global $wpdb; $query_placeholder = array(); $sql = " SELECT "; if( $only_totalrow_count ){ $sql .= " COUNT( DISTINCT id ) "; } else { $sql .= " DISTINCT id , '{$this->type}' as type, post_title LIKE %s AS relevance, post_date as entry_date "; $query_placeholder[] = '%'. $search_term .'%'; } $sql .= " FROM {$wpdb->prefix}posts WHERE 1=1 AND ( ( (post_title LIKE %s) OR (post_content LIKE %s) ) ) AND post_type = '{$this->type}' AND post_status = 'publish' "; $query_placeholder[] = '%'. $search_term .'%'; $query_placeholder[] = '%'. $search_term .'%'; $sql = $wpdb->prepare( $sql, $query_placeholder ); return apply_filters( 'Bp_Search_Forums_sql', $sql, array( 'search_term' => $search_term, 'only_totalrow_count' => $only_totalrow_count, ) ); }
Questions?
We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.