Bp_Search_bbPress_Topics::sql( $search_term,  $only_totalrow_count = false )

Description

Source

File: bp-search/classes/class-bp-search-bbpress-forums-topics.php

		function sql( $search_term, $only_totalrow_count=false ){
			global $wpdb;

			$bp_prefix = bp_core_get_table_prefix();

			$query_placeholder = array();

			if( $only_totalrow_count ){
				$columns = " COUNT( DISTINCT id ) ";
			} else {
				$columns = " DISTINCT id , '{$this->type}' as type, post_title LIKE %s AS relevance, post_date as entry_date  ";
				$query_placeholder[] = '%'. $search_term .'%';
			}

			$from = "{$wpdb->posts} p LEFT JOIN {$wpdb->postmeta} pm ON pm.post_id = p.ID AND pm.meta_key = '_bbp_forum_id'";

			$group_memberships = '';
			if ( bp_is_active( 'groups' ) ) {
				$group_memberships = bp_get_user_groups( get_current_user_id(),
					array(
						'is_admin' => null,
						'is_mod'   => null,
					) );
			}

			$group_query = '';
			if ( ! empty( $group_memberships ) ) {
				$in = array_reduce( array_keys( $group_memberships ), function ( $carry, $group_id ) {
					return $carry . ',\'' . maybe_serialize( [$group_id] ) . '\'';
				} );

				$group_query = ' pm.meta_value IN ( SELECT post_id FROM ' . $wpdb->postmeta . ' WHERE meta_key = \'_bbp_group_ids\' AND meta_value IN(' . trim( $in, ',' ) . ') ) OR ';
			}

			if ( current_user_can( 'read_hidden_forums' ) ) {
				$post_status = [ "'publish'", "'private'", "'hidden'" ];
			} elseif ( current_user_can( 'read_private_forums' ) ) {
				$post_status = [ "'publish'", "'private'" ];
			} else {
				$post_status = [ "'publish'" ];
			}

			$where = array();
			$where[] = "1=1";
			$where[] = "(post_title LIKE %s OR {$bp_prefix}bp_strip_tags(post_content) LIKE %s)";
			$where[] = "post_type = '{$this->type}'";

			$where[] = '(' . $group_query . '
			pm.meta_value IN ( SELECT ID FROM ' . $wpdb->posts . ' WHERE post_type = \'forum\' AND post_status IN (' . join( ',', $post_status ) . ') )
			)';

			$query_placeholder[] = '%'. $search_term .'%';
			$query_placeholder[] = '%'. $search_term .'%';

			$sql = 'SELECT '. $columns . ' FROM ' . $from .' WHERE ' . implode( ' AND ', $where );
			$query = $wpdb->prepare( $sql, $query_placeholder );

			return apply_filters(
				'Bp_Search_Forums_sql',
				$query,
				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.