Changeset 3346

Timestamp:

11/03/2010 11:14:43 PM (14 years ago)

Author:

boonebgorges

Message:

Adds meta functions for xprofile field groups, fields, and individual data items. Fixes #671

Location:

trunk

Files:

• bp-core/admin/bp-core-schema.php (modified) (2 diffs)
• bp-xprofile.php (modified) (2 diffs)

trunk/bp-core/admin/bp-core-schema.php

@@ -228 +228 @@
                 KEY is_required (is_required)
                ) {$charset_collate};";
-
+        
     $sql[] = "CREATE TABLE {$wpdb->base_prefix}bp_xprofile_data (
                 id bigint(20) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
@@ -239 +239 @@
                ) {$charset_collate};";
 
+    $sql[] = "CREATE TABLE {$wpdb->base_prefix}bp_xprofile_meta (
+                id bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
+                object_id bigint(20) NOT NULL,
+                object_type varchar(150) NOT NULL,
+                meta_key varchar(255) DEFAULT NULL,
+                meta_value longtext DEFAULT NULL,
+                KEY object_id (object_id),
+                KEY meta_key (meta_key)
+               ) {$charset_collate};";
+
     dbDelta( $sql );
 

trunk/bp-xprofile.php

@@ -34 +34 @@
     $bp->profile->table_name_groups = $bp->table_prefix . 'bp_xprofile_groups';
     $bp->profile->table_name_fields = $bp->table_prefix . 'bp_xprofile_fields';
+    $bp->profile->table_name_meta   = $bp->table_prefix . 'bp_xprofile_meta';
 
     $bp->profile->format_notification_function = 'xprofile_format_notifications';
@@ -909 +910 @@
 add_action( 'make_spam_user', 'xprofile_remove_data' );
 
