Changeset 701 for trunk/pages/online-hraci.php

Timestamp:

Mar 28, 2010, 9:28:01 PM (15 years ago)

Author:

george

Message:

• Opraveno: Řazení společného výpisu online hráčů.

File:

• trunk/pages/online-hraci.php (modified) (2 diffs)

trunk/pages/online-hraci.php

@@ -72 +72 @@
   'CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", '.$Config['Mangos']['CharacterDataOffset']['ArenaPoints'].' + 1), " ", -1) AS UNSIGNED) AS arena_points, '.
   'mid(lpad( hex( CAST(substring_index(substring_index(data, " ", '.$Config['Mangos']['CharacterDataOffset']['Gender'].' + 1), " ", -1) as unsigned) ), 8, 0), 4, 1) AS gender '.
-  'FROM `characters` WHERE `online`= 1 ORDER BY `'.$order_by.'` '.$order_dir);
+  'FROM `characters` WHERE `online`= 1');
+    $I = 0;
     while($DbRow = $sql->fetch_assoc())
     {
       $DbRow['svet'] = $DbRealm['Name'];
-      $PlayerList[$DbRow['name'].$DbRow['svet']] = $DbRow;
+      $PlayerList[$DbRow[$order_by].$I] = $DbRow;
+      $I++;
     }
   }
@@ -91 +93 @@
     '</tr>');
     
-  ksort($PlayerList);
+  if($order_dir == 'ASC') ksort($PlayerList);
+    else krsort($PlayerList);
 
   foreach($PlayerList as $row)