Changeset 3517 for trunk/wp-content/plugins/wp-db-backup.php

Timestamp:

02/12/2006 07:53:23 AM (19 years ago)

Author:

ryan

Message:

Death to trailing tabs. Props Mark J. fixes #2405

File:

• trunk/wp-content/plugins/wp-db-backup.php (modified) (52 diffs)

trunk/wp-content/plugins/wp-db-backup.php

@@ -37 +37 @@
 
     function wpdbBackup() {
-                
+
         add_action('wp_cron_daily', array(&$this, 'wp_cron_daily'));
 
         $this->backup_dir = trailingslashit($this->backup_dir);
         $this->basename = preg_replace('/^.*wp-content[\\\\\/]plugins[\\\\\/]/', '', __FILE__);
-    
+
         if (isset($_POST['do_backup'])) {
             switch($_POST['do_backup']) {
@@ -50 +50 @@
             case 'fragments':
                 add_action('admin_menu', array(&$this, 'fragment_menu'));
-                break;              
+                break;
             }
         } elseif (isset($_GET['fragment'] )) {
@@ -60 +60 @@
         }
     }
-    
+
     function init() {
         global $user_level;
@@ -69 +69 @@
         if (isset($_GET['backup'])) {
             $via = isset($_GET['via']) ? $_GET['via'] : 'http';
-            
+
             $this->backup_file = $_GET['backup'];
-            
+
             switch($via) {
             case 'smtp':
@@ -102 +102 @@
         die();
     }
-    
+
     function build_backup_script() {
         global $table_prefix, $wpdb;
-    
+
         $datum = date("Ymd_B");
         $backup_filename = DB_NAME . "_$table_prefix$datum.sql";
         if ($this->gzip()) $backup_filename .= '.gz';
-        
+
         echo "<div class='wrap'>";
         //echo "<pre>" . print_r($_POST, 1) . "</pre>";
@@ -144 +144 @@
 
             function backup(table, segment) {
-                var fram = document.getElementById("backuploader");             
+                var fram = document.getElementById("backuploader");
                 fram.src = "' . $_SERVER['REQUEST_URI'] . '&fragment=" + table + ":" + segment + ":' . $backup_filename . '";
             }
-            
+
             var curStep = 0;
-            
+
             function nextStep() {
                 backupStep(curStep);
                 curStep++;
             }
-            
+
             function finishBackup() {
-                var fram = document.getElementById("backuploader");             
+                var fram = document.getElementById("backuploader");
                 setMeter(100);
         ';
@@ -180 +180 @@
             ';
         }
-        
+
         echo '
             }
-            
+
             function backupStep(step) {
                 switch(step) {
                 case 0: backup("", 0); break;
         ';
-        
+
         $also_backup = array();
         if (isset($_POST['other_tables'])) {
@@ -211 +211 @@
         }
         echo "case {$step_count}: finishBackup(); break;";
-        
+
         echo '
                 }
@@ -225 +225 @@
     function backup_fragment($table, $segment, $filename) {
         global $table_prefix, $wpdb;
-            
+
         echo "$table:$segment:$filename";
-        
+
         if($table == '') {
             $msg = __('Creating backup file...');
@@ -237 +237 @@
             }
         }
-        
+
         echo '<script type="text/javascript"><!--//
         var msg = "' . $msg . '";
         window.parent.setProgress(msg);
         ';
-            
+
         if (is_writable(ABSPATH . $this->backup_dir)) {
             $this->fp = $this->open(ABSPATH . $this->backup_dir . $filename, 'a');
@@ -250 +250 @@
             }
             else {
-                if($table == '') {      
+                if($table == '') {
                     //Begin new backup of MySql
                     $this->stow("# WordPress MySQL database backup\n");
@@ -267 +267 @@
                         $this->stow("# Table: " . $this->backquote($table) . "\n");
                         $this->stow("# --------------------------------------------------------\n");
-                    }           
+                    }
                     $this->backup_table($table, $segment);
                 }
@@ -277 +277 @@
 
         if($this->fp) $this->close($this->fp);
-        
+
         if($this->backup_errors) {
             foreach($this->backup_errors as $error) {
@@ -295 +295 @@
             ';
         }
-        
+
         die();
     }
@@ -305 +305 @@
             $also_backup = $_POST['other_tables'];
         }
-        
+
         $core_tables = $_POST['core_tables'];
         $this->backup_file = $this->db_backup($core_tables, $also_backup);
@@ -319 +319 @@
         }
     }
-    
+
     ///////////////////////////////
     function admin_menu() {
@@ -388 +388 @@
         }
     }
-    
+
     //////////////
     function stow($query_line) {
@@ -403 +403 @@
         }
     }
-    
+
     function backup_error($err) {
         if(count($this->backup_errors) < 20) {
@@ -411 +411 @@
         }
     }
