Sid Gifari File Manager

Sid Gifari File Manager

🏠 Root / home / genremedia08 / thepassage.overlookedtracks.com / wp-content9 / plugins / backupbuddy / views /

Editing: _diagnostics-database_replace.php

<?php
/**
 * Diagnostics Database Replace View
 *
 * @package BackupBuddy
 */

is_admin() || die( 'Access Denied.' );

global $wpdb;

echo '<a name="database_replace"></a>';

echo '<p><b>Warning: This is an advanced feature. Use with caution; improper use may result in data loss.</b></p>';
if ( '1' == pb_backupbuddy::_GET( 'database_replace' ) ) {

global $pb_backupbuddy_js_status;
	$pb_backupbuddy_js_status = true;

?>
	<script type="text/javascript">
			function pb_status_append( json ) {
				if( 'undefined' === typeof statusBox ) { // No status box yet so may need to create it.
					statusBox = jQuery( '#pb_backupbuddy_status' );
					if( statusBox.length == 0 ) { // No status box yet so suppress.
						return;
					}
				}

if ( 'string' == ( typeof json ) ) {
					backupbuddy_log( json );
					console.log( 'Status log received string: ' + json );
					return;
				}

// Used in Solid Backups _backup-perform.php and Importer_header.php
				json.date = new Date();
				json.date = new Date(  ( json.time * 1000 ) + json.date.getTimezoneOffset() * 60000 );
				var seconds = json.date.getSeconds();
				if ( seconds < 10 ) {
					seconds = '0' + seconds;
				}
				json.date = backupbuddy_hourpad( json.date.getHours() ) + ':' + json.date.getMinutes() + ':' + seconds;

triggerEvent = 'backupbuddy_' + json.event;

backupbuddy_log( json );

} // End function pb_status_append().

// left hour pad with zeros.
			function backupbuddy_hourpad(n) { return ("0" + n).slice(-2); }

// Used in Solid Backups _backup-perform.php and Importer_header.php and _rollback.php
			function backupbuddy_log( json ) {

message = '';

if ( 'string' == ( typeof json ) ) {
					message = "-----------\t\t-------\t-------\t" + json;
				} else {
					message = json.date + '.' + json.u + " \t" + json.run + "sec \t" + json.mem + "MB\t" + json.data;
				}

statusBox.append( "\r\n" + message );
				statusBox.scrollTop( statusBox[0].scrollHeight - statusBox.height() );

}
		</script>
	<?php

echo pb_backupbuddy::status_box( 'Mass replacing in database with Diagnostics from Solid Backups v' . pb_backupbuddy::settings( 'version' ) . '...' );
	// Instantiate database replacement class.
	require_once pb_backupbuddy::plugin_path() . '/lib/dbreplace/dbreplace.php';
	$dbreplace = new pluginbuddy_dbreplace( '', 1, 60 * 60 * 24 );

// Set up variables by getting POST data.
	$needle = backupbuddy_core::dbEscape( pb_backupbuddy::_POST( 'needle' ) );
	if ( '' == $needle ) {
		echo '<b>Error #4456582. Missing needle. You must enter text to search for.';
		echo '<br><a href="' . esc_attr( pb_backupbuddy::page_url() ) . '&tab=database#database_replace" class="button button-secondary secondary-button">&larr; ' . esc_html__( 'back', 'it-l10n-backupbuddy' ) . '</a>';
		return;
	}
	$replacement = backupbuddy_core::dbEscape( pb_backupbuddy::_POST( 'replacement' ) );
	pb_backupbuddy::status( 'message', 'Replacing `' . $needle . '` with `' . $replacement . '`.' );

// Replace based on the type of table replacement selected.
	if ( 'all' == pb_backupbuddy::_POST( 'table_selection' ) ) { // All tables.
		pb_backupbuddy::status( 'message', 'Replacing in all tables based on settings.' );

$tables = array();
		$rows   = $wpdb->get_results( 'SELECT table_name AS `table_name` FROM information_schema.tables WHERE table_schema = DATABASE()', ARRAY_A );
		foreach ( $rows as $row ) {
			$tables[] = $row['table_name'];
		}
		unset( $rows );
		$rows_changed = 0;
		foreach ( $tables as $table ) {
			pb_backupbuddy::status( 'message', 'Replacing in table `' . $table . '`.' );
			$rows_changed += $dbreplace->bruteforce_table( $table, array( $needle ), array( $replacement ) );
		}
		pb_backupbuddy::status( 'message', 'Total rows updated across all tables: ' . $rows_changed . '.' );

pb_backupbuddy::status( 'message', 'Replacement finished.' );
	} elseif ( pb_backupbuddy::_POST( 'table_selection' ) == 'single_table' ) {
		$table = backupbuddy_core::dbEscape( pb_backupbuddy::_POST( 'table' ) ); // Single specified table.
		pb_backupbuddy::status( 'message', 'Replacing in single table `' . $table . '` based on settings.' );
		$dbreplace->bruteforce_table( $table, array( $needle ), array( $replacement ) );
		pb_backupbuddy::status( 'message', 'Replacement finished.' );
	} elseif ( pb_backupbuddy::_POST( 'table_selection' ) == 'prefix' ) { // Matching table prefix.
		$prefix = backupbuddy_core::dbEscape( pb_backupbuddy::_POST( 'table_prefix' ) );
		pb_backupbuddy::status( 'message', 'Replacing in all tables matching prefix `' . $prefix . '`.' );

$tables         = array();
		$escaped_prefix = str_replace( '_', '\_', $prefix );
		$rows           = $wpdb->get_results( "SELECT table_name AS `table_name` FROM information_schema.tables WHERE table_name LIKE '{$escaped_prefix}%' AND table_schema = DATABASE()", ARRAY_A );
		foreach ( $rows as $row ) {
			$tables[] = $row['table_name'];
		}
		unset( $rows );
		$rows_changed = 0;
		foreach ( $tables as $table ) {
			pb_backupbuddy::status( 'message', 'Replacing in table `' . $table . '`.' );
			$rows_changed += $dbreplace->bruteforce_table( $table, array( $needle ), array( $replacement ) );
		}
		pb_backupbuddy::status( 'message', 'Total rows updated across all tables: ' . $rows_changed . '.' );

pb_backupbuddy::status( 'message', 'Replacement finished.' );
	} else {
		die( 'Error #4456893489349834. Unknown method.' );
	}

echo '<br><a href="' . esc_attr( pb_backupbuddy::page_url() ) . '&tab=database#database_replace" class="button button-secondary secondary-button">&larr; ' . esc_html__( 'back', 'it-l10n-backupbuddy' ) . '</a>';

$pb_backupbuddy_js_status = false;
	return;
}

