$arr[$i]['cl'] = $result['class'];
$arr[$i]['race'] = $result['race'];
$arr[$i]['level'] = $char_data[$UNIT_FIELD_LEVEL];
$arr[$i]['gender'] = $char_gender[3];
$arr[$i]['Extention'] = $Extention;
$arr[$i]['leaderGuid'] = isset($groups[$char_data[0]]) ? $groups[$char_data[0]] : 0;
$i++;
}
$mangos_db->close();
usort($arr, "sort_players");
$arr = array_merge($Count, $arr);
$res['online'] = $arr;
} else {
$res['online'] = NULL;
}
if ($show_status) {
$mangos_db = new DBLayer($mangos[$royaume]['host'], $mangos[$royaume]['user'], $mangos[$royaume]['password'], $mangos[$royaume]['db']);
$mangos_db->query("SET NAMES " . $mangos[$royaume]['encoding'] . "");
$query = $mangos_db->query("SELECT `starttime`,`maxplayers` FROM `uptime` WHERE `starttime`=(SELECT MAX(`starttime`) FROM `uptime`)");
if ($result = $mangos_db->fetch_assoc($query)) {
$status['uptime'] = time() - $result['starttime'];
$status['maxplayers'] = $result['maxplayers'];
$status['online'] = test_realm() ? 1 : 0;
}
$mangos_db->close();
} else {
$status = NULL;
}
unset($mangos_db);
$res['status'] = $status;
$_RESULT = $res;
$arr[$i]['gender'] = $result['gender'];
$arr[$i]['Extention'] = $Extention;
$arr[$i]['leaderGuid'] = isset($groups[$char_data[0]]) ? $groups[$char_data[0]] : 0;
$i++;
}
$characters_db_PM->close();
unset($characters_db_PM);
if (!count($arr) && !test_realm()) {
$res['online'] = NULL;
} else {
usort($arr, "sort_players");
$arr = array_merge($Count, $arr);
$res['online'] = $arr;
}
if ($show_status) {
$query = $arcm_db_PM->query("SELECT UNIX_TIMESTAMP(),`starttime`,`maxplayers` FROM `uptime` WHERE `starttime`=(SELECT MAX(`starttime`) FROM `uptime`)");
if ($result = $arcm_db_PM->fetch_row($query)) {
$status['online'] = test_realm() ? 1 : 0;
$status['uptime'] = $result[0] - $result[1];
$status['maxplayers'] = $result[2];
$status['gmonline'] = $gm_online;
} else {
$status = NULL;
}
} else {
$status = NULL;
}
$arcm_db_PM->close();
unset($arcm_db_PM);
$res['status'] = $status;
$_RESULT = $res;
function get_character_honor($char_id)
{
global $hostr, $userr, $passwordr, $db, $dbr, $dbc, $database_encoding;
$mangos_db = new DBLayer($hostr, $userr, $passwordr, $dbc);
$query = $mangos_db->query("SELECT * FROM `character_kill` WHERE `guid`='{$char_id}'");
while ($res_row = $mangos_db->fetch_assoc($query)) {
$honor += $res_row['honor'];
}
$mangos_db->close();
return $honor;
}
$arr[$i]['gender'] = $result['gender'];
$arr[$i]['Extention'] = $Extention;
$arr[$i]['leaderGuid'] = isset($groups[$char_data[0]]) ? $groups[$char_data[0]] : 0;
$i++;
}
$characters_db->close();
unset($characters_db);
if (!count($arr) && !test_realm()) {
$res['online'] = NULL;
} else {
usort($arr, "sort_players");
$arr = array_merge($Count, $arr);
$res['online'] = $arr;
}
if ($show_status) {
$query = $realm_db->query("SELECT UNIX_TIMESTAMP(),`starttime`,`maxplayers` FROM `uptime` WHERE `starttime`=(SELECT MAX(`starttime`) FROM `uptime`)");
if ($result = $realm_db->fetch_row($query)) {
$status['online'] = test_realm() ? 1 : 0;
$status['uptime'] = $result[0] - $result[1];
$status['maxplayers'] = $result[2];
$status['gmonline'] = $gm_online;
} else {
$status = NULL;
}
} else {
$status = NULL;
}
$realm_db->close();
unset($realm_db);
$res['status'] = $status;
$_RESULT = $res;
<?php
require "subs.php";
require_once "conf.inc.php";
require_once "lib/dblayer.php";
$btn_home = "<a class='button' href='./'><<</a>";
$db = new DBLayer($CNF["db_host"], $CNF["db_user"], $CNF["db_pass"], $CNF["db_name"]);
$db->query("SET NAMES utf8");
$q = "SELECT\n u.`uid`,\n u.`modiff`,\n DATE_FORMAT(u.`modiff`,'%d.%m.%Y %H:%i:%s') AS `modiff_fmt`,\n (SELECT CONCAT(`lastname`,' ',`firstname`) FROM users WHERE `uid`=u.`modiff_uid`) AS `modiff_uid`,\n u.`status_id`,\n u.`lastname`,\n u.`firstname`,\n u.`middlename`,\n u.`login`,\n u.`pass`\n FROM users AS u ORDER BY `uid` DESC LIMIT 5";
if ($qry = $db->query($q)) {
eval(tmplt_gen("stat/forms/begin.form"));
eval(tmplt_gen("users/forms/filter.form"));
while ($res = $db->fetch_assoc($qry)) {
$page .= table_users($res);
}
$page .= "</table>";
$page .= "<div class='table-footer'><span class='statusbar'> </span>";
} else {
echo 'error';
}
//print_r($res);
echo $page;
$db_err = $db->error();
$db->close();
if ($db_err["error_no"] != null) {
print_r($db_err);
}
// DB-errors