-    
+
     /////////////////////////////
     function backup_table($table, $segment = 'none') {
         global $wpdb;
-        
+
         /*
         Taken partially from phpMyAdmin and partially from
         Alain Wolf, Zurich - Switzerland
         Website: http://restkultur.ch/personal/wolf/scripts/db_backup/
-        
+
         Modified by Scott Merril (http://www.skippy.net/) 
         to use the WordPress $wpdb object
@@ -430 +430 @@
             return FALSE;
         }
-    
+
         if(($segment == 'none') || ($segment == 0)) {
             //
@@ -440 +440 @@
             $this->stow("\n");
             $this->stow("DROP TABLE IF EXISTS " . $this->backquote($table) . ";\n");
-            
+
             // 
             //Table structure
@@ -449 +449 @@
             $this->stow("#\n");
             $this->stow("\n");
-            
+
             $create_table = $wpdb->get_results("SHOW CREATE TABLE $table", ARRAY_N);
             if (FALSE === $create_table) {
@@ -456 +456 @@
             }
             $this->stow($create_table[0][1] . ' ;');
-            
+
             if (FALSE === $table_structure) {
                 $this->backup_error(sprintf(__("Error getting table structure of %s"), $table));
                 $this->stow("#\n# Error getting table structure of $table!\n#\n");
             }
-        
+
             //
             // Comment in SQL-file
@@ -469 +469 @@
             $this->stow("#\n");
         }
-        
+
         if(($segment == 'none') || ($segment >= 0)) {
             $ints = array();
@@ -482 +482 @@
                 }
             }
-            
-            
+
+
             // Batch by $row_inc
-            
+
             if($segment == 'none') {
                 $row_start = 0;
@@ -493 +493 @@
                 $row_inc = ROWS_PER_SEGMENT;
             }
-            
-            do {    
+
+            do {
                 if ( !ini_get('safe_mode')) @set_time_limit(15*60);
                 $table_data = $wpdb->get_results("SELECT * FROM $table LIMIT {$row_start}, {$row_inc}", ARRAY_A);
@@ -504 +504 @@
                 }
                 */
-                    
-                $entries = 'INSERT INTO ' . $this->backquote($table) . ' VALUES ('; 
+
+                $entries = 'INSERT INTO ' . $this->backquote($table) . ' VALUES (';
                 //    \x08\\x09, not required
                 $search = array("\x00", "\x0a", "\x0d", "\x1a");
@@ -525 +525 @@
             } while((count($table_data) > 0) and ($segment=='none'));
         }
-        
-        
+
+
         if(($segment == 'none') || ($segment < 0)) {
             // Create footer/closing comment in SQL-file
@@ -535 +535 @@
             $this->stow("\n");
         }
-        
+
     } // end backup_table()
-    
+
     function return_bytes($val) {
        $val = trim($val);
@@ -550 +550 @@
                $val *= 1024;
        }
-    
+
        return $val;
     }
-    
+
     ////////////////////////////
     function db_backup($core_tables, $other_tables) {
         global $table_prefix, $wpdb;
-        
+
         $datum = date("Ymd_B");
         $wp_backup_filename = DB_NAME . "_$table_prefix$datum.sql";
@@ -563 +563 @@
                 $wp_backup_filename .= '.gz';
             }
-        
+
         if (is_writable(ABSPATH . $this->backup_dir)) {
             $this->fp = $this->open(ABSPATH . $this->backup_dir . $wp_backup_filename);
@@ -574 +574 @@
             return false;
         }
-        
+
         //Begin new backup of MySql
         $this->stow("# WordPress MySQL database backup\n");
@@ -582 +582 @@
         $this->stow("# Database: " . $this->backquote(DB_NAME) . "\n");
         $this->stow("# --------------------------------------------------------\n");
-        
+
             if ( (is_array($other_tables)) && (count($other_tables) > 0) )
             $tables = array_merge($core_tables, $other_tables);
         else
             $tables = $core_tables;
-        
+
         foreach ($tables as $table) {
             // Increase script execution time-limit to 15 min for every table.
@@ -597 +597 @@
             $this->backup_table($table);
         }
-                
+
         $this->close($this->fp);
-        
+
         if (count($this->backup_errors)) {
             return false;
@@ -605 +605 @@
             return $wp_backup_filename;
         }
-        
+
     } //wp_db_backup
-    
+
     ///////////////////////////
     function deliver_backup ($filename = '', $delivery = 'http', $recipient = '') {
         if ('' == $filename) { return FALSE; }
-        
+
         $diskfile = ABSPATH . $this->backup_dir . $filename;
         if ('http' == $delivery) {
@@ -641 +641 @@
             $headers .= "Content-Type: multipart/mixed; boundary=\"$boundary\"\n";
             $headers .= 'From: ' . get_settings('admin_email') . "\n";
-        
+
             $message = sprintf(__("Attached to this email is\n   %1s\n   Size:%2s kilobytes\n"), $filename, round(filesize($diskfile)/1024));
             // Add a multipart boundary above the plain message
@@ -649 +649 @@
                 "Content-Transfer-Encoding: 7bit\n\n" .
                 $message . "\n\n";
-            
+
             // Add file attachment to the message
             $message .= "--{$boundary}\n" .
@@ -659 +659 @@
                 $data . "\n\n" .
                 "--{$boundary}--\n";
-            
+
             if (function_exists('wp_mail')) {
                 wp_mail ($recipient, get_bloginfo('name') . ' ' . __('Database Backup'), $message, $headers);
@@ -665 +665 @@
                 mail ($recipient, get_bloginfo('name') . ' ' . __('Database Backup'), $message, $headers);
             }
-            
+
             unlink($diskfile);
         }
         return;
     }
