public static function execute($params)
{
global $wpdb;
// Set exclude database
if (isset($params['options']['no_database'])) {
return $params;
}
// Set progress
Ai1wm_Status::info(__('Exporting database...', AI1WM_PLUGIN_NAME));
// Get database client
if (empty($wpdb->use_mysqli)) {
$client = new Ai1wm_Database_Mysql($wpdb);
} else {
$client = new Ai1wm_Database_Mysqli($wpdb);
}
// Spam comments
if (isset($params['options']['no_spam_comments'])) {
$client->set_table_query_clauses(ai1wm_table_prefix() . 'comments', " WHERE comment_approved != 'spam' ");
$client->set_table_query_clauses(ai1wm_table_prefix() . 'commentmeta', sprintf(" WHERE comment_id IN ( SELECT comment_ID FROM `%s` WHERE comment_approved != 'spam' ) ", ai1wm_table_prefix() . 'comments'));
}
// Post revisions
if (isset($params['options']['no_revisions'])) {
$client->set_table_query_clauses(ai1wm_table_prefix() . 'posts', " WHERE post_type != 'revision' ");
}
$old_table_values = array();
$new_table_values = array();
// Find and replace
if (isset($params['options']['replace']) && ($replace = $params['options']['replace'])) {
for ($i = 0; $i < count($replace['old_value']); $i++) {
if (!empty($replace['old_value'][$i]) && !empty($replace['new_value'][$i])) {
$old_table_values[] = $replace['old_value'][$i];
$new_table_values[] = $replace['new_value'][$i];
}
}
}
$old_table_prefixes = array();
$new_table_prefixes = array();
// Set table prefixes
if (ai1wm_table_prefix()) {
$old_table_prefixes[] = ai1wm_table_prefix();
$new_table_prefixes[] = ai1wm_servmask_prefix();
} else {
// Set table prefixes based on table name
foreach ($client->get_tables() as $table_name) {
$old_table_prefixes[] = $table_name;
$new_table_prefixes[] = ai1wm_servmask_prefix() . $table_name;
}
// Set table prefixes based on user meta
foreach (array('capabilities', 'user_level', 'user_roles') as $user_meta) {
$old_table_prefixes[] = $user_meta;
$new_table_prefixes[] = ai1wm_servmask_prefix() . $user_meta;
}
}
$include_table_prefixes = array();
// Include table prefixes
if (ai1wm_table_prefix()) {
$include_table_prefixes[] = ai1wm_table_prefix();
} else {
foreach ($client->get_tables() as $table_name) {
$include_table_prefixes[] = $table_name;
}
}
// Set database options
$client->set_old_table_prefixes($old_table_prefixes)->set_new_table_prefixes($new_table_prefixes)->set_old_replace_values($old_table_values)->set_new_replace_values($new_table_values)->set_include_table_prefixes($include_table_prefixes)->set_table_prefix_columns(ai1wm_table_prefix() . 'options', array('option_name'))->set_table_prefix_columns(ai1wm_table_prefix() . 'usermeta', array('meta_key'));
// Status options
$client->set_table_query_clauses(ai1wm_table_prefix() . 'options', sprintf(" WHERE option_name != '%s' ", AI1WM_STATUS));
// Set current table index
if (isset($params['current_table_index'])) {
$current_table_index = (int) $params['current_table_index'];
} else {
$current_table_index = 0;
}
// Export database
$completed = $client->export(ai1wm_database_path($params), $current_table_index, 10);
// Export completed
if ($completed) {
// Get archive file
$archive = new Ai1wm_Compressor(ai1wm_archive_path($params));
// Add database to archive
$archive->add_file(ai1wm_database_path($params), AI1WM_DATABASE_NAME);
$archive->close();
// Set progress
Ai1wm_Status::info(__('Done exporting database.', AI1WM_PLUGIN_NAME));
}
// Set current table index
$params['current_table_index'] = $current_table_index;
// Set completed flag
$params['completed'] = $completed;
return $params;
}
