/wp-content/plugins/all-in-one-wp-migration/lib/model/import/class-ai1wm-import-database.php

https://gitlab.com/vanafroo/landingpage · PHP · 466 lines · 265 code · 92 blank · 109 comment · 62 complexity · 70f7ba30d3195c8cdb05103255b9bb1d MD5 · raw file 

    

  1. <?php
    2. 

  2. /**
    3. 

  3.  * Copyright (C) 2014-2016 ServMask Inc.
    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 as published by
    7. 

  7.  * the Free Software Foundation, either version 3 of the License, or
    8. 

  8.  * (at your option) any later version.
    9. 

  9.  *
    10. 

  10.  * This program is distributed in the hope that it will be useful,
    11. 

  11.  * but WITHOUT ANY WARRANTY; without even the implied warranty of
    12. 

  12.  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    13. 

  13.  * GNU General Public License for more details.
    14. 

  14.  *
    15. 

  15.  * You should have received a copy of the GNU General Public License
    16. 

  16.  * along with this program.  If not, see <http://www.gnu.org/licenses/>.
    17. 

  17.  *
    18. 

  18.  * ███████╗███████╗██████╗ ██╗   ██╗███╗   ███╗ █████╗ ███████╗██╗  ██╗
    19. 

  19.  * ██╔════╝██╔════╝██╔══██╗██║   ██║████╗ ████║██╔══██╗██╔════╝██║ ██╔╝
    20. 

  20.  * ███████╗█████╗  ██████╔╝██║   ██║██╔████╔██║███████║███████╗█████╔╝
    21. 

  21.  * ╚════██║██╔══╝  ██╔══██╗╚██╗ ██╔╝██║╚██╔╝██║██╔══██║╚════██║██╔═██╗
    22. 

  22.  * ███████║███████╗██║  ██║ ╚████╔╝ ██║ ╚═╝ ██║██║  ██║███████║██║  ██╗
    23. 

  23.  * ╚══════╝╚══════╝╚═╝  ╚═╝  ╚═══╝  ╚═╝     ╚═╝╚═╝  ╚═╝╚══════╝╚═╝  ╚═╝
    24. 

  24.  */
    25. 

  25. 

  26. class Ai1wm_Import_Database {
    27. 

  27. 

  28. 	public static function execute( $params ) {
    29. 

  29. 		global $wpdb;
    30. 

  30. 

  31. 		// Skip database import
    32. 

  32. 		if ( ! is_file( ai1wm_database_path( $params ) ) ) {
    33. 

  33. 			return $params;
    34. 

  34. 		}
    35. 

  35. 

  36. 		// Read blogs.json file
    37. 

  37. 		$handle = fopen( ai1wm_blogs_path( $params ), 'r' );
    38. 

  38. 		if ( $handle === false ) {
    39. 

  39. 			throw new Ai1wm_Import_Exception( 'Unable to read blogs.json file' );
    40. 

  40. 		}
    41. 

  41. 

  42. 		// Parse blogs.json file
    43. 

  43. 		$blogs = fread( $handle, filesize( ai1wm_blogs_path( $params ) ) );
    44. 

  44. 		$blogs = json_decode( $blogs );
    45. 

  45. 

  46. 		// Close handle
    47. 

  47. 		fclose( $handle );
    48. 

  48. 

  49. 		// Read package.json file
    50. 

  50. 		$handle = fopen( ai1wm_package_path( $params ), 'r' );
    51. 

  51. 		if ( $handle === false ) {
    52. 

  52. 			throw new Ai1wm_Import_Exception( 'Unable to read package.json file' );
    53. 

  53. 		}
    54. 

  54. 

  55. 		// Parse package.json file
    56. 

  56. 		$config = fread( $handle, filesize( ai1wm_package_path( $params ) ) );
    57. 

  57. 		$config = json_decode( $config );
    58. 

  58. 

  59. 		// Close handle
    60. 

  60. 		fclose( $handle );
    61. 

  61. 

  62. 		// Set progress
    63. 

  63. 		Ai1wm_Status::info( __( 'Restoring database...', AI1WM_PLUGIN_NAME ) );
    64. 

  64. 

  65. 		$old_values = array();
    66. 

  66. 		$new_values = array();
    67. 

  67. 

  68. 		// Get Blog URLs
    69. 

  69. 		foreach ( $blogs as $blog ) {
    70. 

  70. 

  71. 			// Get blogs dir Upload Path
    72. 

  72. 			if ( ! in_array( sprintf( "'%s'", trim( ai1wm_blogsdir_path( $blog->Old->Id ), '/' ) ), $old_values ) ) {
    73. 

  73. 				$old_values[] = sprintf( "'%s'", trim( ai1wm_blogsdir_path( $blog->Old->Id ), '/' ) );
    74. 

  74. 				$new_values[] = sprintf( "'%s'", get_option( 'upload_path' ) );
    75. 

  75. 			}
    76. 

  76. 

  77. 			// Get sites Upload Path
    78. 

  78. 			if ( ! in_array( sprintf( "'%s'", trim( ai1wm_uploads_path( $blog->Old->Id ), '/' ) ), $old_values ) ) {
    79. 

  79. 				$old_values[] = sprintf( "'%s'", trim( ai1wm_uploads_path( $blog->Old->Id ), '/' ) );
    80. 

  80. 				$new_values[] = sprintf( "'%s'", get_option( 'upload_path' ) );
    81. 

  81. 			}
    82. 

  82. 

  83. 			// Handle old and new sites dir style
    84. 

  84. 			if ( defined( 'UPLOADBLOGSDIR' ) ) {
    85. 

  85. 

  86. 				// Get Upload Path
    87. 

  87. 				if ( ! in_array( ai1wm_blogsdir_path( $blog->Old->Id ), $old_values ) ) {
    88. 

  88. 					$old_values[] = ai1wm_blogsdir_path( $blog->Old->Id );
    89. 

  89. 					$new_values[] = ai1wm_blogsdir_path( $blog->New->Id );
    90. 

  90. 				}
    91. 

  91. 

  92. 				// Get escaped Upload Path
    93. 

  93. 				if ( ! in_array( addslashes( addcslashes( ai1wm_blogsdir_path( $blog->Old->Id ), '\/' ) ), $old_values ) ) {
    94. 

  94. 					$old_values[] = addslashes( addcslashes( ai1wm_blogsdir_path( $blog->Old->Id ), '\/' ) );
    95. 

  95. 					$new_values[] = addslashes( addcslashes( ai1wm_blogsdir_path( $blog->New->Id ), '\/' ) );
    96. 

  96. 				}
    97. 

  97. 

  98. 				// Get Upload Path
    99. 

  99. 				if ( ! in_array( ai1wm_uploads_path( $blog->Old->Id ), $old_values ) ) {
    100. 

  100. 					$old_values[] = ai1wm_uploads_path( $blog->Old->Id );
    101. 

  101. 					$new_values[] = ai1wm_blogsdir_path( $blog->New->Id );
    102. 

  102. 				}
    103. 

  103. 

  104. 				// Get escaped Upload Path
    105. 

  105. 				if ( ! in_array( addslashes( addcslashes( ai1wm_uploads_path( $blog->Old->Id ), '\/' ) ), $old_values ) ) {
    106. 

  106. 					$old_values[] = addslashes( addcslashes( ai1wm_uploads_path( $blog->Old->Id ), '\/' ) );
    107. 

  107. 					$new_values[] = addslashes( addcslashes( ai1wm_blogsdir_path( $blog->New->Id ), '\/' ) );
    108. 

  108. 				}
    109. 

  109. 

  110. 			} else {
    111. 

  111. 

  112. 				// Get Upload Path
    113. 

  113. 				if ( ! in_array( ai1wm_blogsdir_path( $blog->Old->Id ), $old_values ) ) {
    114. 

  114. 					$old_values[] = ai1wm_blogsdir_path( $blog->Old->Id );
    115. 

  115. 					$new_values[] = ai1wm_uploads_path( $blog->New->Id );
    116. 

  116. 				}
    117. 

  117. 

  118. 				// Get escaped Upload Path
    119. 

  119. 				if ( ! in_array( addslashes( addcslashes( ai1wm_blogsdir_path( $blog->Old->Id ), '\/' ) ), $old_values ) ) {
    120. 

  120. 					$old_values[] = addslashes( addcslashes( ai1wm_blogsdir_path( $blog->Old->Id ), '\/' ) );
    121. 

  121. 					$new_values[] = addslashes( addcslashes( ai1wm_uploads_path( $blog->New->Id ), '\/' ) );
    122. 

  122. 				}
    123. 

  123. 

  124. 				// Get Upload Path
    125. 

  125. 				if ( ! in_array( ai1wm_uploads_path( $blog->Old->Id ), $old_values ) ) {
    126. 

  126. 					$old_values[] = ai1wm_uploads_path( $blog->Old->Id );
    127. 

  127. 					$new_values[] = ai1wm_uploads_path( $blog->New->Id );
    128. 

  128. 				}
    129. 

  129. 

  130. 				// Get escaped Upload Path
    131. 

  131. 				if ( ! in_array( addslashes( addcslashes( ai1wm_uploads_path( $blog->Old->Id ), '\/' ) ), $old_values ) ) {
    132. 

  132. 					$old_values[] = addslashes( addcslashes( ai1wm_uploads_path( $blog->Old->Id ), '\/' ) );
    133. 

  133. 					$new_values[] = addslashes( addcslashes( ai1wm_uploads_path( $blog->New->Id ), '\/' ) );
    134. 

  134. 				}
    135. 

  135. 			}
    136. 

  136. 

  137. 			// Get Site URL
    138. 

  138. 			if ( isset( $blog->Old->SiteURL ) && ( $blog->Old->SiteURL !== $blog->New->SiteURL ) ) {
    139. 

  139. 

  140. 				// Get domain
    141. 

  141. 				$old_domain = parse_url( $blog->Old->SiteURL, PHP_URL_HOST );
    142. 

  142. 				$new_domain = parse_url( $blog->New->SiteURL, PHP_URL_HOST );
    143. 

  143. 

  144. 				// Get scheme
    145. 

  145. 				$new_scheme = parse_url( $blog->New->SiteURL, PHP_URL_SCHEME );
    146. 

  146. 

  147. 				// Replace Site URL scheme
    148. 

  148. 				foreach ( array( 'http', 'https' ) as $old_scheme ) {
    149. 

  149. 

  150. 					// Add plain Site URL
    151. 

  151. 					if ( ! in_array( set_url_scheme( $blog->Old->SiteURL, $old_scheme ), $old_values ) ) {
    152. 

  152. 						$old_values[] = set_url_scheme( $blog->Old->SiteURL, $old_scheme );
    153. 

  153. 						$new_values[] = set_url_scheme( $blog->New->SiteURL, $new_scheme );
    154. 

  154. 					}
    155. 

  155. 

  156. 					// Add encoded Site URL
    157. 

  157. 					if ( ! in_array( urlencode( set_url_scheme( $blog->Old->SiteURL, $old_scheme ) ), $old_values ) ) {
    158. 

  158. 						$old_values[] = urlencode( set_url_scheme( $blog->Old->SiteURL, $old_scheme ) );
    159. 

  159. 						$new_values[] = urlencode( set_url_scheme( $blog->New->SiteURL, $new_scheme ) );
    160. 

  160. 					}
    161. 

  161. 

  162. 					// Add escaped Site URL
    163. 

  163. 					if ( ! in_array( addslashes( addcslashes( set_url_scheme( $blog->Old->SiteURL, $old_scheme ), '/' ) ), $old_values ) ) {
    164. 

  164. 						$old_values[] = addslashes( addcslashes( set_url_scheme( $blog->Old->SiteURL, $old_scheme ), '/' ) );
    165. 

  165. 						$new_values[] = addslashes( addcslashes( set_url_scheme( $blog->New->SiteURL, $new_scheme ), '/' ) );
    166. 

  166. 					}
    167. 

  167. 				}
    168. 

  168. 

  169. 				// Add email
    170. 

  170. 				if ( ! isset( $config->NoEmailReplace ) ) {
    171. 

  171. 					if ( ! in_array( sprintf( "@%s", $old_domain ), $old_values ) ) {
    172. 

  172. 						$old_values[] = sprintf( "@%s", $old_domain );
    173. 

  173. 						$new_values[] = sprintf( "@%s", $new_domain );
    174. 

  174. 					}
    175. 

  175. 				}
    176. 

  176. 			}
    177. 

  177. 

  178. 			// Get Home URL
    179. 

  179. 			if ( isset( $blog->Old->HomeURL ) && ( $blog->Old->HomeURL !== $blog->New->HomeURL ) ) {
    180. 

  180. 

  181. 				// Get domain
    182. 

  182. 				$old_domain = parse_url( $blog->Old->HomeURL, PHP_URL_HOST );
    183. 

  183. 				$new_domain = parse_url( $blog->New->HomeURL, PHP_URL_HOST );
    184. 

  184. 

  185. 				// Get scheme
    186. 

  186. 				$new_scheme = parse_url( $blog->New->HomeURL, PHP_URL_SCHEME );
    187. 

  187. 

  188. 				// Replace Home URL scheme
    189. 

  189. 				foreach ( array( 'http', 'https' ) as $old_scheme ) {
    190. 

  190. 

  191. 					// Add plain Home URL
    192. 

  192. 					if ( ! in_array( set_url_scheme( $blog->Old->HomeURL, $old_scheme ), $old_values ) ) {
    193. 

  193. 						$old_values[] = set_url_scheme( $blog->Old->HomeURL, $old_scheme );
    194. 

  194. 						$new_values[] = set_url_scheme( $blog->New->HomeURL, $new_scheme );
    195. 

  195. 					}
    196. 

  196. 

  197. 					// Add encoded Home URL
    198. 

  198. 					if ( ! in_array( urlencode( set_url_scheme( $blog->Old->HomeURL, $old_scheme ) ), $old_values ) ) {
    199. 

  199. 						$old_values[] = urlencode( set_url_scheme( $blog->Old->HomeURL, $old_scheme ) );
    200. 

  200. 						$new_values[] = urlencode( set_url_scheme( $blog->New->HomeURL, $new_scheme ) );
    201. 

  201. 					}
    202. 

  202. 

  203. 					// Add escaped Home URL
    204. 

  204. 					if ( ! in_array( addslashes( addcslashes( set_url_scheme( $blog->Old->HomeURL, $old_scheme ), '/' ) ), $old_values ) ) {
    205. 

  205. 						$old_values[] = addslashes( addcslashes( set_url_scheme( $blog->Old->HomeURL, $old_scheme ), '/' ) );
    206. 

  206. 						$new_values[] = addslashes( addcslashes( set_url_scheme( $blog->New->HomeURL, $new_scheme ), '/' ) );
    207. 

  207. 					}
    208. 

  208. 				}
    209. 

  209. 

  210. 				// Add email
    211. 

  211. 				if ( ! isset( $config->NoEmailReplace ) ) {
    212. 

  212. 					if ( ! in_array( sprintf( "@%s", $old_domain ), $old_values ) ) {
    213. 

  213. 						$old_values[] = sprintf( "@%s", $old_domain );
    214. 

  214. 						$new_values[] = sprintf( "@%s", $new_domain );
    215. 

  215. 					}
    216. 

  216. 				}
    217. 

  217. 			}
    218. 

  218. 		}
    219. 

  219. 

  220. 		// Get Site URL
    221. 

  221. 		if ( isset( $config->SiteURL ) && ( $config->SiteURL !== site_url() ) ) {
    222. 

  222. 

  223. 			// Get www URL
    224. 

  224. 			if ( stripos( $config->SiteURL, '//www.' ) !== false ) {
    225. 

  225. 				$www = str_ireplace( '//www.', '//', $config->SiteURL );
    226. 

  226. 			} else {
    227. 

  227. 				$www = str_ireplace( '//', '//www.', $config->SiteURL );
    228. 

  228. 			}
    229. 

  229. 

  230. 			// Replace Site URL
    231. 

  231. 			foreach ( array( $config->SiteURL, $www ) as $url ) {
    232. 

  232. 

  233. 				// Get domain
    234. 

  234. 				$old_domain = parse_url( $url, PHP_URL_HOST );
    235. 

  235. 				$new_domain = parse_url( site_url(), PHP_URL_HOST );
    236. 

  236. 

  237. 				// Get path
    238. 

  238. 				$old_path = parse_url( $url, PHP_URL_PATH );
    239. 

  239. 				$new_path = parse_url( site_url(), PHP_URL_PATH );
    240. 

  240. 

  241. 				// Get scheme
    242. 

  242. 				$new_scheme = parse_url( site_url(), PHP_URL_SCHEME );
    243. 

  243. 

  244. 				// Add domain and path
    245. 

  245. 				if ( ! in_array( sprintf( "%s','%s", $old_domain, trailingslashit( $old_path ) ), $old_values ) ) {
    246. 

  246. 					$old_values[] = sprintf( "%s','%s", $old_domain, trailingslashit( $old_path ) );
    247. 

  247. 					$new_values[] = sprintf( "%s','%s", $new_domain, trailingslashit( $new_path ) );
    248. 

  248. 				}
    249. 

  249. 

  250. 				// Replace Site URL scheme
    251. 

  251. 				foreach ( array( 'http', 'https' ) as $old_scheme ) {
    252. 

  252. 

  253. 					// Add plain Site URL
    254. 

  254. 					if ( ! in_array( set_url_scheme( $url, $old_scheme ), $old_values ) ) {
    255. 

  255. 						$old_values[] = set_url_scheme( $url, $old_scheme );
    256. 

  256. 						$new_values[] = set_url_scheme( site_url(), $new_scheme );
    257. 

  257. 					}
    258. 

  258. 

  259. 					// Add encoded Site URL
    260. 

  260. 					if ( ! in_array( urlencode( set_url_scheme( $url, $old_scheme ) ), $old_values ) ) {
    261. 

  261. 						$old_values[] = urlencode( set_url_scheme( $url, $old_scheme ) );
    262. 

  262. 						$new_values[] = urlencode( set_url_scheme( site_url(), $new_scheme ) );
    263. 

  263. 					}
    264. 

  264. 

  265. 					// Add escaped Site URL
    266. 

  266. 					if ( ! in_array( addslashes( addcslashes( set_url_scheme( $url, $old_scheme ), '/' ) ), $old_values ) ) {
    267. 

  267. 						$old_values[] = addslashes( addcslashes( set_url_scheme( $url, $old_scheme ), '/' ) );
    268. 

  268. 						$new_values[] = addslashes( addcslashes( set_url_scheme( site_url(), $new_scheme ), '/' ) );
    269. 

  269. 					}
    270. 

  270. 				}
    271. 

  271. 

  272. 				// Add email
    273. 

  273. 				if ( ! isset( $config->NoEmailReplace ) ) {
    274. 

  274. 					if ( ! in_array( sprintf( "@%s", $old_domain ), $old_values ) ) {
    275. 

  275. 						$old_values[] = sprintf( "@%s", $old_domain );
    276. 

  276. 						$new_values[] = sprintf( "@%s", $new_domain );
    277. 

  277. 					}
    278. 

  278. 				}
    279. 

  279. 			}
    280. 

  280. 		}
    281. 

  281. 

  282. 		// Get Home URL
    283. 

  283. 		if ( isset( $config->HomeURL ) && ( $config->HomeURL !== home_url() ) ) {
    284. 

  284. 

  285. 			// Get www URL
    286. 

  286. 			if ( stripos( $config->HomeURL, '//www.' ) !== false ) {
    287. 

  287. 				$www = str_ireplace( '//www.', '//', $config->HomeURL );
    288. 

  288. 			} else {
    289. 

  289. 				$www = str_ireplace( '//', '//www.', $config->HomeURL );
    290. 

  290. 			}
    291. 

  291. 

  292. 			// Replace Home URL
    293. 

  293. 			foreach ( array( $config->HomeURL, $www ) as $url ) {
    294. 

  294. 

  295. 				// Get domain
    296. 

  296. 				$old_domain = parse_url( $url, PHP_URL_HOST );
    297. 

  297. 				$new_domain = parse_url( home_url(), PHP_URL_HOST );
    298. 

  298. 

  299. 				// Get path
    300. 

  300. 				$old_path = parse_url( $url, PHP_URL_PATH );
    301. 

  301. 				$new_path = parse_url( home_url(), PHP_URL_PATH );
    302. 

  302. 

  303. 				// Get scheme
    304. 

  304. 				$new_scheme = parse_url( home_url(), PHP_URL_SCHEME );
    305. 

  305. 

  306. 				// Add domain and path
    307. 

  307. 				if ( ! in_array( sprintf( "%s','%s", $old_domain, trailingslashit( $old_path ) ), $old_values ) ) {
    308. 

  308. 					$old_values[] = sprintf( "%s','%s", $old_domain, trailingslashit( $old_path ) );
    309. 

  309. 					$new_values[] = sprintf( "%s','%s", $new_domain, trailingslashit( $new_path ) );
    310. 

  310. 				}
    311. 

  311. 

  312. 				// Replace Home URL scheme
    313. 

  313. 				foreach ( array( 'http', 'https' ) as $old_scheme ) {
    314. 

  314. 

  315. 					// Add plain Home URL
    316. 

  316. 					if ( ! in_array( set_url_scheme( $url, $old_scheme ), $old_values ) ) {
    317. 

  317. 						$old_values[] = set_url_scheme( $url, $old_scheme );
    318. 

  318. 						$new_values[] = set_url_scheme( home_url(), $new_scheme );
    319. 

  319. 					}
    320. 

  320. 

  321. 					// Add encoded Home URL
    322. 

  322. 					if ( ! in_array( urlencode( set_url_scheme( $url, $old_scheme ) ), $old_values ) ) {
    323. 

  323. 						$old_values[] = urlencode( set_url_scheme( $url, $old_scheme ) );
    324. 

  324. 						$new_values[] = urlencode( set_url_scheme( home_url(), $new_scheme ) );
    325. 

  325. 					}
    326. 

  326. 

  327. 					// Add escaped Home URL
    328. 

  328. 					if ( ! in_array( addslashes( addcslashes( set_url_scheme( $url, $old_scheme ), '/' ) ), $old_values ) ) {
    329. 

  329. 						$old_values[] = addslashes( addcslashes( set_url_scheme( $url, $old_scheme ), '/' ) );
    330. 

  330. 						$new_values[] = addslashes( addcslashes( set_url_scheme( home_url(), $new_scheme ), '/' ) );
    331. 

  331. 					}
    332. 

  332. 				}
    333. 

  333. 

  334. 				// Add email
    335. 

  335. 				if ( ! isset( $config->NoEmailReplace ) ) {
    336. 

  336. 					if ( ! in_array( sprintf( "@%s", $old_domain ), $old_values ) ) {
    337. 

  337. 						$old_values[] = sprintf( "@%s", $old_domain );
    338. 

  338. 						$new_values[] = sprintf( "@%s", $new_domain );
    339. 

  339. 					}
    340. 

  340. 				}
    341. 

  341. 			}
    342. 

  342. 		}
    343. 

  343. 

  344. 		// Get WordPress Content
    345. 

  345. 		if ( isset( $config->WordPress->Content ) && ( $config->WordPress->Content !== WP_CONTENT_DIR ) ) {
    346. 

  346. 

  347. 			// Add plain WordPress Content
    348. 

  348. 			if ( ! in_array( $config->WordPress->Content, $old_values ) ) {
    349. 

  349. 				$old_values[] = $config->WordPress->Content;
    350. 

  350. 				$new_values[] = WP_CONTENT_DIR;
    351. 

  351. 			}
    352. 

  352. 

  353. 			// Add encoded WordPress Content
    354. 

  354. 			if ( ! in_array( urlencode( $config->WordPress->Content ), $old_values ) ) {
    355. 

  355. 				$old_values[] = urlencode( $config->WordPress->Content );
    356. 

  356. 				$new_values[] = urlencode( WP_CONTENT_DIR );
    357. 

  357. 			}
    358. 

  358. 

  359. 			// Add escaped WordPress Content
    360. 

  360. 			if ( ! in_array( addslashes( addcslashes( $config->WordPress->Content, '\/' ) ), $old_values ) ) {
    361. 

  361. 				$old_values[] = addslashes( addcslashes( $config->WordPress->Content, '\/' ) );
    362. 

  362. 				$new_values[] = addslashes( addcslashes( WP_CONTENT_DIR, '\/' ) );
    363. 

  363. 			}
    364. 

  364. 		}
    365. 

  365. 

  366. 		// Get URL IP
    367. 

  367. 		$url_ip = get_option( AI1WM_URL_IP );
    368. 

  368. 

  369. 		// Get URL adapter
    370. 

  370. 		$url_adapter = get_option( AI1WM_URL_ADAPTER );
    371. 

  371. 

  372. 		// Get secret key
    373. 

  373. 		$secret_key = get_option( AI1WM_SECRET_KEY );
    374. 

  374. 

  375. 		// Get HTTP user
    376. 

  376. 		$auth_user = get_option( AI1WM_AUTH_USER );
    377. 

  377. 

  378. 		// Get HTTP password
    379. 

  379. 		$auth_password = get_option( AI1WM_AUTH_PASSWORD );
    380. 

  380. 

  381. 		// Get active ServMask plugins
    382. 

  382. 		$active_servmask_plugins = ai1wm_active_servmask_plugins();
    383. 

  383. 

  384. 		$old_prefixes = array();
    385. 

  385. 		$new_prefixes = array();
    386. 

  386. 

  387. 		// Set main table prefixes
    388. 

  388. 		$old_prefixes[] = ai1wm_servmask_prefix( 'mainsite' );
    389. 

  389. 		$new_prefixes[] = ai1wm_table_prefix();
    390. 

  390. 

  391. 		// Set site table prefixes
    392. 

  392. 		foreach ( $blogs as $blog ) {
    393. 

  393. 			if ( ai1wm_main_site( $blog->Old->Id ) === false ) {
    394. 

  394. 				$old_prefixes[] = ai1wm_servmask_prefix( $blog->Old->Id );
    395. 

  395. 				$new_prefixes[] = ai1wm_table_prefix( $blog->New->Id );
    396. 

  396. 			}
    397. 

  397. 		}
    398. 

  398. 

  399. 		// Set base table prefixes
    400. 

  400. 		foreach ( $blogs as $blog ) {
    401. 

  401. 			if ( ai1wm_main_site( $blog->Old->Id ) === true ) {
    402. 

  402. 				$old_prefixes[] = ai1wm_servmask_prefix( 'basesite' );
    403. 

  403. 				$new_prefixes[] = ai1wm_table_prefix( $blog->New->Id );
    404. 

  404. 			}
    405. 

  405. 		}
    406. 

  406. 

  407. 		// Set site table prefixes
    408. 

  408. 		foreach ( $blogs as $blog ) {
    409. 

  409. 			if ( ai1wm_main_site( $blog->Old->Id ) === true ) {
    410. 

  410. 				$old_prefixes[] = ai1wm_servmask_prefix( $blog->Old->Id );
    411. 

  411. 				$new_prefixes[] = ai1wm_table_prefix( $blog->New->Id );
    412. 

  412. 			}
    413. 

  413. 		}
    414. 

  414. 

  415. 		// Set table prefixes
    416. 

  416. 		$old_prefixes[] = ai1wm_servmask_prefix();
    417. 

  417. 		$new_prefixes[] = ai1wm_table_prefix();
    418. 

  418. 

  419. 		// Get database client
    420. 

  420. 		if ( empty( $wpdb->use_mysqli ) ) {
    421. 

  421. 			$client = new Ai1wm_Database_Mysql( $wpdb );
    422. 

  422. 		} else {
    423. 

  423. 			$client = new Ai1wm_Database_Mysqli( $wpdb );
    424. 

  424. 		}
    425. 

  425. 

  426. 		// Set database options
    427. 

  427. 		$client->set_old_table_prefixes( $old_prefixes )
    428. 

  428. 			   ->set_new_table_prefixes( $new_prefixes )
    429. 

  429. 			   ->set_old_replace_values( $old_values )
    430. 

  430. 			   ->set_new_replace_values( $new_values );
    431. 

  431. 

  432. 		// Flush database
    433. 

  433. 		if ( ( $version = $config->Plugin->Version ) ) {
    434. 

  434. 			if ( $version !== 'develop' && version_compare( $version, '4.10', '<' ) ) {
    435. 

  435. 				$client->set_include_table_prefixes( array( ai1wm_table_prefix() ) );
    436. 

  436. 				$client->flush();
    437. 

  437. 			}
    438. 

  438. 		}
    439. 

  439. 

  440. 		// Import database
    441. 

  441. 		$client->import( ai1wm_database_path( $params ) );
    442. 

  442. 

  443. 		// Flush WP cache
    444. 

  444. 		ai1wm_cache_flush();
    445. 

  445. 

  446. 		// Activate plugins
    447. 

  447. 		activate_plugins( $active_servmask_plugins, null, is_multisite() );
    448. 

  448. 

  449. 		// Set the new URL IP
    450. 

  450. 		update_option( AI1WM_URL_IP, $url_ip );
    451. 

  451. 

  452. 		// Set the new URL adapter
    453. 

  453. 		update_option( AI1WM_URL_ADAPTER, $url_adapter );
    454. 

  454. 

  455. 		// Set the new secret key value
    456. 

  456. 		update_option( AI1WM_SECRET_KEY, $secret_key );
    457. 

  457. 

  458. 		// Set the new HTTP user
    459. 

  459. 		update_option( AI1WM_AUTH_USER, $auth_user );
    460. 

  460. 

  461. 		// Set the new HTTP password
    462. 

  462. 		update_option( AI1WM_AUTH_PASSWORD, $auth_password );
    463. 

  463. 

  464. 		return $params;
    465. 

  465. 	}
    466. 

  466. }
    467.