Changeset 142 for minimanager/char_edit.php

Timestamp:

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

Author:

george

Message:

Minimanager 0.1.5b

File:

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

minimanager/char_edit.php

@@ -19 +19 @@
 //########################################################################################################################
 function edit_char() {
- global $lang_global, $lang_char, $lang_item, $output, $realm_db, $mangos_db, $realm_id, $user_lvl,
+ global $lang_global, $lang_char, $lang_item, $output, $realm_db, $characters_db, $realm_id, $user_lvl,
                 $item_datasite;
                 
@@ -25 +25 @@
 
 $sql = new SQL;
-$sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+$sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
  
 $id = $sql->quote_smart($_GET['id']);
@@ -40 +40 @@
 
  if ($user_lvl >= $owner_gmlvl){
-        $sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+        $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
 
         $result = $sql->query("SELECT guid,account,data,name,race,class,position_x,position_y,map,online,totaltime,position_z,zone      FROM `character` WHERE guid = '$id'");
@@ -169 +169 @@
 
 //inventory+bank items
-        $sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+        $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
         $query2 = $sql->query("SELECT bag,slot,item,item_template FROM character_inventory WHERE guid = '$id' ORDER BY bag,slot");
 
@@ -232 +232 @@
 function do_edit_char() {
  global $lang_global, $lang_char, $output, $realm_db, 
-                $mangos_db, $realm_id, $user_lvl;
+                $characters_db, $realm_id, $user_lvl , $mangos_db;
                 
 if ( empty($_GET['id']) || empty($_GET['name']) ) error($lang_global['empty_fields']);
 
 $sql = new SQL;
-$sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+$sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
 
 $id = $sql->quote_smart($_GET['id']);
@@ -331 +331 @@
         $tp_to = (isset($_GET['tp_to'])) ? $sql->quote_smart($_GET['tp_to']) : 0;
 
-        $sql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+        $sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
 
         $result = $sql->query("SELECT data FROM `character` WHERE guid = '$id'");
@@ -417 +417 @@
 
         if ($tp_to){
-                $query = $sql->query("SELECT map, position_x, position_y, position_z, orientation FROM game_tele WHERE LOWER(name) = '".strtolower($tp_to)."'");
+                $query = $sql->query("SELECT map, position_x, position_y, position_z, orientation FROM `".$mangos_db[$realm_id]['name']."`.`game_tele` WHERE LOWER(name) = '".strtolower($tp_to)."'");
                 $tele = $sql->fetch_row($query);
                 if($tele) $teleport = "map='$tele[0]', position_x='$tele[1]', position_y='$tele[2]', position_z='$tele[3]', orientation='$tele[4]',";