Default base database tables to backup';
$options = array( '0' => 'This WordPress\' tables (prefix ' . $wpdb->prefix . ')', '1' => __( 'All tables in database (including non-WordPress)', 'it-l10n-backupbuddy' ), '2' => __( 'None (use with caution)', 'it-l10n-backupbuddy' ) );
} else {
$title = 'Base database tables to backup for this profile';
$options = array( '-1' => __( 'Use global default', 'it-l10n-backupbuddy' ), '0' => 'This WordPress\' tables (prefix ' . $wpdb->prefix . ')', '1' => __( 'All tables in database (including non-WordPress)', 'it-l10n-backupbuddy' ), '2' => __( 'None (use with caution)', 'it-l10n-backupbuddy' ) );
}
$settings_form->add_setting( array(
'type' => 'radio',
'name' => 'profiles#' . $profile_id . '#backup_nonwp_tables',
'options' => $options,
'title' => $title,
'tip' => __( '[Default: This WordPress\' tables prefix (' . $wpdb->prefix . ')] - Determines the default set of tables to backup. If this WordPress\' tables is selected then only tables with the same prefix (for example ' . $wpdb->prefix . ' for this installation) will be backed up by default. If all are selected then all tables will be backed up by default. Additional inclusions & exclusions may be defined below.', 'it-l10n-backupbuddy' ),
'css' => '',
'rules' => 'required',
) );
if ( $profile_array['type'] != 'defaults' ) {
$settings_form->add_setting( array(
'type' => 'checkbox',
'name' => 'profiles#' . $profile_id . '#profile_globaltables',
'options' => array( 'unchecked' => '0', 'checked' => '1' ),
'title' => 'Use global defaults for tables to backup?',
'after' => ' Use global defaults',
'css' => '',
) );
}
function pb_additional_tables( $profile_array, $display_size = false ) {
$return = '';
$size_string = '';
global $wpdb;
if ( true === $display_size ) {
$result = mysql_query( "SHOW TABLE STATUS", $wpdb->dbh );
} else {
$result = mysql_query( "SHOW TABLES", $wpdb->dbh );
}
while( $rs = mysql_fetch_array( $result ) ) {
if ( true === $display_size ) {
// Fix up row count and average row length for InnoDB engine which returns inaccurate (and changing) values for these.
if ( 'InnoDB' === $rs[ 'Engine' ] ) {
if ( false !== ( $resultc = mysql_query( "SELECT COUNT(1) FROM `{$rs[ 'Name' ]}`", $wpdb->dbh ) ) ) {
if ( false !== ( $row = mysql_fetch_row( $resultc ) ) ) {
if ( 0 < ( $rs[ 'Rows' ] = $row[ 0 ] ) ) {
$rs[ 'Avg_row_length' ] = ( $rs[ 'Data_length' ] / $rs[ 'Rows' ] );
}
}
mysql_free_result( $resultc );
}
}
// Table size.
$size_string = ' (' . pb_backupbuddy::$format->file_size( ( $rs['Data_length'] + $rs['Index_length'] ) ) . ') ';
} // end if display size enabled.
$return .= '';
$return .= '' . $rs[0] . $size_string;
$return .= '';
$return .= '
 . '/images/redminus.png "Add to exclusions...")
 . '/images/greenplus.png "Add to inclusions...")
';
$return .= '
 .'/images/greenplus.png)
to include,  .'/images/redminus.png)
to exclude.' . ' ' . pb_additional_tables( $profile_array ),
'before' => __('Inclusions beyond base', 'it-l10n-backupbuddy' ) . ':',
//'after' => '' . __( 'One table per line. This may be manually edited.', 'it-l10n-backupbuddy' ) . '',
'tip' => __('Additional databases tables to include OR exclude IN ADDITION to the DEFAULTS determined by the previous option. You may override defaults with exclusions. Excluding tables may result in an incomplete or broken backup so exercise caution.', 'it-l10n-backupbuddy' ),
'rules' => '',
'css' => 'width: 100%;',
) );
$settings_form->add_setting( array(
'type' => 'textarea',
'name' => 'profiles#' . $profile_id . '#mysqldump_additional_excludes',
//'title' => __('Additional tables to exclude', 'it-l10n-backupbuddy' ) . '
' . __( 'One table per line.', 'it-l10n-backupbuddy' ) . '',
'title' => ' ',
'before' => __('Exclusions beyond base', 'it-l10n-backupbuddy' ) . ':',
'after' => '' . __( 'One table per line. This may be manually edited.', 'it-l10n-backupbuddy' ) . '',
'tip' => __('Additional databases tables to EXCLUDE from the backup. Exclusions are exempted after calculating defaults and additional table includes first. These may include non-WordPress and WordPress tables. WARNING: Excluding WordPress tables results in an incomplete backup and could result in failure in the ability to restore or data loss. Use with caution.', 'it-l10n-backupbuddy' ),
'rules' => '',
'css' => 'width: 100%;',
) );
?>