Changeset 701
- Timestamp:
- Mar 28, 2010, 9:28:01 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/pages/online-hraci.php
r700 r701 72 72 'CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", '.$Config['Mangos']['CharacterDataOffset']['ArenaPoints'].' + 1), " ", -1) AS UNSIGNED) AS arena_points, '. 73 73 'mid(lpad( hex( CAST(substring_index(substring_index(data, " ", '.$Config['Mangos']['CharacterDataOffset']['Gender'].' + 1), " ", -1) as unsigned) ), 8, 0), 4, 1) AS gender '. 74 'FROM `characters` WHERE `online`= 1 ORDER BY `'.$order_by.'` '.$order_dir); 74 'FROM `characters` WHERE `online`= 1'); 75 $I = 0; 75 76 while($DbRow = $sql->fetch_assoc()) 76 77 { 77 78 $DbRow['svet'] = $DbRealm['Name']; 78 $PlayerList[$DbRow['name'].$DbRow['svet']] = $DbRow; 79 $PlayerList[$DbRow[$order_by].$I] = $DbRow; 80 $I++; 79 81 } 80 82 } … … 91 93 '</tr>'); 92 94 93 ksort($PlayerList); 95 if($order_dir == 'ASC') ksort($PlayerList); 96 else krsort($PlayerList); 94 97 95 98 foreach($PlayerList as $row)
Note:
See TracChangeset
for help on using the changeset viewer.