source: mangos/inc/stat2.php@ 5

<?php
// This script generate dynamically WoWEmu-like file stat.xml from MaNGOS SQL database for www.wowstatus.net purpose 
// You have to register xml extension to be processed by PHP in Apache httpd.conf (something like AddType application/x-httpd-php .phtml .pwml .php3 .php4 .php .php2 .inc .xml)
// Created by Chronos
// email: robie@centrum.cz

$Hostname = 'localhost';
$Username = 'root';
$Password = 'gurubashi';
$Database = 'mangos'; // must contains characters table
$RealmHostname = $Hostname;
$RealmUsername = $Username;
$RealmPassword = $Password;
$RealmDatabase = 'realmd';  // must contains zone_coordinates and accounts table
$EmuVersion = 'Mangos 3485';
$Owner = 'Maron';
$ServerName = 'Heroes Of Fantasy';
$DatabaseEncoding = 'utf8';

$Output = WoWEmuStat();
$_GLOBALS['SERVER_SOFTWARE'] = 'WoWEmu';
Header('Content-Type: text/xml');
Header('Content-Length: '.strlen($Output));
Header('Server: WoWEmu');
echo($Output);

function WoWEmuStat()
{
  global $Hostname, $Username, $Password, $Database, $EmuVersion, $Owner, $ServerName, $realm_db, $DatabaseEncoding,
  $RealmHostname, $RealmUsername, $RealmPassword, $RealmDatabase;
   
  $Result = 
'<?xml version="1.0" encoding="UTF-8"'."?>\r\n".
'<?xml-stylesheet type="text/xsl" href="stat.xsl"'."?>\r\n".
"  <stats>\r\n".
/*
"    <server>\r\n".
"      <version>".$EmuVersion."</version>\r\n".
"      <owner>".$Owner."</owner>\r\n".
"      <servername>".$ServerName."</servername>\r\n".
"      <uptime>0 weeks 1 days 0 hours 0 mins</uptime>\r\n".
"    </server>\r\n".
"    <serverload>\r\n".
"      <network>\r\n".
"        <configsleep>200</configsleep>\r\n".
"        <loops>0</loops>\r\n".
"        <totaltime>0</totaltime>\r\n".
"        <load>0.00%</load>\r\n".
"      </network>\r\n".
"      <world>\r\n".
"        <configsleep>600</configsleep>\r\n".
"        <loops>95222</loops>\r\n".
"        <totaltime>7594525</totaltime>\r\n".
"        <load>1.50%</load>\r\n".
"      </world>\r\n".
"    </serverload>\r\n".
*/
"    <players>\r\n";

        $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);
  $db_result = mysql_query("SET NAMES $DatabaseEncoding", $mangos_db);
  
  $db_result = mysql_query("SELECT * FROM `character` WHERE `online`='1' ORDER BY `name`", $mangos_db);
        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);
    //echo("SELECT `gmlevel` FROM `account` WHERE `id`='".$result['account']."'");
    $result2 = mysql_fetch_array($db_result2);
    
    $char_data = explode(' ',$result['data']);
                $Result .= "      <player>\r\n".
    "        <name>".$result['name']."</name>\r\n".
    "        <race>".$result['race']."</race>\r\n".
    "        <class>".$result['class']."</class>\r\n".
    "        <level>".$char_data[34]."</level>\r\n".
    "        <map>".$result['map']."</map>\r\n".
    "        <zone>".get_zone_name($result['map'], $result['position_x'], $result['position_y'])."</zone>\r\n".
    "        <ping>".$char_data['1420']."</ping>\r\n".
    "        <plevel>".$result2['gmlevel']."</plevel>\r\n".
    "        <ip>178.12.14.2</ip>\r\n".
    "      </player>\r\n";
  }
  $Result .= "    </players>\r\n".
   "  </stats>\r\n";
   return($Result);
}

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

?>