Changeset 683 for trunk/inc/server.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/server.php (modified) (4 diffs)

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];