Changeset 683 for trunk/pages

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čů.

Location:

trunk/pages

Files:

• gmteam.php (modified) (1 diff)
• realmlist.php (modified) (3 diffs)
• server.php (modified) (2 diffs)

trunk/pages/gmteam.php

@@ -55 +55 @@
 
 $Output .= ShowGMList(array('Id' => 0, 'Name' => 'Všechny světy'));
-$DbResult = $System->Database->query('SELECT * FROM Realm');
+$DbResult = $System->Database->query('SELECT * FROM Realm WHERE Enabled=1');
 while($Realm = $DbResult->fetch_assoc())
 {

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())
     {

trunk/pages/server.php

@@ -1 +1 @@
 <?php
 
-$DbResult = $System->Database->query('SELECT COUNT(*) FROM Realm');
+$DbResult = $System->Database->query('SELECT COUNT(*) FROM Realm WHERE Enabled=1');
 $DbRow = $DbResult->fetch_row();
 $RealmCount = $DbRow[0];
+
+ // Check servers online state.
+$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.
 
 $Output = '<h3 class="PageTitle">Server Heroes of Fantasy</h3>'.
@@ -12 +17 @@
   <tr>
     <td>Přihlašovací server je</td>
-    <td>'.$server->OnlineStateImage($System->NetworkPortState($Config['Web']['WoWServerAddr'], 3724)).'</td>
+    <td>'.$server->OnlineStateImage($OnlineState).'</td>
   </tr>
   <tr>