get_var("SELECT VERSION() AS version"); $total_gain = 0; $no = 0; $row_usage = 0; $data_usage = 0; $index_usage = 0; $overhead_usage = 0; $non_inno_db_tables = 0; $inno_db_tables = 0; $tablesstatus = $optimizer->get_tables(); foreach ($tablesstatus as $tablestatus) { $style = (0 == $no % 2) ? '' : ' class="alternate"'; $no++; echo "\n"; echo ''.number_format_i18n($no).''."\n"; echo "".htmlspecialchars($tablestatus->Name)."\n"; echo ''.number_format_i18n($tablestatus->Rows).''."\n"; echo ''.$wp_optimize->format_size($tablestatus->Data_length).''."\n"; echo ''.$wp_optimize->format_size($tablestatus->Index_length).''."\n";; if ($tablestatus->Engine != 'InnoDB') { echo ''.htmlspecialchars($tablestatus->Engine).''."\n"; echo ''; $font_colour = $optimize_db ? (($tablestatus->Data_free>0) ? '#0000FF' : '#004600') : (($tablestatus->Data_free>0) ? '#9B0000' : '#004600'); echo ''; echo $wp_optimize->format_size($tablestatus->Data_free); echo ''; echo ''."\n"; $overhead_usage += $tablestatus->Data_free; $total_gain += $tablestatus->Data_free; $non_inno_db_tables++; } else { echo ''.htmlspecialchars($tablestatus->Engine).''."\n"; echo ''; echo '-'; echo ''."\n"; $inno_db_tables++; } $row_usage += $tablestatus->Rows; $data_usage += $tablestatus->Data_length; $index_usage += $tablestatus->Index_length; echo ''."\n"; } echo ''."\n"; echo ''.__('Total:', 'wp-optimize').''."\n"; echo ''.sprintf(_n('%d Table', '%d Tables', $no, 'wp-optimize'), number_format_i18n($no)).''."\n"; echo ''.sprintf(_n('%d Record', '%d Records', $row_usage, 'wp-optimize'), number_format_i18n($row_usage)).''."\n"; echo ''.$wp_optimize->format_size($data_usage).''."\n"; echo ''.$wp_optimize->format_size($index_usage).''."\n"; echo ''.'-'.''."\n"; echo ''; $font_colour = $optimize_db ? (($overhead_usage>0) ? '#0000FF' : '#004600') : (($overhead_usage>0) ? '#9B0000' : '#004600'); echo ''.$wp_optimize->format_size($overhead_usage).''; ?>