+/*** XProfile Meta ****************************************************/
+
+function bp_xprofile_delete_meta( $object_id, $object_type, $meta_key = false, $meta_value = false ) {
+    global $wpdb, $bp;
+
+    $object_id = (int) $object_id;
+
+    if ( !$object_id )
+        return false;
+    
+    if ( !isset( $object_type ) )
+        return false;
+    
+    if ( !in_array( $object_type, array( 'group', 'field', 'data' ) ) )
+        return false;
+
+    $meta_key = preg_replace('|[^a-z0-9_]|i', '', $meta_key);
+
+    if ( is_array($meta_value) || is_object($meta_value) )
+        $meta_value = serialize($meta_value);
+
+    $meta_value = trim( $meta_value );
+
+    if ( !$meta_key ) {
+        $wpdb->query( $wpdb->prepare( "DELETE FROM " . $bp->profile->table_name_meta . " WHERE object_id = %d AND object_type = %s", $object_id, $object_type ) );
+    } else if ( $meta_value ) {
+        $wpdb->query( $wpdb->prepare( "DELETE FROM " . $bp->profile->table_name_meta . " WHERE object_id = %d AND object_type = %s AND meta_key = %s AND meta_value = %s", $object_id, $object_type, $meta_key, $meta_value ) );
+    } else {
+        $wpdb->query( $wpdb->prepare( "DELETE FROM " . $bp->profile->table_name_meta . " WHERE object_id = %d AND object_type = %s AND meta_key = %s", $object_id, $object_type, $meta_key ) );
+    }
+
+    /* Delete the cached object */
+    wp_cache_delete( 'bp_xprofile_meta_' . $object_type . '_' . $object_id . '_' . $meta_key, 'bp' );
+
+    return true;
+}
+
+function bp_xprofile_get_meta( $object_id, $object_type, $meta_key = '') {
+    global $wpdb, $bp;
+
+    $object_id = (int) $object_id;
+
+    if ( !$object_id )
+        return false;
+    
+    if ( !isset( $object_type ) )
+        return false;
+    
+    if ( !in_array( $object_type, array( 'group', 'field', 'data' ) ) )
+        return false;
+
+    if ( !empty($meta_key) ) {
+        $meta_key = preg_replace('|[^a-z0-9_]|i', '', $meta_key);
+
+        if ( !$metas = wp_cache_get( 'bp_xprofile_meta_' . $object_type . '_' . $object_id . '_' . $meta_key, 'bp' ) ) {
+            $metas = $wpdb->get_col( $wpdb->prepare("SELECT meta_value FROM " . $bp->profile->table_name_meta . " WHERE object_id = %d AND object_type = %s AND meta_key = %s", $object_id, $object_type, $meta_key) );
+            wp_cache_set( 'bp_xprofile_meta_' . $object_type . '_' . $object_id . '_' . $meta_key, $metas, 'bp' );
+        }
+    } else {
+        $metas = $wpdb->get_col( $wpdb->prepare("SELECT meta_value FROM " . $bp->profile->table_name_meta . " WHERE object_id = %d AND object_type = %s", $object_id, $object_type ) );
+    }
+
+    if ( empty($metas) ) {
+        if ( empty($meta_key) )
+            return array();
+        else
+            return '';
+    }
+
+    $metas = array_map('maybe_unserialize', (array)$metas);
+
+    if ( 1 == count($metas) )
+        return $metas[0];
+    else
+        return $metas;
+}
+
+function bp_xprofile_update_meta( $object_id, $object_type, $meta_key, $meta_value ) {
+    global $wpdb, $bp;
+
+    $object_id = (int) $object_id;
+
+    if ( !$object_id )
+        return false;
+    
+    if ( !isset( $object_type ) )
+        return false;
+    
+    if ( !in_array( $object_type, array( 'group', 'field', 'data' ) ) )
+        return false;
+        
+    $meta_key = preg_replace( '|[^a-z0-9_]|i', '', $meta_key );
+
+    if ( is_string($meta_value) )
+        $meta_value = stripslashes($wpdb->escape($meta_value));
+
+    $meta_value = maybe_serialize($meta_value);
+
+    if (empty($meta_value)) {
+        return bp_xprofile_delete_meta( $object_id, $object_type, $meta_key );
+    }
+    
+    $cur = $wpdb->get_row( $wpdb->prepare( "SELECT * FROM " . $bp->profile->table_name_meta . " WHERE object_id = %d AND object_type = %s AND meta_key = %s", $object_id, $object_type, $meta_key ) );
+
+    if ( !$cur ) {
+        $wpdb->query( $wpdb->prepare( "INSERT INTO " . $bp->profile->table_name_meta . " ( object_id, object_type, meta_key, meta_value ) VALUES ( %d, %s, %s, %s )", $object_id, $object_type,  $meta_key, $meta_value ) );
+    } else if ( $cur->meta_value != $meta_value ) {
+        $wpdb->query( $wpdb->prepare( "UPDATE " . $bp->profile->table_name_meta . " SET meta_value = %s WHERE object_id = %d AND object_type = %s AND meta_key = %s", $meta_value, $object_id, $object_type, $meta_key ) );
+    } else {
+        return false;
+    }
+
+    /* Update the cached object and recache */
+    wp_cache_set( 'bp_xprofile_meta_' . $object_type . '_' . $object_id . '_' . $meta_key, $meta_value, 'bp' );
+
+    return true;
+}
+
+function bp_xprofile_update_fieldgroup_meta( $field_group_id, $meta_key, $meta_value ) {
+    return bp_xprofile_update_meta( $field_group_id, 'group', $meta_key, $meta_value ); 
+}
+
+function bp_xprofile_update_field_meta( $field_id, $meta_key, $meta_value ) {
+    return bp_xprofile_update_meta( $field_id, 'field', $meta_key, $meta_value );   
+}
+
+function bp_xprofile_update_fielddata_meta( $field_data_id, $meta_key, $meta_value ) {
+    return bp_xprofile_update_meta( $field_data_id, 'data', $meta_key, $meta_value );   
+}
 
 /********************************************************************************