$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