← All changes | includes/migrations/v300.php +3 -3 2.1.21 → 2.2.7 View file →

		@@ -7,9 +7,9 @@
7	7
8	8	update_option('patchstack_db_version', '3.0.0');
9	9
10	10	// Migrate all current options to the new prefix.
11		-$exists = $wpdb->get_var( "SELECT COUNT(*) FROM " . $wpdb->prefix . "options WHERE option_name = 'webarx_api_token'" );
	11	+$exists = $wpdb->get_var( "SELECT COUNT(*) FROM " . $prefix . "options WHERE option_name = 'webarx_api_token'" );
12	12	if ( !is_null( $exists ) && $exists >= 1 ) {
13		- $wpdb->query( 'INSERT IGNORE INTO ' . $wpdb->prefix . "options (option_name, option_value, autoload) SELECT REPLACE(option_name, 'webarx_', 'patchstack_') as option_name, option_value, autoload FROM " . $wpdb->prefix . "options WHERE option_name like 'webarx_%'" );
14		- $wpdb->query( 'UPDATE ' . $wpdb->prefix . 'options AS a SET option_value = (SELECT option_value FROM ' . $wpdb->prefix . "options WHERE option_name = REPLACE(a.option_name, 'patchstack_', 'webarx_')) WHERE option_name LIKE 'patchstack_%'" );
	13	+ $wpdb->query( 'INSERT IGNORE INTO ' . $prefix . "options (option_name, option_value, autoload) SELECT REPLACE(option_name, 'webarx_', 'patchstack_') as option_name, option_value, autoload FROM " . $prefix . "options WHERE option_name like 'webarx_%'" );
	14	+ $wpdb->query( 'UPDATE ' . $prefix . 'options AS a SET option_value = (SELECT option_value FROM ' . $prefix . "options WHERE option_name = REPLACE(a.option_name, 'patchstack_', 'webarx_')) WHERE option_name LIKE 'patchstack_%'" );
15	15	}