Changeset 309 for minimanager/pomm_public/pomm_run.php

Timestamp:

Mar 13, 2008, 8:45:46 PM (17 years ago)

Author:

george

Message:

Opravy související s přejmenování sloupce character na characters.

File:

• minimanager/pomm_public/pomm_run.php (modified) (5 diffs)

minimanager/pomm_public/pomm_run.php

@@ -3 +3 @@
  * Project Name: MiniManager for Mangos Server
  * Date: 17.10.2006 inital version (0.0.1a)
- * Author: Q.SA (thanks to mirage666 for the original idea) 
+ * Author: Q.SA (thanks to mirage666 for the original idea)
  * Copyright: Q.SA
  * Email: *****
@@ -18 +18 @@
 
 if( !$user_lvl && !$server[$realm_id]['both_factions']){
-        $result = $sql->query("SELECT race FROM `character` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `character` WHERE account = '$user_id') LIMIT 1");
+        $result = $sql->query("SELECT race FROM `characters` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `characters` 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))) ?
@@ -27 +27 @@
 $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");
+                FROM `characters` WHERE `online`= 1 $order_side");
 
 $i = 0;
@@ -33 +33 @@
         $char_gender = str_pad(dechex($char[7]),8, 0, STR_PAD_LEFT);
 
-        $pos = get_player_position($char[3],$char[4],$char[5],$char[8]); 
+        $pos = get_player_position($char[3],$char[4],$char[5],$char[8]);
         $arr[$i]['x'] = $pos['x'];
         $arr[$i]['y'] = $pos['y'];
@@ -48 +48 @@
 $sql->close();
 
-$_RESULT =$arr; 
+$_RESULT =$arr;
 ?>