Changeset 4360 for trunk/bp-core/bp-core-classes.php

Timestamp:

05/15/2011 03:01:28 PM (15 years ago)

Author:

boonebgorges

Message:

Adds meta_key and meta_value params to bp_has_members() and related functions. Fixes #3205

File:

• trunk/bp-core/bp-core-classes.php (modified) (4 diffs)

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

@@ -110 +110 @@
         /** Static Functions ******************************************************/
 
-        function get_users( $type, $limit = 0, $page = 1, $user_id = 0, $include = false, $search_terms = false, $populate_extras = true, $exclude = false ) {
+        function get_users( $type, $limit = 0, $page = 1, $user_id = 0, $include = false, $search_terms = false, $populate_extras = true, $exclude = false, $meta_key = false, $meta_value = false ) {
                 global $wpdb, $bp;
 
@@ -125 +125 @@
                 if ( 'alphabetical' == $type )
                         $sql['select_alpha'] = ", pd.value as fullname";
+                
+                if ( $meta_key ) {
+                        $sql['select_meta'] = ", umm.meta_key";
+                        
+                        if ( $meta_value )
+                                $sql['select_meta'] .= ", umm.meta_value";
+                }
 
                 $sql['from'] = "FROM " . CUSTOM_USER_TABLE . " u LEFT JOIN " . CUSTOM_USER_META_TABLE . " um ON um.user_id = u.ID";
@@ -130 +137 @@
                 if ( $search_terms && bp_is_active( 'xprofile' ) || 'alphabetical' == $type )
                         $sql['join_profiledata'] = "LEFT JOIN {$bp->profile->table_name_data} pd ON u.ID = pd.user_id";
+                        
+                if ( $meta_key )
+                        $sql['join_meta'] = "LEFT JOIN {$wpdb->usermeta} umm ON umm.user_id = u.ID";
 
                 $sql['where'] = 'WHERE ' . bp_core_get_status_sql( 'u.' );
@@ -174 +184 @@
                         $search_terms             = like_escape( $wpdb->escape( $search_terms ) );
                         $sql['where_searchterms'] = "AND pd.value LIKE '%%$search_terms%%'";
+                }
+                
+                if ( $meta_key ) {
+                        $sql['where_meta'] = $wpdb->prepare( " AND umm.meta_key = %s", $meta_key );
+                        
+                        // If a meta value is provided, match it
+                        if ( $meta_value ) {
+                                $sql['where_meta'] .= $wpdb->prepare( " AND umm.meta_value = %s", $meta_value );
+                        }
                 }