Changeset 683 for trunk/inc

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/inc

Files:

• realm.php (modified) (1 diff)
• server.php (modified) (4 diffs)
• update_state.php (modified) (2 diffs)

trunk/inc/realm.php

@@ -11 +11 @@
     parent::__construct($System);
     $this->Id = $Id;
-    $DbResult = $this->Database->query('SELECT * FROM Realm WHERE Id='.$Id);
+    $DbResult = $this->Database->query('SELECT * FROM Realm WHERE Id='.$Id.' AND Enabled=1');
     $this->Data = $DbResult->fetch_assoc();
     $this->CharactersDatabase = new Database($this->Data['DatabaseHost'], $this->Data['DatabaseUser'], $this->Data['DatabasePassword'], $this->Data['DatabaseCharacters']);

trunk/inc/server.php

@@ -13 +13 @@
     parent::__construct($System);
     $this->Id = $Id;
-    $DbResult = $this->Database->query('SELECT * FROM Logon WHERE Id='.$Id);
+    $DbResult = $this->Database->query('SELECT * FROM Logon WHERE Id='.$Id.' AND Enabled=1' );
     $this->Data = $DbResult->fetch_assoc();
     $this->ServerDatabase = new Database($this->Data['DatabaseHost'], $this->Data['DatabaseUser'], $this->Data['DatabasePassword'], $this->Data['DatabaseRealmd']);
@@ -53 +53 @@
   {
     $TotalCount = 0;
-    $DbResult = $this->Database->query('SELECT Id FROM Realm');
+    $DbResult = $this->Database->query('SELECT Id FROM Realm WHERE Enabled=1');
     while($DbRow = $DbResult->fetch_assoc())
     {
@@ -71 +71 @@
   {
     $TotalCount = 0;
-    $DbResult = $this->Database->query('SELECT Id FROM Realm');
+    $DbResult = $this->Database->query('SELECT Id FROM Realm WHERE Enabled=1');
     while($DbRow = $DbResult->fetch_assoc())
     {
@@ -372 +372 @@
   {
     $Output = '';
-    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Realm');
+    $DbResult = $this->Database->query('SELECT COUNT(*) FROM Realm WHERE Enabled=1');
     $DbRow = $DbResult->fetch_row();
     $RealmCount = $DbRow[0];

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