Changeset 9663 for branches/2.2/src/bp-core/bp-core-classes.php

Timestamp:

03/30/2015 06:44:55 PM (11 years ago)

Author:

boonebgorges

Message:

Enforce no_results when getting a 0=1 result from the member type tax query.

When passing a 'member_type' to BP_User_Query and no users belong to the
member type, the WP_Tax_Query transformation will return a '0 = 1' clause to
indicate that no results were found. We should respect this result, so that no
members are returned for this kind of query.

Fixes #6334 for the 2.2 branch.

File:

• branches/2.2/src/bp-core/bp-core-classes.php (modified) (1 diff)

branches/2.2/src/bp-core/bp-core-classes.php

@@ -436 +436 @@
                                 restore_current_blog();
 
-
-
                                 // Grab the first term_relationships clause and convert to a subquery.
                                 if ( preg_match( '/' . $wpdb->term_relationships . '\.term_taxonomy_id IN \([0-9, ]+\)/', $member_type_sql_clauses['where'], $matches ) ) {
                                         $sql['where']['member_type'] = "u.{$this->uid_name} IN ( SELECT object_id FROM $wpdb->term_relationships WHERE {$matches[0]} )";
+                                } elseif ( false !== strpos( $member_type_sql_clauses['where'], '0 = 1' ) ) {
+                                        $sql['where']['member_type'] = $this->no_results['where'];
                                 }
                         }