upgrade_330

The timeline below displays how wordpress function upgrade_330 has changed across different WordPress versions. If a version is not listed, refer to the next available version below.

WordPress Version: 6.3

/**
 * Execute changes made in WordPress 3.3.
 *
 * @ignore
 * @since 3.3.0
 *
 * @global int   $wp_current_db_version The old (current) database version.
 * @global wpdb  $wpdb                  WordPress database abstraction object.
 * @global array $wp_registered_widgets
 * @global array $sidebars_widgets
 */
function upgrade_330()
{
    global $wp_current_db_version, $wpdb, $wp_registered_widgets, $sidebars_widgets;
    if ($wp_current_db_version < 19061 && wp_should_upgrade_global_tables()) {
        $wpdb->query("DELETE FROM {$wpdb->usermeta} WHERE meta_key IN ('show_admin_bar_admin', 'plugins_last_view')");
    }
    if ($wp_current_db_version >= 11548) {
        return;
    }
    $sidebars_widgets = get_option('sidebars_widgets', array());
    $_sidebars_widgets = array();
    if (isset($sidebars_widgets['wp_inactive_widgets']) || empty($sidebars_widgets)) {
        $sidebars_widgets['array_version'] = 3;
    } elseif (!isset($sidebars_widgets['array_version'])) {
        $sidebars_widgets['array_version'] = 1;
    }
    switch ($sidebars_widgets['array_version']) {
        case 1:
            foreach ((array) $sidebars_widgets as $index => $sidebar) {
                if (is_array($sidebar)) {
                    foreach ((array) $sidebar as $i => $name) {
                        $id = strtolower($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $id = sanitize_title($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $found = false;
                        foreach ($wp_registered_widgets as $widget_id => $widget) {
                            if (strtolower($widget['name']) === strtolower($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            } elseif (sanitize_title($widget['name']) === sanitize_title($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            }
                        }
                        if ($found) {
                            continue;
                        }
                        unset($_sidebars_widgets[$index][$i]);
                    }
                }
            }
            $_sidebars_widgets['array_version'] = 2;
            $sidebars_widgets = $_sidebars_widgets;
            unset($_sidebars_widgets);
        // Intentional fall-through to upgrade to the next version.
        case 2:
            $sidebars_widgets = retrieve_widgets();
            $sidebars_widgets['array_version'] = 3;
            update_option('sidebars_widgets', $sidebars_widgets);
    }
}

WordPress Version: 5.4

/**
 * Execute changes made in WordPress 3.3.
 *
 * @ignore
 * @since 3.3.0
 *
 * @global int   $wp_current_db_version The old (current) database version.
 * @global wpdb  $wpdb                  WordPress database abstraction object.
 * @global array $wp_registered_widgets
 * @global array $sidebars_widgets
 */
function upgrade_330()
{
    global $wp_current_db_version, $wpdb, $wp_registered_widgets, $sidebars_widgets;
    if ($wp_current_db_version < 19061 && wp_should_upgrade_global_tables()) {
        $wpdb->query("DELETE FROM {$wpdb->usermeta} WHERE meta_key IN ('show_admin_bar_admin', 'plugins_last_view')");
    }
    if ($wp_current_db_version >= 11548) {
        return;
    }
    $sidebars_widgets = get_option('sidebars_widgets', array());
    $_sidebars_widgets = array();
    if (isset($sidebars_widgets['wp_inactive_widgets']) || empty($sidebars_widgets)) {
        $sidebars_widgets['array_version'] = 3;
    } elseif (!isset($sidebars_widgets['array_version'])) {
        $sidebars_widgets['array_version'] = 1;
    }
    switch ($sidebars_widgets['array_version']) {
        case 1:
            foreach ((array) $sidebars_widgets as $index => $sidebar) {
                if (is_array($sidebar)) {
                    foreach ((array) $sidebar as $i => $name) {
                        $id = strtolower($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $id = sanitize_title($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $found = false;
                        foreach ($wp_registered_widgets as $widget_id => $widget) {
                            if (strtolower($widget['name']) == strtolower($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            } elseif (sanitize_title($widget['name']) == sanitize_title($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            }
                        }
                        if ($found) {
                            continue;
                        }
                        unset($_sidebars_widgets[$index][$i]);
                    }
                }
            }
            $_sidebars_widgets['array_version'] = 2;
            $sidebars_widgets = $_sidebars_widgets;
            unset($_sidebars_widgets);
        // Intentional fall-through to upgrade to the next version.
        case 2:
            $sidebars_widgets = retrieve_widgets();
            $sidebars_widgets['array_version'] = 3;
            update_option('sidebars_widgets', $sidebars_widgets);
    }
}

WordPress Version: 5.3

/**
 * Execute changes made in WordPress 3.3.
 *
 * @ignore
 * @since 3.3.0
 *
 * @global int   $wp_current_db_version The old (current) database version.
 * @global wpdb  $wpdb                  WordPress database abstraction object.
 * @global array $wp_registered_widgets
 * @global array $sidebars_widgets
 */
function upgrade_330()
{
    global $wp_current_db_version, $wpdb, $wp_registered_widgets, $sidebars_widgets;
    if ($wp_current_db_version < 19061 && wp_should_upgrade_global_tables()) {
        $wpdb->query("DELETE FROM {$wpdb->usermeta} WHERE meta_key IN ('show_admin_bar_admin', 'plugins_last_view')");
    }
    if ($wp_current_db_version >= 11548) {
        return;
    }
    $sidebars_widgets = get_option('sidebars_widgets', array());
    $_sidebars_widgets = array();
    if (isset($sidebars_widgets['wp_inactive_widgets']) || empty($sidebars_widgets)) {
        $sidebars_widgets['array_version'] = 3;
    } elseif (!isset($sidebars_widgets['array_version'])) {
        $sidebars_widgets['array_version'] = 1;
    }
    switch ($sidebars_widgets['array_version']) {
        case 1:
            foreach ((array) $sidebars_widgets as $index => $sidebar) {
                if (is_array($sidebar)) {
                    foreach ((array) $sidebar as $i => $name) {
                        $id = strtolower($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $id = sanitize_title($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $found = false;
                        foreach ($wp_registered_widgets as $widget_id => $widget) {
                            if (strtolower($widget['name']) == strtolower($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            } elseif (sanitize_title($widget['name']) == sanitize_title($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            }
                        }
                        if ($found) {
                            continue;
                        }
                        unset($_sidebars_widgets[$index][$i]);
                    }
                }
            }
            $_sidebars_widgets['array_version'] = 2;
            $sidebars_widgets = $_sidebars_widgets;
            unset($_sidebars_widgets);
        // intentional fall-through to upgrade to the next version.
        case 2:
            $sidebars_widgets = retrieve_widgets();
            $sidebars_widgets['array_version'] = 3;
            update_option('sidebars_widgets', $sidebars_widgets);
    }
}

WordPress Version: 5.1

/**
 * Execute changes made in WordPress 3.3.
 *
 * @ignore
 * @since 3.3.0
 *
 * @global int   $wp_current_db_version
 * @global wpdb  $wpdb
 * @global array $wp_registered_widgets
 * @global array $sidebars_widgets
 */
function upgrade_330()
{
    global $wp_current_db_version, $wpdb, $wp_registered_widgets, $sidebars_widgets;
    if ($wp_current_db_version < 19061 && wp_should_upgrade_global_tables()) {
        $wpdb->query("DELETE FROM {$wpdb->usermeta} WHERE meta_key IN ('show_admin_bar_admin', 'plugins_last_view')");
    }
    if ($wp_current_db_version >= 11548) {
        return;
    }
    $sidebars_widgets = get_option('sidebars_widgets', array());
    $_sidebars_widgets = array();
    if (isset($sidebars_widgets['wp_inactive_widgets']) || empty($sidebars_widgets)) {
        $sidebars_widgets['array_version'] = 3;
    } elseif (!isset($sidebars_widgets['array_version'])) {
        $sidebars_widgets['array_version'] = 1;
    }
    switch ($sidebars_widgets['array_version']) {
        case 1:
            foreach ((array) $sidebars_widgets as $index => $sidebar) {
                if (is_array($sidebar)) {
                    foreach ((array) $sidebar as $i => $name) {
                        $id = strtolower($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $id = sanitize_title($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $found = false;
                        foreach ($wp_registered_widgets as $widget_id => $widget) {
                            if (strtolower($widget['name']) == strtolower($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            } elseif (sanitize_title($widget['name']) == sanitize_title($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            }
                        }
                        if ($found) {
                            continue;
                        }
                        unset($_sidebars_widgets[$index][$i]);
                    }
                }
            }
            $_sidebars_widgets['array_version'] = 2;
            $sidebars_widgets = $_sidebars_widgets;
            unset($_sidebars_widgets);
        // intentional fall-through to upgrade to the next version.
        case 2:
            $sidebars_widgets = retrieve_widgets();
            $sidebars_widgets['array_version'] = 3;
            update_option('sidebars_widgets', $sidebars_widgets);
    }
}

WordPress Version: 4.5

/**
 * Execute changes made in WordPress 3.3.
 *
 * @ignore
 * @since 3.3.0
 *
 * @global int   $wp_current_db_version
 * @global wpdb  $wpdb
 * @global array $wp_registered_widgets
 * @global array $sidebars_widgets
 */
function upgrade_330()
{
    global $wp_current_db_version, $wpdb, $wp_registered_widgets, $sidebars_widgets;
    if ($wp_current_db_version < 19061 && wp_should_upgrade_global_tables()) {
        $wpdb->query("DELETE FROM {$wpdb->usermeta} WHERE meta_key IN ('show_admin_bar_admin', 'plugins_last_view')");
    }
    if ($wp_current_db_version >= 11548) {
        return;
    }
    $sidebars_widgets = get_option('sidebars_widgets', array());
    $_sidebars_widgets = array();
    if (isset($sidebars_widgets['wp_inactive_widgets']) || empty($sidebars_widgets)) {
        $sidebars_widgets['array_version'] = 3;
    } elseif (!isset($sidebars_widgets['array_version'])) {
        $sidebars_widgets['array_version'] = 1;
    }
    switch ($sidebars_widgets['array_version']) {
        case 1:
            foreach ((array) $sidebars_widgets as $index => $sidebar) {
                if (is_array($sidebar)) {
                    foreach ((array) $sidebar as $i => $name) {
                        $id = strtolower($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $id = sanitize_title($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $found = false;
                        foreach ($wp_registered_widgets as $widget_id => $widget) {
                            if (strtolower($widget['name']) == strtolower($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            } elseif (sanitize_title($widget['name']) == sanitize_title($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            }
                        }
                        if ($found) {
                            continue;
                        }
                        unset($_sidebars_widgets[$index][$i]);
                    }
                }
            }
            $_sidebars_widgets['array_version'] = 2;
            $sidebars_widgets = $_sidebars_widgets;
            unset($_sidebars_widgets);
        case 2:
            $sidebars_widgets = retrieve_widgets();
            $sidebars_widgets['array_version'] = 3;
            update_option('sidebars_widgets', $sidebars_widgets);
    }
}

WordPress Version: 4.3

/**
 * Execute changes made in WordPress 3.3.
 *
 * @since 3.3.0
 *
 * @global int   $wp_current_db_version
 * @global wpdb  $wpdb
 * @global array $wp_registered_widgets
 * @global array $sidebars_widgets
 */
function upgrade_330()
{
    global $wp_current_db_version, $wpdb, $wp_registered_widgets, $sidebars_widgets;
    if ($wp_current_db_version < 19061 && wp_should_upgrade_global_tables()) {
        $wpdb->query("DELETE FROM {$wpdb->usermeta} WHERE meta_key IN ('show_admin_bar_admin', 'plugins_last_view')");
    }
    if ($wp_current_db_version >= 11548) {
        return;
    }
    $sidebars_widgets = get_option('sidebars_widgets', array());
    $_sidebars_widgets = array();
    if (isset($sidebars_widgets['wp_inactive_widgets']) || empty($sidebars_widgets)) {
        $sidebars_widgets['array_version'] = 3;
    } elseif (!isset($sidebars_widgets['array_version'])) {
        $sidebars_widgets['array_version'] = 1;
    }
    switch ($sidebars_widgets['array_version']) {
        case 1:
            foreach ((array) $sidebars_widgets as $index => $sidebar) {
                if (is_array($sidebar)) {
                    foreach ((array) $sidebar as $i => $name) {
                        $id = strtolower($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $id = sanitize_title($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $found = false;
                        foreach ($wp_registered_widgets as $widget_id => $widget) {
                            if (strtolower($widget['name']) == strtolower($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            } elseif (sanitize_title($widget['name']) == sanitize_title($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            }
                        }
                        if ($found) {
                            continue;
                        }
                        unset($_sidebars_widgets[$index][$i]);
                    }
                }
            }
            $_sidebars_widgets['array_version'] = 2;
            $sidebars_widgets = $_sidebars_widgets;
            unset($_sidebars_widgets);
        case 2:
            $sidebars_widgets = retrieve_widgets();
            $sidebars_widgets['array_version'] = 3;
            update_option('sidebars_widgets', $sidebars_widgets);
    }
}

WordPress Version: 3.7

/**
 * Execute changes made in WordPress 3.3.
 *
 * @since 3.3.0
 */
function upgrade_330()
{
    global $wp_current_db_version, $wpdb, $wp_registered_widgets, $sidebars_widgets;
    if ($wp_current_db_version < 19061 && is_main_site() && !defined('DO_NOT_UPGRADE_GLOBAL_TABLES')) {
        $wpdb->query("DELETE FROM {$wpdb->usermeta} WHERE meta_key IN ('show_admin_bar_admin', 'plugins_last_view')");
    }
    if ($wp_current_db_version >= 11548) {
        return;
    }
    $sidebars_widgets = get_option('sidebars_widgets', array());
    $_sidebars_widgets = array();
    if (isset($sidebars_widgets['wp_inactive_widgets']) || empty($sidebars_widgets)) {
        $sidebars_widgets['array_version'] = 3;
    } elseif (!isset($sidebars_widgets['array_version'])) {
        $sidebars_widgets['array_version'] = 1;
    }
    switch ($sidebars_widgets['array_version']) {
        case 1:
            foreach ((array) $sidebars_widgets as $index => $sidebar) {
                if (is_array($sidebar)) {
                    foreach ((array) $sidebar as $i => $name) {
                        $id = strtolower($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $id = sanitize_title($name);
                        if (isset($wp_registered_widgets[$id])) {
                            $_sidebars_widgets[$index][$i] = $id;
                            continue;
                        }
                        $found = false;
                        foreach ($wp_registered_widgets as $widget_id => $widget) {
                            if (strtolower($widget['name']) == strtolower($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            } elseif (sanitize_title($widget['name']) == sanitize_title($name)) {
                                $_sidebars_widgets[$index][$i] = $widget['id'];
                                $found = true;
                                break;
                            }
                        }
                        if ($found) {
                            continue;
                        }
                        unset($_sidebars_widgets[$index][$i]);
                    }
                }
            }
            $_sidebars_widgets['array_version'] = 2;
            $sidebars_widgets = $_sidebars_widgets;
            unset($_sidebars_widgets);
        case 2:
            $sidebars_widgets = retrieve_widgets();
            $sidebars_widgets['array_version'] = 3;
            update_option('sidebars_widgets', $sidebars_widgets);
    }
}