source: frontend/components/server/server.playersonline.php@ 5

<?php
if(INCLUDED!==true)exit;
require_once 'core/defines.php';
// ==================== //
$pathway_info[] = array('title'=>$lang['players_online'],'link'=>'');
// ==================== //
$site_defines = Array(
  'character_race' => Array(
    1 => 'Human',
    2 => 'Orc',
    3 => 'Dwarf',
    4 => 'Night Elf',
    5 => 'Undead',
    6 => 'Tauren',
    7 => 'Gnome',
    8 => 'Troll',
    9 => 'Goblin',
  ),
  'character_class' => Array(
    1 => 'Warrior',
    2 => 'Paladin',
    3 => 'Hunter',
    4 => 'Rogue',
    5 => 'Priest',
    7 => 'Shaman',
    8 => 'Mage',
    9 => 'Warlock',
    11 => 'Druid',
  ),
  
  'character_gender' => Array(
    0 => 'Male',
    1 => 'Female',
    2 => 'None'
  ),
  'character_rank' => Array(
    'alliance' => Array(
      1 => 'Private',
      2 => 'Corporal',
      3 => 'Sergeant',
      4 => 'Master Sergeant',
      5 => 'Sergeant Major',
      6 => 'Knight',
      7 => 'Knight-Lieutenant',
      8 => 'Knight-Captain',
      9 => 'Knight-Champion',
      10 => 'Lieutenant Commander',
      11 => 'Commander',
      12 => 'Marshal',
      13 => 'Field Marshal',
      14 => 'Grand Marshal'
    ),
    'horde' => Array(
      1 => 'Scout',
      2 => 'Grunt',
      3 => 'Sergeant',
      4 => 'Senior Sergeant',
      5 => 'First Sergeant',
      6 => 'Stone Guard',
      7 => 'Blood Guard',
      8 => 'Legionnare',
      9 => 'Centurion',
      10 => 'Champion',
      11 => 'Lieutenant General',
      12 => 'General',
      13 => 'Warlord',
      14 => 'High Warlord'
    )
  )
);


function realm_list()
{
  global $DB;
  $res = $DB->selectCol("SELECT id AS ARRAY_KEY,name FROM realmlist ORDER BY name");
  return $res;
}
function get_realm_byid($id)
{
  global $DB;
  $search_q = $DB->selectRow("SELECT * FROM `realmlist` WHERE `id`=?d",$id);
  return $search_q;
}
function parse_worlddb_info($str)
{
    $arr = explode(';',$str);
    $wsdb_info['host'] = $arr[0];
    $wsdb_info['port'] = $arr[1];
    $wsdb_info['user'] = $arr[2];
    $wsdb_info['password'] = $arr[3];
    $wsdb_info['db'] = $arr[4];
    return $wsdb_info;
}
function check_port_status($ip, $port)
{
    if($fp1=fsockopen($ip, $port, $ERROR_NO, $ERROR_STR,(float)1.0)){
        return true;fclose($fp1); 
    }else{
        return false;
    } 
}
function get_zone_name($mapid, $x, $y){
global $maps_a, $zone;
if (!empty($maps_a[$mapid]))
  {
  $zmap=$maps_a[$mapid];
  if (($mapid==0) or ($mapid==1))
    {
    $i=0; $c=count($zone[$mapid]);
    while ($i<$c)
      {
  if ($zone[$mapid][$i][2] < $x  AND $zone[$mapid][$i][3] > $x AND $zone[$mapid][$i][1] < $y  AND $zone[$mapid][$i][0] > $y) $zmap=$zone[$mapid][$i][4];
      $i++;
      }
    }
  } else $zmap="Unknown zone";
return $zmap;
} 

if($_GET['realm']){

  $res_info = array();
  $query = array();
  $realm_info = get_realm_byid($_GET['realm']);
  $cc = 0;
    if(check_port_status($realm_info['address'], $realm_info['port'])===true)
    {
        if(!$realm_info['dbinfo'])output_message('alert','Check field <u>dbinfo</u> in table `realmlist` for realm id='.$realm_info['id']);
        $wsdb_info = parse_worlddb_info($realm_info['dbinfo']);
        $WSDB = DbSimple_Generic::connect("".$config['db_type']."://".$wsdb_info['user'].":".$wsdb_info['password']."@".$wsdb_info['host'].":".$wsdb_info['port']."/".$wsdb_info['db']."");
        if($WSDB)$WSDB->setErrorHandler('databaseErrorHandler');
        if($WSDB)$WSDB->query("SET NAMES ".$config['db_encoding']);
        if($WSDB)$query = $WSDB->select("SELECT * FROM `character` WHERE `online`='1' ORDER BY `name`"); 
    }else{
        output_message('alert','Realm <b>'.$realm_info['name'].'</b> is offline <img src="images/downarrow2.gif" border="0" align="top">');
    }

    foreach ($query as $result) {
        if($res_color==1)$res_color=2;else$res_color=1;
        $cc++;     
        $res_race = $site_defines['character_race'][$result['race']];
        $res_class = $site_defines['character_class'][$result['class']];
        //      $res_pos = "<b>x:</b>$result[position_x] <b>y:</b>$result[position_y] <b>z:</b>$result[position_z]";
        $res_pos=get_zone_name($result['map'], $result['position_x'], $result['position_y']);
        $char_data = explode(' ',$result['data']);

        $char_gender = dechex($char_data[36]);
        $char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);
        $char_gender = $char_gender{3};

        $res_info[$cc]["number"] = $cc;
        $res_info[$cc]["res_color"] = $res_color;
        $res_info[$cc]["name"] = $result['name'];
        $res_info[$cc]["race"] = $result['race'];
        $res_info[$cc]["class"] = $result['class'];
        $res_info[$cc]["gender"] = $char_gender;
        $res_info[$cc]["level"] = $char_data[34];
        $res_info[$cc]["pos"] = $res_pos;
    }
    unset($WSDB);
}else{
  $realm_list = realm_list();
}

?>