← All changes | includes/migrations/v300.php +15 -15 trunk → 2.2.10 View file →

		@@ -1,15 +1,15 @@
1		-<?php
2		-
3		-// Do not allow the file to be called directly.
4		-if (!defined('ABSPATH')) {
5		- exit;
6		-}
7		-
8		-update_option('patchstack_db_version', '3.0.0');
9		-
10		-// Migrate all current options to the new prefix.
11		-$exists = $wpdb->get_var( "SELECT COUNT(*) FROM " . $prefix . "options WHERE option_name = 'webarx_api_token'" );
12		-if ( !is_null( $exists ) && $exists >= 1 ) {
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		-}
	1	+<?php
	2	+
	3	+// Do not allow the file to be called directly.
	4	+if (!defined('ABSPATH')) {
	5	+ exit;
	6	+}
	7	+
	8	+update_option('patchstack_db_version', '3.0.0');
	9	+
	10	+// Migrate all current options to the new prefix.
	11	+$exists = $wpdb->get_var( "SELECT COUNT(*) FROM " . $prefix . "options WHERE option_name = 'webarx_api_token'" );
	12	+if ( !is_null( $exists ) && $exists >= 1 ) {
	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	+}