'.$lang_repair['repair_optimize'].'

'; if($user_lvl >= $action_permission['update']) { $output .= '

'.$lang_repair['select_tables'].'

'; } $output .= ' '; if($user_lvl >= $action_permission['update']) $output .= ' '; $output .= '

	'.$lang_repair['table_name'].'	'.$lang_repair['status'].'	'.$lang_repair['num_records'].'

'; $sql = new SQL; $mm_dbs=array($realm_db, $mmfpm_db); foreach ($mm_dbs as $db) { $output.= '

'; $sql->connect($db['addr'], $db['user'], $db['pass'], $db['name']); $result = $sql->query('SHOW TABLES FROM '.$db['name'].''); while ($table = $sql->fetch_row($result)) { $result1 = $sql->query('SELECT count(*) FROM '.$table[0].''); $result2 = $sql->query('CHECK TABLE '.$table[0].' CHANGED'); $output .= ' '; if($user_lvl >= $action_permission['update']) $output .= ' '; $output .= ' '; } $output .= ' '; } $mm_dbs=array($world_db, $characters_db); foreach ($mm_dbs as $dbs) { foreach ($dbs as $dbr => $db) { $output .= '

'; $sql->connect($db['addr'], $db['user'], $db['pass'], $db['name']); $result = $sql->query('SHOW TABLES FROM '.$db['name'].''); while ($table = $sql->fetch_row($result)) { $result1 = $sql->query('SELECT count(*) FROM '.$table[0].''); $result2 = $sql->query('CHECK TABLE '.$table[0].' CHANGED'); $output .= ' '; if($user_lvl >= $action_permission['update']) $output .= ' '; $output .= ' '; } $output .= ' '; } } unset($dbs); unset($db); unset($result); unset($result2); unset($result1); unset($table); unset($mm_dbs); $output .= '

'; } //############################################################################################## // EXECUTE TABLE REPAIR OR OPTIMIZATION //############################################################################################## function do_repair() { global $output, $realm_db, $mmfpm_db, $world_db, $characters_db, $action_permission; valid_login($action_permission['update']); if ((empty($_POST['repair_action']) && '' === $_POST['repair_action']) || (empty($_POST['check'])) ) redirect('repair.php?error=1'); else { $table_list = $_POST['check']; $table_action = addslashes($_POST['repair_action']); } $sql = new SQL; $counter = 0; foreach($table_list as $table) { $table_data = explode('~', $table); if ($table_data[2] == $realm_db['name']) $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']); elseif ($table_data[2] == $mmfpm_db['name']) $sql->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']); elseif ($table_data[2] == $world_db[$table_data[1]]['name']) $sql->connect($world_db[$table_data[1]]['addr'], $world_db[$table_data[1]]['user'], $world_db[$table_data[1]]['pass']); elseif ($table_data[2] == $characters_db[$table_data[1]]['name']) $sql->connect($characters_db[$table_data[1]]['addr'], $characters_db[$table_data[1]]['user'], $characters_db[$table_data[1]]['pass']); $action_result = $sql->fetch_row($sql->query(''.$table_action.' TABLE '.$table_data[2].'.'.$table_data[3].'')); if ($action_result[3] === 'OK') ++$counter; else $err = $action_result[3]; } unset($action_result); unset($table_data); unset($table); unset($table_action); unset($table_list); if ($counter) redirect('repair.php?error=2&num='.$counter.''); else redirect('repair.php?error=4&rep_err='.$err.''); } //######################################################################################################################## // MAIN //######################################################################################################################## $err = (isset($_GET['error'])) ? $_GET['error'] : NULL; $num = (isset($_GET['num'])) ? $_GET['num'] : NULL; $rep_err = (isset($_GET['rep_err'])) ? $_GET['rep_err'] : NULL; $output .= '

'; $lang_repair = lang_repair(); if (1 == $err) $output .= '

'.$lang_global['empty_fields'].'

'; elseif (2 == $err) $output .= '

'.$lang_repair['repair_finished'].' : '.$num.' '.$lang_repair['tables'].'

'; elseif (3 == $err) $output .= '

'.$lang_repair['no_table_selected'].'

'; elseif (4 == $err) $output .= '

'.$lang_repair['repair_error'].' : '.$rep_err.'

'; else $output .= '

'.$lang_repair['repair_optimize'].'

'; $output .= '

'; unset($err); unset($num); unset($rep_err); $action = (isset($_GET['action'])) ? $_GET['action'] : NULL; if ('repair_form' == $action) repair_form(); elseif ('do_repair' == $action) do_repair(); else repair_form(); unset($action); unset($action_permission); unset($lang_repair); include_once 'footer.php'; ?>