Changeset 1176158

Timestamp:

06/07/2015 12:08:13 PM (11 years ago)

Author:

ilanraid

Message:

Updated to version 1.1.0

• Added option to fix media upload path
• Added options to search and replace in database

Location:

upress-link

Files:

• branches/1.0.0 (added)
• branches/1.0.0/admin (added)
• branches/1.0.0/admin/css (added)
• branches/1.0.0/admin/css/lc_switch.css (added)
• branches/1.0.0/admin/css/upress-link.css (added)
• branches/1.0.0/admin/js (added)
• branches/1.0.0/admin/js/lc_switch.min.js (added)
• branches/1.0.0/admin/js/upress-link.js (added)
• branches/1.0.0/admin/options.php (added)
• branches/1.0.0/includes (added)
• branches/1.0.0/index.php (added)
• branches/1.0.0/languages (added)
• branches/1.0.0/languages/upress-link.pot (added)
• branches/1.0.0/readme.txt (added)
• branches/1.0.0/screenshot-1.jpg (added)
• branches/1.0.0/upress-link.php (added)
• branches/1.1.0 (added)
• branches/1.1.0/admin (added)
• branches/1.1.0/admin/css (added)
• branches/1.1.0/admin/css/lc_switch.css (added)
• branches/1.1.0/admin/css/upress-link.css (added)
• branches/1.1.0/admin/js (added)
• branches/1.1.0/admin/js/lc_switch.min.js (added)
• branches/1.1.0/admin/js/upress-link.js (added)
• branches/1.1.0/admin/options.php (added)
• branches/1.1.0/includes (added)
• branches/1.1.0/index.php (added)
• branches/1.1.0/languages (added)
• branches/1.1.0/languages/upress-link.pot (added)
• branches/1.1.0/readme.txt (added)
• branches/1.1.0/screenshot-1.jpg (added)
• branches/1.1.0/upress-link.php (added)
• trunk/admin/css/upress-link.css (modified) (1 diff)
• trunk/admin/js/upress-link.js (modified) (2 diffs)
• trunk/admin/options.php (modified) (2 diffs)
• trunk/readme.txt (modified) (1 diff)
• trunk/upress-link.php (modified) (4 diffs)

upress-link/trunk/admin/css/upress-link.css

@@ -6 +6 @@
 .no-api-key, .api-error, .api-success {
     display: none;
+    white-space: pre;
 }
 #api_key {

upress-link/trunk/admin/js/upress-link.js

@@ -87 +87 @@
                 toggleSwitchSpinner(self, 'hide');
             });
