Changeset 596 for trunk

Timestamp:

May 20, 2009, 8:26:17 AM (15 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

Files:

• Readme.txt (modified) (1 diff)
• inc/registration_limit.php (added)
• inc/registration_update.php (added)
• inc/server.php (modified) (4 diffs)
• pages/check_registration.php.php (deleted)
• pages/reg_config.php (deleted)
• pages/register.php (modified) (2 diffs)
• pages/register_old.php (deleted)
• sql/updates/596.sql (added)

trunk/Readme.txt

@@ -24 +24 @@
 download - soubory ke stažení
 client - původní složka programu Heroes of Fantasy client
-gallery - obrázková galerie Plogger
 pages - složka se stránkami webu
 mangos_debug - záznam a zobrazování logů mangosu
 
+Neverzované
+gallery - obrázková galerie Plogger
 
+
+4) Periodické spouštění
+
+Každých 5 minut spouštět skript inc/registration_update.php

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

trunk/pages/register.php

@@ -1 +1 @@
 <?php
+
+include('inc/registration_limit.php');
+
+$RegistrationLimit = new RegistrationLimit($db, $server, $Config);
 
 function sha_password($account, $password)
@@ -36 +40 @@
 
 $db->select_db($Config['Mangos']['DatabaseRealmd']);
-$DbResult = $db->query('SELECT COUNT(*) FROM `account`');
-if($DbResult->num_rows >= $Config['Mangos']['MaxAccountCount'])
+if($RegistrationLimit->GetFreeRegistrationCount() == 0)
 {
-  echo('<div class="h10">Registrace jsou uzavřeny</div>');
-  echo('<div class="h11">Limit vyčerpán</div>');
+  echo('<div class="h10">Registrace pro dnešní den vyčerpány</div>');
+  echo('<div class="h10">Dnes bylo '.$RegistrationLimit->GetPerDeyRegistrationCount().' volných registrací</div>');
 } else
 {
-  echo('<div class="h11">Registrace otevřeny</div>');
+  echo('<div class="h11">Pro tento den je povoleno '.$RegistrationLimit->GetPerDeyRegistrationCount().' volných registrací</div>');
+  echo('<div class="h11">Zbývá ještě '.$RegistrationLimit->GetFreeRegistrationCount().' volných registrací</div>');
   echo('<br />');