Changeset 700

Timestamp:

Mar 28, 2010, 7:42:27 PM (14 years ago)

Author:

george

Message:

• Přidáno: Zobrazení seznamu online hráčů pro všechny světy společně.

Location:

trunk

Files:

• inc/html.php (modified) (1 diff)
• pages/online-hraci.php (modified) (4 diffs)

trunk/inc/html.php

@@ -227 +227 @@
         '<tr>'.
         '<td colspan="2">'.
-        '<strong>Server : </strong>'.$server->OnlineStateImage($OnlineState).'<b> (<a href="'.$html->Link('/svety/').'">'.$server->OnlineCharactersCount().' hráčů celkem</a>) | Patch '.$Config['Mangos']['ClientVersion'].' | <a href="'.$html->Link('/pages/realmlist.wtf').'">Realmlist</a> | <a href="'.$html->Link('/server/').'">Server</a> | <a href="'.$html->Link('/svety/').'">Světy</a></b>'.
+        '<strong>Server : </strong>'.$server->OnlineStateImage($OnlineState).'<b> (<a href="'.$html->Link('/online-hraci/').'">'.$server->OnlineCharactersCount().' hráčů celkem</a>) | Patch '.$Config['Mangos']['ClientVersion'].' | <a href="'.$html->Link('/pages/realmlist.wtf').'">Realmlist</a> | <a href="'.$html->Link('/server/').'">Server</a> | <a href="'.$html->Link('/svety/').'">Světy</a></b>'.
         '</td></tr></table><br />');
     }

trunk/pages/online-hraci.php

@@ -24 +24 @@
 echo('<h3 class="PageTitle">Online hráči</h3>');
 
-$Realm = new Realm($System, $_COOKIE['RealmIndex']);
-echo('<div style="text-align: center">Celkem '.$Realm->OnlineCharactersCount().' hráčů.</div>'.
-'<table class="BaseTable">
+if(array_key_exists('RealmIndex', $_COOKIE))
+{
+  $Realm = new Realm($System, $_COOKIE['RealmIndex']);
+  echo('<div style="text-align: center">Celkem '.$Realm->OnlineCharactersCount().' hráčů.</div>'.
+  '<table class="BaseTable">
   <tr>
     <th align="center">Frakce</th>
@@ -37 +39 @@
     MakeLink('Body arén', 'arena_points').'</th></tr>');
 
-$sql = $Realm->CharactersDatabase->query('SELECT guid, name, race, class, zone, map, '.
+  $sql = $Realm->CharactersDatabase->query('SELECT guid, name, race, class, zone, map, '.
   'CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", '.$Config['Mangos']['CharacterDataOffset']['HonorPoints'].'+1), " ", -1) AS UNSIGNED) AS highest_rank, '.
   'CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", '.$Config['Mangos']['CharacterDataOffset']['Level'].' + 1), " ", -1) AS UNSIGNED) AS level, '.
@@ -43 +45 @@
   '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);
-while($row = $sql->fetch_assoc())
-{
-  $aliance = array(1, 3, 4, 7, 11);
-  $frakce = (in_array($row['race'], $aliance)) ? '<img src="'.$html->Link('/imgs/inc/a.gif').'" alt="aliance"/>' : '<img src="'.$html->Link('/imgs/inc/h.gif').'" alt="horda" />';
-  $gender = ($row['gender'] == 0) ? '0' : '1';
-  echo('<tr>
+  while($row = $sql->fetch_assoc())
+  {
+    $aliance = array(1, 3, 4, 7, 11);
+    $frakce = (in_array($row['race'], $aliance)) ? '<img src="'.$html->Link('/imgs/inc/a.gif').'" alt="aliance"/>' : '<img src="'.$html->Link('/imgs/inc/h.gif').'" alt="horda" />';
+    $gender = ($row['gender'] == 0) ? '0' : '1';
+    echo('<tr>
       <td align="center">'.$frakce.'</td>
       <td align="center">'.$row['name'].'</td>
@@ -56 +58 @@
       <td align="center">'.$server->MapName($row['map']).'<br />('.$server->ZoneName($row['zone']).')</td>
       <td align="center">'.$row['highest_rank'].'<br />'.$row['arena_points'].'</td></tr>');
+  }
+  echo('</table>');
+} else
+{
+  $PlayerList = array();
+  $DbResult2 = $System->Database->query('SELECT * FROM Realm WHERE Enabled =1');  
+  while($DbRealm = $DbResult2->fetch_assoc())
+  {
+    $Realm = new Realm($System, $DbRealm['Id']);
+    $sql = $Realm->CharactersDatabase->query('SELECT guid, name, race, class, zone, map, '.
+  'CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", '.$Config['Mangos']['CharacterDataOffset']['HonorPoints'].'+1), " ", -1) AS UNSIGNED) AS highest_rank, '.
+  'CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", '.$Config['Mangos']['CharacterDataOffset']['Level'].' + 1), " ", -1) AS UNSIGNED) AS level, '.
+  '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);
+    while($DbRow = $sql->fetch_assoc())
+    {
+      $DbRow['svet'] = $DbRealm['Name'];
+      $PlayerList[$DbRow['name'].$DbRow['svet']] = $DbRow;
+    }
+  }
+  
+  echo('<div style="text-align: center">Celkem '.count($PlayerList).' hráčů ve všech světech.</div>'.
+  '<table class="BaseTable">
+  <tr>'.
+    '<th align="center">Frakce</th>'.
+    '<th align="center">'.MakeLink('Jméno', 'name').'</th>'.
+    '<th align="center">'.MakeLink('Rasa', 'race').'</th>'.
+    '<th align="center">'.MakeLink('Třída', 'class').'</th>'.
+    '<th align="center">'.MakeLink('Úroveň', 'level').'</th>'.
+    '<th align="center">'.MakeLink('Svět', 'svet').'</th>'.
+    '</tr>');
+    
+  ksort($PlayerList);
+
+  foreach($PlayerList as $row)
+  {
+    $aliance = array(1, 3, 4, 7, 11);
+    $frakce = (in_array($row['race'], $aliance)) ? '<img src="'.$html->Link('/imgs/inc/a.gif').'" alt="aliance"/>' : '<img src="'.$html->Link('/imgs/inc/h.gif').'" alt="horda" />';
+    $gender = ($row['gender'] == 0) ? '0' : '1';
+    echo('<tr>'.
+      '<td align="center">'.$frakce.'</td>'.
+      '<td align="center">'.$row['name'].'</td>'.
+      '<td align="center"><img src="'.$html->Link('/imgs/icons/'.$row['race'].'-'.$gender.'.gif').'" alt="rasa" /></td>'.
+      '<td align="center"><img src="'.$html->Link('/imgs/icons/'.$row['class'].'.gif').'" alt="třída" /></td>'.
+      '<td align="center">'.$row['level'].'</td>'.
+      '<td align="center">'.$row['svet'].'</td>'.
+      '</tr>');
+  }
+  echo('</table>');
 }
-echo('</table>');
 
 ?>