<?php

/**

 *  DUPLICATOR_CREATE_DBSCRIPT

 *  Create the SQL DataDump File

 *  @param string $destination		The full path and filname where the sql script will be written

 */

function duplicator_create_dbscript($destination) {

	try {

		global $wpdb;

		//$dbiconv = ($GLOBALS['duplicator_opts']['dbiconv'] == "0" && function_exists("iconv")) ? false : true;

		$handle  = fopen($destination,'w+');

		$tables  = $wpdb->get_col('SHOW TABLES');

		duplicator_log("log:fun__create_dbscript=>started");

		//if ($dbiconv) {

			//duplicator_log("log:fun__create_dbscript=>dbiconv enabled");

		//}

		foreach ($tables as $table) {

			//Generate Drop Statement

			//$sql_del = ($GLOBALS['duplicator_opts']['dbadd_drop']) ? "DROP TABLE IF EXISTS {$table};\n\n" : "";

			//@fwrite($handle, $sql_del);

			//Generate Create Statement

			$row_count  = $wpdb->get_var("SELECT Count(*) FROM `{$table}`");

			duplicator_log("start: {$table} ({$row_count})");	

			$create  = $wpdb->get_row("SHOW CREATE TABLE `{$table}`", ARRAY_N);

			$sql_crt = "{$create[1]};\n\n";

			@fwrite($handle, $sql_crt);

			if ($row_count > 100) {

				$row_count = ceil($row_count / 100);

			} else if ($row_count > 0) {

				$row_count = 1;  

			}

			//PERFORM ICONV ROUTINE

			//Chunck the query results to avoid memory issues

			/*if ($dbiconv) {

				for ($i = 0; $i < $row_count; $i++) {

					$sql   = "";

					$limit = $i * 100;

					$query = "SELECT * FROM `{$table}` LIMIT {$limit}, 100";

					$rows  = $wpdb->get_results($query, ARRAY_A);

					if (is_array($rows)) {

						foreach ($rows as $row) {

							$sql .= "INSERT INTO `{$table}` VALUES(";

							$num_values  = count($row);

							$num_counter = 1;

							foreach ($row as $value) {

								$value = @iconv(DUPLICATOR_DB_ICONV_IN, DUPLICATOR_DB_ICONV_OUT, $value);

								($num_values == $num_counter) 

									? $sql .= '"' . @mysql_real_escape_string($value) . '"'

									: $sql .= '"' . @mysql_real_escape_string($value) . '", ';

								$num_counter++;

							}

							$sql .= ");\n";

						}

						@fwrite($handle, $sql);

						duplicator_fcgi_flush();

					}

				}

			//DO NOT PERFORM ICONV

			} else {*/

				for ($i = 0; $i < $row_count; $i++) {

					$sql   = "";

					$limit = $i * 100;

					$query = "SELECT * FROM `{$table}` LIMIT {$limit}, 100";

					$rows  = $wpdb->get_results($query, ARRAY_A);

					if (is_array($rows)) {

						foreach ($rows as $row) {

							$sql .= "INSERT INTO `{$table}` VALUES(";

							$num_values  = count($row);

							$num_counter = 1;

							foreach ($row as $value) {

								($num_values == $num_counter) 

									? $sql .= '"' . @mysql_real_escape_string($value) . '"'

									: $sql .= '"' . @mysql_real_escape_string($value) . '", ';

								$num_counter++;

							}

							$sql .= ");\n";

						}

						@fwrite($handle, $sql);

						duplicator_fcgi_flush();

					}

				}

			//}

			@fwrite($handle, "\n\n");

			duplicator_log("done:  {$table}");

		}		

		duplicator_log("log:fun__create_dbscript=>sql file written to {$destination}");

		fclose($handle);

		$wpdb->flush();

		duplicator_log("log:fun__create_dbscript=>ended");

	} catch(Exception $e) {

		duplicator_log("log:fun__create_dbscript=>runtime error: " . $e);

	}

}

/**

 *  DUPLICATOR_BUILD_INSTALLERFILE

 *  Builds the Installer file from the contents of the files/installer directory

 */

