Changeset 2534 for trunk/bp-groups/bp-groups-classes.php

Timestamp:

02/02/2010 12:45:00 PM (15 years ago)

Author:

apeatling

Message:

Adding missing join calls on fetch group functions.

File:

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

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

@@ -337 +337 @@
         }
 
+        foreach ( $paged_groups as $group ) $group_ids[] = $group->id;
         $group_ids = $wpdb->escape( join( ',', (array)$group_ids ) );
         $paged_groups = BP_Groups_Group::get_group_extras( &$paged_groups, $group_ids, 'newest' );
@@ -395 +396 @@
         }
 
+        foreach ( $paged_groups as $group ) $group_ids[] = $group->id;
         $group_ids = $wpdb->escape( join( ',', (array)$group_ids ) );
         $paged_groups = BP_Groups_Group::get_group_extras( &$paged_groups, $group_ids, 'popular' );
@@ -423 +425 @@
         }
 
+        foreach ( $paged_groups as $group ) $group_ids[] = $group->id;
         $group_ids = $wpdb->escape( join( ',', (array)$group_ids ) );
         $paged_groups = BP_Groups_Group::get_group_extras( &$paged_groups, $group_ids, 'alphabetical' );
@@ -455 +458 @@
         }
 
+        foreach ( $paged_groups as $group ) $group_ids[] = $group->id;
         $group_ids = $wpdb->escape( join( ',', (array)$group_ids ) );
         $paged_groups = BP_Groups_Group::get_group_extras( &$paged_groups, $group_ids, 'most_forum_topics' );
@@ -487 +491 @@
         }
 
+        foreach ( $paged_groups as $group ) $group_ids[] = $group->id;
         $group_ids = $wpdb->escape( join( ',', (array)$group_ids ) );
         $paged_groups = BP_Groups_Group::get_group_extras( &$paged_groups, $group_ids, 'most_forum_posts' );
@@ -555 +560 @@
         $paged_groups = $wpdb->get_results( $wpdb->prepare( "SELECT g.*, gm1.meta_value as total_member_count, gm2.meta_value as last_activity FROM {$bp->groups->table_name_groupmeta} gm1, {$bp->groups->table_name_groupmeta} gm2, {$bp->groups->table_name} g WHERE g.id = gm1.group_id AND g.id = gm2.group_id AND gm2.meta_key = 'last_activity' AND gm1.meta_key = 'total_member_count' AND g.name LIKE '$letter%%' {$hidden_sql} {$search_sql} ORDER BY g.name ASC {$pag_sql}"  ) );
 
+        foreach ( $paged_groups as $group ) $group_ids[] = $group->id;
         $group_ids = $wpdb->escape( join( ',', (array)$group_ids ) );
         $paged_groups = BP_Groups_Group::get_group_extras( &$paged_groups, $group_ids, 'letter' );
@@ -583 +589 @@
         }
 
+        foreach ( $paged_groups as $group ) $group_ids[] = $group->id;
         $group_ids = $wpdb->escape( join( ',', (array)$group_ids ) );
         $paged_groups = BP_Groups_Group::get_group_extras( &$paged_groups, $group_ids, 'random' );