Changeset 512 for trunk/pages

Timestamp:

Mar 22, 2009, 4:47:19 PM (16 years ago)

Author:

barny

Message:

Pokus o opravu č.2

File:

• trunk/pages/online.php (modified) (1 diff)

trunk/pages/online.php

@@ -37 +37 @@
   $db -> select_db($db_characters);
   $sql = $db -> query("SELECT guid,name,race,class,zone,map,
-  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1498), ' ', -1) AS UNSIGNED) AS highest_rank,
-  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 53), ' ', -1) AS UNSIGNED) AS level,
-  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1499), ' ', -1) AS UNSIGNED) AS arena_points,
-  mid(lpad( hex( CAST(substring_index(substring_index(data,' ',36),' ',-1) as unsigned) ),8,'0'),4,1) AS gender
+  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1498+1), ' ', -1) AS UNSIGNED) AS highest_rank,
+  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 53+1), ' ', -1) AS UNSIGNED) AS level,
+  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1499+1), ' ', -1) AS UNSIGNED) AS arena_points,
+  mid(lpad( hex( CAST(substring_index(substring_index(data,' ',36+1),' ',-1) as unsigned) ),8,'0'),4,1) AS gender
   FROM `characters` WHERE `online`= 1 ORDER BY `".$order_by."` $order_dir;");
 while($row = $sql -> fetch_array())