function duplicator_build_installerFile() {

	duplicator_log("log:fun__build_installerFile=>start");

	$template_path = duplicator_safe_path(DUPLICATOR_PLUGIN_PATH  . 'files/installer.template.php');

	$main_path	   = duplicator_safe_path(DUPLICATOR_PLUGIN_PATH  . 'files/installer/main.installer.php');

	@chmod($template_path, 0777);

	@chmod($main_path, 0777);

	$main_data  = file_get_contents("{$main_path}");

	$template_result = file_put_contents($template_path, $main_data);

	if ($main_data === false || $template_result == false) {

		duplicator_log("log:fun__build_installerFile=>install generation failed to copy {$main_path}");

	}

	$embeded_files = array (

		"inc.utils.php"		    => "@@INC.UTILS.PHP@@", 

		"ajax.step1.php"		=> "@@AJAX.STEP1.PHP@@", 

		"ajax.step2.php"		=> "@@AJAX.STEP2.PHP@@", 

		"inc.style.css"  		=> "@@INC.STYLE.CSS@@",

		"inc.scripts.js"		=> "@@INC.SCRIPTS.JS@@",

		"view.step1.php"		=> "@@VIEW.STEP1.PHP@@",

		"view.step2.php"		=> "@@VIEW.STEP2.PHP@@",

		"view.step3.php"		=> "@@VIEW.STEP3.PHP@@"); 

	foreach ($embeded_files as $name=>$token) { 

		$file_path    = DUPLICATOR_PLUGIN_PATH  . "files/installer/${name}";

		@chmod($file_path, 0777);

		$search_data     = @file_get_contents($template_path);

		$insert_data  	 = @file_get_contents($file_path);

		file_put_contents($template_path, str_replace("${token}", "{$insert_data}", $search_data));

		if ($search_data === false || $insert_data == false) {

			duplicator_log("log:fun__build_installerFile=>install generation failed at {$token}");

		}

		@chmod($file_path, 0644);

	} 

	@chmod($template_path, 0644);

	@chmod($main_path, 0644);

	duplicator_log("log:fun__build_installerFile=>end");

}

/**

 *  DUPLICATOR_CREATE_INSTALLERFILE

 *  Prep the Installer file for use. use %string% token for replacing 

 *  @param string $uniquename	The unique name this installer file will be associated with

 */

function duplicator_create_installerFile($uniquename) {

	duplicator_log("log:fun__create_installerFile=>started");

	global $wpdb;

	$template		 = duplicator_safe_path(DUPLICATOR_PLUGIN_PATH  . 'files/installer.template.php');

	$installerRescue = duplicator_safe_path(DUPLICATOR_PLUGIN_PATH  . 'files/installer.rescue.php');

	$installerCore	 = duplicator_safe_path(DUPLICATOR_SSDIR_PATH)  . "/{$uniquename}_installer.php";

	$err_msg    = "\n!!!WARNING!!! unable to read/write installer\nSee file:{$installerCore} \nPlease check permission and owner on file and parent folder."; 

	get_option('duplicator_options') == ""  ? "" : $duplicator_opts = unserialize(get_option('duplicator_options'));

	$replace_items = Array(

		"fwrite_url_old" 			=> get_option('siteurl'),

		"fwrite_package_name"  	 	=> "{$uniquename}_package.zip",

		"fwrite_secure_name"	 	=> "{$uniquename}",

		"fwrite_url_new" 			=> $duplicator_opts['url_new'],

		"fwrite_dbhost" 			=> $duplicator_opts['dbhost'],

		"fwrite_dbname" 			=> $duplicator_opts['dbname'],

		"fwrite_dbuser" 			=> $duplicator_opts['dbuser'],

		"fwrite_wp_tableprefix" 	=> $wpdb->prefix,

		"fwrite_blogname"			=> get_option('blogname'),

		"fwrite_wproot"			    => DUPLICATOR_WPROOTPATH,

		"fwrite_rescue_flag"		=> "");

	if( file_exists($template) && is_readable($template)) {

		$install_str = duplicator_parse_template($template, $replace_items);

		if (empty($install_str)) {

			die(duplicator_log("log:fun__create_installerFile=>file-empty-read" . $err_msg));

		}

		//RESCUE FILE

		$replace_items["fwrite_rescue_flag"] = '(rescue file)';

		$rescue_str = duplicator_parse_template($template, $replace_items);

		$fp  = fopen($installerRescue, (!file_exists($installerRescue)) ? 'x+' : 'w');	

		@fwrite($fp, $rescue_str, strlen($rescue_str));

		@fclose($fp);

		$rescue_str = null;

		//INSTALLER FILE

		if (!file_exists($installerCore)) {

			$fp2 = fopen($installerCore, 'x+') or die(duplicator_log("log:fun__create_installerFile=>file-open-error-x" . $err_msg));

		} else {

			$fp2 = fopen($installerCore, 'w')  or die(duplicator_log("log:fun__create_installerFile=>file-open-error-w" . $err_msg));

		}

		if (fwrite($fp2, $install_str, strlen($install_str))) {

			duplicator_log("log:fun__create_installerFile=>installer.php updated at: {$installerCore}");

		} else {

			duplicator_log("log:fun__create_installerFile=>file-create-error" . $err_msg);

		}

		@fclose($fp2);

	} 

	else

	{

		die(duplicator_log("log:fun__create_installerFile=>Template missing or unreadable: '$template'"));

	}

	duplicator_log("log:fun__create_installerFile=>ended");

}

