WordPress Version: 5.4
/**
* Execute changes made in WordPress 2.0.
*
* @ignore
* @since 2.0.0
*
* @global wpdb $wpdb WordPress database abstraction object.
* @global int $wp_current_db_version The old (current) database version.
*/
function upgrade_160()
{
global $wpdb, $wp_current_db_version;
populate_roles_160();
$users = $wpdb->get_results("SELECT * FROM {$wpdb->users}");
foreach ($users as $user) {
if (!empty($user->user_firstname)) {
update_user_meta($user->ID, 'first_name', wp_slash($user->user_firstname));
}
if (!empty($user->user_lastname)) {
update_user_meta($user->ID, 'last_name', wp_slash($user->user_lastname));
}
if (!empty($user->user_nickname)) {
update_user_meta($user->ID, 'nickname', wp_slash($user->user_nickname));
}
if (!empty($user->user_level)) {
update_user_meta($user->ID, $wpdb->prefix . 'user_level', $user->user_level);
}
if (!empty($user->user_icq)) {
update_user_meta($user->ID, 'icq', wp_slash($user->user_icq));
}
if (!empty($user->user_aim)) {
update_user_meta($user->ID, 'aim', wp_slash($user->user_aim));
}
if (!empty($user->user_msn)) {
update_user_meta($user->ID, 'msn', wp_slash($user->user_msn));
}
if (!empty($user->user_yim)) {
update_user_meta($user->ID, 'yim', wp_slash($user->user_icq));
}
if (!empty($user->user_description)) {
update_user_meta($user->ID, 'description', wp_slash($user->user_description));
}
if (isset($user->user_idmode)) {
$idmode = $user->user_idmode;
if ('nickname' === $idmode) {
$id = $user->user_nickname;
}
if ('login' === $idmode) {
$id = $user->user_login;
}
if ('firstname' === $idmode) {
$id = $user->user_firstname;
}
if ('lastname' === $idmode) {
$id = $user->user_lastname;
}
if ('namefl' === $idmode) {
$id = $user->user_firstname . ' ' . $user->user_lastname;
}
if ('namelf' === $idmode) {
$id = $user->user_lastname . ' ' . $user->user_firstname;
}
if (!$idmode) {
$id = $user->user_nickname;
}
$wpdb->update($wpdb->users, array('display_name' => $id), array('ID' => $user->ID));
}
// FIXME: RESET_CAPS is temporary code to reset roles and caps if flag is set.
$caps = get_user_meta($user->ID, $wpdb->prefix . 'capabilities');
if (empty($caps) || defined('RESET_CAPS')) {
$level = get_user_meta($user->ID, $wpdb->prefix . 'user_level', true);
$role = translate_level_to_role($level);
update_user_meta($user->ID, $wpdb->prefix . 'capabilities', array($role => true));
}
}
$old_user_fields = array('user_firstname', 'user_lastname', 'user_icq', 'user_aim', 'user_msn', 'user_yim', 'user_idmode', 'user_ip', 'user_domain', 'user_browser', 'user_description', 'user_nickname', 'user_level');
$wpdb->hide_errors();
foreach ($old_user_fields as $old) {
$wpdb->query("ALTER TABLE {$wpdb->users} DROP {$old}");
}
$wpdb->show_errors();
// Populate comment_count field of posts table.
$comments = $wpdb->get_results("SELECT comment_post_ID, COUNT(*) as c FROM {$wpdb->comments} WHERE comment_approved = '1' GROUP BY comment_post_ID");
if (is_array($comments)) {
foreach ($comments as $comment) {
$wpdb->update($wpdb->posts, array('comment_count' => $comment->c), array('ID' => $comment->comment_post_ID));
}
}
/*
* Some alpha versions used a post status of object instead of attachment
* and put the mime type in post_type instead of post_mime_type.
*/
if ($wp_current_db_version > 2541 && $wp_current_db_version <= 3091) {
$objects = $wpdb->get_results("SELECT ID, post_type FROM {$wpdb->posts} WHERE post_status = 'object'");
foreach ($objects as $object) {
$wpdb->update($wpdb->posts, array('post_status' => 'attachment', 'post_mime_type' => $object->post_type, 'post_type' => ''), array('ID' => $object->ID));
$meta = get_post_meta($object->ID, 'imagedata', true);
if (!empty($meta['file'])) {
update_attached_file($object->ID, $meta['file']);
}
}
}
}