Changeset 614 for trunk/stat

Timestamp:

Aug 7, 2009, 11:38:12 PM (15 years ago)

Author:

george

Message:

• Přidáno: Výběr světa i na začátku stránek, kterých se výběr týká.

File:

• trunk/stat/stat.php (modified) (4 diffs)

trunk/stat/stat.php

@@ -5 +5 @@
 $Username = $Config['Database']['User'];
 $Password = $Config['Database']['Password'];
-$Database = $Config['Mangos']['DatabaseMangos']; // must contains characters table
+$Database = $Config['Mangos']['RealmList'][1]['DatabaseMangos']; // must contains characters table
 $RealmHostname = $Hostname;
 $RealmUsername = $Username;
 $RealmPassword = $Password;
 $RealmDatabase = $Config['Mangos']['DatabaseRealmd'];  // must contains zone_coordinates and accounts table
-$CharactersDatabase = $Config['Mangos']['DatabaseCharacters'];  // must contains zone_coordinates and accounts table
+$CharactersDatabase = $Config['Mangos']['RealmList'][1]['DatabaseCharacters'];  // must contains zone_coordinates and accounts table
 $EmuVersion = $Config['Mangos']['ClientVersion'];
 $Owner = $Config['Web']['Admin'];
@@ -52 +52 @@
 "    <players>\r\n";
 
-        $realm_db = mysql_connect($RealmHostname, $RealmUsername, $RealmPassword);
-        mysql_select_db($RealmDatabase, $realm_db);
+  $realm_db = mysql_connect($RealmHostname, $RealmUsername, $RealmPassword);
+  mysql_select_db($RealmDatabase, $realm_db);
   $db_result = mysql_query("SET NAMES $DatabaseEncoding", $realm_db);
 
-        $mangos_db = mysql_connect($Hostname, $Username, $Password, TRUE);
-        mysql_select_db($Database, $mangos_db);
+  $mangos_db = mysql_connect($Hostname, $Username, $Password, TRUE);
+  mysql_select_db($Database, $mangos_db);
   $db_result = mysql_query("SET NAMES $DatabaseEncoding", $mangos_db);
   
-        $characters_db = mysql_connect($RealmHostname, $RealmUsername, $RealmPassword);
-        mysql_select_db($CharactersDatabase, $characters_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 `characters` WHERE `online`='1' ORDER BY `name`", $characters_db);
-        while($result = mysql_fetch_array($db_result))
-        {
+  while($result = mysql_fetch_array($db_result))
+  {
     // Get GM level by character
     $db_result2 = mysql_query("SELECT gmlevel FROM `account` WHERE `id`='".$result['account']."'", $realm_db);
@@ -73 +73 @@
     
     $char_data = explode(' ',$result['data']);
-                $Result .= "      <player>\r\n".
+    $Result .= "      <player>\r\n".
     "        <name>".$result['name']."</name>\r\n".
     "        <race>".$result['race']."</race>\r\n".
@@ -92 +92 @@
 function get_zone_name($mapid, $x, $y)
 {
-        global $realm_db;
-        $query = mysql_query("SELECT * FROM `zone_coordinates` ORDER BY `priory`", $realm_db);
-        $zmap = 0;
-        while($result = mysql_fetch_array($query))
-        {
-        if ($result['map']==$mapid AND $result['y_min'] < $x  AND $result['y_max'] > $x AND $result['x_max'] < $y  AND $result['x_min'] > $y) $zmap=$result['zone_id'];
-        }
-        return $zmap;
+  global $realm_db;
+  $query = mysql_query("SELECT * FROM `zone_coordinates` ORDER BY `priory`", $realm_db);
+  $zmap = 0;
+  while($result = mysql_fetch_array($query))
+  {
+    if ($result['map']==$mapid AND $result['y_min'] < $x  AND $result['y_max'] > $x AND $result['x_max'] < $y  AND $result['x_min'] > $y) $zmap=$result['zone_id'];
+  }
+  return $zmap;
 }