Changeset 68

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ů.

Location:

trunk/www

Files:

• index.php (modified) (1 diff)
• model/server.php (modified) (1 diff)
• view/server.php (modified) (1 diff)

trunk/www/index.php

@@ -296 +296 @@
         $RealmView = new RealmView($this->Database, $this->System);
         $Output .= $RealmView->Stop();
+      } else
+      if($_GET['Action'] == 'UpdateRealmCharacters')
+      {
+        $Server = new Server($this->Database, $_GET['Id']);
+        $Output .= $Server->UpdateRealmlistAccountCount();
       } else
       if($_GET['Action'] == 'Test')

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)');
+    }
+  }
 }
 

trunk/www/view/server.php

@@ -151 +151 @@
       //$Output .= ' <a href="?Action=ServerDatabaseImport&amp;Id='.$Server->Id.'">Načtení čisté databáze</a>';
       $Output .= ' <a href="?Action=RealmAdd&amp;Id='.$Server->Id.'">Vytvořit nový svět</a>';
+      $Output .= ' <a href="?Action=UpdateRealmCharacters&amp;Id='.$Server->Id.'">Aktualizovat počty postav</a>';
     }
     $Output .= ' <a href="?Action=GameAccountRegister&amp;Id='.$Server->Id.'">Vytvoření herního účtu</a>';