Changeset 684 for trunk

Timestamp:

Jan 23, 2010, 5:34:23 PM (15 years ago)

Author:

george

Message:

• Opraveno: Další chybějící kontroly hodnoty Enabled.
• Upraveno: Zobrazení nadpisů skupin světů.

Location:

trunk

Files:

• inc/html.php (modified) (1 diff)
• inc/server.php (modified) (1 diff)
• pages/realmlist.php (modified) (1 diff)

trunk/inc/html.php

@@ -265 +265 @@
     
     // Check servers online state.
-    $DbResult = $System->Database->query('SELECT COUNT(*) FROM Logon WHERE Online = 1');
+    $DbResult = $System->Database->query('SELECT COUNT(*) FROM Logon WHERE Online = 1 AND Enabled=1');
     $DbRow = $DbResult->fetch_row();
     $OnlineState = $DbRow[0] > 0; // Report online state if one of all servers is online.

trunk/inc/server.php

@@ -383 +383 @@
       '<div>Výběr světa <select name="RealmIndex" onchange="document.getElementById(\'RealmSelection'.$FormNameSufix.'\').submit()">';
       
-      $DbResult = $this->Database->query('SELECT * FROM Realm');
+      $DbResult = $this->Database->query('SELECT * FROM Realm WHERE Enabled=1');
       while($Realm = $DbResult->fetch_assoc())
       {

trunk/pages/realmlist.php

@@ -15 +15 @@
   $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');
+  $DbResult = $System->Database->query('SELECT Logon.ClientVersion, 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'];
+    $Output .= '<div style="text-align: center">'.$DbRow['Name'].' '.$DbRow['ClientVersion'].' - realmlist: <a href="?page=realmlist&amp;Server='.$DbRow['Id'].'">'.$DbRow['Address'];
     if($DbRow['Port'] != 3724) $Output .= ':'.$DbRow['Port'];
     $Output .= '</a></div>';