Changeset 521


Ignore:
Timestamp:
Mar 23, 2009, 10:44:35 PM (16 years ago)
Author:
barny
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/pages/online.php

    r520 r521  
    3737  $db -> select_db($db_characters);
    3838  $sql = $db -> query("SELECT guid,name,race,class,zone,map,
    39   CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters, `data`, ' ', 1498+1), ' ', -1) AS UNSIGNED) AS highest_rank,
     39  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1497+1), ' ', -1) AS UNSIGNED) AS highest_rank,
    4040  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 53+1), ' ', -1) AS UNSIGNED) AS level,
    41   CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1499), ' ', -1) AS UNSIGNED) AS arena_points,
     41  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1499+1), ' ', -1) AS UNSIGNED) AS arena_points,
    4242  mid(lpad( hex( CAST(substring_index(substring_index(data,' ',36+1),' ',-1) as unsigned) ),8,'0'),4,1) AS gender
    4343  FROM `characters` WHERE `online`= 1 ORDER BY `".$order_by."` $order_dir;");
Note: See TracChangeset for help on using the changeset viewer.