'检查', 'repair' => '修复', 'analyze' => '分析', 'optimize' => '优化'); $goodresults = $tables = array(); $query = $db->query('SHOW TABLE STATUS'); while ($myval = $db->fetch_array($query)) { if (substr($myval['Name'], 0, strlen($dbpre)) == $dbpre) { $tables[] = $myval['Name']; } } foreach ($optimize as $val) { if (array_key_exists($val, $optimize_arr)) { $newtable =& $tables; foreach ($newtable as $table) { $result = $db->query($val . ' TABLE ' . $table) ? '成功' : '失败'; $goodresults[] = array('do' => $optimize_arr[$val], 'table' => $table, 'result' => $result); } } } if ($goodresults && is_array($goodresults) && 0 < count($goodresults)) { $here = 'Mymps数据库维护'; $mymps .= mymps_admin_tpl_global_head(); $mymps .= '

'; foreach ($goodresults as $result) { $mymps .= ''; } $mymps .= '

操作	操作的数据表	结果
' . $result['do'] . '	' . $result['table'] . '	' . $result['result'] . '

'; $mymps .= mymps_admin_tpl_global_foot(); echo $mymps; } else { write_msg('操作失败！'); exit; } } else { $query = $db->query('SHOW TABLE STATUS'); $mymps_rows_total = $plugin_rows_total = $other_rows_total = $mymps_Index_length = $other_Index_length = $mymps_Data_free = $other_Data_free = $mymps_Data_length = $other_Data_length = 0; while ($info = $db->fetch_array($query)) { $info['Index_length_unit'] += sizeunit(@intval($info['Index_length'])); $info['Data_free_unit'] += sizeunit(@intval($info['Data_free'])); $info['Data_length_unit'] += sizeunit(@intval($info['Data_length'])); if (substr($info['Name'], 0, strlen($db_mymps)) == $db_mymps) { $mymps_table_info[] = $info; $mymps_rows_total += $info['Rows']; $mymps_Index_length += $info['Index_length']; $mymps_Data_free += $info['Data_free']; $mymps_Data_length += $info['Data_length']; } else { $other_table_info[] = $info; $other_rows_total += $info['Rows']; $other_Index_length += $info['Index_length']; $other_Data_free += $info['Data_free']; $other_Data_length += $info['Data_length']; } } $here = '数据库维护'; include mymps_tpl('mymps_optimize'); }