Changeset 7275

Timestamp:

07/16/2013 07:31:05 PM (12 years ago)

Author:

boonebgorges

Message:

Fixes total group count for BP_Groups_Group::get() when using meta_query

The fix contained in this changeset is intended to be temporary. A longer-term
fix will mean refactoring the way that total-group queries are composed, so
that the get() method does not have to assemble these queries twice.

See #5099

File:

• trunk/bp-groups/bp-groups-classes.php (modified) (1 diff)

trunk/bp-groups/bp-groups-classes.php

@@ -464 +464 @@
         if ( ! empty( $r['user_id'] ) ) {
             $total_sql['where'][] = $wpdb->prepare( "m.group_id = g.id AND m.user_id = %d AND m.is_confirmed = 1 AND m.is_banned = 0", $r['user_id'] );
+        }
+
+        // Temporary implementation of meta_query for total count
+        // See #5099
+        if ( ! empty( $meta_query_sql['where'] ) ) {
+            // Join the groupmeta table
+            $total_sql['select'] .= ", {$bp->groups->table_name_groupmeta} gmmq";
+
+            // Modify the meta_query clause from paged_sql for our syntax
+            $meta_query_clause = preg_replace( '/^\s*AND/', '', $meta_query_sql['where'] );
+            $meta_query_clause = str_replace( $bp->groups->table_name_groupmeta, 'gmmq', $meta_query_clause );
+            $total_sql['where'][] = $meta_query_clause;
         }