PHP backupbuddy_core::get_mysqldump_additional方法代码示例

 function backup_create_dat_file($trigger)
 {
     pb_backupbuddy::status('details', __('Creating DAT (data) file snapshotting site & backup information.', 'it-l10n-backupbuddy'));
     global $wpdb, $current_blog;
     $is_multisite = $is_multisite_export = false;
     //$from_multisite is from a site within a network
     $upload_url_rewrite = $upload_url = '';
     if (is_multisite() && $trigger == 'scheduled' || is_multisite() && is_network_admin()) {
         // MS Network Export IF ( in a network and triggered by a schedule ) OR ( in a network and logged in as network admin)
         $is_multisite = true;
     } elseif (is_multisite()) {
         // MS Export (individual site)
         $is_multisite_export = true;
         $uploads = wp_upload_dir();
         $upload_url_rewrite = site_url(str_replace(ABSPATH, '', $uploads['basedir']));
         // URL we rewrite uploads to. REAL direct url.
         $upload_url = $uploads['baseurl'];
         // Pretty virtual path to uploads directory.
     }
     // Handle wp-config.php file in a parent directory.
     if ($this->_backup['type'] == 'full') {
         $wp_config_parent = false;
         if (file_exists(ABSPATH . 'wp-config.php')) {
             // wp-config in normal place.
             pb_backupbuddy::status('details', 'wp-config.php found in normal location.');
         } else {
             // wp-config not in normal place.
             pb_backupbuddy::status('message', 'wp-config.php not found in normal location; checking parent directory.');
             if (file_exists(dirname(ABSPATH) . '/wp-config.php')) {
                 // Config in parent.
                 $wp_config_parent = true;
                 pb_backupbuddy::status('message', 'wp-config.php found in parent directory. Copying wp-config.php to temporary location for backing up.');
                 $this->_backup['wp-config_in_parent'] = true;
                 copy(dirname(ABSPATH) . '/wp-config.php', $this->_backup['temp_directory'] . 'wp-config.php');
             } else {
                 pb_backupbuddy::status('error', 'wp-config.php not found in normal location NOR parent directory. This will result in an incomplete backup which will be marked as bad.');
             }
         }
     } else {
         $wp_config_parent = false;
     }
     global $wp_version;
     $totalPosts = 0;
     foreach (wp_count_posts('post') as $counttype => $count) {
         $totalPosts += $count;
     }
     $totalPages = 0;
     foreach (wp_count_posts('page') as $counttype => $count) {
         $totalPages += $count;
     }
     $totalComments = 0;
     foreach (wp_count_comments() as $counttype => $count) {
         $totalComments += $count;
     }
     $totalUsers = count_users();
     $totalUsers = $totalUsers['total_users'];
     pb_backupbuddy::status('startSubFunction', json_encode(array('function' => 'post_count', 'title' => 'Found ' . $totalPosts . ' posts, ' . $totalPages . ' pages, and ' . $totalComments . ' comments.')));
     pb_backupbuddy::status('startSubFunction', json_encode(array('function' => 'post_count', 'title' => 'Found ' . $totalUsers . ' user accounts.')));
     $dat_content = array('backupbuddy_version' => pb_backupbuddy::settings('version'), 'wordpress_version' => $wp_version, 'backup_time' => $this->_backup['start_time'], 'backup_type' => $this->_backup['type'], 'profile' => $this->_backup['profile'], 'default_profile' => pb_backupbuddy::$options['profiles'][0], 'serial' => $this->_backup['serial'], 'trigger' => $trigger, 'wp-config_in_parent' => $wp_config_parent, 'deployment_direction' => $this->_backup['deployment_direction'], 'abspath' => ABSPATH, 'siteurl' => site_url(), 'homeurl' => home_url(), 'blogname' => get_option('blogname'), 'blogdescription' => get_option('blogdescription'), 'active_plugins' => implode(', ', get_option('active_plugins')), 'posts' => $totalPosts, 'pages' => $totalPages, 'comments' => $totalComments, 'users' => $totalUsers, 'wp_content_url' => WP_CONTENT_URL, 'wp_content_dir' => WP_CONTENT_DIR, 'db_charset' => $wpdb->charset, 'db_collate' => $wpdb->collate, 'db_prefix' => $wpdb->prefix, 'db_server' => DB_HOST, 'db_name' => DB_NAME, 'db_user' => '', 'db_password' => '', 'db_exclusions' => implode(',', backupbuddy_core::get_mysqldump_additional('excludes', $this->_backup['profile'])), 'db_inclusions' => implode(',', backupbuddy_core::get_mysqldump_additional('includes', $this->_backup['profile'])), 'db_version' => $wpdb->db_version(), 'breakout_tables' => $this->_backup['breakout_tables'], 'tables_sizes' => $this->_backup['table_sizes'], 'force_single_db_file' => $this->_backup['force_single_db_file'], 'is_multisite' => $is_multisite, 'is_multisite_export' => $is_multisite_export, 'domain' => is_object($current_blog) ? $current_blog->domain : '', 'path' => is_object($current_blog) ? $current_blog->path : '', 'upload_url' => $upload_url, 'upload_url_rewrite' => $upload_url_rewrite);
     // End setting $dat_content.
     // If currently using SSL or forcing admin SSL then we will check the hardcoded defined URL to make sure it matches.
     if (is_ssl() or defined('FORCE_SSL_ADMIN') && FORCE_SSL_ADMIN == true) {
         $dat_content['siteurl'] = get_option('siteurl');
         pb_backupbuddy::status('details', __('Compensating for SSL in siteurl.', 'it-l10n-backupbuddy'));
     }
     // Output for troubleshooting.
     pb_backupbuddy::status('details', 'DAT file contents (sans database user/pass): ' . str_replace("\n", '; ', print_r($dat_content, true)));
     // Remaining DB settings.
     $dat_content['db_user'] = DB_USER;
     $dat_content['db_password'] = DB_PASSWORD;
     // Serialize .dat file array.
     $dat_content = base64_encode(serialize($dat_content));
     // Write data to the dat file.
     $dat_file = $this->_backup['temp_directory'] . 'backupbuddy_dat.php';
     if (false === ($file_handle = fopen($dat_file, 'w'))) {
         pb_backupbuddy::status('details', sprintf(__('Error #9017: Temp data file is not creatable/writable. Check your permissions. (%s)', 'it-l10n-backupbuddy'), $dat_file));
         pb_backupbuddy::status('error', 'Temp data file is not creatable/writable. Check your permissions. (' . $dat_file . ')', '9017');
         return false;
     }
     fwrite($file_handle, "<?php die('Access Denied.'); // <!-- ?>\n" . $dat_content);
     fclose($file_handle);
     pb_backupbuddy::status('details', __('Finished creating DAT (data) file.', 'it-l10n-backupbuddy'));
     return true;
 }

 public static function get_database_size($profile_id = 0)
 {
     global $wpdb;
     $prefix = $wpdb->prefix;
     $prefix_length = strlen($wpdb->prefix);
     $additional_includes = backupbuddy_core::get_mysqldump_additional('includes', pb_backupbuddy::$options['profiles'][$profile_id]);
     $additional_excludes = backupbuddy_core::get_mysqldump_additional('excludes', pb_backupbuddy::$options['profiles'][$profile_id]);
     $total_size = 0;
     $total_size_with_exclusions = 0;
     $rows = $wpdb->get_results("SHOW TABLE STATUS", ARRAY_A);
     foreach ($rows as $row) {
         $excluded = true;
         // Default.
         // TABLE STATUS.
         $rowsb = $wpdb->get_results("CHECK TABLE `{$row['Name']}`", ARRAY_A);
         foreach ($rowsb as $rowb) {
             if ($rowb['Msg_type'] == 'status') {
                 $status = $rowb['Msg_text'];
             }
         }
         unset($rowsb);
         // TABLE SIZE.
         $size = $row['Data_length'] + $row['Index_length'];
         $total_size += $size;
         // HANDLE EXCLUSIONS.
         if (pb_backupbuddy::$options['profiles'][$profile_id]['backup_nonwp_tables'] == 0) {
             // Only matching prefix.
             if (substr($row['Name'], 0, $prefix_length) == $prefix or in_array($row['Name'], $additional_includes)) {
                 if (!in_array($row['Name'], $additional_excludes)) {
                     $total_size_with_exclusions += $size;
                     $excluded = false;
                 }
             }
         } else {
             // All tables.
             if (!in_array($row['Name'], $additional_excludes)) {
                 $total_size_with_exclusions += $size;
                 $excluded = false;
             }
         }
     }
     pb_backupbuddy::$options['stats']['db_size'] = $total_size;
     pb_backupbuddy::$options['stats']['db_size_excluded'] = $total_size_with_exclusions;
     pb_backupbuddy::$options['stats']['db_size_updated'] = time();
     pb_backupbuddy::save();
     unset($rows);
     return array($total_size, $total_size_with_exclusions);
 }

		</tr>
	</thead>
	<tfoot>
		<tr class="thead">
			<?php 
