echo ' '; echo '<font color="red">'; echo $part2 . '</font> '; } } ?> </h4> <?php $total_cleaned = get_option(OPTION_NAME_TOTAL_CLEANED); $total_cleaned_num = floatval($total_cleaned); if ($total_cleaned_num > 0) { echo '<h5>'; _e('Total clean up overall:', 'wp-optimize'); echo ' '; echo '<font color="green">'; echo wpo_format_size($total_cleaned); echo '</font>'; echo '</h5>'; } ?> </div> </div> </div> <div class="wpo_col wpo_span_1_of_3"> <!-- <p> <?php wpo_headerImage(); ?> </p> --> <p>
function optimizeTables($Optimize = false) { ?> <h3> <?php _e('Database Name:', 'wp-optimize'); ?> '<?php _e(DB_NAME, 'wp-optimize'); echo "'"; ?> </h3> <?php if ($Optimize) { ?> <p><?php _e('Optimized all the tables found in the database.', 'wp-optimize'); ?> </p> <?php } ?> <br style="clear" /> <table class="widefat"> <thead> <tr> <th><?php _e('No.', 'wp-optimize'); ?> </th> <th><?php _e('Tables', 'wp-optimize'); ?> </th> <th><?php _e('Records', 'wp-optimize'); ?> </th> <th><?php _e('Data Size', 'wp-optimize'); ?> </th> <th><?php _e('Index Size', 'wp-optimize'); ?> </th> <th><?php _e('Type', 'wp-optimize'); ?> </th> <th><?php _e('Overhead', 'wp-optimize'); ?> </th> </tr> </thead> <tbody id="the-list"> <?php $alternate = ' class="alternate"'; global $wpdb; // Read SQL Version and act accordingly // Check for InnoDB tables // Check for windows servers $sqlversion = $wpdb->get_var("SELECT VERSION() AS version"); $total_gain = 0; $no = 0; $row_usage = 0; $data_usage = 0; $index_usage = 0; $overhead_usage = 0; $tablesstatus = $wpdb->get_results("SHOW TABLE STATUS"); foreach ($tablesstatus as $tablestatus) { if ($no % 2 == 0) { $style = ''; } else { $style = ' class="alternate"'; } $no++; echo "<tr{$style}>\n"; echo '<td>' . number_format_i18n($no) . '</td>' . "\n"; echo "<td>{$tablestatus->Name}</td>\n"; echo '<td>' . number_format_i18n($tablestatus->Rows) . '</td>' . "\n"; echo '<td>' . wpo_format_size($tablestatus->Data_length) . '</td>' . "\n"; echo '<td>' . wpo_format_size($tablestatus->Index_length) . '</td>' . "\n"; echo '<td>' . $tablestatus->Engine . '</td>' . "\n"; //echo '<td>'.wpo_format_size($tablestatus->Data_free).'</td>'."\n"; if ($tablestatus->Engine != 'InnoDB') { echo '<td>'; if (isset($_POST["optimize-db"])) { if ($tablestatus->Data_free > 0) { echo '<font color="blue">'; echo wpo_format_size($tablestatus->Data_free); echo '</font>'; } else { echo '<font color="green">'; echo wpo_format_size($tablestatus->Data_free); echo '</font>'; } } else { if ($tablestatus->Data_free > 0) { echo '<font color="red">'; echo wpo_format_size($tablestatus->Data_free); echo '</font>'; } else { echo '<font color="green">'; echo wpo_format_size($tablestatus->Data_free); echo '</font>'; } } echo '</td>' . "\n"; } else { echo '<td>'; echo '<font color="blue">'; echo '-'; echo '</font>'; echo '</td>' . "\n"; } $row_usage += $tablestatus->Rows; $data_usage += $tablestatus->Data_length; $index_usage += $tablestatus->Index_length; if ($tablestatus->Engine != 'InnoDB') { $overhead_usage += $tablestatus->Data_free; $total_gain += $tablestatus->Data_free; } else { $overhead_usage += 0; $total_gain += 0; } echo '</tr>' . "\n"; } echo '<tr class="thead">' . "\n"; echo '<th>' . __('Total:', 'wp-optimize') . '</th>' . "\n"; echo '<th>' . sprintf(_n('%s Table', '%s Tables', $no, 'wp-optimize'), number_format_i18n($no)) . '</th>' . "\n"; echo '<th>' . sprintf(_n('%s Record', '%s Records', $row_usage, 'wp-optimize'), number_format_i18n($row_usage)) . '</th>' . "\n"; echo '<th>' . wpo_format_size($data_usage) . '</th>' . "\n"; echo '<th>' . wpo_format_size($index_usage) . '</th>' . "\n"; echo '<th>' . '-' . '</th>' . "\n"; echo '<th>'; if (isset($_POST["optimize-db"])) { if ($overhead_usage > 0) { echo '<font color="blue">'; echo wpo_format_size($overhead_usage); echo '</font>'; } else { echo '<font color="green">'; echo wpo_format_size($overhead_usage); echo '</font>'; } } else { if ($overhead_usage > 0) { echo '<font color="red">'; echo wpo_format_size($overhead_usage); echo '</font>'; } else { echo '<font color="green">'; echo wpo_format_size($overhead_usage); echo '</font>'; } } echo '</th>' . "\n"; echo '</tr>'; ?> </tbody> </table> <h3><?php _e('Total Size of Database', 'wp-optimize'); ?> :</h3> <h2><?php list($part1, $part2) = wpo_getCurrentDBSize(); echo $part1; ?> </h2> <?php if (isset($_POST["optimize-db"])) { ?> <?php //$total_gain = round ($total_gain,3); ?> <h3><?php _e('Optimization Results', 'wp-optimize'); ?> :</h3> <p style="color: #0000FF;"> <?php if ($total_gain > 0) { _e('Total Space Saved', 'wp-optimize'); echo ': '; echo wpo_format_size($total_gain); wpo_updateTotalCleaned(strval($total_gain)); } ?> </p> <?php } else { //$total_gain = round ($total_gain,3); ?> <?php if (!$total_gain == 0) { ?> <h3><?php if ($total_gain > 0) { _e('Optimization Possibility', 'wp-optimize'); echo ':'; } ?> </h3> <p style="color: #FF0000;"> <?php if ($total_gain > 0) { _e('Total space can be saved', 'wp-optimize'); ?> : <?php echo wpo_format_size($total_gain); } ?> </p> <?php } } ?> <?php }
function wpo_getCurrentDBSize() { global $wpdb; $total_gain = 0; $total_size = 0; $no = 0; $row_usage = 0; $data_usage = 0; $index_usage = 0; $overhead_usage = 0; $tablesstatus = $wpdb->get_results("SHOW TABLE STATUS"); wpo_debugLog('Checking DB size .... '); foreach ($tablesstatus as $tablestatus) { $row_usage += $tablestatus->Rows; $data_usage += $tablestatus->Data_length; $index_usage += $tablestatus->Index_length; if ($tablestatus->Engine != 'InnoDB') { $overhead_usage += $tablestatus->Data_free; $total_gain += $tablestatus->Data_free; } } $total_size = $data_usage + $index_usage; wpo_debugLog('Total Size .... ' . $total_size); wpo_debugLog('Total Gain .... ' . $total_gain); return array(wpo_format_size($total_size), wpo_format_size($total_gain)); //$wpdb->flush(); }
function wpo_getCurrentDBSize() { global $wpdb; $total_gain = 0; $total_size = 0; $no = 0; $row_usage = 0; $data_usage = 0; $index_usage = 0; $overhead_usage = 0; $tablesstatus = $wpdb->get_results("SHOW TABLE STATUS"); foreach ($tablesstatus as $tablestatus) { $row_usage += $tablestatus->Rows; $data_usage += $tablestatus->Data_length; $index_usage += $tablestatus->Index_length; $overhead_usage += $tablestatus->Data_free; $total_gain += $tablestatus->Data_free; } $total_size = $data_usage + $index_usage; return array(wpo_format_size($total_size), wpo_format_size($total_gain)); //$wpdb->flush(); }