wpdb = $wpdb; load_plugin_textdomain( 'acf-field-migrator', false, '/advanced-custom-fields-migrator/languages/' ); add_action( 'added_option', array( &$this, 'force_autoload_no' ), 10, 2 ); if ( ! current_user_can( 'manage_options' ) ) return; $this->options_link = ''.__('Settings', 'acf-migrator').''; add_action( 'admin_enqueue_scripts', array( &$this, 'admin_enqueues' ) ); add_action( 'admin_menu', array( &$this, 'add_admin_menu' ) ); add_action( 'wp_ajax_acfmigrator', array( &$this, 'ajax_process_record' ) ); add_filter( 'plugin_action_links', array( &$this, 'add_plugin_action_links' ), 10, 2 ); } public function force_autoload_no( $option, $value ) { if ( ! get_acfm_options( 'force_autoload_no' ) ) return true; // Only for ACF fields - for now if ( ! preg_match( '#^_+\d+_[a-zA-Z](\w)+$#', $option ) ) return true; $result = $this->wpdb->update( $this->wpdb->options, array( 'autoload' => 'no' ), array( 'option_name' => $option ) ); return $result ? true : false; } // Display a Settings link on the main Plugins page public function add_plugin_action_links( $links, $file ) { if ( $file == plugin_basename( __FILE__ ) ) { array_unshift( $links, $this->options_link ); $link = ''.__('Migrate', 'acf-migrator').''; array_unshift( $links, $link ); } return $links; } // Register the management page public function add_admin_menu() { $this->menu_id = add_management_page( __( 'ACF Migration', 'acf-migrator' ), __( 'ACF Migration', 'acf-migrator' ), 'manage_options', 'acf-migrator', array(&$this, 'user_interface') ); add_action( 'admin_print_styles-' . $this->menu_id, array( &$this, 'styles' ) ); add_screen_meta_link( 'acf-migrator-options-link', __('ACF Migration Settings', 'acf-migrator'), admin_url('options-general.php?page=acf-migrator-options'), $this->menu_id, array('style' => 'font-weight: bold;') ); } public function styles() { wp_register_style( 'acf-migrator-admin', plugins_url( 'settings.css', __FILE__ ) ); wp_enqueue_style( 'acf-migrator-admin' ); } // Enqueue the needed Javascript and CSS public function admin_enqueues( $hook_suffix ) { if ( $hook_suffix != $this->menu_id ) return; // WordPress 3.1 vs older version compatibility if ( wp_script_is( 'jquery-ui-widget', 'registered' ) ) wp_enqueue_script( 'jquery-ui-progressbar', plugins_url( 'jquery-ui/jquery.ui.progressbar.min.js', __FILE__ ), array( 'jquery-ui-core', 'jquery-ui-widget' ), '1.8.6' ); else wp_enqueue_script( 'jquery-ui-progressbar', plugins_url( 'jquery-ui/jquery.ui.progressbar.min.1.7.2.js', __FILE__ ), array( 'jquery-ui-core' ), '1.7.2' ); wp_enqueue_style( 'jquery-ui-acfmigrator', plugins_url( 'jquery-ui/redmond/jquery-ui-1.7.2.custom.css', __FILE__ ), array(), '1.7.2' ); } public function user_interface() { echo <<

EOD; _e('ACF Migration Cleanup', 'acf-migrator'); echo '

'; // If the button was clicked if ( ! empty( $_POST['acf-migrator'] ) || ! empty( $_REQUEST['posts'] ) || get_acfm_options( 'debug_mode' ) ) { if ( ! get_acfm_options( 'debug_mode' ) ) { // Form nonce check check_admin_referer( 'acf-migrator' ); } // Create the list of image IDs if ( ! empty( $_REQUEST['posts'] ) ) { $posts = array_map( 'intval', explode( ',', trim( $_REQUEST['posts'], ',' ) ) ); $count = count( $posts ); $posts = implode( ',', $posts ); } else { $posts = array(); $count = 0; if ( false ) { $posts = $this->get_postmeta(); $count = count( $posts ); } if ( get_acfm_options( 'revert_migration' ) ) { $posts = $this->get_options(); $count = count( $posts ); } // always run cleanup_autoload if ( get_acfm_options( 'reset_autoload' ) ) { $posts[] = '0:cleanup_autoload'; $count++; } if ( ! get_acfm_options( 'debug_mode' ) && ! $count ) { echo '

' . _e( 'All done. No further postmeta to migrate.', 'acf-migrator' ) . "

"; return; } } if ( get_acfm_options( 'debug_mode' ) ) { print_r($posts); echo '
'; echo '' . __LINE__ . ':' . basename( __FILE__ ) . '
'; foreach ( $posts as $key => $migrate_id ) { $this->migrate_id = $migrate_id; $this->ajax_process_record(); } exit( __LINE__ . ':' . basename( __FILE__ ) . " DONE
\n" ); } $posts = array_unique( $posts ); $posts = "'" . implode( "','", $posts ) . "'"; $this->show_status( $count, $posts ); delete_transient( 'Acf_Field_Migration-done_uids' ); } else { // No button click? Display the form. $this->show_greeting(); } echo ''; } public function get_options() { // select wp_options having ACF postmeta data $sql = 'SELECT option_id FROM `' . $this->wpdb->options . '` WHERE option_name REGEXP "^__[[:digit:]]+_[[:alnum:]]([[:alnum:]]|_)+$" AND option_value REGEXP "^field_[[:alnum:]]+$"'; $posts_to_migrate = get_acfm_options( 'posts_to_migrate' ); if ( $posts_to_migrate ) { $posts_to_migrate = str_replace( ',', '|', $posts_to_migrate ); $sql .= ' AND option_name REGEXP "_(' . $posts_to_migrate . ')_"'; } $posts_to_skip = get_acfm_options( 'posts_to_skip' ); if ( $posts_to_skip ) { $posts_to_skip = str_replace( ',', '|', $posts_to_skip ); $sql .= ' AND option_name REGEXP "_(' . $posts_to_skip . ')_"'; } $migration_limit = get_acfm_options( 'migration_limit' ); if ( $migration_limit ) { $sql .= ' LIMIT ' . $migration_limit; } $results = $this->wpdb->get_col( $sql ); return $results; } public function get_postmeta() { // select distinct post ids haveing postmeta with option_name like "_%" $sql = 'SELECT meta_id FROM `' . $this->wpdb->postmeta . '` WHERE meta_key REGEXP "^_+[[:alnum:]]([[:alnum:]]|_)+$" AND meta_value REGEXP "^field_[[:alnum:]]+$"'; $posts_to_migrate = get_acfm_options( 'posts_to_migrate' ); if ( $posts_to_migrate ) { $sql .= ' AND post_id IN ( ' . $posts_to_migrate . ')'; } $posts_to_skip = get_acfm_options( 'posts_to_skip' ); if ( $posts_to_skip ) { $sql .= ' AND post_id NOT IN ( ' . $posts_to_skip . ')'; } $migration_limit = get_acfm_options( 'migration_limit' ); if ( $migration_limit ) { $sql .= ' LIMIT ' . $migration_limit; } $results = $this->wpdb->get_col( $sql ); return $results; } public function cleanup_autoload() { // update wp_options having option_name like "_%" and autoload = 'yes' // set autoload = no // return count of updated records $sql = 'UPDATE `' . $this->wpdb->options . '` SET autoload = "no" WHERE autoload = "yes" AND option_name REGEXP "^_+[[:digit:]]+_[[:alnum:]]([[:alnum:]]|_)+$";'; $count = $this->wpdb->query( $sql ); return $count; } public function show_status( $count, $posts ) { echo '

' . __( "Please be patient while postmeta records are migrated. Do not navigate away from this page until this script is done or the migrate will not be completed. You will be notified via this page when the migratation is completed.", 'acf-migrator' ) . '

'; echo '

' . sprintf( __( 'Estimated time required to migrate is %1$s minutes.', 'acf-migrator' ), number_format( $count * .20 ) ) . '

'; $text_goback = ( ! empty( $_GET['goback'] ) ) ? sprintf( __( 'To go back to the previous page, click here.', 'acf-migrator' ), 'javascript:history.go(-1)' ) : ''; $text_failures = sprintf( __( 'All done! %1$s postmeta records were successfully migrated in %2$s seconds and there were %3$s failure(s). To try migrating the failed records again, click here. %5$s', 'acf-migrator' ), "' + rt_successes + '", "' + rt_totaltime + '", "' + rt_errors + '", esc_url( wp_nonce_url( admin_url( 'tools.php?page=acf-migrator&goback=1' ), 'acf-migrator' ) . '&posts=' ) . "' + rt_failedlist + '", $text_goback ); $text_nofailures = sprintf( __( 'All done! %1$s postmeta records were successfully migrated in %2$s seconds and there were no failures. %3$s', 'acf-migrator' ), "' + rt_successes + '", "' + rt_totaltime + '", $text_goback ); ?>

0' ); ?>
0' ); ?>

© Copyright %s TYPO3Vagabond.com.'; $copyright = sprintf( $copyright, date( 'Y' ) ); echo $copyright; } // Process a single image ID (this is an AJAX handler) public function ajax_process_record() { if ( ! get_acfm_options( 'debug_mode' ) ) { error_reporting( 0 ); // Don't break the JSON result header( 'Content-type: application/json' ); // record_id:type_of_record $parts = $_REQUEST['id']; } else { $parts = $this->migrate_id; } if ( ! get_acfm_options( 'debug_mode' ) ) { error_log( $parts ); } else { print_r($parts); echo '
'; echo '' . __LINE__ . ':' . basename( __FILE__ ) . '
'; } $orig_migrate_id = $parts; $parts = explode( ':', $parts ); $type = isset( $parts[1] ) ? $parts[1] : false; $this->migrate_id = (int) $parts[0]; $process_type = ''; if ( false === $type ) { $process_type = 'post'; } elseif ( 'cleanup_autoload' == $type ) { $process_type = $type; } else { die( json_encode( array( 'error' => sprintf( __( "Undefined type: %s", 'acf-migrator' ), esc_html( $orig_migrate_id ) ) ) ) ); } switch( $process_type ) { case 'cleanup_autoload': $count = $this->cleanup_autoload(); if ( $count ) { $count = number_format( $count ); die( json_encode( array( 'success' => sprintf( __( 'wp_options autoload set to \'no\' for %s entries', 'acf-migrator' ), $count ) ) ) ); } else { die( json_encode( array( 'success' => sprintf( __( 'No wp_options autoload settings needed changing', 'acf-migrator' ), $count ) ) ) ); } break; case 'post': $success = $this->revert_migration( $this->migrate_id ); if ( $success ) { if ( ! get_acfm_options( 'debug_mode' ) ) die( json_encode( array( 'success' => sprintf( __( 'Postmeta ID %1$s was successfully restored in %2$s seconds.', 'acf-migrator' ), $this->migrate_id, timer_stop() ) ) ) ); else echo sprintf( __( 'Postmeta ID %1$s was successfully restored in %2$s seconds.', 'acf-migrator' ), $this->migrate_id, timer_stop() ) . '
'; } else { if ( ! get_acfm_options( 'debug_mode' ) ) die( json_encode( array( 'error' => sprintf( __( 'Postmeta ID %1$s was NOT successfully restored in %2$s seconds.', 'acf-migrator' ), $this->migrate_id, timer_stop() ) ) ) ); else echo sprintf( __( 'Postmeta ID %1$s was NOT successfully restored in %2$s seconds.', 'acf-migrator' ), $this->migrate_id, timer_stop() ) . '
'; } break; // shouldn't be called, but code left in for now incase I have // similar troubles in the future case 'migrate-never': $success = $this->migrate_postmeta( $this->migrate_id ); if ( $success ) { if ( ! get_acfm_options( 'debug_mode' ) ) die( json_encode( array( 'success' => sprintf( __( 'Postmeta ID %1$s was successfully migrated in %2$s seconds.', 'acf-migrator' ), $this->migrate_id, timer_stop() ) ) ) ); else echo sprintf( __( 'Postmeta ID %1$s was successfully migrated in %2$s seconds.', 'acf-migrator' ), $this->migrate_id, timer_stop() ) . '
'; } else { if ( ! get_acfm_options( 'debug_mode' ) ) die( json_encode( array( 'error' => sprintf( __( 'Postmeta ID %1$s was NOT successfully migrated in %2$s seconds.', 'acf-migrator' ), $this->migrate_id, timer_stop() ) ) ) ); else echo sprintf( __( 'Postmeta ID %1$s was NOT successfully migrated in %2$s seconds.', 'acf-migrator' ), $this->migrate_id, timer_stop() ) . '
'; } break; default: if ( ! get_acfm_options( 'debug_mode' ) ) die( json_encode( array( 'success' => __('Something was done') ) ) ); else echo __('Something was done') . '
'; break; } } public function revert_migration( $id ) { $sql = 'SELECT option_name, option_value FROM `' . $this->wpdb->options . '` WHERE option_id = ' . $id; $result = $this->wpdb->get_row( $sql ); if ( ! $result ) return false; if ( ! preg_match( '#^__(\d+)_(\w+)$#', $result->option_name, $matches ) ) return false; $post_id = $matches[ 1 ]; $meta_key = $matches[ 2 ]; $_meta_key = '_' . $meta_key; // no need to unserialize as we're only dealing with strings $success = add_post_meta( $post_id, $_meta_key, $result->option_value, true ); if ( ! $success ) update_post_meta( $post_id, $_meta_key, $result->option_value, true ); $option_name = str_replace( '__', '_', $result->option_name ); // get our actual post meta value $option_value = get_option( $option_name ); $success = add_post_meta( $post_id, $meta_key, $option_value, true ); if ( ! $success ) update_post_meta( $post_id, $meta_key, $option_value, true ); delete_option( $result->option_name ); delete_option( $option_name ); return true; } public function migrate_postmeta( $id ) { $sql = 'SELECT post_id, meta_key, meta_value FROM `' . $this->wpdb->postmeta . '` WHERE meta_id = ' . $id; $result = $this->wpdb->get_row( $sql ); if ( ! $result ) return false; // our meta_key is already _alnum formatted $option_name = '_' . $result->post_id . $result->meta_key; $_option_name = '_' . $option_name; // no need to unserialize as we're only dealing with strings $success = add_option( $_option_name, $result->meta_value, null, 'no' ); if ( ! $success ) update_option( $_option_name, $result->meta_value ); $meta_key = ltrim( $result->meta_key, '_' ); // get our actual post meta value $meta_value = get_post_meta( $result->post_id, $meta_key, true ); $success = add_option( $option_name, $meta_value, null, 'no' ); if ( ! $success ) update_option( $option_name, $meta_value ); delete_post_meta( $result->post_id, $result->meta_key ); delete_post_meta( $result->post_id, $meta_key ); return true; } // Helper function to escape quotes in strings for use in Javascript public function esc_quotes( $string ) { return str_replace( '"', '\"', $string ); } } // Start up this plugin function Acf_Field_Migration() { global $Acf_Field_Migration; $Acf_Field_Migration = new Acf_Field_Migration(); } add_action( 'init', 'Acf_Field_Migration' ); ?>