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

Timestamp:

11/13/2009 01:01:37 AM (16 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;