source: trunk/pages/realmlist.php@ 683

<?php

if(array_key_exists('Server', $_GET))
{
  $DbResult = $System->Database->query('SELECT Logon.Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host WHERE Logon.Id='.$_GET['Server'].' AND   Logon.Enabled=1');
  if($DbResult->num_rows > 0)
  {
    $Realm = $DbResult->fetch_assoc();
    echo('set realmlist '.$Realm['Address']);
    if($Realm['Port'] != 3724) echo(':'.$Realm['Port']);
    echo('</div>');
  } else echo('Neznámé Id serveru');
} else
{
  $Output = '<h2 align="center">Seznam světů</h2>';

  $DbResult = $System->Database->query('SELECT Logon.Name, Logon.Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host WHERE Logon.Enabled=1');
  while($DbRow = $DbResult->fetch_assoc())
  {
    $Server = new Server($System, $DbRow['Id']);
    $Output .= '<div style="text-align: center">'.$DbRow['Name'].' <a href="?page=realmlist&amp;Server='.$DbRow['Id'].'">'.$DbRow['Address'];
    if($DbRow['Port'] != 3724) $Output .= ':'.$DbRow['Port'];
    $Output .= '</a></div>';
    $Output .= '<table class="BaseTable">'.
    '<tr>'.
    '<th>Název</th>'.
    '<th>Násobek XP</th>'.
    '<th>Zaměření</th>'.
    '<th>Stav</th>'.
    '<th>Hráči online / max. online / celkem</th>'.
    '</tr>';
  
    $DbResult2 = $System->Database->query('SELECT * FROM Realm WHERE Logon='.$Server->Id.' AND Enabled=1 ORDER BY Name');
    while($DbRow = $DbResult2->fetch_assoc())
    {
      $Realm = new Realm($System, $DbRow['Id']);
      $Output .= '<tr><td><a href="?page=online&amp;RealmIndex='.$Realm->Id.'">'.$Realm->Data['Name'].'</a></td><td>'.$Realm->Data['Rate'].'</td><td>'.$Realm->Data['Type'].'</td><td>'.$Server->OnlineStateImage($Realm->Data['Online']).'</td><td>'.$Realm->OnlineCharactersCount().' / '.$Realm->Data['MaxOnlinePlayers'].' / '.$Realm->CharacterCount().'</td></tr>';
      $Output .= '<tr><td colspan="5">'.$Realm->Data['Description'].'</td></tr>';
      //if(array_key_exists($Index + 1, $Config['Mangos']['RealmList'])) 
      $Output .= '<tr><td colspan="5">&nbsp;</td></tr>';
    }
    $Output .= '</table><br/>';
  }
  echo($Output);
}

?>