Ejemplo n.º 1
0
/**
 * Upgrade from 3.0.x to 3.1
 */
function mr_upgrade_from_3_0_to_3_1()
{
    // activate plugin and db updates will occur
    Multi_Rating::activate_plugin();
    // replace username with user ID
    global $wpdb;
    $num_column_exists = $wpdb->query('SHOW COLUMNS FROM ' . $wpdb->prefix . Multi_Rating::RATING_ITEM_ENTRY_TBL_NAME . ' LIKE "username"');
    if ($num_column_exists > 0) {
        // if username column exists
        $query = 'SELECT username, rating_item_entry_id FROM ' . $wpdb->prefix . Multi_Rating::RATING_ITEM_ENTRY_TBL_NAME . ' WHERE username != ""';
        $rows = $wpdb->get_results($query);
        foreach ($rows as $row) {
            $query = 'SELECT ID FROM ' . $wpdb->users . ' WHERE user_login = "******"';
            $user_id = $wpdb->get_var($query);
            if ($user_id) {
                $wpdb->update($wpdb->prefix . Multi_Rating::RATING_ITEM_ENTRY_TBL_NAME, array('user_id' => $user_id), array('rating_item_entry_id' => $row->rating_item_entry_id));
            }
        }
        $wpdb->query('ALTER TABLE ' . $wpdb->prefix . Multi_Rating::RATING_ITEM_ENTRY_TBL_NAME . ' DROP COLUMN username');
    }
}
Ejemplo n.º 2
0
/**
 * Activate plugin
 */
function mr_activate_plugin()
{
    if (is_admin() && (!defined('DOING_AJAX') || !DOING_AJAX)) {
        add_option(MULTI_RATING::DO_ACTIVATION_REDIRECT_OPTION, true);
        Multi_Rating::activate_plugin();
    }
}