-    
+
     ////////////////////////////
     function backup_menu() {
@@ -676 +676 @@
         $feedback = '';
         $WHOOPS = FALSE;
-        
+
         // did we just do a backup?  If so, let's report the status
         if ( $this->backup_complete ) {
@@ -699 +699 @@
             $feedback .= '</p></div>';
         }
-        
+
         if (count($this->backup_errors)) {
             $feedback .= '<div class="updated error">' . __('The following errors were reported:') . "<pre>";
@@ -707 +707 @@
             $feedback .= "</pre></div>";
         }
-        
+
         // did we just save options for wp-cron?
         if ( (function_exists('wp_cron_init')) && isset($_POST['wp_cron_backup_options']) ) {
@@ -717 +717 @@
             $feedback .= '<div class="updated"><p>' . __('Scheduled Backup Options Saved!') . '</p></div>';
         }
-        
+
         // Simple table name storage
         $wp_table_names = explode(',','categories,comments,linkcategories,links,options,post2cat,postmeta,posts,users,usermeta');
         // Apply WP DB prefix to table names
         $wp_table_names = array_map(create_function('$a', 'global $table_prefix;return "{$table_prefix}{$a}";'), $wp_table_names);
-        
+
         $other_tables = array();
         $also_backup = array();
-    
-        // Get complete db table list   
+
+        // Get complete db table list
         $all_tables = $wpdb->get_results("SHOW TABLES", ARRAY_N);
         $all_tables = array_map(create_function('$a', 'return $a[0];'), $all_tables);
@@ -733 +733 @@
         // Get list of non-WP tables
         $other_tables = array_diff($all_tables, $wp_backup_default_tables);
-        
+
         if ('' != $feedback) {
             echo $feedback;
@@ -750 +750 @@
             }
         }
-        
+
         if ( !is_writable( ABSPATH . $this->backup_dir) ) {
             echo '<div class="updated error"><p align="center">' . __('WARNING: Your backup directory is <strong>NOT</strong> writable! We can not create the backup directory.') . '<br />' . ABSPATH . "</p></div>";
@@ -782 +782 @@
         echo '<div><input type="radio" name="deliver" id="do_email" value="smtp" /> ';
         echo '<label for="do_email">'.__('Email backup to:').'</label><input type="text" name="backup_recipient" size="20" value="' . get_settings('admin_email') . '" />';
-        
+
         // Check DB dize.
         $table_status = $wpdb->get_results("SHOW TABLE STATUS FROM " . $this->backquote(DB_NAME));
@@ -789 +789 @@
             $table_size = $table->Data_length - $table->Data_free;
             if(in_array($table->Name, $wp_backup_default_tables)) {
-                $core_size += $table_size;  
+                $core_size += $table_size;
             }
             $db_size += $table_size;
@@ -796 +796 @@
         $mem_limit = $this->return_bytes($mem_limit);
         $mem_limit = ($mem_limit == 0) ? 8*1024*1024 :  $mem_limit - 2000000;
-        
+
         if (! $WHOOPS) {
             echo '<input type="hidden" name="do_backup" id="do_backup" value="backup" /></div>';
@@ -805 +805 @@
         echo '</fieldset>';
         echo '</form>';
-        
+
         // this stuff only displays if wp_cron is installed
         if (function_exists('wp_cron_init')) {
@@ -851 +851 @@
         }
         // end of wp_cron section
-        
+
         echo '</div>';
-        
+
     }// end wp_backup_menu()
-    
+
     /////////////////////////////
     function wp_cron_daily() {
-        
+
         $schedule = intval(get_option('wp_cron_backup_schedule'));
         if (0 == $schedule) {
@@ -864 +864 @@
                 return;
         }
-        
+
         global $table_prefix, $wpdb;
 
@@ -873 +873 @@
         $core_tables = array_intersect($all_tables, $wp_table_names);
         $other_tables = get_option('wp_cron_backup_tables');
-        
+
         $recipient = get_option('wp_cron_backup_recipient');
-        
+
         $backup_file = $this->db_backup($core_tables, $other_tables);
         if (FALSE !== $backup_file) {
             $this->deliver_backup ($backup_file, 'smtp', $recipient);
         }
-        
+
         return;
     } // wp_cron_db_backup