Changeset 1268

Timestamp:

03/26/2009 04:38:40 PM (17 years ago)

Author:

apeatling

Message:

Added alphabetical ordering option to member listing.

Location:

trunk/bp-core

Files:

• bp-core-classes.php (modified) (2 diffs)
• bp-core-templatetags.php (modified) (3 diffs)

trunk/bp-core/bp-core-classes.php

@@ -185 +185 @@
     }
     
+    function get_alphabetical_users( $limit = null, $page = 1 ) {
+        global $wpdb, $bp;
+
+        if ( !function_exists( 'xprofile_install' ) )
+            return BP_Core_User::get_active_users( $limit, $page );
+        
+        if ( $limit && $page )
+            $pag_sql = $wpdb->prepare( " LIMIT %d, %d", intval( ( $page - 1 ) * $limit), intval( $limit ) );
+
+        $total_users = count( $wpdb->get_results( $wpdb->prepare( "SELECT DISTINCT u.ID user_id FROM {$wpdb->base_prefix}users u LEFT JOIN {$bp->profile->table_name_data} pd ON u.ID = pd.user_id LEFT JOIN {$bp->profile->table_name_fields} pf ON pd.field_id = pf.id WHERE u.spam = 0 AND u.deleted = 0 AND u.user_status = 0 AND pf.name = %s ORDER BY pd.value ASC", BP_XPROFILE_FULLNAME_FIELD_NAME ) ) );
+        $paged_users = $wpdb->get_results( $wpdb->prepare( "SELECT DISTINCT u.ID as user_id FROM {$wpdb->base_prefix}users u LEFT JOIN {$bp->profile->table_name_data} pd ON u.ID = pd.user_id LEFT JOIN {$bp->profile->table_name_fields} pf ON pd.field_id = pf.id WHERE u.spam = 0 AND u.deleted = 0 AND u.user_status = 0 AND pf.name = %s ORDER BY pd.value ASC{$pag_sql}", BP_XPROFILE_FULLNAME_FIELD_NAME ) );
+
+        return array( 'users' => $paged_users, 'total' => $total_users );
+    }
+    
     function get_users_by_letter( $letter, $limit = null, $page = 1 ) {
         global $wpdb, $bp;
         
         if ( !function_exists('xprofile_install') )
-            return false;
+            return BP_Core_User::get_active_users( $limit, $page );
         
         if ( $limit && $page )
@@ -209 +224 @@
         
         if ( !function_exists('xprofile_install') )
-            return false;
+            return BP_Core_User::get_active_users( $limit, $page );
         
         if ( $limit && $page )

trunk/bp-core/bp-core-templatetags.php

@@ -741 +741 @@
                 case 'online':
                     $this->members = BP_Core_User::get_online_users( $this->pag_num, $this->pag_page );
-                    break;  
+                    break;
+                    
+                case 'alphabetical':
+                    $this->members = BP_Core_User::get_alphabetical_users( $this->pag_num, $this->pag_page );
+                    break;
                 
                 case 'active': default:
@@ -837 +841 @@
     extract( $r, EXTR_SKIP );
 
-    // type: active ( default ) | random | newest | popular | online
+    // type: active ( default ) | random | newest | popular | online | alphabetical
     
     if ( $max ) {
@@ -843 +847 @@
             $per_page = $max;
     }
-    
+
     $site_members_template = new BP_Core_Members_Template( $type, $per_page, $max );