info['ID'] = 'DBDUMP';
$this->info['name'] = __( 'DB Backup', 'backwpup' );
$this->info['description'] = __( 'Database backup', 'backwpup' );
$this->info['URI'] = __( 'http://backwpup.com', 'backwpup' );
$this->info['author'] = 'WP Media';
$this->info['authorURI'] = 'https://wp-media.me';
$this->info['version'] = BackWPup::get_plugin_data( 'Version' );
}
/**
* Whether the job type creates a file.
*
* @return bool
*/
public function creates_file() {
return true;
}
/**
* Returns default options for the job type.
*
* @return array
*/
public function option_defaults() {
/**
* Database connection.
*
* @var wpdb $wpdb
*/
global $wpdb;
$defaults = [
'dbdumpexclude' => [],
'dbdumpfile' => sanitize_file_name( DB_NAME ),
'dbdumptype' => 'sql',
'dbdumpfilecompression' => '',
];
// Set only WordPress tables as default.
$cache_group = 'backwpup_dbdump';
$tables_key = 'show_tables_' . DB_NAME;
$dbtables = wp_cache_get( $tables_key, $cache_group );
if ( false === $dbtables ) {
$dbtables = $wpdb->get_results( 'SHOW TABLES', ARRAY_N ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery -- No WP API for SHOW TABLES.
wp_cache_set( $tables_key, $dbtables, $cache_group, MINUTE_IN_SECONDS );
}
foreach ( $dbtables as $dbtable ) {
if ( 0 !== strncmp( (string) $dbtable[0], $wpdb->prefix, strlen( $wpdb->prefix ) ) ) {
$defaults['dbdumpexclude'][] = $dbtable[0];
}
}
return $defaults;
}
/**
* Renders the job type edit tab.
*
* @param int|array $jobid Job ID or list of job IDs.
*/
public function edit_tab( $jobid ) {
/**
* Database connection.
*
* @var wpdb $wpdb
*/
global $wpdb; ?>
get_results( 'SHOW FULL TABLES', ARRAY_N ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery -- No WP API for SHOW FULL TABLES.
wp_cache_set( $tables_key, $tables, $cache_group, MINUTE_IN_SECONDS );
}
echo '';
?>