<?php

/*

Plugin Name: Database Backup for WordPress

Plugin URI: https://github.com/deliciousbrains/wp-db-backup

Description: On-demand backup of your WordPress database. Navigate to <a href="edit.php?page=wp-db-backup">Tools &rarr; Backup</a> to get started.

Author: Delicious Brains

Author URI: https://deliciousbrains.com

Version: 2.5.2

Domain Path: /languages

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License as published by

the Free Software Foundation; either version 2 of the License, or

(at your option) any later version.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License

along with this program; if not, write to the Free Software

Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110, USA

*/

if ( ! defined( 'ABSPATH' ) ) {

	die( 'Please do not load this file directly.' );

}

if ( ! defined( 'DBBWP_ROWS_PER_SEGMENT' ) ) {

	define( 'DBBWP_ROWS_PER_SEGMENT', 100 );

}

/**

 * Set DBBWP_MOD_EVASIVE_OVERRIDE to true

 * and increase DBBWP_MOD_EVASIVE_DELAY

 * if the backup stops prematurely.

 */

// define('DBBWP_MOD_EVASIVE_OVERRIDE', false);

if ( ! defined( 'DBBWP_MOD_EVASIVE_DELAY' ) ) {

	define( 'DBBWP_MOD_EVASIVE_DELAY', '500' );

}

class wpdbBackup {

	var $backup_complete = false;

	var $backup_file     = '';

	var $backup_filename;

	var $core_table_names = array();

	var $errors           = array();

	var $basename;

	var $page_url;

	var $referer_check_key;

	var $version = '2.5.2';

	function module_check() {

		$mod_evasive = false;

		if ( defined( 'DBBWP_MOD_EVASIVE_OVERRIDE' ) && true === DBBWP_MOD_EVASIVE_OVERRIDE ) {

			return true;

		}

		if ( ! defined( 'DBBWP_MOD_EVASIVE_OVERRIDE' ) || false === DBBWP_MOD_EVASIVE_OVERRIDE ) {

			return false;

		}

		if ( function_exists( 'apache_get_modules' ) ) {

			foreach ( (array) apache_get_modules() as $mod ) {

				if ( false !== strpos( $mod, 'mod_evasive' ) || false !== strpos( $mod, 'mod_dosevasive' ) ) {

					return true;

				}

			}

		}

		return false;

	}

	function __construct() {

		global $table_prefix, $wpdb;

		add_action( 'wp_ajax_save_backup_time', array( &$this, 'save_backup_time' ) );

		add_action( 'init', array( &$this, 'init_textdomain' ) );

		add_action( 'init', array( &$this, 'set_page_url' ) );

		add_action( 'admin_notices', array( &$this, 'update_notice' ) );

		add_action( 'wp_db_backup_cron', array( &$this, 'cron_backup' ) );

		add_action( 'wp_cron_daily', array( &$this, 'wp_cron_daily' ) );

		add_filter( 'cron_schedules', array( &$this, 'add_sched_options' ) );

		add_filter( 'wp_db_b_schedule_choices', array( &$this, 'schedule_choices' ) );

		$table_prefix          = ( isset( $table_prefix ) ) ? $table_prefix : $wpdb->prefix;

		$datum                 = date( 'Ymd_B' );

		$this->backup_filename = DB_NAME . "_$table_prefix$datum.sql";

		$possible_names = array(

			'categories',

			'commentmeta',

			'comments',

			'link2cat',

			'linkcategories',

			'links',

			'options',

			'post2cat',

			'postmeta',

			'posts',

			'terms',

			'term_taxonomy',

			'term_relationships',

			'termmeta',

			'users',

			'usermeta',

		);

		foreach ( $possible_names as $name ) {

			if ( isset( $wpdb->{$name} ) ) {

				$this->core_table_names[] = $wpdb->{$name};

			}

		}

		$tmp_dir = get_temp_dir();

		if ( isset( $_GET['wp_db_temp_dir'] ) ) {

			$requested_dir = sanitize_text_field( $_GET['wp_db_temp_dir'] );

			if ( is_writeable( $requested_dir ) ) {

				$tmp_dir = $requested_dir;

			}

		}

		$this->backup_dir = trailingslashit( apply_filters( 'wp_db_b_backup_dir', $tmp_dir ) );

		$this->basename   = 'wp-db-backup';

		$this->referer_check_key = $this->basename . '-download_' . DB_NAME;

		if ( isset( $_POST['do_backup'] ) ) {

			$this->wp_secure( 'fatal' );

			check_admin_referer( $this->referer_check_key );

			$this->can_user_backup( 'main' );

			// save exclude prefs

			update_option(

				'wp_db_backup_excs',

				array(

					'revisions' => $this->get_revisions_to_exclude(),

					'spam'      => $this->get_spam_to_exclude(),

				)

			);

			switch ( $_POST['do_backup'] ) {

				case 'backup':

					add_action( 'init', array( &$this, 'perform_backup' ) );

					break;

				case 'fragments':

					add_action( 'admin_menu', array( &$this, 'admin_menu' ) );

					break;

			}

		} elseif ( isset( $_GET['fragment'] ) ) {

			$this->can_user_backup( 'frame' );

			add_action( 'init', array( &$this, 'init' ) );

		} elseif ( isset( $_GET['backup'] ) ) {

			$this->can_user_backup();

			add_action( 'init', array( &$this, 'init' ) );

		} else {

			add_action( 'admin_menu', array( &$this, 'admin_menu' ) );

		}

	}

