Changeset 683 for trunk/pages/realmlist.php

Timestamp:

Jan 23, 2010, 5:23:04 PM (14 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:

• trunk/pages/realmlist.php (modified) (3 diffs)

trunk/pages/realmlist.php

@@ -3 +3 @@
 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']);
+  $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)
   {
@@ -15 +15 @@
   $Output = '<h2 align="center">Seznam světů</h2>';
 
-  $DbResult = $System->Database->query('SELECT Logon.Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host');
+  $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">Realmlist <a href="?page=realmlist&amp;Server='.$DbRow['Id'].'">'.$DbRow['Address'];
+    $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>';
@@ -31 +31 @@
     '</tr>';
   
-    $DbResult2 = $System->Database->query('SELECT * FROM Realm WHERE Logon='.$Server->Id.' ORDER BY Name');
+    $DbResult2 = $System->Database->query('SELECT * FROM Realm WHERE Logon='.$Server->Id.' AND Enabled=1 ORDER BY Name');
     while($DbRow = $DbResult2->fetch_assoc())
     {