| 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 |
} |
| 16 |
|
