Changeset 2631 for trunk/wp-includes/functions.php

Timestamp:

06/12/2005 08:49:13 PM (20 years ago)

Author:

matt

Message:

Beginning of user system overhaul, TODO: update all code that deals with user data

File:

• trunk/wp-includes/functions.php (modified) (1 diff)

trunk/wp-includes/functions.php

@@ -1887 +1887 @@
 }
 
+function update_usermeta( $user_id, $meta_key, $meta_value ) {
+    global $wpdb;
+    $user_id = (int) $user_id;
+    $meta_key = preg_replace('|a-z0-9_|i', '', $meta_key);
+    $cur = $wpdb->get_row("SELECT * FROM $wpdb->usermeta WHERE user_id = '$user_id' AND meta_key = '$meta_key'");
+    if ( !$cur ) {
+        $wpdb->query("INSERT INTO $wpdb->usermeta ( user_id, meta_key, meta_value )
+        VALUES
+        ( '$user_id', '$meta_key', '$meta_value' )");
+        return true;
+    }
+    if ( $cur->meta_value != $meta_value )
+        $wpdb->query("UPDATE $wpdb->usermeta SET meta_value = '$meta_value' WHERE user_id = '$user_id' AND meta_key = '$meta_key'");
+}
+
 ?>