Changeset 1929

Timestamp:

09/23/2009 01:18:49 AM (16 years ago)

Author:

apeatling

Message:

Added ability to loop groups alphabetically by using 'type=alphabetical' in the site groups loop. Fixes #764

Location:

trunk

Files:

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

trunk/bp-groups.php

@@ -1865 +1865 @@
 }
 
+function groups_get_alphabetically( $limit = null, $page = 1 ) {
+    return BP_Groups_Group::get_alphabetically( $limit, $page );    
+}
+
 function groups_get_by_most_forum_topics( $limit = null, $page = 1 ) {
     return BP_Groups_Group::get_by_most_forum_topics( $limit, $page );

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

@@ -377 +377 @@
     }
     
+    function get_alphabetically( $limit = null, $page = null ) {
+        global $wpdb, $bp;
+                
+        if ( $limit && $page )
+            $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) );
+        
+        if ( !is_site_admin() )
+            $hidden_sql = "WHERE status != 'hidden'";
+        
+        $paged_groups = $wpdb->get_results( $wpdb->prepare( "SELECT id as group_id FROM {$bp->groups->table_name} {$hidden_sql} ORDER BY name ASC {$pag_sql}" ) );
+        $total_groups = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(id) FROM {$bp->groups->table_name} {$hidden_sql} ORDER BY name ASC", $limit ) );
+
+        return array( 'groups' => $paged_groups, 'total' => $total_groups );
+    }
+    
     function get_by_most_forum_topics( $limit = null, $page = null ) {
         global $wpdb, $bp, $bbdb;

trunk/bp-groups/bp-groups-templatetags.php

@@ -1820 +1820 @@
                     $this->groups = groups_get_active( $this->pag_num, $this->pag_page );
                     break;  
+
+                case 'alphabetical': default:
+                    $this->groups = groups_get_alphabetically( $this->pag_num, $this->pag_page );
+                    break;  
                 
                 case 'random':