Changeset 2088 for trunk/bp-xprofile/bp-xprofile-classes.php

Timestamp:

11/13/2009 01:01:37 AM (17 years ago)

Author:

apeatling

Message:

Initial support for threaded activity stream commenting. Some major performance improvements around fetching profile and group data.

File:

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

trunk/bp-xprofile/bp-xprofile-classes.php

@@ -719 +719 @@
         /** Static Functions **/
 
+        /**
+         * BP_XProfile_ProfileData::get_all_for_user()
+         *
+         * Get all of the profile information for a specific user.
+         */
+        function get_all_for_user( $user_id ) {
+                global $wpdb, $bp;
+
+                $results = $wpdb->get_results( $wpdb->prepare( "SELECT g.name as field_group_name, f.name as field_name, f.type as field_type, d.value as field_data, u.user_login, u.user_nicename, u.user_email FROM {$bp->profile->table_name_groups} g LEFT JOIN {$bp->profile->table_name_fields} f ON g.id = f.group_id INNER JOIN {$bp->profile->table_name_data} d ON f.id = d.field_id LEFT JOIN {$wpdb->users} u ON d.user_id = u.ID WHERE d.user_id = %d AND d.value != ''", $user_id ) );
+
+                if ( $results ) {
+                        $profile_data['user_login'] = $results[0]->user_login;
+                        $profile_data['user_nicename'] = $results[0]->user_nicename;
+                        $profile_data['user_email'] = $results[0]->user_email;
+
+                        foreach( (array) $results as $field ) {
+                                $profile_data[$field->field_name] = array( 'field_group' => $field->field_group_name, 'field_type' => $field->field_type, 'field_data' => $field->field_data );
+                        }
+                }
+
+                return $profile_data;
+        }
+
         function get_value_byid( $field_id, $user_id = null ) {
                 global $wpdb, $bp;