connect($mangos_db[$realm_id]['addr'], $mangos_db[$realm_id]['user'], $mangos_db[$realm_id]['pass'], $mangos_db[$realm_id]['name']);
$output .= "";
if (test_port($server[$realm_id]['addr'],$server[$realm_id]['game_port'])) {
$query = $sql->query("SELECT uptime FROM uptime ORDER BY starttime DESC LIMIT 1");
$uptime = $sql->result($query, 0);
$output .= "
{$lang_index['realm']} ".get_realm_name($realm_id)." {$lang_index['online']} : (".(int)($uptime/60/60/24)."D : ".(($uptime/60/60 >= 24 )?(int)($uptime/60/60-24*(int)($uptime/60/60/24)):(int)($uptime/60/60))."H : ".(($uptime/60 >= 60 )?(int)($uptime/60-60*(int)($uptime/60/60)):(int)($uptime/60))."M : ".(($uptime >= 60 )?(int)($uptime-60*(int)($uptime/60)):(int)$uptime)."S)
";
$online = true;
} else {
$output .= "{$lang_index['realm']} ".get_realm_name($realm_id)." {$lang_index['offline_or_let_high']}
";
$online = false;
}
$output .= "Mangos: {$server[$realm_id]['rev']} Using DB: {$mangos_db[$realm_id]['db_rev']}";
$sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
$sql->db($characters_db[$realm_id]['name']);
//MOTD part
$start = (isset($_GET['start'])) ? $sql->quote_smart($_GET['start']) : 0;
$query_1 = $sql->query("SELECT count(*) FROM bugreport");
$all_record = $sql->result($query_1, 0);
if ($user_lvl > 0) $output .= "";
$output .= "
| ";
if ($user_lvl) $output .= "{$lang_index['add_motd']}";
$output .= " |
";
if($all_record){
$result = $sql->query("SELECT id, type, content FROM bugreport ORDER BY id DESC LIMIT $start, 3");
while($post = $sql->fetch_row($result)){
$output .= "".bbcode2html($post[2])." |
$post[1] ";
if ($user_lvl > 0) $output .= "![](\"img/cross.png\") {$post[0]}
{$lang_global['are_you_sure']}', del_motd + $post[0]);\" style=\"cursor:pointer;\" />
![](\"img/edit.png\") ";
$output .= " |
|
";
}
$output .= "| ".generate_pagination("index.php?", $all_record, 3, $start)." |
";
}
$output .= "
";
//print online chars
if ($online){
$order_by = (isset($_GET['order_by'])) ? $sql->quote_smart($_GET['order_by']) : "name";
$dir = (isset($_GET['dir'])) ? $sql->quote_smart($_GET['dir']) : 1;
$order_dir = ($dir) ? "ASC" : "DESC";
$dir = ($dir) ? 0 : 1;
$result = $sql->query("SELECT count(*) FROM `character` WHERE `online`= 1");
$total_online = $sql->result($result, 0);
if( !$user_lvl && !$server[$realm_id]['both_factions']){
$result = $sql->query("SELECT race FROM `character` WHERE account = '$user_id' AND totaltime = (SELECT MAX(totaltime) FROM `character` WHERE account = '$user_id') LIMIT 1");
if ($sql->num_rows($result)){
$order_side = (in_array($sql->result($result, 0, 'race'),array(2,5,6,8,10))) ?
" AND race IN (2,5,6,8,10) " : " AND race IN (1,3,4,7,11) ";
} else $order_side = "";
} else $order_side = "";
require_once("scripts/defines.php");
$result = $sql->query("SELECT guid,name,race,class,zone,map,
CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS highest_rank,
CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1) AS UNSIGNED) AS level,account,
CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_GUILD_ID+1)."), ' ', -1) AS UNSIGNED) as GNAME,
mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender
FROM `character` WHERE `online`= 1 $order_side ORDER BY $order_by $order_dir");
$output .= "
{$lang_index['tot_users_online']} : $total_online
| {$lang_index['name']} |
{$lang_index['race']} |
{$lang_index['class']} |
{$lang_index['level']} |
Rank |
Guild |
{$lang_index['map']} |
{$lang_index['zone']} |
";
require_once("scripts/id_tab.php");
while($char = $sql->fetch_row($result)){
//$guild_name = 'dummy';
$accid = $char[8];
$sql->connect($realm_db['addr'], $realm_db['user'], $realm_db['pass'], $realm_db['name']);
//$sql->db($realm_db['name']);
$gmlvl = $sql->query("SELECT `gmlevel` FROM `account`WHERE `id`='$accid';");
$gml = $sql->fetch_row($gmlvl);
$gm = $gml[0];
$sql->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
//$sql->db($characters_db[$realm_id]['name']);
$guild_name = $sql->fetch_row($sql->query("SELECT `name` FROM `guild` WHERE `guildid`=".$char[9].";"));
$level = $char[7];
if($level > 0)
{
$lev = ''.$level.'';
}
if($level > 9)
{
$lev = ''.$level.'';
}
if($level > 19)
{
$lev = ''.$level.'';
}
if($level > 29)
{
$lev = ''.$level.'';
}
if($level > 39)
{
$lev = ''.$level.'';
}
if($level > 49)
{
$lev = ''.$level.'';
}
if($level > 59)
{
$lev = ''.$level.'';
}
if($level > 69)
{
$lev = ''.$level.'';
}
if($level > 70)
{
$lev = ''.$level.'';
}
$output .= "
| $char[1] |
 |
 |
$lev |
![](img/ranks/rank".pvp_ranks($char[6],$CHAR_RACE[$char[2]][1]).".gif) |
$guild_name[0] |
".get_map_name($char[5])." |
".get_zone_name($char[4])." |
";
}
$output .= "
";
}
$sql->close();
require_once("footer.php");
?>