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

Timestamp:

10/09/2008 04:37:49 AM (17 years ago)

Author:

apeatling

Message:

• Moved all group pages to the root, rather than using a member URL
• Introduced groupmeta support - groups_update_groupmeta / groups_delete_groupmeta / groups_get_groupmeta
• Added widgets for site wide activity and who's online
• Updated home theme to support display of new BuddyPress widgets
• Added site wide activity feed support
• Fixed bug where ajax functions would only work when logged in
• Various other bug fixes

File:

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

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

@@ -56 +56 @@
             $this->enable_photos = $group->enable_photos;
             $this->photos_admin_only = $group->photos_admin_only;
-            $this->date_created = $group->date_created;
+            $this->date_created = strtotime($group->date_created);
+            $this->total_member_count = groups_get_groupmeta( $this->id, 'total_member_count' );
             
             if ( !$group->avatar_thumb )
@@ -70 +71 @@
             if ( $get_user_dataset ) {
                 $this->user_dataset = $this->get_user_dataset();
-                $this->total_member_count = count( $this->user_dataset );
+                
+                if ( !$this->total_member_count ) {
+                    $this->total_member_count = count( $this->user_dataset );
+                    groups_update_groupmeta( $this->id, 'total_member_count', $this->total_member_count );
+                }
             }
         }   
@@ -159 +164 @@
             );
         }
-
+        
         $result = $wpdb->query($sql);
         
@@ -221 +226 @@
             return false;
         
+        /* Remove groupmeta */
+        groups_delete_groupmeta( $group_id );
+        
         return true;
     }
     
-    function group_exists( $slug ) {
-        global $wpdb, $bp;
-        return $wpdb->get_var( $wpdb->prepare( "SELECT id FROM " . $bp['groups']['table_name'] . " WHERE slug = %s", $slug ) );
+    function group_exists( $slug, $table_name = false ) {
+        global $wpdb, $bp;
+        
+        if ( !$table_name )
+            $table_name = $bp['groups']['table_name'];
+            
+        return $wpdb->get_var( $wpdb->prepare( "SELECT id FROM $table_name WHERE slug = %s", $slug ) );
     }
 
@@ -313 +325 @@
             $limit = 5;
 
-        return $wpdb->get_results( $wpdb->prepare( "SELECT id FROM " . $bp['groups']['table_name'] . " ORDER BY date_created DESC LIMIT %d", $limit ) ); 
+        return $wpdb->get_results( $wpdb->prepare( "SELECT id as group_id FROM " . $bp['groups']['table_name'] . " ORDER BY date_created DESC LIMIT %d", $limit ) ); 
+    }
+    
+    function get_active( $limit = 5 ) {
+        global $wpdb, $bp;
+        
+        if ( !$limit )
+            $limit = 5;
+
+        return $wpdb->get_results( $wpdb->prepare( "SELECT group_id FROM " . $bp['groups']['table_name_groupmeta'] . " WHERE meta_key = 'last_activity' ORDER BY meta_value DESC LIMIT %d", $limit ) ); 
+    }
+    
+    function get_popular( $limit = 5 ) {
+        global $wpdb, $bp;
+        
+        if ( !$limit )
+            $limit = 5;
+
+        return $wpdb->get_results( $wpdb->prepare( "SELECT group_id FROM " . $bp['groups']['table_name_groupmeta'] . " WHERE meta_key = 'total_member_count' ORDER BY meta_value DESC LIMIT %d", $limit ) ); 
     }
 }