/** * 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'); } }
/** * 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(); } }