Changeset 683 for trunk/inc/update_state.php

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:

• trunk/inc/update_state.php (modified) (2 diffs)

trunk/inc/update_state.php

@@ -13 +13 @@
 // Check logon servers
 $System = new System($Config);
-$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.Id, Host.Address, Logon.Port FROM Logon JOIN Host ON Host.Id=Logon.Host AND Logon.Enabled=1');
 while($Logon = $DbResult->fetch_assoc())
 {
@@ -23 +23 @@
 
 // Check realms
-$DbResult = $System->Database->query('SELECT Realm.Id, Host.Address, Realm.Port FROM Realm JOIN Host ON Host.Id=Realm.Host');
+$DbResult = $System->Database->query('SELECT Realm.Id, Host.Address, Realm.Port FROM Realm JOIN Host ON Host.Id=Realm.Host AND Realm.Enabled=1');
 while($Realm = $DbResult->fetch_assoc())
 {