Changeset 509 for trunk/pages/online.php
- Timestamp:
- Mar 22, 2009, 4:00:09 PM (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/pages/online.php
r407 r509 37 37 $db -> select_db($db_characters); 38 38 $sql = $db -> query("SELECT guid,name,race,class,zone,map, 39 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1 563), ' ', -1) AS UNSIGNED) AS highest_rank,40 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) AS UNSIGNED) AS level,41 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1 500), ' ', -1) AS UNSIGNED) AS arena_points,39 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1498), ' ', -1) AS UNSIGNED) AS highest_rank, 40 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 53), ' ', -1) AS UNSIGNED) AS level, 41 CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1499), ' ', -1) AS UNSIGNED) AS arena_points, 42 42 mid(lpad( hex( CAST(substring_index(substring_index(data,' ',37),' ',-1) as unsigned) ),8,'0'),4,1) AS gender 43 43 FROM `characters` WHERE `online`= 1 ORDER BY `".$order_by."` $order_dir;");
Note:
See TracChangeset
for help on using the changeset viewer.