	function init() {

		$this->can_user_backup();

		if ( isset( $_GET['backup'] ) ) {

			$via = isset( $_GET['via'] ) ? sanitize_text_field( $_GET['via'] ) : 'http';

			$this->backup_file = sanitize_text_field( $_GET['backup'] );

			$this->validate_file( $this->backup_file );

			switch ( $via ) {

				case 'smtp':

				case 'email':

					$success = $this->deliver_backup( $this->backup_file, 'smtp', sanitize_text_field( $_GET['recipient'] ), 'frame' );

					$this->error_display( 'frame' );

					if ( $success ) {

						echo '

						<!-- ' . $via . ' -->

						<script type="text/javascript"><!--\\

					';

						echo '

						alert("' . __( 'Backup Complete!', 'wp-db-backup' ) . '");

						window.onbeforeunload = null;

						</script>

					';

					}

					break;

				default:

					$success = $this->deliver_backup( $this->backup_file, $via );

					echo $this->error_display( 'frame', false );

					if ( $success ) {

						echo '

					<script type="text/javascript">

						window.parent.setProgress("' . __( 'Backup Complete!', 'wp-db-backup' ) . '");

					</script>

					';

					}

			}

			exit;

		}

		if ( isset( $_GET['fragment'] ) ) {

			list($table, $segment, $filename) = explode( ':', sanitize_text_field( $_GET['fragment'] ) );

			if ( empty( $table ) || in_array( $table, $this->get_tables() ) ) {

				$this->validate_file( $filename );

				$this->backup_fragment( $table, $segment, $filename );

			} else {

				$this->error(

					array(

						'loc'  => 'frame',

						'kind' => 'fatal',

						'msg'  => __(

							'There was an error determining the table to backup. Please check the settings used for the backup and try again.',

							'wp-db-backup'

						),

					)

				);

			}

		}

		die();

	}

	function init_textdomain() {

		load_plugin_textdomain(

			'wp-db-backup',

			false,

			dirname( plugin_basename( __FILE__ ) ) . '/languages'

		);

	}

	function set_page_url() {

		$query_args = array( 'page' => $this->basename );

		if ( function_exists( 'wp_create_nonce' ) ) {

			$query_args = array_merge( $query_args, array( '_wpnonce' => wp_create_nonce( $this->referer_check_key ) ) );

		}

		$base           = ( function_exists( 'site_url' ) ) ? site_url( '', 'admin' ) : get_option( 'siteurl' );

		$this->page_url = add_query_arg( $query_args, $base . '/wp-admin/edit.php' );

	}

	/*

	 * Add a link to back up your database when doing a core upgrade.

	 */

	function update_notice() {

		global $pagenow;

		if ( empty( $pagenow ) || 'update-core.php' !== $pagenow ) {

			return false;

		}

		?>

		<div class="notice notice-warning">

			<p>

				<?php

				printf(

					__( 'Click <a href="%s">here</a> to back up your database using the WordPress Database Backup plugin. <strong>Note:</strong> WordPress Database Backup does <em>not</em> back up your files, just your database.', 'wp-db-backup' ),

					esc_url( get_admin_url( null, 'tools.php?page=wp-db-backup' ) )

				);

				?>

			</p>

		</div>

		<?php

	}

