<h2>File Contents: /home/planet5/www/yogitonics.com/wp-content/plugins/updraftplus/includes/class-search-replace.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/www/yogitonics.com/wp-content/plugins/updraftplus/includes/class-search-replace.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
// phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery -- Direct $wpdb query is required for this operation.
// phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching -- some query operations need to always receive the most up-to-date or actual data directly from the database, reducing the risk of serving stale information.
if (!defined(&#039;ABSPATH&#039;)) die(&#039;No direct access allowed&#039;);

class UpdraftPlus_Search_Replace {

	private $columns = array();

	private $current_row = 0;

	private $use_wpdb = false;

	private $use_mysqli = false;

	private $wpdb_obj = null;

	private $mysql_dbh = null;

	protected $max_recursion = 0;
	
	/**
	 * Constructor
	 */
	public function __construct() {
		add_action(&#039;updraftplus_restore_db_pre&#039;, array($this, &#039;updraftplus_restore_db_pre&#039;));
		$this-&gt;max_recursion = apply_filters(&#039;updraftplus_search_replace_max_recursion&#039;, 20);
	}

	/**
	 * This function is called via the filter updraftplus_restore_db_pre it sets up the search and replace database objects
	 *
	 * @return void
	 */
	public function updraftplus_restore_db_pre() {
		global $wpdb, $updraftplus_restorer;
		
		$this-&gt;use_wpdb = $updraftplus_restorer-&gt;use_wpdb();
		$this-&gt;wpdb_obj = $wpdb;

		$mysql_dbh = false;
		$use_mysqli = false;

		if (!$this-&gt;use_wpdb) {
			// We have our own extension which drops lots of the overhead on the query
			$wpdb_obj = $updraftplus_restorer-&gt;get_db_object();
			// Was that successful?
			if (!$wpdb_obj-&gt;is_mysql || !$wpdb_obj-&gt;ready) {
				$this-&gt;use_wpdb = true;
			} else {
				$this-&gt;wpdb_obj = $wpdb_obj;
				$mysql_dbh = $wpdb_obj-&gt;updraftplus_get_database_handle();
				$use_mysqli = $wpdb_obj-&gt;updraftplus_use_mysqli();
			}
		}

		$this-&gt;mysql_dbh = $mysql_dbh;
		$this-&gt;use_mysqli = $use_mysqli;
	}

	/**
	 * The engine
	 *
	 * @param string|array $search    - a string or array of things to search for
	 * @param string|array $replace   - a string or array of things to replace the search terms with
	 * @param array        $tables    - an array of tables
	 * @param integer      $page_size - the page size
	 */
	public function icit_srdb_replacer($search, $replace, $tables, $page_size) {

		if (!is_array($tables)) return false;

		global $wpdb, $updraftplus;

		$report = array(
			&#039;tables&#039; =&gt; 0,
			&#039;rows&#039; =&gt; 0,
			&#039;change&#039; =&gt; 0,
			&#039;updates&#039; =&gt; 0,
			&#039;start&#039; =&gt; microtime(true),
			&#039;end&#039; =&gt; microtime(true),
			&#039;errors&#039; =&gt; array(),
		);

		$page_size = (empty($page_size) || !is_numeric($page_size)) ? 5000 : $page_size;

		foreach ($tables as $table =&gt; $stripped_table) {

			$report[&#039;tables&#039;]++;

			if ($search === $replace) {
				$updraftplus-&gt;log(&quot;No search/replace required: would-be search and replacement are identical&quot;);
				continue;
			}

			$this-&gt;columns = array();

			$print_line = __(&#039;Search and replacing table:&#039;, &#039;updraftplus&#039;).&#039; &#039;.$table;

			$updraftplus-&gt;check_db_connection($this-&gt;wpdb_obj, true);

			// Get a list of columns in this table
			// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- DESCRIBE is a DDL command that cannot be parameterized; $table is a SQL identifier sanitized using backquote().
			$fields = $wpdb-&gt;get_results(&#039;DESCRIBE &#039;.UpdraftPlus_Manipulation_Functions::backquote($table), ARRAY_A);

			$prikey_field = false;
			foreach ($fields as $column) {
				$primary_key = (&#039;PRI&#039; == $column[&#039;Key&#039;]) ? true : false;
				if ($primary_key) $prikey_field = $column[&#039;Field&#039;];
				if (&#039;posts&#039; == $stripped_table &amp;&amp; &#039;guid&#039; == $column[&#039;Field&#039;]) {
					$updraftplus-&gt;log(&#039;Skipping search/replace on GUID column in posts table&#039;);
					continue;
				}
				$this-&gt;columns[$column[&#039;Field&#039;]] = $primary_key;
			}

			// Count the number of rows we have in the table if large we&#039;ll split into blocks, This is a mod from Simon Wheatley

			// InnoDB does not do count(*) quickly. You can use an index for more speed - see: http://www.cloudspace.com/blog/2009/08/06/fast-mysql-innodb-count-really-fast/

			$where = &#039;&#039;;
			// Opportunity to use internal knowledge on tables which may be huge
			if (&#039;postmeta&#039; == $stripped_table &amp;&amp; ((is_array($search) &amp;&amp; 0 === strpos($search[0], &#039;http&#039;)) || (is_string($search) &amp;&amp; 0 === strpos($search, &#039;http&#039;)))) {
				$where = &quot; WHERE meta_value LIKE &#039;%http%&#039;&quot;;
			}

			$count_rows_sql = &#039;SELECT COUNT(*) FROM &#039;.$table;
			if ($prikey_field) $count_rows_sql .= &quot; USE INDEX (PRIMARY)&quot;;
			$count_rows_sql .= $where;

			// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- $count_rows_sql is constructed from safe table identifiers; SQL identifiers cannot be parameterized with $wpdb-&gt;prepare().
			$row_countr = $wpdb-&gt;get_results($count_rows_sql, ARRAY_N);

			// If that failed, try this
			if (false !== $prikey_field &amp;&amp; $wpdb-&gt;last_error) {
				$escaped_table_name = UpdraftPlus_Database_Utility::escape_table_name($table);
				// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- $escaped_table_name and $prikey_field are SQL identifiers; identifiers cannot be parameterized with $wpdb-&gt;prepare(), table name is safely escaped via escape_table_name().
				$row_countr = $wpdb-&gt;get_results(&quot;SELECT COUNT(*) FROM $escaped_table_name USE INDEX ($prikey_field)&quot;.$where, ARRAY_N);
				// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- Table name is safely escaped via escape_table_name().
				if ($wpdb-&gt;last_error) $row_countr = $wpdb-&gt;get_results(&quot;SELECT COUNT(*) FROM $escaped_table_name&quot;, ARRAY_N);
			}

			$row_count = $row_countr[0][0];
			/* translators: %d: Number of rows. */
			$print_line .= &#039;: &#039;.sprintf(__(&#039;rows: %d&#039;, &#039;updraftplus&#039;), $row_count);
			$updraftplus-&gt;log($print_line, &#039;notice-restore&#039;, &#039;restoring-table-&#039;.$table);
			$updraftplus-&gt;log(&#039;Search and replacing table: &#039;.$table.&quot;: rows: &quot;.$row_count);

			if (0 == $row_count) continue;

			for ($on_row = 0; $on_row &lt;= $row_count; $on_row = $on_row+$page_size) {

				$this-&gt;current_row = 0;

				if ($on_row&gt;0) $updraftplus-&gt;log_e(&quot;Searching and replacing reached row: %d&quot;, $on_row);

				// Grab the contents of the table
				list($data, $page_size) = $this-&gt;fetch_sql_result($table, $on_row, $page_size, $where);
				// $sql_line is calculated here only for the purpose of logging errors
				// $where might contain a %, so don&#039;t place it inside the main parameter

				$sql_line = sprintf(&#039;SELECT * FROM %s LIMIT %d, %d&#039;, $table.$where, $on_row, $on_row+$page_size);

				// Our strategy here is to minimise memory usage if possible; to process one row at a time if we can, rather than reading everything into memory
				if ($this-&gt;use_wpdb) {

					if ($wpdb-&gt;last_error) {
						$report[&#039;errors&#039;][] = $this-&gt;print_error($sql_line);
					} else {
						foreach ($data as $row) {
							$rowrep = $this-&gt;process_row($table, $row, $search, $replace, $stripped_table);
							$report[&#039;rows&#039;]++;
							$report[&#039;updates&#039;] += $rowrep[&#039;updates&#039;];
							$report[&#039;change&#039;] += $rowrep[&#039;change&#039;];
							foreach ($rowrep[&#039;errors&#039;] as $err) $report[&#039;errors&#039;][] = $err;
						}
					}
				} else {
					if (false === $data) {
						$report[&#039;errors&#039;][] = $this-&gt;print_error($sql_line);
					} elseif (true !== $data &amp;&amp; null !== $data) {
						if ($this-&gt;use_mysqli) {
							while ($row = mysqli_fetch_array($data)) { // phpcs:ignore WordPress.DB.RestrictedFunctions.mysql_mysqli_fetch_array -- Using mysqli directly for streaming large result sets during restore to avoid high memory usage with $wpdb
								$rowrep = $this-&gt;process_row($table, $row, $search, $replace, $stripped_table);
								$report[&#039;rows&#039;]++;
								$report[&#039;updates&#039;] += $rowrep[&#039;updates&#039;];
								$report[&#039;change&#039;] += $rowrep[&#039;change&#039;];
								foreach ($rowrep[&#039;errors&#039;] as $err) $report[&#039;errors&#039;][] = $err;
							}
							mysqli_free_result($data); // phpcs:ignore WordPress.DB.RestrictedFunctions.mysql_mysqli_free_result -- Using mysqli directly for streaming large result sets during restore to avoid high memory usage with $wpdb
						} else {
							// phpcs:ignore PHPCompatibility.Extensions.RemovedExtensions.mysql_DeprecatedRemoved, WordPress.DB.RestrictedFunctions.mysql_mysql_fetch_array -- Ignore removed extension compatibility, direct mysql function used for low-level database operations outside of $wpdb.
							while ($row = mysql_fetch_array($data)) {
								$rowrep = $this-&gt;process_row($table, $row, $search, $replace, $stripped_table);
								$report[&#039;rows&#039;]++;
								$report[&#039;updates&#039;] += $rowrep[&#039;updates&#039;];
								$report[&#039;change&#039;] += $rowrep[&#039;change&#039;];
								foreach ($rowrep[&#039;errors&#039;] as $err) $report[&#039;errors&#039;][] = $err;
							}
							@mysql_free_result($data); // phpcs:ignore Generic.PHP.NoSilencedErrors.Discouraged, PHPCompatibility.Extensions.RemovedExtensions.mysql_DeprecatedRemoved, WordPress.DB.RestrictedFunctions.mysql_mysql_free_result -- If an error occurs during mysql free result and it fails to free result, it will not impact anything at all. mysql_* function used in the scenario in which the mysqli extension doesn&#039;t exist.
						}
					}
				}

			}

		}

		$report[&#039;end&#039;] = microtime(true);

		return $report;
	}

	/**
	 * This function will get data from the passed in table ready to be search and replaced
	 *
	 * @param string  $table     - the table name
	 * @param integer $on_row    - the row to start from
	 * @param integer $page_size - the page size
	 * @param string  $where     - the where condition
	 *
	 * @return array - an array of data or an array with a false value
	 */
	private function fetch_sql_result($table, $on_row, $page_size, $where = &#039;&#039;) {

		$sql_line = sprintf(&#039;SELECT * FROM %s%s LIMIT %d, %d&#039;, $table, $where, $on_row, $page_size);

		global $updraftplus;
		$updraftplus-&gt;check_db_connection($this-&gt;wpdb_obj, true);

		if ($this-&gt;use_wpdb) {
			global $wpdb;
			// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- $sql_line is a SELECT query built from safe table identifiers and paginated offsets; SQL identifiers and LIMIT/OFFSET values cannot be parameterized with $wpdb-&gt;prepare().
			$data = $wpdb-&gt;get_results($sql_line, ARRAY_A);
			if (!$wpdb-&gt;last_error) return array($data, $page_size);
		} else {
			if ($this-&gt;use_mysqli) {
				// phpcs:ignore WordPress.DB.RestrictedFunctions.mysql_mysqli_query -- Direct mysqli call required; this uses a dedicated low-level database handle ($this-&gt;mysql_dbh) outside $wpdb for search-replace operations.
				$data = mysqli_query($this-&gt;mysql_dbh, $sql_line);
			} else {
				// phpcs:ignore PHPCompatibility.Extensions.RemovedExtensions.mysql_DeprecatedRemoved, WordPress.DB.RestrictedFunctions.mysql_mysql_query -- Ignore removed extension compatibility, direct mysql function used for low-level database operations outside of $wpdb.
				$data = mysql_query($sql_line, $this-&gt;mysql_dbh);
			}
			if (false !== $data) return array($data, $page_size);
		}
		
		if (5000 &lt;= $page_size) return $this-&gt;fetch_sql_result($table, $on_row, 2000, $where);
		if (2000 &lt;= $page_size) return $this-&gt;fetch_sql_result($table, $on_row, 500, $where);

		// At this point, $page_size should be 500; and that failed
		return array(false, $page_size);

	}

	/**
	 * This function will process a single row from the database calling recursive_unserialize_replace to search and replace the data found in the search and replace arrays
	 *
	 * @param string $table          - the current table we are working on
	 * @param array  $row            - the current row we are working on
	 * @param array  $search         - an array of things to search for
	 * @param array  $replace        - an array of things to replace the search terms with
	 * @param string $stripped_table - the stripped table
	 *
	 * @return array - returns an array report which includes changes made and any errors
	 */
	private function process_row($table, $row, $search, $replace, $stripped_table) {

		global $updraftplus, $wpdb, $updraftplus_restorer;

		$report = array(&#039;change&#039; =&gt; 0, &#039;errors&#039; =&gt; array(), &#039;updates&#039; =&gt; 0);

		$this-&gt;current_row++;
		
		$update_sql = array();
		$where_sql = array();
		$upd = false;

		foreach ($this-&gt;columns as $column =&gt; $primary_key) {
		
			// Don&#039;t search/replace these
			if ((&#039;options&#039; == $stripped_table &amp;&amp; &#039;option_value&#039; == $column &amp;&amp; !empty($row[&#039;option_name&#039;]) &amp;&amp; &#039;updraft_remotesites&#039; == $row[&#039;option_name&#039;]) || (&#039;sitemeta&#039; == $stripped_table &amp;&amp; &#039;meta_value&#039; == $column &amp;&amp; !empty($row[&#039;meta_key&#039;]) &amp;&amp; &#039;updraftplus_options&#039; == $row[&#039;meta_key&#039;])) {
				continue;
			}
		
			$edited_data = $data_to_fix = $row[$column];
			$successful = false;

			// We catch errors/exceptions so that they&#039;re not fatal. Once saw a fatal (&quot;Cannot access empty property&quot;) on &quot;if (is_a($value, &#039;__PHP_Incomplete_Class&#039;)) {&quot; (not clear what $value has to be to cause that).
			try {
				// Run a search replace on the data that&#039;ll respect the serialisation.
				$edited_data = $this-&gt;recursive_unserialize_replace($search, $replace, $data_to_fix);
				$successful = true;
			} catch (Exception $e) {
				$log_message = &#039;An Exception (&#039;.get_class($e).&#039;) occurred during the recursive search/replace. Exception message: &#039;.$e-&gt;getMessage().&#039; (Code: &#039;.$e-&gt;getCode().&#039;, line &#039;.$e-&gt;getLine().&#039; in &#039;.$e-&gt;getFile().&#039;)&#039;;
				$report[&#039;errors&#039;][] = $log_message;
				UpdraftPlus_Manipulation_Functions::error_log($log_message);
				$updraftplus-&gt;log($log_message);
				/* translators: 1: Exception class, 2: Exception message. */
				$updraftplus-&gt;log(sprintf(__(&#039;A PHP exception (%1$s) has occurred: %2$s&#039;, &#039;updraftplus&#039;), get_class($e), $e-&gt;getMessage()), &#039;warning-restore&#039;);
			} catch (Error $e) {// phpcs:ignore PHPCompatibility.Classes.NewClasses.errorFound -- The Error class does not exist in PHP below 5.6.
				$log_message = &#039;A PHP Fatal error (recoverable, &#039;.get_class($e).&#039;) occurred during the recursive search/replace. Exception message: Error message: &#039;.$e-&gt;getMessage().&#039; (Code: &#039;.$e-&gt;getCode().&#039;, line &#039;.$e-&gt;getLine().&#039; in &#039;.$e-&gt;getFile().&#039;)&#039;;
				$report[&#039;errors&#039;][] = $log_message;
				UpdraftPlus_Manipulation_Functions::error_log($log_message);
				$updraftplus-&gt;log($log_message);
				/* translators: 1: Fatal error class, 2: Error message. */
				$updraftplus-&gt;log(sprintf(__(&#039;A PHP fatal error (%1$s) has occurred: %2$s&#039;, &#039;updraftplus&#039;), get_class($e), $e-&gt;getMessage()), &#039;warning-restore&#039;);
			}

			// Something was changed
			if ($successful &amp;&amp; $edited_data != $data_to_fix) {
				$report[&#039;change&#039;]++;
				$ed = $edited_data;
				$wpdb-&gt;escape_by_ref($ed);
				// Undo breakage introduced in WP 4.8.3 core
				if (is_callable(array($wpdb, &#039;remove_placeholder_escape&#039;))) $ed = $wpdb-&gt;remove_placeholder_escape($ed);
				$update_sql[] = UpdraftPlus_Manipulation_Functions::backquote($column) . &#039; = &quot;&#039; . $ed . &#039;&quot;&#039;;
				$upd = true;
			}

			if ($primary_key) {
				$df = $data_to_fix;
				$wpdb-&gt;escape_by_ref($df);
				// Undo breakage introduced in WP 4.8.3 core
				if (is_callable(array($wpdb, &#039;remove_placeholder_escape&#039;))) $df = $wpdb-&gt;remove_placeholder_escape($df);
				$where_sql[] = UpdraftPlus_Manipulation_Functions::backquote($column) . &#039; = &quot;&#039; . $df . &#039;&quot;&#039;;
			}
		}

		if ($upd &amp;&amp; !empty($where_sql)) {
			$sql = &#039;UPDATE &#039;.UpdraftPlus_Manipulation_Functions::backquote($table).&#039; SET &#039;.implode(&#039;, &#039;, $update_sql).&#039; WHERE &#039;.implode(&#039; AND &#039;, array_filter($where_sql));
			$result = $updraftplus_restorer-&gt;sql_exec($sql, 5, &#039;&#039;, false);
			if (false === $result || is_wp_error($result)) {
				$last_error = $this-&gt;print_error($sql);
				$report[&#039;errors&#039;][] = $last_error;
			} else {
				$report[&#039;updates&#039;]++;
			}

		} elseif ($upd) {
			$report[&#039;errors&#039;][] = sprintf(&#039;&quot;%s&quot; has no primary key, manual change needed on row %s.&#039;, $table, $this-&gt;current_row);
			$updraftplus-&gt;log(__(&#039;Error:&#039;, &#039;updraftplus&#039;).&#039; &#039;.
				/* translators: 1: Table name, 2: Row number requiring manual change. */
				sprintf(__(&#039;&quot;%1$s&quot; has no primary key, manual change needed on row %2$s.&#039;, &#039;updraftplus&#039;), $table, $this-&gt;current_row),
			&#039;warning-restore&#039;);
		}

		return $report;

	}
	
	/**
	 * Take a serialised array and unserialise it replacing elements as needed and
	 * unserialising any subordinate arrays and performing the replace on those too.
	 * N.B. $from and $to can be arrays - they get passed only to str_replace(), which can take an array
	 *
	 * @param string $from            String we&#039;re looking to replace.
	 * @param string $to              What we want it to be replaced with
	 * @param array  $data            Used to pass any subordinate arrays back to in.
	 * @param bool   $serialised      Does the array passed via $data need serialising.
	 * @param int    $recursion_level Current recursion depth within the original data.
	 * @param array  $visited_data    Data that has been seen in previous recursion iterations.
	 *
	 * @return array	The original array with all elements replaced as needed.
	 */
	private function recursive_unserialize_replace($from = &#039;&#039;, $to = &#039;&#039;, $data = &#039;&#039;, $serialised = false, $recursion_level = 0, $visited_data = array()) {

		global $updraftplus;

		static $error_count = 0;

		// some unserialised data cannot be re-serialised eg. SimpleXMLElements
		try {
			$case_insensitive = false;

			// If we&#039;ve reached the maximum recursion level, short circuit
			if (0 !== $this-&gt;max_recursion &amp;&amp; $recursion_level &gt;= $this-&gt;max_recursion) {
				return $data;
			}

			if (is_array($data) || is_object($data)) {
				// If we&#039;ve seen this exact object or array before, short circuit
				if (in_array($data, $visited_data, true)) {
					return $data; // Avoid infinite recursions when there&#039;s a circular reference
				}
				// Add this data to the list of
				$visited_data[] = $data;
			}

			if (is_array($from) &amp;&amp; is_array($to)) {
				$case_insensitive = preg_match(&#039;#^https?:#i&#039;, implode($from)) &amp;&amp; preg_match(&#039;#^https?:#i&#039;, implode($to)) ? true : false;
			} else {
				$case_insensitive = preg_match(&#039;#^https?:#i&#039;, $from) &amp;&amp; preg_match(&#039;#^https?:#i&#039;, $to) ? true : false;
			}

			// O:8:&quot;DateTime&quot;:0:{} : see https://bugs.php.net/bug.php?id=62852
			if (is_serialized($data) &amp;&amp; false === strpos($data, &#039;O:8:&quot;DateTime&quot;:0:{}&#039;) &amp;&amp; false !== ($unserialized = UpdraftPlus::unserialize($data))) {
				$data = $this-&gt;recursive_unserialize_replace($from, $to, $unserialized, true, $recursion_level + 1);
			} elseif (is_array($data)) {
				$_tmp = array();
				foreach ($data as $key =&gt; $value) {
					$_tmp[$key] = $this-&gt;recursive_unserialize_replace($from, $to, $value, false, $recursion_level + 1, $visited_data);
				}

				$data = $_tmp;
				unset($_tmp);
			} elseif (is_object($data)) {
				$_tmp = clone $data;
				$props = get_object_vars($data);

				foreach ($props as $key =&gt; $value) {
					// Skip any representation of a protected property or integer property
					if (!preg_match(&#039;/^[a-zA-Z_\x80-\xff][a-zA-Z0-9_\x80-\xff]*$/&#039;, $key)) continue;

					$_tmp-&gt;$key = $this-&gt;recursive_unserialize_replace($from, $to, $value, false, $recursion_level + 1, $visited_data);
				}

				$data = $_tmp;
				unset($_tmp);
			} elseif (is_string($data) &amp;&amp; (null !== ($_tmp = json_decode($data, true)))) {

				if (is_array($_tmp)) {
					foreach ($_tmp as $key =&gt; $value) {
						$_tmp[$key] = $this-&gt;recursive_unserialize_replace($from, $to, $value, false, $recursion_level + 1, $visited_data);
					}

					$data = json_encode($_tmp);
					unset($_tmp);
				}

			} else {
				if (is_string($data)) {
					if ($case_insensitive) {
						$data = str_ireplace($from, $to, $data);
					} else {
						$data = str_replace($from, $to, $data);
					}
// Below is the wrong approach. In fact, in the problematic case, the resolution is an extra search/replace to undo unnecessary ones
// if (is_string($from)) {
// $data = str_replace($from, $to, $data);
// } else {
// # Array. We only want a maximum of one replacement to take place. This is only an issue in non-default setups, but in those situations, carrying out all the search/replaces can be wrong. This is also why the most specific URL should be done first.
// foreach ($from as $i =&gt; $f) {
// $ndata = str_replace($f, $to[$i], $data);
// if ($ndata != $data) {
// $data = $ndata;
// break;
// }
// }
// }
				}
			}

			if ($serialised)
				return serialize($data);

		} catch (Exception $error) {
			if (3 &gt; $error_count) {
				$log_message = &#039;PHP Fatal Exception error (&#039;.get_class($error).&#039;) has occurred during recursive_unserialize_replace. Error Message: &#039;.$error-&gt;getMessage().&#039; (Code: &#039;.$error-&gt;getCode().&#039;, line &#039;.$error-&gt;getLine().&#039; in &#039;.$error-&gt;getFile().&#039;)&#039;;
				$updraftplus-&gt;log($log_message, &#039;warning-restore&#039;);
				$error_count++;
			}
		}

		return $data;
	}

	/**
	 * This function will get the last database error and log it
	 *
	 * @param string $sql_line - the sql line that caused the error
	 *
	 * @return void
	 */
	public function print_error($sql_line) {
		global $wpdb, $updraftplus;
		if ($this-&gt;use_wpdb) {
			$last_error = $wpdb-&gt;last_error;
		} else {
			// phpcs:ignore PHPCompatibility.Extensions.RemovedExtensions.mysql_DeprecatedRemoved, WordPress.DB.RestrictedFunctions.mysql_mysql_error, WordPress.DB.RestrictedFunctions.mysql_mysqli_error -- Ignore removed extension compatibility, direct mysql/mysqli function used for low-level database operations outside of $wpdb.
			$last_error = ($this-&gt;use_mysqli) ? mysqli_error($this-&gt;mysql_dbh) : mysql_error($this-&gt;mysql_dbh);
		}
		$updraftplus-&gt;log(__(&#039;Error:&#039;, &#039;updraftplus&#039;).&quot; &quot;.$last_error.&quot; - &quot;.__(&#039;the database query being run was:&#039;, &#039;updraftplus&#039;).&#039; &#039;.$sql_line, &#039;warning-restore&#039;);
		return $last_error;
	}
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2Fwww%2Fyogitonics.com%2Fwp-content%2Fplugins%2Fupdraftplus%2Fincludes'>⬅ Back to Directory</a>