+
         }).on('click', 'button[data-action], input[type=button][data-action]', function(e) {
             e.preventDefault();
 
             var self = $(this);
-            var wrapper = self.parents('.ajax-button-wrapper');
-            self.css({
-                width: self.outerWidth(),
-                height: self.outerHeight()
-            }).find('.text').fadeOut('fast', function() {
-                self.find('.spinner').fadeIn('fast');
-            }).end().attr('disabled', true);
+            startAjaxSpinner(self);
 
             $.post(ajaxurl, {
@@ -120 +115 @@
                 }
 
-                self.find('.spinner').fadeOut('fast', function () {
-                    self.find('.text').fadeIn('fast').end().css( {
-                        width: '',
-                        height: ''
-                    }).removeAttr('disabled');
-                });
-            });
+                endAjaxSpinner(self);
+            });
+
+        }).on('click', '.media-path-fix-button', function(e) {
+            e.preventDefault();
+
+            var self = $(this);
+            startAjaxSpinner(self);
+
+            $.post(ajaxurl, {
+                'action': 'fix_media_upload_path',
+                '_nonce': upressAjax._nonce
+            }, function(response) {
+                console.log(response);
+
+                if (response.status == "fail") {
+                    flashErrorMessage(response.data.message);
+                }
+                if(response.status == "success") {
+                    if(self.data('success-message')) {
+                        flashSuccessMessage(self.data('success-message'));
+                    } else {
+                        flashSuccessMessage(upressAjax.requestSuccess);
+                    }
+                }
+
+                endAjaxSpinner(self);
+            });
+        }).on('click', '.search-and-replace-button', function(e) {
+            e.preventDefault();
+
+            var self = $(this);
+            startAjaxSpinner(self);
+
+            $.post(ajaxurl, {
+                'action': 'database_search_and_replace',
+                'replace_from': $('.search-and-replace-from').val(),
+                'replace_to': $('.search-and-replace-to').val(),
+                '_nonce': upressAjax._nonce
+            }, function(response) {
+                console.log(response);
+
+                if (response.status == "fail") {
+                    flashErrorMessage(response.errors_msg);
+                }
+                if(response.status == "success") {
+                    $('.search-and-replace-from').val('');
+                    $('.search-and-replace-to').val('');
+
+                    if(self.data('success-message')) {
+                        flashSuccessMessage(self.data('success-message'));
+                    } else {
+                        if(response.success_msg) {
+                            flashSuccessMessage(response.success_msg);
+                        } else {
+                            flashSuccessMessage(upressAjax.requestSuccess);
+                        }
+                    }
+                }
+
+                endAjaxSpinner(self);
+            });
+        });
+    };
+
+    var startAjaxSpinner = function(self) {
+        var wrapper = self.parents('.ajax-button-wrapper');
+        self.css({
+            width: self.outerWidth(),
+            height: self.outerHeight()
+        }).find('.text').fadeOut('fast', function() {
+            self.find('.spinner').fadeIn('fast');
+        }).end().attr('disabled', true);
+    };
+    var endAjaxSpinner = function(self) {
+        self.find('.spinner').fadeOut('fast', function () {
+            self.find('.text').fadeIn('fast').end().css( {
+                width: '',
+                height: ''
+            }).removeAttr('disabled');
         });
     };
 
     var initButtons = function() {
-        $('button[data-action]').each(function() {
+        $('button[data-action], button[data-ajax-spinner]').each(function() {
             var self = $(this);
             var text = self.text();

upress-link/trunk/admin/options.php

@@ -47 +47 @@
     </form>
 
+
+    <hr>
+    <h3><?php esc_attr_e( 'More actions', $this->text_domain ); ?></h3>
+    <div class="wrap">
+        <h4><?php esc_attr_e( 'Fix media upload path', $this->text_domain ); ?></h4>
+        <p><?php esc_attr_e( 'Sometimes after migrating a WordPress installation the media path is not set correctly and breaks uploading media content. This will fix the issue and correct the upload path.', $this->text_domain ); ?></p>
+        <p><button class="button-secondary media-path-fix-button" type="button" data-ajax-spinner><?php esc_attr_e( 'Run media path fix', $this->text_domain ); ?></button></p>
+
+        <h4><?php esc_attr_e( 'Database search and replace', $this->text_domain ); ?></h4>
+        <p><?php esc_attr_e( 'This will allow you to replace a text in your entire website in a simple click of a button', $this->text_domain ); ?></p>
+        <p>
+            <table class="form-table">
+                <tr valign="top">
+                    <th scope="row"><?php esc_attr_e( 'Search:', $this->text_domain ); ?></th>
+                    <td><input type="text" class="regular-text search-and-replace-from" /></td>
+                </tr>
+                <tr valign="top">
+                    <th scope="row"><?php esc_attr_e( 'Replace:', $this->text_domain ); ?></th>
+                    <td><input type="text" class="regular-text search-and-replace-to" /></td>
+                </tr>
+            </table>
+
+            <button class="button-secondary search-and-replace-button" type="button" data-ajax-spinner><?php esc_attr_e( 'Search and replace', $this->text_domain ); ?></button>
+        </p>
+    </div>
+
+
     <?php if( $is_api_key_set ) : ?>
     <hr>
@@ -198 +225 @@
 <input type="hidden" id="api-key-valid" value="<?php echo (int)$is_api_key_correct; ?>">
 
+
+<hr>
 <span class="description"><?php esc_attr_e( '*Updates are queued and refreshed 1 minute after the update.', $this->text_domain ); ?></span>

upress-link/trunk/readme.txt

@@ -53 +53 @@
 
 == Changelog ==
+= 1.1 =
+1. Added option to fix media upload path
+1. Added options to search and replace in database
 = 1.0 =
 Initial release

upress-link/trunk/upress-link.php

@@ -29 +29 @@
     die;
 }
-define( 'UPL_VERSION', '1.0.0' );
+define( 'UPL_VERSION', '1.1.0' );
 define( 'UPL_PATH', dirname( __FILE__ ) );
 define( 'UPL_PATH_INCLUDES', dirname( __FILE__ ) . '/includes' );
@@ -52 +52 @@
             add_action( 'admin_enqueue_scripts', array( $this, 'upl_admin_enqueue_scripts' ) );
 
+            //ajax actions
             add_action( 'wp_ajax_check_api_key', array( $this, 'upl_ajax_check_api_key' ) );
             add_action( 'wp_ajax_send_request', array( $this, 'upl_ajax_send_request' ) );
+
+            add_action( 'wp_ajax_fix_media_upload_path', array( $this, 'upl_ajax_fix_media_upload_path' ) );
+            add_action( 'wp_ajax_database_search_and_replace', array( $this, 'upl_ajax_database_search_and_replace' ) );
         }
 
@@ -199 +203 @@
         exit;
     }
+    function upl_ajax_fix_media_upload_path() {
+        global $wpdb;
+
+        $nonce = $_POST['_nonce'];
+        if ( ! wp_verify_nonce( $nonce, $this->plugin_slug . '_ajax' ) ) { wp_die( 'Not authorized!' ); }
+        if ( ! current_user_can( 'manage_options' ) ) { wp_die( __( 'You do not have sufficient permissions to access this page.' ) ); }
+
+        $result = $wpdb->update( $wpdb->options, array( 'option_value' => null ), array( 'option_name' => 'upload_path' ) );
+
+        $response = array(
+            'status' => ( $result === false ? 'fail' : 'success' ),
+            'data' => ( $result === false ? $wpdb->last_error : $wpdb->last_query ),
+            'debug' => $wpdb
+        );
+
+        $response = json_encode( $response );
+        header( "Content-Type: application/json" );
+        echo $response;
+        exit;
+    }
+    function upl_ajax_database_search_and_replace() {
+        global $wpdb;
+
+        $nonce = $_POST['_nonce'];
+        if ( ! wp_verify_nonce( $nonce, $this->plugin_slug . '_ajax' ) ) { wp_die( 'Not authorized!' ); }
+        if ( ! current_user_can( 'manage_options' ) ) { wp_die( __( 'You do not have sufficient permissions to access this page.' ) ); }
+
+        $search = $_POST['replace_from'];
+        $replace = $_POST['replace_to'];
+
+        if( ! isset( $search ) || ! isset( $replace ) ) wp_die( 'Something is missing!' );
+
+        $result = $wpdb->get_results(
+            'SHOW TABLES',
+            ARRAY_N
+        );
+        /*$result = $wpdb->query(
+            $wpdb->prepare(
+                'SHOW TABLES'
+            )
+        );*/
+        $tables = array();
+        foreach ( $result as $res )
+        {
+            $tables[] = $res[0];
+        }
+
+        $report = array( 'tables' => 0,
+                         'rows' => 0,
+                         'change' => 0,
+                         'updates' => 0,
+                         'start' => microtime( ),
+                         'end' => microtime( ),
+                         'errors' => array( ),
+        );
+
+        if ( is_array( $tables ) && ! empty( $tables ) ) {
+            foreach( $tables as $table ) {
+                $report[ 'tables' ]++;
+
+                $columns = array( );
+
+                $fields = $wpdb->get_results( 'DESCRIBE ' . $table, ARRAY_A );
+                foreach( $fields as $column ) {
+                    $columns[ $column[ 'Field' ] ] = $column[ 'Key' ] == 'PRI' ? true : false;
+                }
+
+                $rows_result = $wpdb->get_row( 'SELECT COUNT(*) FROM ' . $table, ARRAY_N );
+                $row_count = $rows_result[ 0 ];
+                if ( $row_count == 0 )
+                    continue;
+
+                $page_size = 50000;
+                $pages = ceil( $row_count / $page_size );
+
+                for( $page = 0; $page < $pages; $page++ ) {
+                    $current_row = 0;
+                    $start = $page * $page_size;
+                    $end = $start + $page_size;
+                    // Grab the content of the table
+                    $data = $wpdb->get_results( sprintf( 'SELECT * FROM %s LIMIT %d, %d', $table, $start, $end ), ARRAY_A );
+
+                    if ( ! $data )
+                        $report[ 'errors' ][] = mysql_error( );
+
+                    foreach( $data as $row ) {
+                        $report[ 'rows' ]++; // Increment the row counter
+                        $current_row++;
+
+                        $update_sql = array( );
+                        $where_sql = array( );
+                        $upd = false;
+
+                        foreach( $columns as $column => $primary_key ) {
+                            $edited_data = $data_to_fix = $row[ $column ];
+
+                            // Run a search replace on the data that'll respect the serialisation.
+                            $edited_data = $this->recursive_unserialize_replace( $search, $replace, $data_to_fix );
+
+                            // Something was changed
+                            if ( $edited_data != $data_to_fix ) {
+                                $report[ 'change' ]++;
+                                $update_sql[] = $column . ' = "' . esc_sql( $edited_data ) . '"';
+                                $upd = true;
+                            }
+
+                            if ( $primary_key )
+                                $where_sql[] = $column . ' = "' . esc_sql( $data_to_fix ) . '"';
+                        }
+
+                        if ( $upd && ! empty( $where_sql ) ) {
+                            $sql = 'UPDATE ' . $table . ' SET ' . implode( ', ', $update_sql ) . ' WHERE ' . implode( ' AND ', array_filter( $where_sql ) );
+                            $result = $wpdb->get_results( $sql, ARRAY_A );
+                            if ( ! $result )
+                                $report[ 'errors' ][] = mysql_error( );
+                            else
+                                $report[ 'updates' ]++;
+
+                        } elseif ( $upd ) {
+                            $report[ 'errors' ][] = sprintf( '"%s" has no primary key, manual change needed on row %s.', $table, $current_row );
+                        }
+                    }
+                }
+            }
+        }
+
+        $report[ 'end' ] = microtime( );
+
+        $errors = '';
+        if ( ! empty( $report[ 'errors' ] ) && is_array( $report[ 'errors' ] ) ) {
+            foreach( $report[ 'errors' ] as $error )
+                $errors .=  $error . "\n";
+        }
+        $time = array_sum( explode( ' ', $report[ 'end' ] ) ) - array_sum( explode( ' ', $report[ 'start' ] ) );
+
+        $response = array(
+            'status' => ( $result === false ? 'fail' : 'success' ),
+            'data' => ( $result === false ? $wpdb->last_error : $report ),
+            'debug' => $wpdb,
+            'time' => $time,
+            'success_msg' => sprintf( __( 'Replace completed for the text "%s" which was replaced by "%s". %d tables scanned with %d total rows. Replacement took %f seconds.', $this->text_domain ),
+                $search, $replace, $report[ 'tables' ], $report[ 'rows' ], $report[ 'change' ], $report[ 'updates' ], $time ),
+            'errors_msg' => $errors
+        );
+
+        $response = json_encode( $response );
+        header( "Content-Type: application/json" );
+        echo $response;
+        exit;
+    }
 
 
@@ -224 +378 @@
         }
     }
