Changeset 863 for trunk/wp-admin/upgrade-functions.php

Timestamp:

02/11/2004 04:51:19 AM (22 years ago)

Author:

rboren

Message:

Add author_name query and author permalinks.

File:

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

trunk/wp-admin/upgrade-functions.php

@@ -681 +681 @@
     $wpdb->query("ALTER TABLE `$tableposts` CHANGE `comment_status` `comment_status` ENUM( 'open', 'closed', 'registered_only' ) DEFAULT 'open' NOT NULL");
 
+    maybe_add_column($tableusers, 'user_nicename', "ALTER TABLE `$tableusers` ADD `user_nicename` VARCHAR(50) DEFAULT '' NOT NULL ;");
+
+    // Set user_nicename.
+    $users = $wpdb->get_results("SELECT ID, user_nickname, user_nicename FROM $tableusers");
+    foreach ($users as $user) {
+        if ('' == $user->user_nicename) { 
+            $newname = sanitize_title($user->user_nickname);
+            $wpdb->query("UPDATE $tableusers SET user_nicename = '$newname' WHERE ID = '$user->ID'");
+        }
+    }
+
     // Convert passwords to MD5 and update table appropiately
     $query = 'DESCRIBE '.$tableusers.' user_pass';