source: minimanager/repair.php@ 19

<?php
/*
 * Project Name: MiniManager for Mangos Server
 * Date: 17.10.2006 inital version (0.0.1a)
 * Author: Q.SA
 * Copyright: Q.SA
 * Email: *****
 * License: GNU General Public License v2(GPL)
 */

require_once("header.php");
valid_login(3);

//##############################################################################################
// PRINT REPAIR/OPTIMIZE FORM
//##############################################################################################
function repair_form(){
 global $lang_global, $lang_repair, $output, $realm_db, $realm_id, $mangos_db;
 
 $output .= "<center>
                <fieldset style=\"width: 700px;\">
                <legend>{$lang_repair['repair_optimize']}</legend>
                <form action=\"repair.php?action=do_repair\" method=\"post\" name=\"form\">
                  <table class=\"hidden\">";
 $output .= "<tr><td>
           <select name=\"repair_action\">
                <option value=\"REPAIR\">{$lang_repair['repair']}</option>
                <option value=\"OPTIMIZE\">{$lang_repair['optimize']}</option>
           </select>
           </td><td>";
                makebutton($lang_repair['start'], "javascript:do_submit()",100);
                makebutton($lang_global['back'], "javascript:window.history.back()",100);
 $output .= "</td></tr>
        </table><p>{$lang_repair['select_tables']}</p>";
 $output .="<script type=\"text/javascript\" src=\"js/check.js\"></script>";
                 
 $sql = new SQL;
 $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);

 $result = $sql->query("SHOW TABLES FROM {$realm_db['name']}");
                
 $output .= "<table class=\"lined\" style=\"width: 550px;\">
                        <tr>
                                <th width=\"5%\"><input name=\"allbox\" type=\"checkbox\" value=\"Check All\" onclick=\"CheckAll(document.form);\" /></th>
                                <th width=\"25%\">{$lang_repair['table_name']}</th>
                                <th width=\"35%\">{$lang_repair['status']}</th>
                                <th width=\"15%\">{$lang_repair['num_records']}</th>
                        </tr>
                        <tr class=\"large_bold\"><td colspan=\"3\" class=\"hidden\" align=\"left\">{$realm_db['name']} {$lang_repair['tables']} :</td></tr>";
                 
 while ($table = $sql->fetch_row($result)){
        $result1 = $sql->query("SELECT count(*) FROM `$table[0]`");
        $result2 = $sql->query("CHECK TABLE `$table[0]` CHANGED");
        
        $output .= "<tr>
                    <td><input type=\"checkbox\" name=\"check[]\" value=\"realm~0~{$realm_db['name']}~$table[0]\" onclick=\"CheckCheckAll(document.form);\" /></td>
                    <td>$table[0]</td>
                        <td>".$sql->result($result2, 0, 'Msg_type')." : ".$sql->result($result2, 0, 'Msg_text')."</td>
                        <td>".$sql->result($result1, 0)."</td>
            </tr>";
}

 foreach ($mangos_db as $db){
        $output .= "<tr class=\"large_bold\"><td colspan=\"3\" class=\"hidden\" align=\"left\">{$db['name']} Tables :</td></tr>";
        
        $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 .= "<tr>
                    <td><input type=\"checkbox\" name=\"check[]\" value=\"world~{$db['id']}~{$db['name']}~$table[0]\" onclick=\"CheckCheckAll(document.form);\" /></td>
                    <td>$table[0]</td>
                        <td>".$sql->result($result2, 0, 'Msg_type')." : ".$sql->result($result2, 0, 'Msg_text')."</td>
                        <td>".$sql->result($result1, 0)."</td>
            </tr>";
        }
 }
        
 $output .= "</table></form></fieldset><br /><br /></center>";
}


//##############################################################################################
// EXECUTE TABLE REPAIR OR OPTIMIZATION
//##############################################################################################
function do_repair(){
 global $lang_global, $output, $realm_db, $mangos_db;

 if ((!isset($_POST['repair_action']) && $_POST['repair_action'] === '') || (!isset($_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[0] == "realm"){
                        $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
                } else {
                                $sql->connect($mangos_db[$table_data[1]]['addr'], $mangos_db[$table_data[1]]['user'], $mangos_db[$table_data[1]]['pass']);
                                }

                 $result = $sql->query("$table_action TABLE {$table_data[2]}.`{$table_data[3]}`");
                 $action_result = $sql->fetch_row($result);
                 
                 if ($action_result[3] === "OK") $counter++;
                        else $err = $action_result[3];
                }

 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 .= "<div class=\"top\">";
switch ($err) {
case 1:
   $output .= "<h1><font class=\"error\">{$lang_global['empty_fields']}</font></h1>";
   break;
case 2:
   $output .= "<h1><font class=\"error\">{$lang_repair['repair_finished']} : $num {$lang_repair['tables']}</font></h1>";
   break;
case 3:
        $output .= "<h1><font class=\"error\">{$lang_repair['no_table_selected']}</font></h1>";
   break;
case 4:
        $output .= "<h1><font class=\"error\">{$lang_repair['repair_error']} : $rep_err</font></h1>";
   break;
default: //no error
   $output .= "<h1>{$lang_repair['repair_optimize']}</h1>";
}
$output .= "</div>";

$action = (isset($_GET['action'])) ? $_GET['action'] : NULL;

switch ($action) {
case "repair_form":
        repair_form();
        break;
case "do_repair":
        do_repair();
        break;
default:
    repair_form();
}

include_once("footer.php");
?>