Ignore:
Timestamp:
Jan 23, 2010, 5:23:04 PM (15 years ago)
Author:
george
Message:
  • Přidáno: Nové sloupce Enabled pro povolení/zakázání světů, přihlšaovacích serverů a počítačů.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/pages/realmlist.php

    r681 r683  
    33if(array_key_exists('Server', $_GET))
    44{
    5   $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']);
     5  $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');
    66  if($DbResult->num_rows > 0)
    77  {
     
    1515  $Output = '<h2 align="center">Seznam světů</h2>';
    1616
    17   $DbResult = $System->Database->query('SELECT Logon.Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host');
     17  $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');
    1818  while($DbRow = $DbResult->fetch_assoc())
    1919  {
    2020    $Server = new Server($System, $DbRow['Id']);
    21     $Output .= '<div style="text-align: center">Realmlist <a href="?page=realmlist&amp;Server='.$DbRow['Id'].'">'.$DbRow['Address'];
     21    $Output .= '<div style="text-align: center">'.$DbRow['Name'].' <a href="?page=realmlist&amp;Server='.$DbRow['Id'].'">'.$DbRow['Address'];
    2222    if($DbRow['Port'] != 3724) $Output .= ':'.$DbRow['Port'];
    2323    $Output .= '</a></div>';
     
    3131    '</tr>';
    3232 
    33     $DbResult2 = $System->Database->query('SELECT * FROM Realm WHERE Logon='.$Server->Id.' ORDER BY Name');
     33    $DbResult2 = $System->Database->query('SELECT * FROM Realm WHERE Logon='.$Server->Id.' AND Enabled=1 ORDER BY Name');
    3434    while($DbRow = $DbResult2->fetch_assoc())
    3535    {
Note: See TracChangeset for help on using the changeset viewer.