Changeset 19 for minimanager/repair.php

Timestamp:

Aug 13, 2007, 9:05:34 PM (17 years ago)

Author:

george

Message:

Aktualizace MaNGOS Minimanageru na verzi 0.1.4a.

File:

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

minimanager/repair.php

@@ -35 +35 @@
  $output .="<script type=\"text/javascript\" src=\"js/check.js\"></script>";
                  
- $mysql = new MySQL;
- $mysql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
+ $sql = new SQL;
+ $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
 
- $result = $mysql->query("SHOW TABLES FROM {$realm_db['name']}");
+ $result = $sql->query("SHOW TABLES FROM {$realm_db['name']}");
                 
  $output .= "<table class=\"lined\" style=\"width: 550px;\">
                         <tr>
-                                <td width=\"5%\" class=\"head\"><input name=\"allbox\" type=\"checkbox\" value=\"Check All\" onclick=\"CheckAll(document.form);\" /></td>
-                                <td width=\"25%\" class=\"head\">{$lang_repair['table_name']}</td>
-                                <td width=\"35%\" class=\"head\">{$lang_repair['status']}</td>
-                                <td width=\"15%\" class=\"head\">{$lang_repair['num_records']}</td>
+                                <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 = $mysql->fetch_row($result)){
-        $result1 = $mysql->query("SELECT count(*) FROM `$table[0]`");
-        $result2 = $mysql->query("CHECK TABLE `$table[0]` CHANGED");
+ 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>".$mysql->result($result2, 0, 'Msg_type')." : ".$mysql->result($result2, 0, 'Msg_text')."</td>
-                        <td>".$mysql->result($result1, 0)."</td>
+                        <td>".$sql->result($result2, 0, 'Msg_type')." : ".$sql->result($result2, 0, 'Msg_text')."</td>
+                        <td>".$sql->result($result1, 0)."</td>
             </tr>";
 }
@@ -64 +64 @@
         $output .= "<tr class=\"large_bold\"><td colspan=\"3\" class=\"hidden\" align=\"left\">{$db['name']} Tables :</td></tr>";
         
-        $mysql->connect($db['addr'], $db['user'], $db['pass'], $db['name']);
-        $result = $mysql->query("SHOW TABLES FROM {$db['name']}");
+        $sql->connect($db['addr'], $db['user'], $db['pass'], $db['name']);
+        $result = $sql->query("SHOW TABLES FROM {$db['name']}");
 
-        while ($table = $mysql->fetch_row($result)){
-        $result1 = $mysql->query("SELECT count(*) FROM `$table[0]`");
-        $result2 = $mysql->query("CHECK TABLE `$table[0]` CHANGED");
+        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>".$mysql->result($result2, 0, 'Msg_type')." : ".$mysql->result($result2, 0, 'Msg_text')."</td>
-                        <td>".$mysql->result($result1, 0)."</td>
+                        <td>".$sql->result($result2, 0, 'Msg_type')." : ".$sql->result($result2, 0, 'Msg_text')."</td>
+                        <td>".$sql->result($result1, 0)."</td>
             </tr>";
         }
@@ -97 +97 @@
         }
 
- $mysql = new MySQL;
+ $sql = new SQL;
  $counter = 0;
 
@@ -104 +104 @@
                 $table_data = explode("~", $table);
                 if ($table_data[0] == "realm"){
-                        $mysql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass']);
+                        $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
                 } else {
-                                $mysql->connect($mangos_db[$table_data[1]]['addr'], $mangos_db[$table_data[1]]['user'], $mangos_db[$table_data[1]]['pass']);
+                                $sql->connect($mangos_db[$table_data[1]]['addr'], $mangos_db[$table_data[1]]['user'], $mangos_db[$table_data[1]]['pass']);
                                 }
 
-                 $result = $mysql->query("$table_action TABLE {$table_data[2]}.`{$table_data[3]}`");
-                 $action_result = $mysql->fetch_row($result);
+                 $result = $sql->query("$table_action TABLE {$table_data[2]}.`{$table_data[3]}`");
+                 $action_result = $sql->fetch_row($result);
                  
                  if ($action_result[3] === "OK") $counter++;