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

Timestamp:

11/10/2008 04:43:42 PM (18 years ago)

Author:

apeatling

Message:

Re-wrote and paginated group member lists.

File:

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

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

@@ -634 +634 @@
         }
         
+        function get_all_for_group( $group_id, $limit = false, $page = false ) {
+                global $bp, $wpdb;
+                
+                if ( $limit && $page )
+                        $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) );
+                
+                $members = $wpdb->get_results( $wpdb->prepare( "SELECT user_id, date_modified FROM " . $bp['groups']['table_name_members'] . " WHERE group_id = %d AND is_confirmed = 1 {$pag_sql}", $group_id ) );
+                
+                if ( !$members )
+                        return false;
+                
+                if ( !isset($pag_sql) ) 
+                        $total_member_count = count($members);
+                else
+                        $total_member_count = $wpdb->get_var( $wpdb->prepare( "SELECT count(user_id) FROM " . $bp['groups']['table_name_members'] . " WHERE group_id = %d AND is_confirmed = 1", $group_id ) );
+        
+                return array( 'members' => $members, 'count' => $total_member_count );
+        }
+        
         function delete_all_for_user( $user_id ) {
                 global $wpdb, $bp;