echo '<p><b>Tip:</b> When replacing a site address there may be more than one URL. Ie. http://site.com, http://www.site.com, https://site.com, etc.</p>';

$tables   = array();
$prefixes = array();

// Make sure this WP's prefix is in there for sure (useful if someone uses a prefix that has an underscore in it; they shouldnt but they do).
global $table_prefix;
$prefixes[] = $table_prefix;

// Calculate prefixes foudn in this database. Does not handle multiple-underscore.
$rows = $wpdb->get_results( 'SELECT table_name AS `table_name` FROM information_schema.tables WHERE table_schema = DATABASE()', ARRAY_A );
foreach ( $rows as $row ) {
	$tables[] = $row['table_name'];

if ( preg_match( '/[a-zA-Z0-9]*_([0-9]+_)*/i', $row['table_name'], $matches ) ) {
		$prefixes[] = $matches[0];
	}
}
unset( $rows );

$prefixes = array_unique( $prefixes );
natsort( $prefixes );
?>
<div>
	<form action="<?php echo pb_backupbuddy::page_url(); ?>&database_replace=1&tab=database#database_replace" method="post">
		<input type="hidden" name="action" value="replace">

<h4>Replace <?php pb_backupbuddy::tip( 'Text you want to be searched for and replaced. Everything in the box is considered one match and may span multiple lines.' ); ?></h4>
		<textarea name="needle" style="width: 100%;"></textarea>
		<br>

<h4>In table(s)</h4>
		<label for="table_selection_all"><input id="table_selection_all"  checked='checked' type="radio" name="table_selection" value="all"> all tables</label>
		<label for="table_selection_prefix"><input id="table_selection_prefix" type="radio" name="table_selection" value="prefix"> with prefix:</label>
		<select name="table_prefix" id="table_selection_prefix" onclick="jQuery('#table_selection_prefix').click();">
			<?php
			foreach ( $prefixes as $prefix ) {
				echo '<option value="' . esc_attr( $prefix ) . '">' . esc_html( $prefix ) . '</option>';
			}
			?>
		</select>
		<label for="table_selection_table"><input id="table_selection_table" type="radio" name="table_selection" value="single_table"> single:</label>
		<select name="table" id="table_selection_table" onclick="jQuery('#table_selection_table').click();">
			<?php
			foreach ( $tables as $table ) {
				echo '<option value="' . esc_attr( $table ) . '">' . esc_html( $table ) . '</option>';
			}
			?>
		</select>
		<?php
		if ( substr_count( $table_prefix, '_' ) > 1 ) {
			echo '<span class="pb_label pb_label-warning">Warning</span> ';
			esc_html_e( 'Site table prefix contains multiple underscores. Prefix list may be inaccurate if these are not Multisite subsites.', 'it-l10n-backupbuddy' );
		}
		?>
		<br><br>

<p>
			<input type="submit" name="submit" value="Begin Replacement" class="button button-primary" /> <span class="description">Caution; this cannot be undone. Serialized data is handled by this replacement.</span>
		</p>
	</form>
</div>
<br>