+
+
+    /**
+     * Take a serialised array and unserialise it replacing elements as needed and
+     * unserialising any subordinate arrays and performing the replace on those too.
+     *
+     * @param string $from       String we're looking to replace.
+     * @param string $to         What we want it to be replaced with
+     * @param array  $data       Used to pass any subordinate arrays back to in.
+     * @param bool   $serialised Does the array passed via $data need serialising.
+     *
+     * @return array    The original array with all elements replaced as needed.
+     */
+    private function recursive_unserialize_replace( $from = '', $to = '', $data = '', $serialised = false ) {
+        // some unseriliased data cannot be re-serialised eg. SimpleXMLElements
+        try {
+
+            if ( is_string( $data ) && ( $unserialized = @unserialize( $data ) ) !== false ) {
+                $data = $this->recursive_unserialize_replace( $from, $to, $unserialized, true );
+            }
+
+            elseif ( is_array( $data ) ) {
+                $_tmp = array( );
+                foreach ( $data as $key => $value ) {
+                    $_tmp[ $key ] = $this->recursive_unserialize_replace( $from, $to, $value, false );
+                }
+
+                $data = $_tmp;
+                unset( $_tmp );
+            }
+
+            else {
+                if ( is_string( $data ) )
+                    $data = str_replace( $from, $to, $data );
+            }
+
+            if ( $serialised )
+                return serialize( $data );
+
+        } catch( Exception $error ) {
+
+        }
+
+        return $data;
+    }
 }
 new uPress_Link();