/**

 *  DUPLICATOR_PARSE_TEMPLATE

 *  Tokenize a file based on an array key 

 *

 *  @param string $filename		The filename to tokenize

 *  @param array  $data			The array of key value items to tokenize

 */

function duplicator_parse_template($filename, $data) {

    $q = file_get_contents($filename);

    foreach ($data as $key => $value) {

        $q = str_replace('%'.$key.'%', $value, $q);

    }

    return $q;

}

/**

 *  DUPLICATOR_BYTESIZE

 *  Display human readable byte sizes

 *  @param string $size		The size in bytes

 */

function duplicator_bytesize($size) {

    try {

		$units = array('B', 'KB', 'MB', 'GB', 'TB');

		for ($i = 0; $size >= 1024 && $i < 4; $i++) $size /= 1024;

		return round($size, 2).$units[$i];

	} catch (Exception $e) {

		return "n/a";

	}

}

/**

 *  DUPLICATOR_DIRSIZE

 *  Get the directory size recursively, but don't calc the snapshot directory, exclusion diretories

 *  @param string $directory		The directory to calculate

 */

function duplicator_dirInfo($directory) { 

	try {

		$size = 0; 

		$count = 0;

		$folders = 0;

		$flag = false;

		//EXCLUDE: Snapshot directory

		$directory = duplicator_safe_path($directory);

		if( strstr($directory, DUPLICATOR_SSDIR_PATH)) {

			return;

		}

		//EXCLUDE: Directory Exclusions List

		if ($GLOBALS['duplicator_bypass-array'] != null) {

			foreach ($GLOBALS['duplicator_bypass-array'] as $val) {

				if (duplicator_safe_path($val) == $directory) {

					return;

				}

			}

		}

		if ($handle = @opendir($directory)) { 

			while (false !== ($file = @readdir($handle))) { 

				if ($file != '.' && $file != '..') { 

					$nextpath = $directory . '/' . $file; 

					if (is_dir($nextpath)) { 

						$folders++;

						$result = duplicator_dirInfo($nextpath); 

						$size  += $result['size']; 

						$count += $result['count']; 

						$folders += $result['folders']; 

					} 

					else if (is_file($nextpath) && is_readable($nextpath)) { 

						if(!in_array(@pathinfo($nextpath, PATHINFO_EXTENSION), $GLOBALS['duplicator_skip_ext-array'])) {

							$fmod  = @filesize($nextpath);

							if ($fmod === false) {

								$flag = true;

							} else {

								$size +=  @filesize($nextpath);

							}

							$count++;

						}

					} 

				} 

			} 

		} 

		closedir($handle); 

		$total['size']    = $size; 

		$total['count']   = $count; 

		$total['folders'] = $folders; 

		$total['flag']    = $flag; 

		return $total; 

	}  catch(Exception $e) {

		duplicator_log("log:fun__dirInfo=>runtime error: " . $e . "\nNOTE: Try excluding the stat failed to the Duplicators directory exclusion list or change the permissions.");

	}

} 

