Changeset 68 for trunk/www/model/server.php

Timestamp:

Aug 9, 2009, 8:28:30 AM (15 years ago)

Author:

george

Message:

• Přidáno: Funkce pro aktualizaci počtu postav v seznamu světů.

File:

• trunk/www/model/server.php (modified) (1 diff)

trunk/www/model/server.php

@@ -330 +330 @@
     return($DbRow[0]);
   }  
+  
+  function UpdateRealmlistAccountCount()
+  {
+    global $Config;
+    
+    $this->Database->query('TRUNCATE TABLE server'.$this->Id.'_realmd.realmcharacters');
+    $DbResult = $this->Database->select('Realm', '*', 'Server = '.$this->Id);
+    while($Realm = $DbResult->fetch_assoc())
+    {
+      $this->Database->query('INSERT INTO server'.$this->Id.'_realmd.realmcharacters (SELECT '.$Realm['Id'].' AS realmid, server'.$this->Id.'_realmd.account.id AS acctid, (SELECT COUNT(*) FROM realm'.$Realm['Id'].'_characters.characters WHERE realm'.$Realm['Id'].'_characters.characters.account = server'.$this->Id.'_realmd.account.id) AS numchars FROM server'.$this->Id.'_realmd.account)');
+    }
+  }
 }