Changeset 4064

Timestamp:

02/21/2011 03:45:49 PM (14 years ago)

Author:

johnjamesjacoby

Message:

Second attempt at synchronizing total group count and group pagination, this time checking existence of members.

File:

• trunk/bp-groups/bp-groups-classes.php (modified) (2 diffs)

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

@@ -319 +319 @@
         $paged_groups     = $wpdb->get_results( $paged_groups_sql );
 
-        $total_sql['select'] = "SELECT COUNT(DISTINCT g.id) FROM {$bp->groups->table_name} g, {$bp->groups->table_name_groupmeta} gm2";
+        $total_sql['select'] = "SELECT COUNT(DISTINCT g.id) FROM {$bp->groups->table_name} g, {$bp->groups->table_name_members} gm1, {$bp->groups->table_name_groupmeta} gm2";
 
         if ( !empty( $user_id ) )
@@ -338 +338 @@
         }
 
+        $total_sql['where'][] = "g.id = gm1.group_id";
         $total_sql['where'][] = "g.id = gm2.group_id";
         $total_sql['where'][] = "gm2.meta_key = 'last_activity'";