/**

 *  DUPLICATOR_CREATE_SNAPSHOTPATH

 *  Creates the snapshot directory if it doesn't already exisit

 */

function duplicator_init_snapshotpath() {

	$path_wproot = duplicator_safe_path(DUPLICATOR_WPROOTPATH);

	$path_ssdir  = duplicator_safe_path(DUPLICATOR_SSDIR_PATH);

	$path_plugin = duplicator_safe_path(DUPLICATOR_PLUGIN_PATH);

	//--------------------------------

	//CHMOD DIRECTORY ACCESS

	//wordpress root directory

	@chmod($path_wproot , 0755);

	//snapshot directory

	@mkdir($path_ssdir, 0755);

	@chmod($path_ssdir, 0755);

	//plugins dir/files

	@chmod($path_plugin . 'files', 0755);

	@chmod(duplicator_safe_path($path_plugin . 'files/installer.rescue.php'), 0644);

	//--------------------------------

	//FILE CREATION	

	//SSDIR: Create Index File

	$ssfile = @fopen($path_ssdir .'/index.php', 'w');

	@fwrite($ssfile, '<?php error_reporting(0);  if (stristr(php_sapi_name(), "fcgi")) { $url  =  "http://" . $_SERVER["HTTP_HOST"]; header("Location: {$url}/404.html");} else { header("HTML/1.1 404 Not Found", true, 404);} exit(); ?>');

	@fclose($ssfile);

	//SSDIR: Create token file in snapshot

	$tokenfile = @fopen($path_ssdir .'/dtoken.php', 'w');

	@fwrite($tokenfile, '<?php error_reporting(0);  if (stristr(php_sapi_name(), "fcgi")) { $url  =  "http://" . $_SERVER["HTTP_HOST"]; header("Location: {$url}/404.html");} else { header("HTML/1.1 404 Not Found", true, 404);} exit(); ?>');

	@fclose($tokenfile);

	//SSDIR: Create .htaccess

	$htfile = @fopen($path_ssdir .'/.htaccess', 'w');

	@fwrite($htfile, "Options -Indexes");

	@fclose($htfile);

	//SSDIR: Robots.txt file

	$robotfile = @fopen($path_ssdir .'/robots.txt', 'w');

	@fwrite($robotfile, "User-agent: * \nDisallow: /" . DUPLICATOR_SSDIR_NAME . '/');

	@fclose($robotfile);

	//PLUG DIR: Create token file in plugin

	$tokenfile2 = @fopen($path_plugin .'files/dtoken.php', 'w');

	@fwrite($tokenfile2, '<?php @error_reporting(0); @require_once("../../../../wp-admin/admin.php"); global $wp_query; $wp_query->set_404(); header("HTML/1.1 404 Not Found", true, 404); header("Status: 404 Not Found"); @include(get_template_directory () . "/404.php"); ?>');

	@fclose($tokenfile2);

}

/**

 *  DUPLICATOR_SAFE_PATH

 *  Makes path safe for any OS

 *  Paths should ALWAYS READ be "/"

 *		uni: /home/path/file.xt

 *		win:  D:/home/path/file.txt 

 *  @param string $path		The path to make safe

 */

function duplicator_safe_path($path) {

	return str_replace("\\", "/", $path);

}

/**

 *  DUPLICATOR_FCGI_FLUSH

 *  PHP_SAPI for fcgi requires a data flush of at least 256

 *  bytes every 40 seconds or else it forces a script hault

 */

function duplicator_fcgi_flush() {

	echo(str_repeat(' ',264));

	@flush();

}

/**

 *  DUPLICATOR_SNAPSHOT_URLPATH

 *	returns the snapshot url

 */

function duplicator_snapshot_urlpath() {

	return get_site_url(null, '', is_ssl() ? 'https' : 'http') . '/' . DUPLICATOR_SSDIR_NAME . '/' ;

}

/**

 *  DUPLICATOR_LOG

 *  Centralized logging method

 *  @param string $msg		The message to log

 */

function duplicator_log($msg, $level = 0) {

	$stamp = date('h:i:s');

	@fwrite($GLOBALS['duplicator_package_log_handle'], "{$stamp} {$msg} \n");