Changeset 142 for minimanager/repair.php

Timestamp:

Nov 23, 2007, 11:29:33 PM (17 years ago)

Author:

george

Message:

Minimanager 0.1.5b

File:

• minimanager/repair.php (modified) (8 diffs)

minimanager/repair.php

@@ -16 +16 @@
 //##############################################################################################
 function repair_form(){
- global $lang_global, $lang_repair, $output, $realm_db, $realm_id, $mangos_db;
- 
+ global $lang_global, $lang_repair, $output, $realm_db, $realm_id, $mangos_db, $characters_db;
+
  $output .= "<center>
-                <fieldset style=\"width: 700px;\">
+                <fieldset class=\"tquarter_frame\">
                 <legend>{$lang_repair['repair_optimize']}</legend>
                 <form action=\"repair.php?action=do_repair\" method=\"post\" name=\"form\">
@@ -34 +34 @@
         </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>
@@ -48 +48 @@
                         </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>
@@ -63 +63 @@
  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']}");
@@ -70 +70 @@
         $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>
@@ -79 +79 @@
         }
  }
-        
+
+ //$output .= "</table></form></fieldset><br /><br /></center>";
+
+foreach ($characters_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>";
 }
@@ -106 +127 @@
                         $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
                 } else {
+                        if ($table_data[0] == "mangos"){
                                 $sql->connect($mangos_db[$table_data[1]]['addr'], $mangos_db[$table_data[1]]['user'], $mangos_db[$table_data[1]]['pass']);
+                                } else {
+                                                $sql->connect($characters_db[$table_data[1]]['addr'], $characters_db[$table_data[1]]['user'], $characters_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];
@@ -127 +152 @@
 $num = (isset($_GET['num'])) ? $_GET['num'] : NULL;
 $rep_err = (isset($_GET['rep_err'])) ? $_GET['rep_err'] : NULL;
-        
+
 $output .= "<div class=\"top\">";
 switch ($err) {