Location: PHPKode > scripts > Better WP Security > better-wp-security/inc/backup.php
<?php

if ( ! class_exists( 'bwps_backup' ) ) {

	class bwps_backup extends bit51_bwps {
		
		/**
		 * Schedules database backups
		 *
		 **/
		function __construct() {
		
			global $bwpsoptions;
			
			if ( $bwpsoptions['backup_enabled'] == 1 ) {
			
				$nextbackup = $bwpsoptions['backup_next']; //get next schedule
				$lastbackup = $bwpsoptions['backup_last']; //get last backup
			
				switch ( $bwpsoptions['backup_interval'] ) { //schedule backup at appropriate time
					case '0':
						$next = 60 * 60 * $bwpsoptions['backup_time'];
						break;
					case '1':
						$next = 60 * 60 * 24 * $bwpsoptions['backup_time'];
						break;
					case '2':
						$next = 60 * 60 * 24 * 7  * $bwpsoptions['backup_time'];
						break;
				}
			
				if ( $lastbackup == '' || $nextbackup < current_time( 'timestamp' ) ) {
			
					$bwpsoptions['backup_last'] = current_time( 'timestamp' );
							
					$bwpsoptions['backup_next'] = ( current_time( 'timestamp' ) + $next );
					
					//Get the options
					if ( is_multisite() ) {
							
						switch_to_blog( 1 );
							
						update_option( $this->primarysettings, $bwpsoptions );
							
						restore_current_blog();
							
					} else {
							
						update_option( $this->primarysettings, $bwpsoptions );
								
					}

					$this->execute_backup(); //execute backup
			
				}
			
			}
						
		}
		
		/**
		 * Executes database backup
		 *
		 */
		function execute_backup() {
			global $wpdb, $bwpsoptions;
				
			@ini_set( 'auto_detect_line_endings', true );
				
			//get all of the tables
			$tables = $wpdb->get_results( 'SHOW TABLES', ARRAY_N );
				
			$return = '';
				
			//cycle through each table
			foreach($tables as $table) {
				
				$result = $wpdb->get_results( 'SELECT * FROM `' . $table[0] . '`;', ARRAY_N );
				$num_fields = sizeof( $wpdb->get_results( 'DESCRIBE `' . $table[0] . '`;' ) );
					
				$return.= 'DROP TABLE IF EXISTS `' . $table[0] . '`;';
				$row2 = $wpdb->get_row( 'SHOW CREATE TABLE `' . $table[0] . '`;', ARRAY_N );
				$return.= PHP_EOL . PHP_EOL . $row2[1] . ";" . PHP_EOL . PHP_EOL;
					
				foreach( $result as $row ) {
						
					$return .= 'INSERT INTO `' . $table[0] . '` VALUES(';
							
					for( $j=0; $j < $num_fields; $j++ ) {
							
						$row[$j] = addslashes( $row[$j] );
						$row[$j] = preg_replace( '#' . PHP_EOL . '#', "\n", $row[$j] );
								
						if ( isset( $row[$j] ) ) { 
							$return .= '"' . $row[$j] . '"' ; 
						} else { 
							$return.= '""'; 
						}
								
						if ( $j < ( $num_fields - 1 ) ) { 
							$return .= ','; 
						}
								
					}
							
					$return .= ");" . PHP_EOL;
							
				}
						
				$return .= PHP_EOL . PHP_EOL;
						
			}
					
			$return .= PHP_EOL . PHP_EOL;
				
			//save file
			$file = 'database-backup-' . current_time( 'timestamp' );
			$handle = @fopen( BWPS_PP . 'backups/' . $file . '.sql', 'w+' );
			@fwrite( $handle, $return );
			@fclose( $handle );
		
			//zip the file
			if ( class_exists( 'ZipArchive' ) ) {
				
				$zip = new ZipArchive();
				$archive = $zip->open(BWPS_PP . 'backups/' . $file . '.zip', ZipArchive::CREATE);
				$zip->addFile(BWPS_PP . 'backups/' . $file . '.sql', $file . '.sql' );
				$zip->close();
			
				//delete .sql and keep zip
				@unlink( BWPS_PP . 'backups/' . $file . '.sql' );
				$fileext = '.zip';
				
			} else {
			
				$fileext = '.sql';
					
			}
				
			if ( $bwpsoptions['backup_email'] == 1 ) {
			
				//Get the right email address.
				if ( is_email( $bwpsoptions['backup_emailaddress'] ) ) {
				
					$toaddress = $bwpsoptions['backup_emailaddress'];
			
				} else {
			
					$toaddress = get_site_option( 'admin_email' );
				
				}
				
				$to = $toaddress;
				$headers = 'From: ' . get_option( 'blogname' ) . ' <' . $to . '>' . PHP_EOL;
				$subject = __( 'Site Database Backup', $this->hook ) . ' ' . date( 'l, F jS, Y \a\\t g:i a', current_time( 'timestamp' ) );
				$attachment = array( BWPS_PP . 'backups/' . $file . $fileext );
				$message = __( 'Attached is the backup file for the database powering', $this->hook ) . ' ' . get_option( 'siteurl' ) . __( ' taken', $this->hook ) . ' ' . date( 'l, F jS, Y \a\\t g:i a', current_time( 'timestamp' ) );
				
				wp_mail( $to, $subject, $message, $headers, $attachment );
					
				$files = scandir( BWPS_PP . 'backups/', 1 );
					
				foreach ( $files as $file ) {
					if ( strstr( $file, 'database-backup' ) ) {
						@unlink( BWPS_PP . 'backups/' . $file );
					}
				}
			
			}
				
			//delete extra files
			if ( $bwpsoptions['backups_to_retain'] != 0 ) {
				$files = scandir( BWPS_PP . 'backups/', 1 );
				
				$count = 0;
				
				foreach ( $files as $file ) {
					if ( strstr( $file, 'database-backup' ) ) {
						if ( $count >= $bwpsoptions['backups_to_retain'] ) {
							@unlink( BWPS_PP . 'backups/' . $file );
						}
						$count++;
					}
						
				}
				
			}
				
		}
	
	}

}
Return current item: Better WP Security