echo '<th>', __('Database Table', 'it-l10n-backupbuddy'), '</th>', '<th>', __('Status', 'it-l10n-backupbuddy'), '</th>', '<th>', __('Settings', 'it-l10n-backupbuddy'), '</th>', '<th>', __('Updated / Checked', 'it-l10n-backupbuddy'), '</th>', '<th>', __('Rows', 'it-l10n-backupbuddy'), '</th>', '<th>', __('Size', 'it-l10n-backupbuddy'), '</th>', '<th>', __('Excluded Size', 'it-l10n-backupbuddy'), '</th>';
?>
		</tr>
	</tfoot>
	<tbody>
		<?php 
global $wpdb;
$prefix = $wpdb->prefix;
$prefix_length = strlen($wpdb->prefix);
$additional_includes = backupbuddy_core::get_mysqldump_additional('includes', $profile);
$additional_excludes = backupbuddy_core::get_mysqldump_additional('excludes', $profile);
$total_size = 0;
$total_size_with_exclusions = 0;
$total_rows = 0;
$rows = $wpdb->get_results("SHOW TABLE STATUS", ARRAY_A);
foreach ($rows as $row) {
    $excluded = true;
    // Default.
    // TABLE STATUS.
    $rowsb = $wpdb->get_results("CHECK TABLE `{$row['Name']}`", ARRAY_A);
    foreach ($rowsb as $rowb) {
        if ($rowb['Msg_type'] == 'status') {
            $status = $rowb['Msg_text'];
        }
    }
    unset($rowsb);