Changeset 596 for trunk/inc

Timestamp:

May 20, 2009, 8:26:17 AM (16 years ago)

Author:

george

Message:

• Přidáno: Třída pro systém omezování počtu registrací. Automatické povolování registrací dle předchozího počtu hráčů online vůči zadané požadované hodnotě.

Location:

trunk/inc

Files:

• registration_limit.php (added)
• registration_update.php (added)
• server.php (modified) (4 diffs)

trunk/inc/server.php

@@ -27 +27 @@
     
     $this->db->select_db($Config['Mangos']['DatabaseRealmd']);
-    $pocet = $this->db->query('SELECT `id` FROM `account` WHERE `online` = 1')->num_rows;
-    return($pocet);
+    $DbResult = $this->db->query('SELECT COUNT(*) FROM `account` WHERE `online` = 1');
+    $DbRow = $DbResult->fetch_row();
+    return($DbRow[0]);
   }
 
@@ -48 +49 @@
     global $Config;
     
-    $this->db->select_db($Config['Mangos']['DatabaseCharacters']);
-    $pocet = $this->db->query('SELECT `guid` FROM `characters` WHERE `online` = 1')->num_rows;
-    return($pocet);
+    $this->db->select_db($Config['Mangos']['DatabaseCharacters']);    
+    $DbResult = $this->db->query('SELECT COUNT(*) FROM `characters` WHERE `online` = 1');
+    $DbRow = $DbResult->fetch_row();
+    return($DbRow[0]);
   }
 
@@ -87 +89 @@
 
     $this->db->select_db($Config['Mangos']['DatabaseCharacters']);
-    $row = $this->db->query('SELECT COUNT(*) FROM characters')->fetch_array();
+    $row = $this->db->query('SELECT COUNT(*) FROM characters')->fetch_row();
     return($row[0]);
   }
@@ -96 +98 @@
 
     $this->db->select_db($Config['Mangos']['DatabaseRealmd']);
-    $row = $this->db->query('SELECT COUNT(*) FROM account')->fetch_array();
+    $row = $this->db->query('SELECT COUNT(*) FROM account')->fetch_row();
     return($row[0]);
   }