PageRenderTime 85ms CodeModel.GetById 26ms RepoModel.GetById 0ms app.codeStats 3ms

/wp-snapshots/511a4b30d372c5933_20130212_wastark_installer.php

https://bitbucket.org/nathancorbier/wastark.com
PHP | 3222 lines | 2522 code | 365 blank | 335 comment | 258 complexity | 022e0d5132ab95cfeae8e25c4fddf91e MD5 | raw file
Possible License(s): BSD-3-Clause

Large files files are truncated, but you can click here to view the full file

    

  1. <?php

    2. 

  2. /*

    3. 

  3. 	Copyright 2011-12 Cory Lamle  lifeinthegrid.com 

    4. 

  4. 		

    5. 

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

    6. 

  6.     it under the terms of the GNU General Public License, version 2, as 

    7. 

  7.     published by the Free Software Foundation.

    8. 

  8. 

    9. 

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

    10. 

  10.     but WITHOUT ANY WARRANTY; without even the implied warranty of

    11. 

  11.     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    12. 

  12.     GNU General Public License for more details.

    13. 

  13. 

    14. 

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

    15. 

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

    16. 

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

    17. 

  17. 	

    18. 

  18. 	SOURCE CONTRIBUTORS:

    19. 

  19. 	Gaurav Aggarwal

    20. 

  20. 	David Coveney of Interconnect IT Ltd 

    21. 

  21. 	https://github.com/interconnectit/Search-Replace-DB/

    22. 

  22. */

    23. 

  23. 

    24. 

  24. //DOWNLOAD ONLY: 

    25. 

  25. if ( isset($_GET['get']) && file_exists($_GET['file'])) {

    26. 

  26. 	if (strstr($_GET['file'], '_installer.php')	|| strstr($_GET['file'], 'installer.rescue.php')) {

    27. 

  27. 		header('Content-Description: File Transfer');

    28. 

  28. 		header('Content-Type: application/octet-stream');

    29. 

  29. 		header('Content-Disposition: attachment; filename=installer.php');

    30. 

  30. 		header('Content-Transfer-Encoding: binary');

    31. 

  31. 		header('Expires: 0');

    32. 

  32. 		header('Cache-Control: must-revalidate, post-check=0, pre-check=0');

    33. 

  33. 		header('Pragma: public');

    34. 

  34. 		header('Content-Length: ' . filesize($_GET['file']));

    35. 

  35. 		@ob_clean();

    36. 

  36. 		@flush();

    37. 

  37. 		if (@readfile($_GET['file']) == false) {

    38. 

  38. 			$data = file_get_contents($_GET['file']);

    39. 

  39. 			if ($data == false) {

    40. 

  40. 				die("Unable to read installer file.  The server currently has readfile and file_get_contents disabled on this server.  Please contact your server admin to remove this restriction");

    41. 

  41. 			} else {

    42. 

  42. 				print $data;

    43. 

  43. 			}

    44. 

  44. 		}

    45. 

  45. 		exit;

    46. 

  46. 	} else {

    47. 

  47. 		header("HTML/1.1 404 Not Found", true, 404); 

    48. 

  48. 		header("Status: 404 Not Found"); 

    49. 

  49. 	}

    50. 

  50. } 

    51. 

  51. 

    52. 

  52. //Prevent Access from rovers or direct browsing in snapshop directory

    53. 

  53. if (file_exists('dtoken.php')) {

    54. 

  54. 	exit;

    55. 

  55. }

    56. 

  56. ?>

    57. 

  57. 

    58. 

  58. <?php if ( false ) :?>

    59. 

  59. <!DOCTYPE html>

    60. 

  60. <html>

    61. 

  61. <head>

    62. 

  62. 	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

    63. 

  63. 	<title>Error: PHP is not running</title>

    64. 

  64. </head>

    65. 

  65. <body>

    66. 

  66. 	<h2>Error: PHP is not running</h2>

    67. 

  67. 	<p>Duplicator requires that your web server is running PHP. Your server does not have PHP installed, or PHP is turned off.</p>

    68. 

  68. </body>

    69. 

  69. </html>

    70. 

  70. <?php endif; ?> 

    71. 

  71. 

    72. 

  72. 

    73. 

  73. <?php

    74. 

  74. /* ==============================================================================================

    75. 

  75. 	ADVANCED FEATURES - Allows admins to perform aditional logic on the import. 

    76. 

  76. 	

    77. 

  77. 	$GLOBALS['TABLES_SKIP_COLS']

    78. 

  78. 		Add Known column names of tables you don't want the search and replace logic to run on.

    79. 

  79. 	$GLOBALS['REPLACE_LIST'] 

    80. 

  80. 		Add additional search and replace items add list here 

    81. 

  81. 		Example: array(array('search'=> '/html/oldpath/images',  'replace'=> '/html/newpath/images'));		

    82. 

  82. ================================================================================================= */

    83. 

  83. 

    84. 

  84. $GLOBALS['FW_TABLEPREFIX'] 	= 'wp_';

    85. 

  85. $GLOBALS['FW_URL_OLD'] 		= 'http://wastark.com';

    86. 

  86. $GLOBALS['FW_URL_NEW'] 		= '';

    87. 

  87. $GLOBALS['FW_PACKAGE_NAME'] = '511a4b30d372c5933_20130212_wastark_package.zip';

    88. 

  88. $GLOBALS['FW_SECURE_NAME'] 	= '511a4b30d372c5933_20130212_wastark';

    89. 

  89. $GLOBALS['FW_DBHOST'] 		= 'localhost';

    90. 

  90. $GLOBALS['FW_DBNAME'] 		= '';

    91. 

  91. $GLOBALS['FW_DBUSER'] 		= '';

    92. 

  92. $GLOBALS['FW_BLOGNAME'] 	= 'W. A. Stark';

    93. 

  93. $GLOBALS['FW_RESCUE_FLAG'] 	= '';

    94. 

  94. $GLOBALS['FW_WPROOT'] 		= '/home/starehcf/public_html/wastark.com/';

    95. 

  95. 

    96. 

  96. //DATABASE SETUP: all time in seconds	

    97. 

  97. $GLOBALS['DB_MAX_TIME']    = 5000;

    98. 

  98. $GLOBALS['DB_MAX_PACKETS'] = 268435456;

    99. 

  99. ini_set('mysql.connect_timeout', '5000');

    100. 

  100. 

    101. 

  101. //PHP SETUP: all time in seconds

    102. 

  102. ini_set('memory_limit',		  '5000M');

    103. 

  103. ini_set("max_execution_time", '5000'); 

    104. 

  104. ini_set("max_input_time",	  '5000');

    105. 

  105. ini_set('default_socket_timeout', '5000');

    106. 

  106. @set_time_limit(0);

    107. 

  107. 

    108. 

  108. $GLOBALS['DBCHARSET_DEFAULT'] = 'utf8';

    109. 

  109. $GLOBALS['DBCOLLATE_DEFAULT'] = 'utf8_general_ci';

    110. 

  110. 

    111. 

  111. //UPDATE TABLE SETTINGS

    112. 

  112. $GLOBALS['TABLES_SKIP_COLS'] = array('');

    113. 

  113. $GLOBALS['REPLACE_LIST'] =  array();

    114. 

  114. 

    115. 

  115. 

    116. 

  116. /* ================================================================================================

    117. 

  117. END ADVANCED FEATURES: Do not edit below here.

    118. 

  118. =================================================================================================== */

    119. 

  119. 

    120. 

  120. //CONSTANTS

    121. 

  121. define("DUPLICATOR_SSDIR_NAME", 	'wp-snapshots');  //This should match DUPLICATOR_SSDIR_NAME in duplicator.php

    122. 

  122. 

    123. 

  123. //GLOBALS

    124. 

  124. $GLOBALS['DUPLICATOR_INSTALLER_VERSION'] =  '0.4.2';

    125. 

  125. $GLOBALS["SQL_FILE_NAME"] 	= "installer-data.sql";

    126. 

  126. $GLOBALS["LOG_FILE_NAME"] 	= "installer-log.txt";

    127. 

  127. $GLOBALS['SEPERATOR1']		= str_repeat("********", 10);

    128. 

  128. $GLOBALS['LOGGING']			= isset($_POST['logging']) ? $_POST['logging'] : 1;

    129. 

  129. 

    130. 

  130. $GLOBALS['CURRENT_ROOT_PATH']	= dirname(__FILE__);

    131. 

  131. $GLOBALS['CHOWN_ROOT_PATH']	 	= @chmod("{$GLOBALS['CURRENT_ROOT_PATH']}", 0755);

    132. 

  132. $GLOBALS['CHOWN_LOG_PATH']  	= @chmod("{$GLOBALS['CURRENT_ROOT_PATH']}/{$GLOBALS['LOG_FILE_NAME']}", 0644);

    133. 

  133. $GLOBALS['URL_SSL']				= (isset($_SERVER["HTTPS"]) && $_SERVER["HTTPS"] == 'on') ? true : false;

    134. 

  134. $GLOBALS['URL_PATH']			= ($GLOBALS['URL_SSL']) 

    135. 

  135. 									? "https://{$_SERVER['SERVER_NAME']}{$_SERVER['REQUEST_URI']}" 

    136. 

  136. 									: "http://{$_SERVER['SERVER_NAME']}{$_SERVER['REQUEST_URI']}";	

    137. 

  137. 

    138. 

  138. //SHARED POST PARMS

    139. 

  139. $_POST['action_step']	= isset($_POST['action_step']) 	? $_POST['action_step'] 		: "0";

    140. 

  140. $_POST['dbhost']		= isset($_POST['dbhost'])	 	? trim($_POST['dbhost'])	 	: null;

    141. 

  141. $_POST['dbuser']		= isset($_POST['dbuser'])	 	? trim($_POST['dbuser'])	 	: null;

    142. 

  142. $_POST['dbpass']  		= isset($_POST['dbpass'])		? trim($_POST['dbpass'])		: null;

    143. 

  143. $_POST['dbname']		= isset($_POST['dbname'])	 	? trim($_POST['dbname'])	 	: null;

    144. 

  144. $_POST['dbcharset']		= isset($_POST['dbcharset'])	? trim($_POST['dbcharset'])	: $GLOBALS['DBCHARSET_DEFAULT'];

    145. 

  145. $_POST['dbcollate']		= isset($_POST['dbcollate'])	? trim($_POST['dbcollate'])	: $GLOBALS['DBCOLLATE_DEFAULT'];

    146. 

  146. 

    147. 

  147. 

    148. 

  148. //Restart log if user starts from step 1

    149. 

  149. if ($_POST['action_step'] == 1) {

    150. 

  150. 	$GLOBALS['LOG_FILE_HANDLE']		= @fopen($GLOBALS['LOG_FILE_NAME'], "w+");

    151. 

  151. } else {

    152. 

  152. 	$GLOBALS['LOG_FILE_HANDLE']		= @fopen($GLOBALS['LOG_FILE_NAME'], "a+");

    153. 

  153. }

    154. 

  154. 

    155. 

  155. ?>

    156. 

  156. 

    157. 

  157. <?php

    158. 

  158. 

    159. 

  159. /** ******************************************************

    160. 

  160.  *  CLASS::DupUtil

    161. 

  161.  *  Various Static Utility methods for working with the installer */

    162. 

  162. class DupUtil {

    163. 

  163. 

    164. 

  164. 	/** METHOD: LOG

    165. 

  165. 	 *  Used to write debug info to the output page

    166. 

  166. 	 *  @param string $msg		A a message that belongs to a unique title block

    167. 

  167. 	 *  @param int $loglevel	Log level

    168. 

  168. 	 *  @param bool $newline	Insert a newline 

    169. 

  169. 	 */

    170. 

  170. 	static public function log ($msg, $logging = 1) {

    171. 

  171. 		if ($logging <= $GLOBALS["LOGGING"] ) {

    172. 

  172. 			@fwrite($GLOBALS["LOG_FILE_HANDLE"], "{$msg}\n");

    173. 

  173. 		}

    174. 

  174. 	}

    175. 

  175. 

    176. 

  176. 	/** METHOD: GET_MICROTIME

    177. 

  177. 	* Get current microtime as a float. Can be used for simple profiling.

    178. 

  178. 	*/

    179. 

  179. 	static public function get_microtime() {

    180. 

  180. 		return microtime(true);

    181. 

  181. 	}

    182. 

  182. 

    183. 

  183.    /** METHOD: ELAPSED_TIME

    184. 

  184.     * Return a string with the elapsed time.

    185. 

  185.     * Order of $end and $start can be switched. 

    186. 

  186. 	*/

    187. 

  187.    static public function elapsed_time($end, $start) {

    188. 

  188. 		return sprintf("%.4f sec.", abs($end - $start));

    189. 

  189.    }

    190. 

  190.    

    191. 

  191.    /** METHOD: ESC_HTML_ATTR

    192. 

  192. 	* @param string $string Thing that needs escaping

    193. 

  193. 	* @param bool $echo   Do we echo or return?

    194. 

  194. 	* @return string    Escaped string. 

    195. 

  195. 	*/

    196. 

  196. 	static public function esc_html_attr( $string = '', $echo = false ) {

    197. 

  197. 		$output = htmlentities( $string, ENT_QUOTES, 'UTF-8' );

    198. 

  198. 		if ( $echo )

    199. 

  199. 			echo $output;

    200. 

  200. 		else

    201. 

  201. 			return $output;

    202. 

  202. 	}

    203. 

  203.    

    204. 

  204. 	/** METHOD: TABLE_COUNT

    205. 

  205. 	 *  Count the tables in a given database

    206. 

  206. 	 *  @param string $_POST['dbname']		Database to count tables in 

    207. 

  207. 	 */

    208. 

  208. 	static public function dbtable_count($conn, $dbname) {

    209. 

  209. 		$res = mysqli_query($conn, "SELECT COUNT(*) AS count FROM information_schema.tables WHERE table_schema = '{$dbname}' ");

    210. 

  210. 		$row = mysqli_fetch_row($res);

    211. 

  211. 		return is_null($row) ? 0 : $row[0];

    212. 

  212. 	}

    213. 

  213. 	

    214. 

  214. 	/** METHOD: TABLE_ROW_COUNT

    215. 

  215. 	 *  Returns the table count

    216. 

  216. 	 *  @param string $conn	        A valid link resource

    217. 

  217. 	 *  @param string $table_name	A valid table name

    218. 

  218. 	 */

    219. 

  219. 	static public function table_row_count($conn, $table_name) { 

    220. 

  220. 		$total = mysqli_query($conn, "SELECT COUNT(*) FROM `$table_name`"); 

    221. 

  221. 		if ($total) {

    222. 

  222. 			$total = @mysqli_fetch_array($total);

    223. 

  223. 			return $total[0];  

    224. 

  224. 		} else {

    225. 

  225. 			return 0;

    226. 

  226. 		}

    227. 

  227. 	} 

    228. 

  228. 	

    229. 

  229. 	/** METHOD: ADD_ENDING_SLASH

    230. 

  230. 	 *  Adds a slash to the end of a path

    231. 

  231. 	 *  @param string $path		A path

    232. 

  232. 	 */

    233. 

  233. 	static public function add_slash($path){

    234. 

  234. 		$last_char = substr($path, strlen($path)-1, 1);

    235. 

  235. 		if ($last_char != '/' ) {

    236. 

  236. 			$path .= '/';

    237. 

  237. 		}

    238. 

  238. 		return $path;

    239. 

  239. 	}

    240. 

  240. 

    241. 

  241. 

    242. 

  242. 	/** METHOD: SET_SAFE_PATH

    243. 

  243. 	 *  Makes path safe for any OS

    244. 

  244. 	 *  Paths should ALWAYS READ be "/"

    245. 

  245. 	 *		uni: /home/path/file.xt

    246. 

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

    247. 

  247. 	 *  @param string $path		The path to make safe

    248. 

  248. 	 */

    249. 

  249. 	static public function set_safe_path($path) {

    250. 

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

    251. 

  251. 	}

    252. 

  252. 	

    253. 

  253. 	static public function unset_safe_path($path) {

    254. 

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

    255. 

  255. 	}

    256. 

  256. 

    257. 

  257. 	/** METHOD: FCGI_FLUSH

    258. 

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

    259. 

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

    260. 

  260. 	 */

    261. 

  261. 	static public function fcgi_flush() {

    262. 

  262. 		echo(str_repeat(' ',256));

    263. 

  263. 		@flush();

    264. 

  264. 	}

    265. 

  265. 	

    266. 

  266. 	/** METHOD: COPY_FILE

    267. 

  267. 	 *  A safe method used to copy larger files

    268. 

  268. 	 *  @param string $source		The path to the file being copied

    269. 

  269. 	 *  @param string $destination	The path to the file being made

    270. 

  270. 	 */

    271. 

  271. 	static public function copy_file($source, $destination) {

    272. 

  272. 		$sp = fopen($source, 'r');

    273. 

  273. 		$op = fopen($destination, 'w');

    274. 

  274. 

    275. 

  275. 		while (!feof($sp)) {

    276. 

  276. 		   $buffer = fread($sp, 512);  // use a buffer of 512 bytes

    277. 

  277. 		   fwrite($op, $buffer);

    278. 

  278. 		}

    279. 

  279.   		// close handles

    280. 

  280. 		fclose($op);

    281. 

  281. 		fclose($sp);

    282. 

  282. 	}

    283. 

  283. 	

    284. 

  284. 	/** METHOD: string_has_value

    285. 

  285. 	 *  Finds a string in a file and returns true if found

    286. 

  286. 	 *  @param array  $list		A list of strings to search for

    287. 

  287. 	 *  @param string $haystack	The string to search in

    288. 

  288. 	 */

    289. 

  289. 	static public function string_has_value($list, $file) {

    290. 

  290. 		foreach($list as $var) {

    291. 

  291. 			if (strstr($file, $var) !== false ) {

    292. 

  292. 				return true;

    293. 

  293. 			}

    294. 

  294. 		} 

    295. 

  295. 		return false;

    296. 

  296. 	}

    297. 

  297. 	

    298. 

  298. 	/** METHOD: get_active_plugins

    299. 

  299. 	 *  Returns the active plugins for a package

    300. 

  300. 	 *  @param  conn   $dbh	 A database connection handle

    301. 

  301. 	 *  @return array  $list A list of active plugins

    302. 

  302. 	 */

    303. 

  303. 	static public function get_active_plugins($dbh) {

    304. 

  304. 		$query = @mysqli_query($dbh, "SELECT option_value FROM `{$GLOBALS['FW_TABLEPREFIX']}options` WHERE option_name = 'active_plugins' ");

    305. 

  305. 		if ($query) {

    306. 

  306. 			$row = mysqli_fetch_array($query);  

    307. 

  307. 			$all_plugins = unserialize($row[0]);  

    308. 

  308. 			if (is_array($all_plugins)) {

    309. 

  309. 				return $all_plugins;

    310. 

  310. 			}

    311. 

  311. 		}

    312. 

  312. 		return array();

    313. 

  313. 	}

    314. 

  314. 	

    315. 

  315. 	/** METHOD: get_database_tables

    316. 

  316. 	 *  Returns the tables for a database

    317. 

  317. 	 *  @param  conn   $dbh	 A database connection handle	 

    318. 

  318. 	 *  @return array  $list A list of all table names

    319. 

  319. 	 */

    320. 

  320. 	static public function get_database_tables($dbh) {

    321. 

  321. 		$query = @mysqli_query($dbh, 'SHOW TABLES');

    322. 

  322. 		if ($query ) {

    323. 

  323. 			while ($table = mysqli_fetch_array($query )) {

    324. 

  324. 				$all_tables[] = $table[ 0 ];

    325. 

  325. 			}

    326. 

  326. 			if (is_array($all_tables)) {

    327. 

  327. 				return $all_tables;

    328. 

  328. 			}

    329. 

  329. 		}

    330. 

  330. 		return array();

    331. 

  331. 	}

    332. 

  332. 	

    333. 

  333. 	

    334. 

  334. 	/**

    335. 

  335. 	 * MySQL database version number

    336. 

  336. 	 * @param conn $dbh Database connection handle

    337. 

  337. 	 * @return false|string false on failure, version number on success

    338. 

  338. 	 */

    339. 

  339. 	static public function mysql_version($dbh) {

    340. 

  340. 		if (function_exists( 'mysqli_get_server_info' ) ) {

    341. 

  341. 			return preg_replace( '/[^0-9.].*/', '', mysqli_get_server_info( $dbh ) );

    342. 

  342. 		} else {

    343. 

  343. 			return 0;

    344. 

  344. 		}

    345. 

  345. 	}

    346. 

  346. 	

    347. 

  347. 	/**

    348. 

  348. 	 * MySQL server variable

    349. 

  349. 	 * @param conn $dbh Database connection handle

    350. 

  350. 	 * @return string the server variable to query for

    351. 

  351. 	 */

    352. 

  352. 	static public function mysql_variable_value($dbh, $variable) {

    353. 

  353. 		$result = @mysqli_query($dbh, "SHOW VARIABLES LIKE '{$variable}'");

    354. 

  354. 		$row = mysqli_fetch_array($result);

    355. 

  355. 		@mysqli_free_result($result);

    356. 

  356. 		return isset($row[1]) ? $row[1] : null;

    357. 

  357. 	}

    358. 

  358. 	

    359. 

  359. 	/**

    360. 

  360. 	 * Determine if a MySQL database supports a particular feature

    361. 

  361. 	 * @param conn $dbh Database connection handle	 

    362. 

  362. 	 * @param string $feature the feature to check for

    363. 

  363. 	 * @return bool

    364. 

  364. 	 */

    365. 

  365. 	static public function mysql_has_ability($dbh, $feature) {

    366. 

  366. 		$version = self::mysql_version($dbh);

    367. 

  367. 

    368. 

  368. 		switch ( strtolower( $feature ) ) {

    369. 

  369. 			case 'collation' :    

    370. 

  370. 			case 'group_concat' : 

    371. 

  371. 			case 'subqueries' :   

    372. 

  372. 				return version_compare( $version, '4.1', '>=' );

    373. 

  373. 			case 'set_charset' :

    374. 

  374. 				return version_compare($version, '5.0.7', '>=');

    375. 

  375. 		};

    376. 

  376. 		return false;

    377. 

  377. 	}

    378. 

  378. 	

    379. 

  379. 	/**

    380. 

  380. 	 * Sets the MySQL connection's character set.

    381. 

  381. 	 * @param resource $dbh     The resource given by mysqli_connect

    382. 

  382. 	 * @param string   $charset The character set (optional)

    383. 

  383. 	 * @param string   $collate The collation (optional)

    384. 

  384. 	 */

    385. 

  385. 	static public function mysql_set_charset($dbh, $charset = null, $collate = null) {

    386. 

  386. 		

    387. 

  387. 		$charset = ( !isset($charset) ) ? $GLOBALS['DBCHARSET_DEFAULT'] : $charset;

    388. 

  388. 		$collate = ( !isset($collate) ) ? $GLOBALS['DBCOLLATE_DEFAULT'] : $collate;

    389. 

  389. 		

    390. 

  390. 		if ( self::mysql_has_ability($dbh, 'collation') && !empty( $charset ) ) {

    391. 

  391. 			if ( function_exists( 'mysqli_set_charset' ) && self::mysql_has_ability($dbh, 'set_charset') ) {

    392. 

  392. 				 return mysqli_set_charset($dbh, $charset);

    393. 

  393. 			} else {

    394. 

  394. 				$sql = " SET NAMES {$charset}";

    395. 

  395. 				if ( ! empty( $collate ) )

    396. 

  396. 					$sql .= " COLLATE {$collate}";

    397. 

  397. 				return mysqli_query($dbh, $sql);

    398. 

  398. 			}

    399. 

  399. 		}

    400. 

  400. 	}

    401. 

  401. 	

    402. 

  402. 	

    403. 

  403. 	/**

    404. 

  404. 	 *  READABLE_BYTESIZE

    405. 

  405. 	 *  Display human readable byte sizes

    406. 

  406. 	 *  @param string $size		The size in bytes

    407. 

  407. 	 */

    408. 

  408. 	static public function readable_bytesize($size) {

    409. 

  409. 		try {

    410. 

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

    411. 

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

    412. 

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

    413. 

  413. 		} catch (Exception $e) {

    414. 

  414. 			return "n/a";

    415. 

  415. 		}

    416. 

  416. 	}

    417. 

  417. 	

    418. 

  418. 	

    419. 

  419. }

    420. 

  420. 

    421. 

  421. ?>

    422. 

  422. 

    423. 

  423. 

    424. 

  424. <?php

    425. 

  425. 	if (isset($_POST['action_ajax'])) {

    426. 

  426. 		switch ( $_POST['action_ajax'] ) {

    427. 

  427. 			case "1" :?>  <?php

    428. 

  428.  	//====================================================================================================

    429. 

  429. 	//PRECHECKS - Validate and make sure to have a clean enviroment

    430. 

  430. 	//====================================================================================================

    431. 

  431.  	define('MSG_ERR_CONFIG_FOUND',		'<div class="error"><b style="color:#C16C1D;">INSTALL ERROR!</b><br/> A wp-config.php already exists in this location.  This error prevents users from accidentally overwriting the wrong directories contents.  You have two options: <ul><li>Empty this root directory except for the package and installer and try again.</li><li>Delete just the wp-config.php file and try again.  This will over-write all other files in the directory.</li></ul></div>');

    432. 

  432. 	define('MSG_ERR_ZIPNOTFOUND', 		'<div class="error"><b style="color:#C16C1D;">INSTALL ERROR!</b><br/> The packaged zip file was not found. Be sure the zip package is in the same directory as the installer file.  If you are trying to reinstall a package you can copy the package from the "' . DUPLICATOR_SSDIR_NAME . '" directory back up to your root which is the same location as your installer.php file. </div>');

    433. 

  433. 	define('MSG_ERR_ZIPEXTRACTION', 	'<div class="error"><b style="color:#C16C1D;">INSTALL ERROR!</b><br/> Failed in extracting zip file. Please be sure the archive is completely downloaded. Try to extract the archive manually to make sure the file is not corrupted.  </div>');

    434. 

  434. 	define('MSG_ERR_ZIPMANUAL', 		'<div class="error"><b style="color:#C16C1D;">INSTALL ERROR!</b><br/> When choosing manual package extraction, the contents of the package must already be extracted and the wp-config.php and database.sql files must be present in the same directory as the installer.php for the process to continue.  Please manually extract the package into the current directory before continuing in manual extraction mode.  Also validate that the wp-config.php and database.sql files are present.  </div>');

    435. 

  435. 	define('MSG_ERR_MAKELOG', 			'<div class="error"><b style="color:#C16C1D;">INSTALL ERROR!</b><br/> PHP is having issues writing to the log file <b>' . DupUtil::set_safe_path($GLOBALS['CURRENT_ROOT_PATH']) . '\installer-log.txt .</b> In order for the Duplicator to proceed validate your owner/group and permission settings for PHP on this path. Try temporarily setting you permissions to 777 to see if the issue gets resolved.  If you are on a shared hosting environment please contact your hosting company and tell them you are getting errors writing files to the path above when using PHP. </div>');

    436. 

  436. 	define('MSG_FAIL_MYSQLI_SUPPORT', 	'<div class="error"><b style="color:#B80000;">PHP MYSQLI NOT ENABLED!</b><br/>In order to complete an install the mysqli extension for PHP is required. If you are on a hosted server please contact your host and request that mysqli be enabled.  For more information visit: http://php.net/manual/en/mysqli.installation.php</div>');

    437. 

  437. 	define('MSG_FAIL_DBCONNECT', 		'<div class="error"><b style="color:#B80000;">DATABASE CONNECTION FAILED!</b><br/></div>');

    438. 

  438. 	define('MSG_FAIL_DBCONNECT_CREATE', '<div class="error"><b style="color:#B80000;">DATABASE CREATION FAILURE!</b><br/> Unable to create database "%s".<br/>  Please try creating the database manually to proceed with installation</div>');

    439. 

  439. 	define('MSG_FAIL_DBTRYCLEAN',   	'<div class="error"><b style="color:#C16C1D;">DATABASE CREATION FAILURE!</b><br/> Unable to remove all tables from database "%s".<br/>  Please remove all tables from this database and try the installation again.</div>');

    440. 

  440. 	define('MSG_ERR_DBCREATE',   		'<div class="error"><b style="color:#C16C1D;">INSTALL ERROR!</b><br/> The database "%s" does not exists.<br/>  Enable allow database creation to proceed with the installation.</div>');

    441. 

  441. 	define('MSG_ERR_DBCLEANCHECK', 		'<div class="error"><b style="color:#C16C1D;">INSTALL ERROR!</b><br/> The database "%s" has %s tables.  The Duplicator only works with an EMPTY database.  Enable the "Table Removal" checkbox to delete all tables and proceed with installation.  Please backup all your data before proceeding!<br/><br/>  Some hosting providers do not allow table removal from scripts like the Duplicator.  In this case you will need to login to your hosting providers control panel and remove the tables manually.  Please contact your hosting provider for further details. </div>');	

    442. 

  442. 	define('MSG_OK_DBPASS', 			'<div class="error"><b style="color:#006E32;">CONNECTION SUCCESSFUL!</b><br/> With the parameters provided.</div>');	

    443. 

  443.  

    444. 

  444.  

    445. 

  445.  	//POST PARAMS

    446. 

  446. 	$_POST['dbmake']   = (isset($_POST['dbmake'])	&& $_POST['dbmake'] ==  '1') ? true : false;

    447. 

  447. 	$_POST['dbclean']  = (isset($_POST['dbclean'])  && $_POST['dbclean'] == '1') ? true : false;	

    448. 

  448. 	$_POST['dbnbsp']   = (isset($_POST['dbnbsp']) 	&& $_POST['dbnbsp'] == '1')  	? true : false;

    449. 

  449. 	$_POST['no_ssl']   = (isset($_POST['no_ssl'])	&& $_POST['no_ssl'] == '1')  		? true : false;

    450. 

  450. 	$_POST['package_name']  = isset($_POST['package_name']) ? $_POST['package_name'] 	: null;

    451. 

  451. 	$_POST['zip_manual']    = (isset($_POST['zip_manual'])	&& $_POST['zip_manual'] == '1')  	? true : false;

    452. 

  452. 	

    453. 

  453. 	//LOGGING

    454. 

  454. 	$POST_LOG = $_POST;

    455. 

  455. 	unset($POST_LOG['dbpass']);

    456. 

  456. 	ksort($POST_LOG);

    457. 

  457. 	

    458. 

  458. 	//PAGE VARS

    459. 

  459. 	$back_link		= "<div class='tryagain'><a href='javascript:void(0)' onclick='Duplicator.hideErrorResult()' style='color:#444; font-weight:bold'>&laquo; Try Again</a></div>";

    460. 

  460. 	$root_path		= DupUtil::set_safe_path($GLOBALS['CURRENT_ROOT_PATH']);

    461. 

  461. 	$package_path	= "{$root_path}/{$_POST['package_name']}";

    462. 

  462. 	$package_size	= @filesize($package_path);	

    463. 

  463. 	$ajax1_start	= DupUtil::get_microtime();	

    464. 

  464. 	$JSON = array();

    465. 

  465. 	$JSON['pass'] = 0;

    466. 

  466. 	

    467. 

  467.  

    468. 

  468. 	//===============================

    469. 

  469. 	//DATABASE TEST CONNECTION

    470. 

  470. 	//===============================

    471. 

  471. 	if (isset($_GET['dbtest'])) {

    472. 

  472. 		

    473. 

  473. 		if (! is_null($_POST['dbname'])) {

    474. 

  474. 			$dbh = @mysqli_connect($_POST['dbhost'], $_POST['dbuser'], $_POST['dbpass'], $_POST['dbname']);

    475. 

  475. 		} else {

    476. 

  476. 			$dbh = @mysqli_connect($_POST['dbhost'], $_POST['dbuser'], $_POST['dbpass']);

    477. 

  477. 		}

    478. 

  478. 		

    479. 

  479. 		if (! $dbh) {

    480. 

  480. 			die(MSG_FAIL_DBCONNECT . mysqli_connect_error());

    481. 

  481. 		}

    482. 

  482. 			

    483. 

  483. 		if (! $_POST['dbmake']) {

    484. 

  484. 			mysqli_select_db($dbh, $_POST['dbname']) or die(sprintf(MSG_ERR_DBCREATE, $_POST['dbname']));

    485. 

  485. 		}

    486. 

  486. 		

    487. 

  487. 		if (! $_POST['dbclean']) {

    488. 

  488. 			$tblcount = DupUtil::dbtable_count($dbh, $_POST['dbname']);

    489. 

  489. 			if ($tblcount > 0) {

    490. 

  490. 				die(sprintf(MSG_ERR_DBCLEANCHECK, $_POST['dbname'], $tblcount ));

    491. 

  491. 			}

    492. 

  492. 		}

    493. 

  493. 		die(MSG_OK_DBPASS);

    494. 

  494. 	} 

    495. 

  495. 	

    496. 

  496. 	//===============================

    497. 

  497. 	//VALIDATION MESSAGES

    498. 

  498. 	//===============================

    499. 

  499. 	//MSG_ERR_MAKELOG

    500. 

  500. 	($GLOBALS['LOG_FILE_HANDLE'] != false) or die(MSG_ERR_MAKELOG . $back_link);

    501. 

  501. 	

    502. 

  502. 	

    503. 

  503. 	//MSG_FAIL_MYSQLI_SUPPORT

    504. 

  504. 	function_exists('mysqli_connect') or die(MSG_FAIL_MYSQLI_SUPPORT);

    505. 

  505. 	

    506. 

  506. 	//MSG_FAIL_DBCONNECT

    507. 

  507. 	$dbh = @mysqli_connect($_POST['dbhost'], $_POST['dbuser'], $_POST['dbpass']); 

    508. 

  508. 	($dbh) or die(MSG_FAIL_DBCONNECT . mysqli_connect_error() . $back_link);

    509. 

  509. 	if (! $_POST['dbmake']) {

    510. 

  510. 		mysqli_select_db($dbh, $_POST['dbname']) or die(sprintf(MSG_ERR_DBCREATE, $_POST['dbname'])  . $back_link);

    511. 

  511. 	}

    512. 

  512. 	//MSG_ERR_DBCLEANCHECK

    513. 

  513. 	if (! $_POST['dbclean']) {

    514. 

  514. 		$tblcount = DupUtil::dbtable_count($dbh, $_POST['dbname']);

    515. 

  515. 		if ($tblcount > 0) {

    516. 

  516. 			die(sprintf(MSG_ERR_DBCLEANCHECK, $_POST['dbname'], $tblcount ) . $back_link);

    517. 

  517. 		}

    518. 

  518. 	}

    519. 

  519. 	

    520. 

  520. 	//MSG_ERR_ZIPMANUAL

    521. 

  521. 	if ($_POST['zip_manual']) {

    522. 

  522. 		if (! file_exists("wp-config.php") && ! file_exists("database.sql")) {

    523. 

  523. 			die(MSG_ERR_ZIPMANUAL  . $back_link);

    524. 

  524. 		}

    525. 

  525. 	} else {

    526. 

  526. 		//MSG_ERR_CONFIG_FOUND

    527. 

  527. 		(! file_exists('wp-config.php')) or die(MSG_ERR_CONFIG_FOUND . $back_link);

    528. 

  528. 		//MSG_ERR_ZIPNOTFOUND

    529. 

  529. 		(is_readable("{$package_path}")) or die(MSG_ERR_ZIPNOTFOUND . $back_link);

    530. 

  530. 	}

    531. 

  531. 	

    532. 

  532. 	DupUtil::log("{$GLOBALS['SEPERATOR1']}");

    533. 

  533. 	DupUtil::log('DUPLICATOR INSTALL-LOG');

    534. 

  534. 	DupUtil::log('STEP1 START @ ' . @date('h:i:s') );

    535. 

  535. 	DupUtil::log('NOTICE: Do not post to public sites or forums');

    536. 

  536. 	DupUtil::log("{$GLOBALS['SEPERATOR1']}");

    537. 

  537. 	DupUtil::log("VERSION:\t{$GLOBALS['DUPLICATOR_INSTALLER_VERSION']}");

    538. 

  538. 	DupUtil::log("PHP:\t\t" . phpversion());

    539. 

  539. 	DupUtil::log("PHP SAPI:\t" . php_sapi_name());

    540. 

  540. 	DupUtil::log("ZIPARCHIVE:\t" . var_export(class_exists('ZipArchive'), true));

    541. 

  541. 	DupUtil::log("SERVER:\t\t{$_SERVER['SERVER_SOFTWARE']}");

    542. 

  542. 	DupUtil::log("DOC ROOT:\t{$root_path}");

    543. 

  543. 	DupUtil::log("DOC ROOT 755:\t" . var_export($GLOBALS['CHOWN_ROOT_PATH'], true));

    544. 

  544. 	DupUtil::log("LOG FILE 644:\t" . var_export($GLOBALS['CHOWN_LOG_PATH'], true));

    545. 

  545. 	DupUtil::log("BUILD NAME:\t{$GLOBALS['FW_SECURE_NAME']}");

    546. 

  546. 	DupUtil::log("REQUEST URL:\t{$GLOBALS['URL_PATH']}");	

    547. 

  547. 	DupUtil::log("--------------------------------------");	

    548. 

  548. 	DupUtil::log("POST DATA");	

    549. 

  549. 	DupUtil::log("--------------------------------------");	

    550. 

  550. 	DupUtil::log(print_r($POST_LOG, true));

    551. 

  551. 

    552. 

  552. 

    553. 

  553. 	//====================================================================================================

    554. 

  554. 	//UNZIP & FILE SETUP - Extract the zip file and prep files

    555. 

  555. 	//====================================================================================================

    556. 

  556. 	DupUtil::log("{$GLOBALS['SEPERATOR1']}");

    557. 

  557. 	DupUtil::log('UNZIP & FILE SETUP');

    558. 

  558. 	DupUtil::log("{$GLOBALS['SEPERATOR1']}");	

    559. 

  559. 	DupUtil::log("PACKAGE:\t" . $_POST['package_name'] );	

    560. 

  560. 	DupUtil::log("SIZE:\t\t" . DupUtil::readable_bytesize(@filesize($_POST['package_name'])));	

    561. 

  561. 	

    562. 

  562. 	$zip_start = DupUtil::get_microtime();

    563. 

  563. 		

    564. 

  564. 	if ($_POST['zip_manual']) {

    565. 

  565. 		DupUtil::log("\n-package extraction is in manual mode-\n");

    566. 

  566. 	} else {

    567. 

  567. 		if ($GLOBALS['FW_PACKAGE_NAME'] != $_POST['package_name']) {

    568. 

  568. 			DupUtil::log("WARNING: This Package Set may be incompatible!  \nBelow is a summary of the package this installer was built with and the package used. \nTo guarantee accuracy make sure the installer and package match. For more details see the online FAQs.  \ncreated with:   {$GLOBALS['FW_PACKAGE_NAME']}  \nprocessed with: {$_POST['package_name']}  \n");

    569. 

  569. 		}

    570. 

  570. 		

    571. 

  571. 		$target = $root_path;

    572. 

  572. 		$zip = new ZipArchive();

    573. 

  573. 		if ($zip->open($_POST['package_name']) === TRUE)	{

    574. 

  574. 			@$zip->extractTo($target);

    575. 

  575. 			DupUtil::log("INFORMATION:\t" . print_r($zip, true));

    576. 

  576. 			$close_response = $zip->close();

    577. 

  577. 			DupUtil::log("ZIP CLOSE: " . var_export($close_response, true));

    578. 

  578. 		 } else {

    579. 

  579. 			die(MSG_ERR_ZIPEXTRACTION . $back_link );

    580. 

  580. 		}

    581. 

  581. 		$zip = null;

    582. 

  582. 	}

    583. 

  583. 	

    584. 

  584. 	//===============================

    585. 

  585. 	//SCRIPTS: wp-config/database.sql

    586. 

  586. 	//===============================

    587. 

  587. 	

    588. 

  588. 	//WP-CONFIG

    589. 

  589. 	$patterns = array("/'DB_NAME',\s*'.*?'/",

    590. 

  590. 					  "/'DB_USER',\s*'.*?'/",

    591. 

  591. 					  "/'DB_PASSWORD',\s*'.*?'/",

    592. 

  592. 					  "/'DB_HOST',\s*'.*?'/");

    593. 

  593. 					   

    594. 

  594. 	$replace = array("'DB_NAME', "		. '\''.$_POST['dbname'].'\'',

    595. 

  595. 					 "'DB_USER', "		. '\''.$_POST['dbuser'].'\'',

    596. 

  596. 					 "'DB_PASSWORD', "	. '\''.$_POST['dbpass'].'\'',

    597. 

  597. 					 "'DB_HOST', "		. '\''.$_POST['dbhost'].'\'');		

    598. 

  598. 					  

    599. 

  599. 	if ($_POST['no_ssl']) {

    600. 

  600. 		array_push($patterns, "/'FORCE_SSL_ADMIN',\s*true/");

    601. 

  601. 		array_push($replace,  "'FORCE_SSL_ADMIN', false");

    602. 

  602. 	} 

    603. 

  603. 	

    604. 

  604. 	$wpconfig = @file_get_contents('wp-config.php', true);

    605. 

  605. 	$wpconfig = preg_replace($patterns, $replace, $wpconfig);

    606. 

  606. 	file_put_contents('wp-config.php', $wpconfig);

    607. 

  607. 	$wpconfig = null;

    608. 

  608. 	

    609. 

  609. 	

    610. 

  610. 	//DATABASE SCRIPT

    611. 

  611. 	@chmod("{$root_path}/database.sql", 0777);

    612. 

  612. 	$sql_file = @file_get_contents('database.sql', true);

    613. 

  613. 	if ($sql_file == false || strlen($sql_file) < 10) {

    614. 

  614. 		$sql_file = file_get_contents('installer-data.sql', true);

    615. 

  615. 		if ($sql_file == false || strlen($sql_file) < 10) {

    616. 

  616. 			DupUtil::log("ERROR: Unable to read from the extracted database.sql file .\nValidate the permissions and/or group-owner rights on directory '{$root_path}'\n");

    617. 

  617. 		}

    618. 

  618. 	}

    619. 

  619. 	

    620. 

  620. 	//Complex Subject See: http://webcollab.sourceforge.net/unicode.html

    621. 

  621. 	//Removes invalid space characters

    622. 

  622. 	if ($_POST['dbnbsp']) {

    623. 

  623. 		DupUtil::log("ran fix non-breaking space characters\n" );

    624. 

  624. 		$sql_file = preg_replace('/\xC2\xA0/',' ',$sql_file);

    625. 

  625. 	}

    626. 

  626. 	

    627. 

  627. 	//Write new contents to install-data.sql

    628. 

  628. 	@chmod($sql_result_file_path, 0777);

    629. 

  629. 	file_put_contents($GLOBALS['SQL_FILE_NAME'], $sql_file);

    630. 

  630. 	

    631. 

  631. 	$sql_result_file_data   = explode(";\n", $sql_file);

    632. 

  632. 	$sql_result_file_length = count($sql_result_file_data);

    633. 

  633. 	$sql_result_file_path   = "{$root_path}/{$GLOBALS['SQL_FILE_NAME']}";

    634. 

  634. 	$sql_file = null;

    635. 

  635. 	

    636. 

  636. 	if (! is_readable($sql_result_file_path) || filesize($sql_result_file_path) == 0) {

    637. 

  637. 		DupUtil::log("ERROR: Unable to create new sql file {$GLOBALS['SQL_FILE_NAME']}.\nValidate the permissions and/or group-owner rights on directory '{$root_path}' and file '{$GLOBALS['SQL_FILE_NAME']}'\n");

    638. 

  638. 	} 

    639. 

  639. 	

    640. 

  640. 	DupUtil::log("UPDATED SCRIPTS:");

    641. 

  641. 	DupUtil::log("\tsql file:  '{$sql_result_file_path}'");

    642. 

  642. 	DupUtil::log("\twp-config: '{$root_path}/wp-config.php'");

    643. 

  643. 	$zip_end = DupUtil::get_microtime();

    644. 

  644. 	DupUtil::log("\nSECTION RUNTIME: " . DupUtil::elapsed_time($zip_end, $zip_start));

    645. 

  645. 	DupUtil::log("\n");

    646. 

  646. 	DupUtil::fcgi_flush();

    647. 

  647. 	

    648. 

  648. 

    649. 

  649.  	//====================================================================================================

    650. 

  650. 	//DATABASE ROUTINES

    651. 

  651. 	//====================================================================================================

    652. 

  652. 	

    653. 

  653. 	@mysqli_query($dbh, "SET wait_timeout = {$GLOBALS['DB_MAX_TIME']}");

    654. 

  654. 	@mysqli_query($dbh, "SET max_allowed_packet = {$GLOBALS['DB_MAX_PACKETS']}");

    655. 

  655. 	DupUtil::mysql_set_charset($dbh, $_POST['dbcharset'], $_POST['dbcollate']);

    656. 

  656. 	

    657. 

  657. 	//Set defaults incase the variable could not be read

    658. 

  658. 	$dbvar_maxtime  = DupUtil::mysql_variable_value($dbh, 'wait_timeout'); 

    659. 

  659. 	$dbvar_maxpacks = DupUtil::mysql_variable_value($dbh, 'max_allowed_packet'); 

    660. 

  660. 	$dbvar_maxtime  = is_null($dbvar_maxtime)   ? 300 	  : $dbvar_maxtime;

    661. 

  661. 	$dbvar_maxpacks = is_null($dbvar_maxpacks)  ? 1048576 : $dbvar_maxpacks;

    662. 

  662. 	

    663. 

  663. 	

    664. 

  664. 	DupUtil::log("{$GLOBALS['SEPERATOR1']}");

    665. 

  665. 	DupUtil::log('DATABASE-ROUTINES');

    666. 

  666. 	DupUtil::log("{$GLOBALS['SEPERATOR1']}");

    667. 

  667. 	DupUtil::log("--------------------------------------");	

    668. 

  668. 	DupUtil::log("SERVER ENVIROMENT");	

    669. 

  669. 	DupUtil::log("--------------------------------------");	

    670. 

  670. 	DupUtil::log("MYSQL VERSION:\t" .  mysqli_get_server_info($dbh));

    671. 

  671. 	DupUtil::log("TIMEOUT:\t{$dbvar_maxtime}");	

    672. 

  672. 	DupUtil::log("MAXPACK:\t{$dbvar_maxpacks}"); 

    673. 

  673. 	

    674. 

  674. 	//CREATE DB

    675. 

  675. 	if ($_POST['dbmake']) {

    676. 

  676. 		mysqli_query($dbh, "CREATE DATABASE IF NOT EXISTS `{$_POST['dbname']}`");

    677. 

  677. 		mysqli_select_db($dbh, $_POST['dbname']) 

    678. 

  678. 			or die(sprintf(MSG_FAIL_DBCONNECT_CREATE, $_POST['dbname']) . $back_link);

    679. 

  679. 	}

    680. 

  680. 	

    681. 

  681. 	//DROP DB TABLES

    682. 

  682. 	$drop_log = "Database already empty. Ready for install.";

    683. 

  683. 	if ($_POST['dbclean']) {

    684. 

  684. 		$sql = "SHOW TABLES FROM `{$_POST['dbname']}`";

    685. 

  685. 		$found_tables = null;

    686. 

  686. 		if($result = mysqli_query($dbh, $sql)){

    687. 

  687. 			while($row = mysqli_fetch_row($result)){

    688. 

  688. 				$found_tables[] = $row[0];

    689. 

  689. 			}

    690. 

  690. 			if (count($found_tables) > 0) {

    691. 

  691. 				foreach($found_tables as $table_name){

    692. 

  692. 					$sql = "DROP TABLE `{$_POST['dbname']}`.{$table_name}";

    693. 

  693. 					if(! $result = mysqli_query($dbh, $sql)){

    694. 

  694. 						die(sprintf(MSG_FAIL_DBTRYCLEAN, $_POST['dbname']) . $back_link);

    695. 

  695. 					} 

    696. 

  696. 				}

    697. 

  697. 			} 

    698. 

  698. 			$drop_log = 'removed (' . count($found_tables) . ') tables';

    699. 

  699. 		} 

    700. 

  700. 	}

    701. 

  701. 

    702. 

  702. 	//WRITE DATA

    703. 

  703. 	DupUtil::log("--------------------------------------");	

    704. 

  704. 	DupUtil::log("DATABASE RESULTS");

    705. 

  705. 	DupUtil::log("--------------------------------------");	

    706. 

  706. 	$profile_start = DupUtil::get_microtime();

    707. 

  707. 	$fcgi_buffer_pool = 5000;

    708. 

  708. 	$fcgi_buffer_count = 0;

    709. 

  709. 	$dbquery_rows = 0;

    710. 

  710.     $dbquery_errs = 0;

    711. 

  711. 	$counter = 0;

    712. 

  712. 	@mysqli_autocommit($dbh, false);

    713. 

  713. 	while ($counter < $sql_result_file_length) {

    714. 

  714.     

    715. 

  715. 		$query_strlen = strlen(trim($sql_result_file_data[$counter]));

    716. 

  716.         if ($dbvar_maxpacks < $query_strlen) {

    717. 

  717.             DupUtil::log("**ERROR** Query size limit [length={$query_strlen}] [sql=" . substr($sql_result_file_data[$counter], 75) . "...]");

    718. 

  718.             $dbquery_errs++;

    719. 

  719.         } 

    720. 

  720. 		elseif ($query_strlen > 0) {

    721. 

  721.             @mysqli_free_result(@mysqli_query($dbh,  ($sql_result_file_data[$counter])));

    722. 

  722.             $err = mysqli_error($dbh);

    723. 

  723. 			//Check to make sure the connection is alive

    724. 

  724.             if (! empty($err)){

    725. 

  725.                 

    726. 

  726.                 if (!mysqli_ping ($dbh)) {

    727. 

  727.                    mysqli_close($dbh);

    728. 

  728.                    $dbh = mysqli_connect($_POST['dbhost'], $_POST['dbuser'], $_POST['dbpass'], $_POST['dbname']);

    729. 

  729.                 }

    730. 

  730.                 DupUtil::log("**ERROR** database error write '{$err}' - [sql=" . substr($sql_result_file_data[$counter], 0, 75) . "...]");

    731. 

  731.                 $dbquery_errs++;

    732. 

  732. 				

    733. 

  733. 			//Buffer data to browser to keep connection open				

    734. 

  734.             } else {

    735. 

  735. 				if ($fcgi_buffer_count++ > $fcgi_buffer_pool) {

    736. 

  736. 					$fcgi_buffer_count = 0;

    737. 

  737. 					DupUtil::fcgi_flush();

    738. 

  738. 				}

    739. 

  739. 				$dbquery_rows++;

    740. 

  740. 			}

    741. 

  741.         }

    742. 

  742.         $counter++;

    743. 

  743. 	}

    744. 

  744. 	@mysqli_commit($dbh);

    745. 

  745. 	@mysqli_autocommit($dbh, true);

    746. 

  746.     

    747. 

  747.     DupUtil::log("ERRORS FOUND:\t{$dbquery_errs}");

    748. 

  748. 	DupUtil::log("DROP TABLE:\t{$drop_log}");

    749. 

  749. 	DupUtil::log("QUERIES RAN:\t{$dbquery_rows}\n");

    750. 

  750. 

    751. 

  751. 	$dbtable_count = 0;

    752. 

  752. 	if ($result = mysqli_query($dbh, "SHOW TABLES")) {

    753. 

  753. 		while ($row = mysqli_fetch_array($result, MYSQLI_NUM)) {

    754. 

  754. 			$table_rows = DupUtil::table_row_count($dbh, $row[0]);

    755. 

  755. 			DupUtil::log("{$row[0]}: ({$table_rows})");

    756. 

  756. 			$dbtable_count++;

    757. 

  757. 		}

    758. 

  758. 		@mysqli_free_result($result);

    759. 

  759. 	}

    760. 

  760. 	

    761. 

  761. 	if ($dbtable_count == 0) {

    762. 

  762. 		DupUtil::log("NOTICE: You may have to manually run the installer-data.sql to validate data input. Also check to make sure your installer file is correct and the

    763. 

  763. 		table prefix '{$GLOBALS['FW_TABLEPREFIX']}' is correct for this particular version of WordPress. \n");

    764. 

  764. 	}

    765. 

  765. 	

    766. 

  766. 	//DATA CLEANUP: Perform Transient Cache Cleanup

    767. 

  767. 	//Remove all duplicator entries and record this one since this is a new install.

    768. 

  768. 	$dbdelete_count = 0;

    769. 

  769. 	@mysqli_query($dbh, "DELETE FROM `{$GLOBALS['FW_TABLEPREFIX']}duplicator`");

    770. 

  770. 	$dbdelete_count1 = @mysqli_affected_rows($dbh) or 0;

    771. 

  771. 	@mysqli_query($dbh, "DELETE FROM `{$GLOBALS['FW_TABLEPREFIX']}options` WHERE `option_name` LIKE ('_transient%') OR `option_name` LIKE ('_site_transient%')");

    772. 

  772. 	$dbdelete_count2 = @mysqli_affected_rows($dbh) or 0;

    773. 

  773. 	$dbdelete_count  = (abs($dbdelete_count1) + abs($dbdelete_count2));

    774. 

  774. 	DupUtil::log("Removed '{$dbdelete_count}' cache/transient rows");

    775. 

  775. 	@mysqli_close($dbh);

    776. 

  776. 	

    777. 

  777. 	$profile_end = DupUtil::get_microtime();

    778. 

  778. 	DupUtil::log("\nSECTION RUNTIME: " . DupUtil::elapsed_time($profile_end, $profile_start));

    779. 

  779. 	

    780. 

  780. 	$ajax1_end = DupUtil::get_microtime();

    781. 

  781. 	$ajax1_sum = DupUtil::elapsed_time($ajax1_end, $ajax1_start);

    782. 

  782. 	DupUtil::log("\n{$GLOBALS['SEPERATOR1']}");

    783. 

  783. 	DupUtil::log('STEP1 COMPLETE @ ' . @date('h:i:s') . " - TOTAL RUNTIME: {$ajax1_sum}");

    784. 

  784. 	DupUtil::log("{$GLOBALS['SEPERATOR1']}");

    785. 

  785. 	

    786. 

  786. 	$JSON['pass'] = 1;

    787. 

  787. 	$JSON['table_count'] = $dbtable_count;

    788. 

  788. 	$JSON['table_rows'] = ($dbquery_rows - ($dbtable_count + $dbdelete_count + $dbquery_errs));

    789. 

  789. 	$JSON['query_errs']  = $dbquery_errs;

    790. 

  790. 	echo json_encode($JSON);

    791. 

  791. 	die('');

    792. 

  792. ?> <?php break; 

    793. 

  793. 			case "2" :?> <?php

    794. 

  794. 

    795. 

  795. /** ******************************************************

    796. 

  796.  * CLASS::DUPDBTEXTSWAP

    797. 

  797.  * Walks every table in db that then walks every row and column replacing searches with replaces

    798. 

  798.  * large tables are split into 50k row blocks to save on memory. */

    799. 

  799. class DupDBTextSwap {

    800. 

  800. 

    801. 

  801. 	/**

    802. 

  802. 	 * LOG ERRORS

    803. 

  803. 	 */

    804. 

  804. 	static public function log_errors($report) {

    805. 

  805. 		if ( ! empty($report['errsql']) ) {

    806. 

  806. 			DupUtil::log("====================================");

    807. 

  807. 			DupUtil::log("DATA-REPLACE ERRORS (MySQL)");

    808. 

  808. 			foreach( $report['errsql'] as $error ) {DupUtil::log($error);}

    809. 

  809. 			DupUtil::log("");

    810. 

  810. 		}

    811. 

  811. 		if ( ! empty($report['errser']) ) {

    812. 

  812. 			DupUtil::log("====================================");

    813. 

  813. 			DupUtil::log("DATA-REPLACE ERRORS (Serialization):");

    814. 

  814. 			foreach( $report['errser'] as $error ) {DupUtil::log($error);}

    815. 

  815. 			DupUtil::log("");

    816. 

  816. 		}	

    817. 

  817. 		if ( ! empty($report['errkey']) ) {

    818. 

  818. 			DupUtil::log("====================================");

    819. 

  819. 			DupUtil::log("DATA-REPLACE ERRORS (Key):");

    820. 

  820. 			DupUtil::log('Use SQL: SELECT @row := @row + 1 as row, t.* FROM some_table t, (SELECT @row := 0) r');

    821. 

  821. 			foreach( $report['errkey'] as $error ) {DupUtil::log($error);}

    822. 

  822. 			DupUtil::log("");

    823. 

  823. 		}		

    824. 

  824. 	}

    825. 

  825. 	

    826. 

  826. 	/**

    827. 

  827. 	 * LOG STATS

    828. 

  828. 	 */

    829. 

  829. 	static public function log_stats($report) {

    830. 

  830. 		if ( ! empty( $report ) && is_array( $report ) ) {

    831. 

  831. 			$stats  = sprintf("SEARCH1:\t'%s' \nREPLACE1:\t'%s' \n", $_POST['url_old'], $_POST['url_new']);

    832. 

  832. 			$stats .= sprintf("SEARCH2:\t'%s' \nREPLACE2:\t'%s' \n", $_POST['path_old'], $_POST['path_new']);

    833. 

  833. 			$stats .= sprintf("SCANNED:\tTables:%d | Rows:%d | Cells:%d \n", 	$report['scan_tables'], $report['scan_rows'], $report['scan_cells']);

    834. 

  834. 			$stats .= sprintf("UPDATED:\tTables:%d | Rows:%d |Cells:%d \n",	$report['updt_tables'], $report['updt_rows'], $report['updt_cells']);		

    835. 

  835. 			$stats .= sprintf("ERRORS:\t\t%d \nRUNTIME:\t%f sec",  $report['err_all'], $report['time'] );			

    836. 

  836. 			DupUtil::log($stats);

    837. 

  837. 		}

    838. 

  838. 	}

    839. 

  839. 	

    840. 

  840. 	/**

    841. 

  841. 	 * LOAD

    842. 

  842. 	 * Begins the processing for replace logic

    843. 

  843. 	 * @param mysql  $conn 		 The db connection object

    844. 

  844. 	 * @param array  $list       Key value pair of 'search' and 'replace' arrays

    845. 

  845. 	 * @param array  $tables     The tables we want to look at.

    846. 

  846. 	 * @return array Collection of information gathered during the run.

    847. 

  847. 	 */

    848. 

  848. 	static public function load($conn, $list=array(), $tables=array(), $cols=array()) {

    849. 

  849. 		$exclude_cols = $cols;

    850. 

  850. 		

    851. 

  851. 		$report = array('scan_tables'=>0, 	'scan_rows'=>0, 	'scan_cells'=>0,

    852. 

  852. 						'updt_tables'=>0, 	'updt_rows'=>0, 	'updt_cells'=>0, 

    853. 

  853. 						'errsql'=>array(),  'errser'=>array(),  'errkey'=>array(),

    854. 

  854. 						'errsql_sum'=>0, 	'errser_sum'=>0,	'errkey_sum'=>0,

    855. 

  855. 						'time'=>'', 	  	'err_all'=>0);

    856. 

  856. 		

    857. 

  857. 		$profile_start = DupUtil::get_microtime();

    858. 

  858. 		if ( is_array( $tables ) && ! empty( $tables ) ) {

    859. 

  859. 		

    860. 

  860. 			foreach ($tables as $table) {

    861. 

  861. 				$report['scan_tables']++;

    862. 

  862. 				$columns = array( );

    863. 

  863. 

    864. 

  864. 				// Get a list of columns in this table

    865. 

  865. 				$fields = mysqli_query($conn,  'DESCRIBE ' . $table);

    866. 

  866. 				while ($column = mysqli_fetch_array( $fields )) {

    867. 

  867. 					$columns[ $column[ 'Field' ] ] = $column[ 'Key' ] == 'PRI' ? true : false;

    868. 

  868. 				}

    869. 

  869. 

    870. 

  870. 				// Count the number of rows we have in the table if large we'll split into blocks, This is a mod from Simon Wheatley

    871. 

  871. 				$row_count   = mysqli_query($conn, 'SELECT COUNT(*) FROM ' . $table);

    872. 

  872. 				$rows_result = mysqli_fetch_array( $row_count );

    873. 

  873. 				@mysqli_free_result($row_count);

    874. 

  874. 				$row_count   = $rows_result[ 0 ];

    875. 

  875. 				if ( $row_count == 0 )

    876. 

  876. 					continue;

    877. 

  877. 

    878. 

  878. 				$page_size = 25000;

    879. 

  879. 				$pages = ceil($row_count / $page_size);

    880. 

  880. 

    881. 

  881. 				for ($page = 0; $page < $pages; $page++) {

    882. 

  882. 

    883. 

  883. 					$current_row = 0;

    884. 

  884. 					$start = $page * $page_size;

    885. 

  885. 					$end = $start + $page_size;

    886. 

  886. 					// Grab the content of the table

    887. 

  887. 					$data = mysqli_query($conn, sprintf( 'SELECT * FROM %s LIMIT %d, %d', $table, $start, $end ) );

    888. 

  888. 

    889. 

  889. 					if (! $data)

    890. 

  890. 						$report['errsql'][] = mysqli_error($conn);

    891. 

  891. 

    892. 

  892. 					//Loops every row

    893. 

  893. 					while ($row = mysqli_fetch_array($data)) {

    894. 

  894. 						$report['scan_rows']++; 

    895. 

  895. 						$current_row++;

    896. 

  896. 						$upd_col = array();

    897. 

  897. 						$upd_sql = array();

    898. 

  898. 						$where_sql = array();

    899. 

  899. 						$upd = false;

    900. 

  900. 						$serial_err = 0;

    901. 

  901. 

    902. 

  902. 						//Loops every cell

    903. 

  903. 						foreach( $columns as $column => $primary_key ) {

    904. 

  904. 							if (in_array( $column, $exclude_cols ) ) {

    905. 

  905. 								continue;

    906. 

  906. 							}

    907. 

  907. 							

    908. 

  908. 							$report['scan_cells']++; 

    909. 

  909. 							$edited_data = $data_to_fix = $row[$column];

    910. 

  910. 							$base64coverted = false;

    911. 

  911. 							

    912. 

  912. 							//Only replacing string values

    913. 

  913. 							if (! is_numeric($row[$column])) {

    914. 

  914. 								

    915. 

  915. 								//Base 64 detection

    916. 

  916. 								if (base64_decode($row[$column], true)) {

    917. 

  917. 									$decoded = base64_decode($row[$column], true);

    918. 

  918. 									if(self::is_serialized($decoded)) {

    919. 

  919. 										$edited_data = $decoded;

    920. 

  920. 										$base64coverted = true;

    921. 

  921. 									}

    922. 

  922. 								}

    923. 

  923. 

    924. 

  924. 								//Replace logic - level 1: simple check on basic serilized strings

    925. 

  925. 								foreach($list as $item) {

    926. 

  926. 									$edited_data = self::recursive_unserialize_replace($item['search'], $item['replace'], $edited_data);

    927. 

  927. 								}

    928. 

  928. 

    929. 

  929. 								//Replace logic - level 2: repair larger/complex serilized strings

    930. 

  930. 								$serial_check = self::fix_serial_string($edited_data);

    931. 

  931. 								if ($serial_check['fixed']) {

    932. 

  932. 									$edited_data = $serial_check['data'];

    933. 

  933. 								} 

    934. 

  934. 								elseif ($serial_check['tried'] && ! $serial_check['fixed']) {

    935. 

  935. 									$serial_err++;

    936. 

  936. 								} 

    937. 

  937. 							}

    938. 

  938. 							

    939. 

  939. 							//Change was made

    940. 

  940. 							if ( $edited_data != $data_to_fix || $serial_err > 0) {

    941. 

  941. 								$report['updt_cells']++;

    942. 

  942. 								//Base 64 encode

    943. 

  943. 								if ($base64coverted) {

    944. 

  944. 									$edited_data = base64_encode($edited_data);

    945. 

  945. 								}

    946. 

  946. 								$upd_col[] = $column;

    947. 

  947. 								$upd_sql[] = $column . ' = "' . mysqli_real_escape_string($conn,  $edited_data) . '"';

    948. 

  948. 								$upd = true;

    949. 

  949. 							}

    950. 

  950. 

    951. 

  951. 							if ($primary_key) {

    952. 

  952. 								$where_sql[] = $column . ' = "' . mysqli_real_escape_string($conn, $data_to_fix) . '"';

    953. 

  953. 							} 

    954. 

  954. 						}

    955. 

  955. 						

    956. 

  956. 						//PERFORM ROW UPDATE

    957. 

  957. 						if ($upd && ! empty($where_sql)) {

    958. 

  958. 							

    959. 

  959. 							$sql = "UPDATE `{$table}` SET " . implode( ', ', $upd_sql ) . ' WHERE ' . implode( ' AND ', array_filter( $where_sql ) );

    960. 

  960. 							$result = mysqli_query($conn, $sql) or $report['errsql'][] = mysqli_error($conn);

    961. 

  961. 							if ($result) {

    962. 

  962. 								if ($serial_err > 0) {

    963. 

  963. 									$report['errser'][] = "SELECT " . implode( ', ', $upd_col ) ." FROM `{$table}`  WHERE " . implode(' AND ', array_filter( $where_sql )) . ';';

    964. 

  964. 								} 

    965. 

  965. 								$report['updt_rows']++;

    966. 

  966. 							} 

    967. 

  967. 												

    968. 

  968. 						} elseif ($upd) {

    969. 

  969. 							$report['errkey'][] = sprintf("Row [%s] on Table [%s] requires a manual update.", $current_row, $table);

    970. 

  970. 						}

    971. 

  971. 						DupUtil::fcgi_flush();

    972. 

  972. 					}

    973. 

  973. 					@mysqli_free_result($data);

    974. 

  974. 				}

    975. 

  975. 				

    976. 

  976. 				if ($upd) {

    977. 

  977. 					$report['updt_tables']++;

    978. 

  978. 				}

    979. 

  979. 			}

    980. 

  980. 		}

    981. 

  981. 		$profile_end = DupUtil::get_microtime();

    982. 

  982. 		$report['time'] = DupUtil::elapsed_time($profile_end, $profile_start);

    983. 

  983. 		$report['errsql_sum'] = empty($report['errsql']) ? 0 : count($report['errsql']);

    984. 

  984. 		$report['errser_sum'] = empty($report['errser']) ? 0 : count($report['errser']);

    985. 

  985. 		$report['errkey_sum'] = empty($report['errkey']) ? 0 : count($report['errkey']);

    986. 

  986. 		$report['err_all'] 	  = $report['errsql_sum'] + $report['errser_sum'] + $report['errkey_sum'];

    987. 

  987. 		return $report;

    988. 

  988. 	} 

    989. 

  989. 	

    990. 

  990. 	/**

    991. 

  991. 	 * Take a serialised array and unserialise it replacing elements and

    992. 

  992. 	 * unserialising any subordinate arrays and performing the replace.

    993. 

  993. 	 * @param string $from       String we're looking to replace.

    994. 

  994. 	 * @param string $to         What we want it to be replaced with

    995. 

  995. 	 * @param array  $data       Used to pass any subordinate arrays back to in.

    996. 

  996. 	 * @param bool   $serialised Does the array passed via $data need serialising.

    997. 

  997. 	 * @return array	The original array with all elements replaced as needed. 

    998. 

  998. 	 */

    999. 

  999. 	static private function recursive_unserialize_replace($from = '', $to = '', $data = '', $serialised = false) {

    1000. 

  1000. 

    1001. 

  1001. 		// some unseriliased data cannot be re-serialised eg. SimpleXMLElements

    1002. 

  1002. 		try {

    1003. 

  1003. 

    1004. 

  1004. 			if (is_string($data) && ($unserialized = @unserialize( $data )) !== false) {

    1005. 

  1005. 				$data = self::recursive_unserialize_replace($from, $to, $unserialized, true);

    1006. 

  1006. 			} 

    1007. 

  1007. 			elseif (is_array($data)) {

    1008. 

  1008. 				$_tmp = array();

    1009. 

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

    1010. 

  1010. 					$_tmp[$key] = self::recursive_unserialize_replace($from, $to, $value, false);

    1011. 

  1011. 				}

    1012. 

  1012. 				$data = $_tmp;

    1013. 

  1013. 				unset($_tmp);

    1014. 

  1014. 			} 

    1015. 

  1015. 			elseif (is_object($data)) {

    1016. 

  1016. 				$dataClass = get_class($data);

    1017. 

  1017. 				$_tmp = new $dataClass();

    1018. 

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

    1019. 

  1019. 					$_tmp->$key = self::recursive_unserialize_replace($from, $to, $value, false);

    1020. 

  1020. 				}

    1021. 

  1021. 				$data = $_tmp;

    1022. 

  1022. 				unset($_tmp);

    1023. 

  1023. 			} 

    1024. 

  1024. 			else {

    1025. 

  1025. 				if (is_string($data)) {

    1026. 

  1026. 					$data = str_replace($from, $to, $data);

    1027. 

  1027. 				}

    1028. 

  1028. 			}

    1029. 

  1029. 

    1030. 

  1030. 			if ($serialised)

    1031. 

  1031. 				return serialize($data);

    1032. 

  1032. 

    1033. 

  1033. 		} catch(Exception $error) {

    1034. 

  1034. 			DupUtil::log("\nRECURSIVE UNSERIALIZE ERROR: With string\n". $error, 2);	

    1035. 

  1035. 		}

    1036. 

  1036. 		return $data;

    1037. 

  1037. 	}

    1038. 

  1038. 	

    1039. 

  1039. 	

    1040. 

  1040. 	/**

    1041. 

  1041. 	 *  IS_SERIALIZED

    1042. 

  1042. 	 *  Test if a string in properly serialized */

    1043. 

  1043. 	static public function is_serialized($data) {

    1044. 

  1044. 		$test = @unserialize(($data));

    1045. 

  1045. 		return ($test !== false || $test === 'b:0;') ? true : false;

    1046. 

  1046. 	}

    1047. 

  1047. 

    1048. 

  1048. 	/**

    1049. 

  1049. 	 *  FIX_STRING

    1050. 

  1050. 	 *  Fixes the string length of a string object that has been serialized but the length is broken

    1051. 

  1051. 	 *  @param string $data	The string ojbect to recalculate the size on.

    1052. 

  1052. 	 *  @return 

    1053. 

  1053. 	*/

    1054. 

  1054. 	static private function fix_serial_string($data) {

    1055. 

  1055. 	

    1056. 

  1056. 		$result = array('data'=>$data, 	'fixed'=>false, 'tried'=>false);

    1057. 

  1057. 		

    1058. 

  1058. 		if (preg_match("/s:[0-9]+:/", $data)) {

    1059. 

  1059. 			if (! self::is_serialized($data) ) {

    1060. 

  1060. 				$regex = '!(?<=^|;)s:(\d+)(?=:"(.*?)";(?:}|a:|s:|b:|d:|i:|o:|N;))!s';

    1061. 

  1061. 				$serial_string = preg_match( '/^s:[0-9]+:"(.*$)/s', trim($data), $matches);

    1062. 

  1062. 				//Nested serial string

    1063. 

  1063. 				if ($serial_string) {

    1064. 

  1064. 					$inner = preg_replace_callback($regex, 'DupDBTextSwap::fix_string_callback', rtrim($matches[1], '";')); 

    1065. 

  1065. 					$serialized_fixed =  's:' . strlen($inner) . ':"' . $inner . '";' ;

    1066. 

  1066. 				} else {

    1067. 

  1067. 					$serialized_fixed = preg_replace_callback($regex, 'DupDBTextSwap::fix_string_callback', $data); 

    1068. 

  1068. 				}

    1069. 

  1069. 				

    1070. 

  1070. 				if (self::is_serialized($serialized_fixed) ) {

    1071. 

  1071. 					$result['data']  = $serialized_fixed;

    1072. 

  1072. 					$result['fixed'] = true;

    1073. 

  1073. 				} 

    1074. 

  1074. 				$result['tried'] = true;

    1075. 

  1075. 			}

    1076. 

  1076. 		}

    1077. 

  1077. 		return $result;

    1078. 

  1078. 	}

    1079. 

  1079. 	

    1080. 

  1080. 	static private function fix_string_callback($matches) { 

    1081. 

  1081. 		return 's:' . strlen(($matches[2])); 

    1082. 

  1082. 	} 	

    1083. 

  1083. 			

    1084. 

  1084. }

    1085. 

  1085. 

    1086. 

  1086. //====================================================================================================

    1087. 

  1087. //DATABASE UPDATES

    1088. 

  1088. //====================================================================================================

    1089. 

  1089. 

    1090. 

  1090. $ajax2_start = DupUtil::get_microtime();	

    1091. 

  1091. 

    1092. 

  1092. //MYSQL CONNECTION

    1093. 

  1093. $dbh = @mysqli_connect($_POST['dbhost'], $_POST['dbuser'], $_POST['dbpass'], $_POST['dbname']);

    1094. 

  1094. $charset_server = @mysqli_character_set_name($dbh);

    1095. 

  1095. @mysqli_query($dbh, "SET wait_timeout = {$GLOBALS['DB_MAX_TIME']}");

    1096. 

  1096. DupUtil::mysql_set_charset($dbh, $_POST['dbcharset'], $_POST['dbcollate']);

    1097. 

  1097. 

    1098. 

  1098. //POST PARAMS

    1099. 

  1099. $_POST['blogname'] = mysqli_real_escape_string($dbh, $_POST['blogname']);

    1100. 

  1100. $_POST['postguid'] = isset($_POST['postguid'])  && $_POST['postguid'] == 1 ? 1 : 0;

    1101. 

  1101. $_POST['path_old'] = isset($_POST['path_old'])	? trim($_POST['path_old'])				: null;

    1102. 

  1102. $_POST['path_new'] = isset($_POST['path_new'])	? trim($_POST['path_new'])				: null;

    1103. 

  1103. $_POST['siteurl']  = isset($_POST['siteurl'])	? rtrim(trim($_POST['siteurl']), '/')	: null;

    1104. 

  1104. $_POST['tables']   = isset($_POST['tables'])    && is_array($_POST['tables']) ? array_map('stripcslashes', $_POST['tables']) : array();

    1105. 

  1105. $_POST['url_old']  = isset($_POST['url_old'])	? trim($_POST['url_old'])				: null;

    1106. 

  1106. $_POST['url_new']  = isset($_POST['url_new'])	? rtrim(trim($_POST['url_new']), '/')	: null;

    1107. 

  1107. 

    1108. 

  1108. //LOGGING

    1109. 

  1109. $POST_LOG = $_POST;

    1110. 

  1110. unset($POST_LOG['tables']);

    1111. 

  1111. unset($POST_LOG['plugins']);

    1112. 

  1112. unset($POST_LOG['dbpass']);

    1113. 

  1113. ksort($POST_LOG);

    1114. 

  1114. 

    1115. 

  1115. //GLOBAL DB-REPLACE

    1116. 

  1116. DupUtil::log("\n\n\n{$GLOBALS['SEPERATOR1']}");

    1117. 

  1117. DupUtil::log('DUPLICATOR INSTALL-LOG');

    1118. 

  1118. DupUtil::log('STEP2 START @ ' . @date('h:i:s') );

    1119. 

  1119. DupUtil::log('NOTICE: NOTICE: Do not post to public sites or forums');

    1120. 

  1120. DupUtil::log("{$GLOBALS['SEPERATOR1']}");

    1121. 

  1121. DupUtil::log("CHARSET SERVER:\t{$charset_server}"); 

    1122. 

  1122. DupUtil::log("CHARSET CLIENT:\t" . @mysqli_character_set_name($dbh)); 

    1123. 

  1123. DupUtil::log("--------------------------------------");	

    1124. 

  1124. DupUtil::log("POST DATA");	

    1125. 

  1125. DupUtil::log("--------------------------------------");	

    1126. 

  1126. DupUtil::log(print_r($POST_LOG, true));

    1127. 

  1127. 

    1128. 

  1128. DupUtil::log("--------------------------------------");

    1129. 

  1129. DupUtil::log("SCANNED TABLES");

    1130. 

  1130. DupUtil::log("--------------------------------------");	

    1131. 

  1131. $msg = (isset($_POST['tables']) && count($_POST['tables'] > 0)) ?  print_r($_POST['tables'], true) : 'No tables selected to update';

    1132. 

  1132. DupUtil::log($msg);

    1133. 

  1133. 

    1134. 

  1134. DupUtil::log("--------------------------------------");

    1135. 

  1135. DupUtil::log("KEEP PLUGINS ACTIVE");

    1136. 

  1136. DupUtil::log("--------------------------------------");	

    1137. 

  1137. $msg = (isset($_POST['plugins']) && count($_POST['plugins'] > 0)) ?  print_r($_POST['plugins'], true) : 'No plugins selected for activation';

    1138. 

  1138. DupUtil::log($msg);

    1139. 

  1139. 

    1140. 

  1140. 

    1141. 

  1141. //UPDATE SETTINGS

    1142. 

  1142. $serial_plugin_list = (isset($_POST['plugins']) && count($_POST['plugins'] > 0)) ? @serialize($_POST['plugins']) : '';

    1143. 

  1143. mysqli_query($dbh, "UPDATE `{$GLOBALS['FW_TABLEPREFIX']}options` SET option_value = '{$_POST['blogname']}' WHERE option_name = 'blogname' ");	

    1144. 

  1144. mysqli_query($dbh, "UPDATE `{$GLOBALS['FW_TABLEPREFIX']}options` SET option_value = '{$_POST['url_new']}'  WHERE option_name = 'home' ");	

    1145. 

  1145. mysqli_query($dbh, "UPDATE `{$GLOBALS['FW_TABLEPREFIX']}options` SET option_value = '{$_POST['siteurl']}'  WHERE option_name = 'siteurl' ");

    1146. 

  1146. mysqli_query($dbh, "UPDATE `{$GLOBALS['FW_TABLEPREFIX']}options` SET option_value = '{$serial_plugin_list}'  WHERE option_name = 'active_plugins' ");

    1147. 

  1147. 

    1148. 

  1148. DupUtil::log("--------------------------------------");

    1149. 

  1149. DupUtil::log("GLOBAL DB-REPLACE");

    1150. 

  1150. DupUtil::log("--------------------------------------");	

    1151. 

  1151. 

    1152. 

  1152. array_push($GLOBALS['REPLACE_LIST'], 

    1153. 

  1153. 	array('search' =>$_POST['url_old'],  'replace'=>$_POST['url_new']),

    1154. 

  1154. 	array('search' =>$_POST['path_old'], 'replace'=>$_POST['path_new']),

    1155. 

  1155. 	array('search' =>rtrim(DupUtil::unset_safe_path($_POST['path_old']), '\\'), 'replace'=>rtrim($_POST['path_new'], '/'))

    1156. 

  1156. ); 

    1157. 

  1157. 

    1158. 

  1158. @mysqli_autocommit($dbh, false);	

    1159. 

  1159. $report = DupDBTextSwap::load( $dbh, $GLOBALS['REPLACE_LIST'],  $_POST['tables'], $GLOBALS['TABLES_SKIP_COLS']);

    1160. 

  1160. @mysqli_commit($dbh);

    1161. 

  1161. @mysqli_autocommit($dbh, true);

    1162. 

  1162. 

    1163. 

  1163. 

    1164. 

  1164. //BUILD JSON RESPONSE

    1165. 

  1165. $JSON = array();

    1166. 

  1166. $JSON['step1'] = json_decode(urldecode($_POST['json']));

    1167. 

  1167. $JSON['step2'] = $report;

    1168. 

  1168. $JSON['step2']['warn_all'] = 0;

    1169. 

  1169. $JSON['step2']['warnlist'] = array();

    1170. 

  1170. 

    1171. 

  1171. DupDBTextSwap::log_stats($report);

    1172. 

  1172. DupDBTextSwap::log_errors($report);

    1173. 

  1173. 

    1174. 

  1174. //Reset the postguid data

    1175. 

  1175. if ($_POST['postguid']) {

    1176. 

  1176. 	mysqli_query($dbh, "UPDATE `{$GLOBALS['FW_TABLEPREFIX']}posts` SET guid = REPLACE(guid, '{$_POST['url_new']}', '{$_POST['url_old']}')");

    1177. 

  1177. 	$update_guid = @mysqli_affected_rows($dbh) or 0;

    1178. 

  1178. 	DupUtil::log("Reverted '{$update_guid}' post guid columns back to '{$_POST['url_old']}'");

    1179. 

  1179. }

    1180. 

  1180. 

    1181. 

  1181. 

    1182. 

  1182. //====================================================================================================

    1183. 

  1183. //FINAL CLEANUP

    1184. 

  1184. //====================================================================================================

    1185. 

  1185. DupUtil::log("\n{$GLOBALS['SEPERATOR1']}");

    1186. 

  1186. DupUtil::log('START FINAL CLEANUP: ' . @date('h:i:s') );

    1187. 

  1187. DupUtil::log("{$GLOBALS['SEPERATOR1']}");

    1188. 

  1188. 

    1189. 

  1189. $patterns = array("/'WP_HOME',\s*'.*?'/",

    1190. 

  1190. 				  "/'WP_SITEURL',\s*'.*?'/");

    1191. 

  1191. 				   

    1192. 

  1192. $replace = array("'WP_HOME', "		. '\''.$_POST['url_new'].'\'',

    1193. 

  1193. 				 "'WP_SITEURL', "  .  '\''.$_POST['url_new'].'\'');	

    1194. 

  1194. 				  

    1195. 

  1195. $config_file = @file_get_contents('wp-config.php', true);

    1196. 

  1196. $config_file = preg_replace($patterns, $replace, $config_file);

    1197. 

  1197. file_put_contents('wp-config.php', $config_file);

    1198. 

  1198. 

    1199. 

  1199. 

    1200. 

  1200. //Create Snapshots directory

    1201. 

  1201. if(!file_exists(DUPLICATOR_SSDIR_NAME)) {

    1202. 

  1202. 	mkdir(DUPLICATOR_SSDIR_NAME, 0755);

    1203. 

  1203. }

    1204. 

  1204. $fp = fopen(DUPLICATOR_SSDIR_NAME . '/index.php', 'w');

    1205. 

  1205. fclose($fp);

    1206. 

  1206. 

    1207. 

  1207. 

    1208. 

  1208. //WEB CONFIG FILE

    1209. 

  1209. $currdata = parse_url($_POST['url_old']); 

    1210. 

  1210. $newdata  = parse_url($_POST['url_new']);

    1211. 

  1211. $currpath = DupUtil::add_slash(isset($currdata['path']) ? $currdata['path'] : "");

    1212. 

  1212. $newpath  = DupUtil::add_slash(isset($newdata['path'])  ? $newdata['path']  : "");

    1213. 

  1213. 

    1214. 

  1214. if ($currpath != $newpath) {

    1215. 

  1215. 	DupUtil::log("HTACCESS CHANGES:");

    1216. 

  1216. 	@copy('.htaccess', '.htaccess.orig');

    1217. 

  1217. 	@copy('web.config', 'web.config.orig');

    1218. 

  1218. 	@unlink('.htaccess');

    1219. 

  1219. 	@unlink('web.config');

    1220. 

  1220. 	DupUtil::log("created backup of original .htaccess to htaccess.orig and web.config to web…
    1221.

Large files files are truncated, but you can click here to view the full file