Changeset 142 for minimanager/run_patch.php

Timestamp:

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

Author:

george

Message:

Minimanager 0.1.5b

File:

• minimanager/run_patch.php (modified) (7 diffs)

minimanager/run_patch.php

@@ -8 +8 @@
  * License: GNU General Public License v2(GPL)
  */
- 
+
 require_once("header.php");
 valid_login(3);
@@ -16 +16 @@
 //#####################################################################################################
 function print_upload(){
- global $lang_run_patch, $lang_global, $backup_dir, $output, $realm_db, $mangos_db, $realm_id;
+ global $lang_run_patch, $lang_global, $backup_dir, $output, $realm_db, $mangos_db, $realm_id, $characters_db;
 
 if (isset($_FILES["uploaded_file"]["name"])){
  if ($_FILES["uploaded_file"]["type"] != "application/octet-stream" && $_FILES["uploaded_file"]["type"] != "text/plain") error("{$lang_run_patch['run_sql_file_only']}<br />". $_FILES["uploaded_file"]["type"]);
- if (file_exists($_FILES["uploaded_file"]["tmp_name"])){        
+ if (file_exists($_FILES["uploaded_file"]["tmp_name"])){
         $buffer = implode('', file($_FILES["uploaded_file"]["tmp_name"]));
         } else error($lang_run_patch['file_not_found']);
  } else $buffer = "";
- 
+
         $upload_max_filesize=ini_get("upload_max_filesize");
         if (eregi("([0-9]+)K",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024;
         if (eregi("([0-9]+)M",$upload_max_filesize,$tempregs)) $upload_max_filesize=$tempregs[1]*1024*1024;
- 
+
         $output .= "<center>{$lang_run_patch['select_sql_file']} :<br />
-                                {$lang_run_patch['max_filesize']} $upload_max_filesize bytes 
+                                {$lang_run_patch['max_filesize']} $upload_max_filesize bytes
                                 (".round ($upload_max_filesize/1024/1024)." Mbytes)<br />
                 <table class=\"hidden\">
@@ -44 +44 @@
                                 <tr>
                                  <td align=\"left\">{$lang_run_patch['run_rules']}</td>
-                                 <td align=\"right\">{$lang_run_patch['select_db']}: 
+                                 <td align=\"right\">{$lang_run_patch['select_db']}:
                                  <select name=\"use_db\">";
          foreach ($mangos_db as $db) $output .= "<option value=\"{$db['name']}\">{$db['name']}</option>";
+         foreach ($characters_db as $db) $output .= "<option value=\"{$db['name']}\">{$db['name']}</option>";
          $output .= "<option value=\"{$realm_db['name']}\">{$realm_db['name']}</option>
                                  </select>
@@ -52 +53 @@
                                 <tr><td colspan=\"2\"><textarea name=\"query\" rows=\"14\" cols=\"93\">$buffer</textarea></td></tr>
                                 <tr><td colspan=\"2\">";
-                                        makebutton($lang_run_patch['run_sql'], "javascript:do_submit('form1',0)",200);
-         $output .= "</td></tr>
-                                </table>
-                                </form></center><br />";        
+                makebutton($lang_run_patch['run_sql'], "javascript:do_submit('form1',0)",200);
+                 $output .= "</td></tr>
+                                        </table>
+                                </form></center><br />";
 }
 
@@ -63 +64 @@
 //#####################################################################################################
 function do_run_patch(){
- global $lang_run_patch, $lang_global, $output, $mangos_db, $realm_db;
+ global $lang_run_patch, $lang_global, $output, $mangos_db, $realm_db, $characters_db;
 
  if ( empty($_POST['query']) || empty($_POST['use_db']) ) redirect("run_patch.php?error=1");
@@ -69 +70 @@
  $sql = new SQL;
  $sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
- 
+
  $use_db = $sql->quote_smart($_POST['use_db']);
  $query = $_POST['query'];
- 
+
  if ($use_db == $realm_db['name']) $sql->db($realm_db['name']);
         else {
                 foreach ($mangos_db as $db)
                         if ($use_db == $db['name']) $sql->connect($db['addr'], $db['user'], $db['pass'], $db['name']);
+                foreach ($characters_db as $db)
+                        if ($use_db == $db['name']) $sql->connect($db['addr'], $db['user'], $db['pass'], $db['name']);
         }
-        
+
  $new_queries = array();
  $good = 0;
  $bad = 0;
  $line = 0;
- 
+
  $queries = explode("\n",$query);
  for($i=0; $i<count($queries); $i++) {
     $queries[$i] = trim($queries[$i]);
-        
+
     if(strpos ($queries[$i], '#') === 0 || strpos ($queries[$i], '--') === 0)  $line++;
                 else array_push($new_queries, $queries[$i]);
    }
  $qr=split(";\n",implode("\n",$new_queries));
- 
+
  foreach($qr as $qry) {
         $line++;
@@ -106 +109 @@
 
  $sql->close();
- 
+
  if ($queries) redirect("run_patch.php?error=2&tot=$good");
         else redirect("run_patch.php?error=3");