Changeset 146 for stat/stat.php

Timestamp:

Nov 24, 2007, 6:01:41 PM (17 years ago)

Author:

george

Message:

Opraveno: Správné načítání z databáze mangosu characters.

File:

• stat/stat.php (modified) (3 diffs)

stat/stat.php

@@ -10 +10 @@
 $RealmPassword = $Password;
 $RealmDatabase = 'realmd';  // must contains zone_coordinates and accounts table
+$CharactersDatabase = 'characters';  // must contains zone_coordinates and accounts table
 $EmuVersion = $Config['Mangos']['Version'];
 $Owner = $Config['Web']['Admin'];
@@ -23 +24 @@
 {
   global $Hostname, $Username, $Password, $Database, $EmuVersion, $Owner, $ServerName, $realm_db, $DatabaseEncoding,
-  $RealmHostname, $RealmUsername, $RealmPassword, $RealmDatabase;
+  $RealmHostname, $RealmUsername, $RealmPassword, $RealmDatabase, $CharactersDatabase;
    
   $Result = 
@@ -59 +60 @@
   $db_result = mysql_query("SET NAMES $DatabaseEncoding", $mangos_db);
   
-  $db_result = mysql_query("SELECT * FROM `character` WHERE `online`='1' ORDER BY `name`", $mangos_db);
+        $characters_db = mysql_connect($RealmHostname, $RealmUsername, $RealmPassword);
+        mysql_select_db($CharactersDatabase, $characters_db);
+  $db_result = mysql_query("SET NAMES $DatabaseEncoding", $characters_db);
+
+  $db_result = mysql_query("SELECT * FROM `character` WHERE `online`='1' ORDER BY `name`", $characters_db);
         while($result = mysql_fetch_array($db_result))
         {