' );
}
Auth::require_authentication(); // Die if not logged in.
// Tests variables to populate with results.
$tests = array(
'connect' => false, // Able to connect & login to db server?
'connect_error' => '', // mysql error message in response to connect & login (if any).
'selectdb' => false, // Able to select the database?
'selectdb_error' => '', // mysql error message in response to selecting (if any).
'createtable' => false, // ability to CREATE a new table (and delete it).
'createtable_error' => '', // create table mysql error (if any).
'wordpress_exists' => false, // WordPress tables matching prefix found?
);
/***** BEGIN TESTS *****/
if ( false === @mysql_connect( $_POST['server'], $_POST['user'], $_POST['pass'] ) ) { // CONNECT failed.
$tests['connect_error'] = mysql_error();
} else { // CONNECT success.
$tests['connect'] = true;
if ( false === @mysql_select_db( $_POST['name'] ) ) { // SELECT failed.
$tests['selectdb_error'] = mysql_error();
} else { // SELECT success.
$tests['selectdb'] = true;
// Test ability to create (and delete) a table to verify permissions.
@mysql_query("DROP TABLE `" . mysql_real_escape_string( $_POST['prefix'] ) . "buddy_test`"); // drop just in case a prior attempt failed.
$result = mysql_query( "CREATE TABLE `" . mysql_real_escape_string( $_POST['prefix'] ) . "buddy_test` (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY)" );
if ( false !== $result ) { // create success.
// Drop temp test table we created before we declare success.
$result = mysql_query("DROP TABLE `" . mysql_real_escape_string( $_POST['prefix'] ) . "buddy_test`");
if ( false !== $result ) { // drop success.
$tests['createtable'] = true;
} else { // drop fail.
$tests['createtable_error'] = 'Unable to delete temporary table. ' . mysql_error();
}
} else { // create fail.
$tests['createtable_error'] = 'Unable to create temporary table. ' . mysql_error();
}
// WordPress tables exist matching prefix?
$result = mysql_query( "SHOW TABLES LIKE '" . mysql_real_escape_string( str_replace( '_', '\_', $_POST['prefix'] ) . "%" ) . "'" );
if ( mysql_num_rows( $result ) > 0 ) { // WordPress EXISTS already. Collision.
$tests['wordpress_exists'] = true;
}
unset( $result );
} // end select success.
} // end connect success.
/***** END TESTS *****/
function test_pass() {
echo 'Pass';
}
function test_fail() {
echo 'Fail';
}
function test_warn() {
echo 'Warning';
}
function fatal_test_die() {
echo 'Fatal errors encountered during testing. Please resolve them to continue tests.
';
if ( pb_backupbuddy::_POST( 'skip_database_import' ) == '1' ) {
echo '
Important Database import set to be skipped based on advanced options. Any failures ignored.
';
echo '';
}
die();
}
?>
Testing database settings...
1. Connect & login to database server
Error: ' . $tests['connect_error'] . '
';
$fatal_error = true;
} ?>
2. Selecting database to verify access
Error: ' . $tests['selectdb_error'] . '
';
$fatal_error = true;
} ?>
3. Creating & dropping table to verify permission
Error: ' . $tests['createtable_error'] . '
';
$fatal_error = true;
} ?>
4. Verifying no existing WordPress tables matching prefix
Warning: ' . $warn_message . '
';
} ?>
5. Verifying specified prefix is in valid format
Error: Prefix contains characters that are not allowed. Prefixes should be in the format of letters or numbers and underscore. Ex: wp_, wp5_, mysite_, etc.
';
$fatal_error = true;
}
if ( true === $prefix_warning ) {
echo 'Warning: A prefix in the format of alphanumeric characters followed by an underscore is highly recommended to conform to WordPress & BackupBuddy conventions & expectations. Ex: wp_, wp5_, mysite_, etc.
';
}
?>
Important Database import & migration set to be skipped based on advanced options. Any failures ignored.
';
}
?>
Overall result failure. Correct errors and re-test. ';
} else {
echo 'Overall result success. Proceed to next step.
';
} ?>