	function build_backup_script() {

		global $table_prefix, $wpdb;

		echo '<fieldset class="options backup-running"><legend>' . __( 'Progress', 'wp-db-backup' ) . '</legend>

		<div class="panel-heading">

			<h3>Backup In Progress...</h3>

		</div>

		<div class="panel-content">

			<div class="progress-bar">

			    <div id="progress-status"></div>

				<div id="meterbox" style="height:11px;width:80%;padding:3px;border:1px solid #659fff;"><div id="meter" style="color:#fff;height:11px;line-height:11px;background-color:#659fff;width:0%;text-align:center;font-size:6pt;"></div></div>

				<div id="progress_message"></div>'?>

			</div>

			<div class="info-notice">

			<img src="<?php echo plugin_dir_url( __FILE__ ) . 'assets/warning.svg'; ?>">

				<p>

					Whilst the backup is in progress, please do not close the browser, reload or change the page, or click the stop or back browser buttons. This would result in the backup failing.

				</p>

			</div>

			<?php echo '<div id="errors"></div>

            <iframe id="backuploader" src="about:blank" style="display:none;border:none;height:1em;width:1px;"></iframe>

			</fieldset>

			<script type="text/javascript">

			//<![CDATA[

			window.onbeforeunload = function() {

				return "' . __( 'Navigating away from this page will cause your backup to fail.', 'wp-db-backup' ) . '";

			}

			function setMeter(pct) {

                var meterStatus = document.getElementById("progress-status");

				var meter = document.getElementById("meter");

				meter.style.width = pct + "%";

				meterStatus.innerHTML = Math.floor(pct) + "%";

			}

			function setProgress(str) {

				var progress = document.getElementById("progress_message");

				progress.innerHTML = str;

			}

			function addError(str) {

				var errors = document.getElementById("errors");

				errors.innerHTML = errors.innerHTML + str + "<br />";

			}

			function backup(table, segment) {

				var fram = document.getElementById("backuploader");

				fram.src = "' . $this->page_url . '&fragment=" + table + ":" + segment + ":' . $this->backup_filename . ':&wp_db_temp_dir=' . $this->backup_dir . '";

			}

			var curStep = 0;

			function nextStep() {

				backupStep(curStep);

				curStep++;

			}

			function finishBackup() {

				var fram = document.getElementById("backuploader");

				setMeter(100);

		';

		$download_uri = add_query_arg( 'backup', $this->backup_filename, $this->page_url );

		switch ( $_POST['deliver'] ) {

			case 'http':

				echo '

				setProgress("' . __( 'Preparing download.', 'wp-db-backup' ) . '");

				window.onbeforeunload = null;

				fram.src = "' . $download_uri . '";

				setTimeout( function() {

					var secondFrame = document.createElement("iframe");

					secondFrame.style.display = "none";

					fram.parentNode.insertBefore(secondFrame, fram);

					secondFrame.src = "' . $download_uri . '&download-retry=1";

				}, 30000 );

			';

				break;

			case 'smtp':

				$email = sanitize_text_field( wp_unslash( $_POST['backup_recipient'] ) );

				if ( get_option( 'wpdb_backup_recip' ) != $email ) {

					update_option( 'wpdb_backup_recip', $email );

				}

				echo '

				setProgress("' . sprintf( __( 'Your backup has been emailed to %s', 'wp-db-backup' ), $email ) . '");

				window.onbeforeunload = null;

				fram.src = "' . $download_uri . '&via=email&recipient=' . $email . '";

			';

				break;

			default:

				echo '

				setProgress("' . __( 'Backup Complete!', 'wp-db-backup' ) . '");

				window.onbeforeunload = null;

			';

		}

		echo '

			}

			function backupStep(step) {

				switch(step) {

				case 0: backup("", 0); break;

		';

		$also_backup = $this->get_post_data_array( 'other_tables' );

		$core_tables = $this->get_post_data_array( 'core_tables' );

		$tables      = array_merge( $core_tables, $also_backup );

		$step_count  = 1;

		foreach ( $tables as $table ) {

			$rec_count    = $wpdb->get_var( "SELECT count(*) FROM {$table}" );

			$rec_segments = ceil( $rec_count / DBBWP_ROWS_PER_SEGMENT );

			$table_count  = 0;

			if ( $this->module_check() ) {

				$delay      = "setTimeout('";

				$delay_time = "', " . (int) DBBWP_MOD_EVASIVE_DELAY . ')';

			} else {

				$delay = $delay_time = ''; }

			do {

				echo "case {$step_count}: {$delay}backup(\"{$table}\", {$table_count}){$delay_time}; break;\n";

				$step_count++;

				$table_count++;

			} while ( $table_count < $rec_segments );

			echo "case {$step_count}: {$delay}backup(\"{$table}\", -1){$delay_time}; break;\n";

			$step_count++;

		}

		echo "case {$step_count}: finishBackup(); break;";

		echo '

				}