Changeset 511 for trunk/pages


Ignore:
Timestamp:
Mar 22, 2009, 4:27:29 PM (16 years ago)
Author:
barny
Message:

Oprava Gender

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/pages/online.php

    r509 r511  
    4040  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 53), ' ', -1) AS UNSIGNED) AS level,
    4141  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 1499), ' ', -1) AS UNSIGNED) AS arena_points,
    42   mid(lpad( hex( CAST(substring_index(substring_index(data,' ',37),' ',-1) as unsigned) ),8,'0'),4,1) AS gender
     42  mid(lpad( hex( CAST(substring_index(substring_index(data,' ',36),' ',-1) as unsigned) ),8,'0'),4,1) AS gender
    4343  FROM `characters` WHERE `online`= 1 ORDER BY `".$order_by."` $order_dir;");
    4444while($row = $sql -> fetch_array())
Note: See TracChangeset for help on using the changeset viewer.