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.