Changeset 19 for minimanager/pomm_public/pomm_run.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/pomm_public/pomm_run.php (modified) (2 diffs)

minimanager/pomm_public/pomm_run.php

@@ -14 +14 @@
 $JsHttpRequest =& new JsHttpRequest($site_encoding);
 
-$mysql = new MySQL;
-$mysql->connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
+$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']);
 
 if( !$user_lvl && !$server[$realm_id]['both_factions']){
-        $result = $mysql->query("SELECT race FROM `character` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `character` WHERE account = '$user_id') LIMIT 1");
-        if ($mysql->num_rows($result)){
-                $order_side = (in_array($mysql->result($result, 0, 'race'),array(2,5,6,8,10))) ?
+        $result = $sql->query("SELECT race FROM `character` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `character` WHERE account = '$user_id') LIMIT 1");
+        if ($sql->num_rows($result)){
+                $order_side = (in_array($sql->result($result, 0, 'race'),array(2,5,6,8,10))) ?
                 " AND race IN (2,5,6,8,10) " : " AND race IN (1,3,4,7,11) ";
         } else $order_side = "";
 } else $order_side = "";
 
-$result = $mysql->query("SELECT name,race,class,position_x,position_y,map,SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1),
-                SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 37), ' ', -1)
+$result = $sql->query("SELECT name,race,class,position_x,position_y,map,SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1),
+                SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 37), ' ', -1),zone
                 FROM `character` WHERE `online`= 1 $order_side");
 
 $i = 0;
-while($char = $mysql->fetch_row($result)){
+while($char = $sql->fetch_row($result)){
         $char_gender = str_pad(dechex($char[7]),8, 0, STR_PAD_LEFT);
 
-        $pos = get_player_position($char[3],$char[4],$char[5]); 
+        $pos = get_player_position($char[3],$char[4],$char[5],$char[8]); 
         $arr[$i]['x'] = $pos['x'];
         $arr[$i]['y'] = $pos['y'];
         $arr[$i]['name'] = $char[0];
-        if (($char[5] == 1)||($char[5] == 0)||($char[5] == 530)) $arr[$i]['zone'] = ereg_replace("'", "`", get_zone_name($char[5], $char[3], $char[4]));
+        if (($char[5] == 1)||($char[5] == 0)||($char[5] == 530)) $arr[$i]['zone'] = ereg_replace("'", "`", get_zone_name($char[8]));
                 else $arr[$i]['zone'] = ereg_replace("'", "`", get_map_name($char[5]));
         $arr[$i]['cl'] = $char[2];
@@ -46 +46 @@
         }
 
-$mysql->close();
+$sql->close();
 
 $_RESULT =$arr;