}
if (!isset($_POST['action']) || $_POST['action'] == "all") {
$action = "%";
} else {
$action = $_POST['action'];
}
//$date = substr_replace($date, '', 2, 1);
//$date = substr_replace($date, '', 4, 1);
// Make the array for the log list
$query = "SELECT * FROM {$config->logs} WHERE FROM_UNIXTIME(timestamp,'%d-%m-%Y') LIKE '{$date}' AND username LIKE '{$admin}' AND action LIKE '{$action}' ORDER BY timestamp DESC";
$resource = mysql_query($query) or die(mysql_error());
$log_array = array();
while ($result = mysql_fetch_object($resource)) {
$username = htmlentities($result->username, ENT_QUOTES);
// Asign variables to the array used in the template
$log_info = array("id" => $result->id, "date" => dateShorttime($result->timestamp), "ip" => $result->ip, "username" => $username, "action" => $result->action, "remarks" => $result->remarks);
$log_array[] = $log_info;
}
// Make the array for the actions
$query2 = "SELECT DISTINCT action FROM {$config->logs} ORDER BY action ASC";
$resource2 = mysql_query($query2) or die(mysql_error());
$action_array = array();
while ($result2 = mysql_fetch_object($resource2)) {
$action_array[] = $result2->action;
}
// Make the array for the admin list
$query3 = "SELECT username FROM {$config->webadmins} ORDER BY id ASC";
$resource3 = mysql_query($query3) or die(mysql_error());
$admin_array = array();
while ($result3 = mysql_fetch_object($resource3)) {
$admin_array[] = $result3->username;
if ($result->server_name != "website") {
//$query2 = "SELECT nickname FROM $config->amxadmins WHERE steamid = '".$result->admin_id."'";
$query2 = "SELECT nickname FROM {$config->amxadmins} WHERE username = '******' OR username = '******' OR username = '******'";
$resource2 = mysql_query($query2) or die(mysql_error());
$result2 = mysql_fetch_object($resource2);
$admin_name = cp1251_to_utf8($result->admin_nick) . " (" . cp1251_to_utf8($result2 ? $result2->nickname : "") . ")";
//$server_name = $result->server_name;
$server_name = cp1251_to_utf8($result->server_name);
} else {
$admin_name = cp1251_to_utf8($result->admin_nick);
$server_name = lang("_WEBSITE");
}
$id_type = "bhid";
$id = $_GET["bhid"];
$ban_info = array("id_type" => $id_type, "bhid" => $id, "player_name" => $player_name, "map_name" => $map_name, "player_id" => $player_id, "player_ip" => $player_ip, "ban_start" => $ban_start, "ban_duration" => $ban_duration, "ban_end" => $ban_end, "ban_type" => $ban_type, "ban_reason" => $ban_reason, "admin_name" => $admin_name, "amx_name" => isset($admin_amxname) ? $admin_amxname : "", "server_name" => $server_name);
$unban_info = array("verify" => TRUE, "unban_start" => dateShorttime($result->unban_created), "unban_reason" => cp1251_to_utf8($result->unban_reason), "admin_name" => $result->unban_admin_nick);
}
if (isset($_GET["bhid"])) {
// Make the array for the history ban list
if ($result->player_id != "") {
$query = "SELECT bhid, player_nick, admin_nick, ban_length, ban_reason, ban_created, server_ip FROM {$config->ban_history} WHERE player_id = '" . $result->player_id . "' ORDER BY ban_created DESC";
} else {
$query = "SELECT bhid, player_nick, admin_nick, ban_length, ban_reason, ban_created, server_ip FROM {$config->ban_history} WHERE player_ip = '" . $result->player_ip . "' ORDER BY ban_created DESC";
}
$resource = mysql_query($query) or die(mysql_error());
$unban_array = array();
while ($result = mysql_fetch_object($resource)) {
$bhid = $result->bhid;
$date = dateMonth($result->ban_created);
$player = cp1251_to_utf8($result->player_nick);
$admin = cp1251_to_utf8($result->admin_nick);
$ban_type = "SteamID";
}
$ban_reason = cp1251_to_utf8($result->ban_reason);
if ($result->server_name != "website") {
$query2 = "SELECT nickname FROM {$config->amxadmins} WHERE steamid = '" . $result->admin_id . "'";
$resource2 = mysql_query($query2) or die(mysql_error());
$result2 = mysql_fetch_object($resource2);
$admin_name = htmlentities($result->admin_nick, ENT_QUOTES) . " (" . htmlentities($result2->nickname, ENT_QUOTES) . ")";
$server_name = $result->server_name;
} else {
$admin_name = htmlentities($result->admin_nick, ENT_QUOTES);
$server_name = "Website";
}
$ban_info = array("player_name" => $player_name, "player_id" => $player_id, "player_ip" => $player_ip, "ban_start" => $ban_start, "ban_duration" => $ban_duration, "ban_end" => $ban_end, "ban_type" => $ban_type, "ban_reason" => $ban_reason, "admin_name" => $admin_name, "server_name" => $server_name);
if (isset($_GET["bhid"])) {
$unban_info = array("verify" => TRUE, "unban_start" => dateShorttime($result->unban_created), "unban_reason" => htmlentities($result->unban_reason, ENT_QUOTES), "admin_name" => $result->unban_admin_nick);
}
}
if (isset($_GET["bid"])) {
// Make the array for the history ban list
if ($result->player_id != "") {
$query = "SELECT bhid, player_nick, admin_nick, ban_length, ban_reason, ban_created, server_ip FROM {$config->ban_history} WHERE player_id = '" . $result->player_id . "' ORDER BY ban_created DESC";
} else {
$query = "SELECT bhid, player_nick, admin_nick, ban_length, ban_reason, ban_created, server_ip FROM {$config->ban_history} WHERE player_ip = '" . $result->player_ip . "' ORDER BY ban_created DESC";
}
$resource = mysql_query($query) or die(mysql_error());
$unban_array = array();
while ($result = mysql_fetch_object($resource)) {
$bhid = $result->bhid;
$date = dateMonth($result->ban_created);
$player = htmlentities($result->player_nick, ENT_QUOTES);
$query5 .= " server_ip = '{$server}' ";
}
}
}
}
}
}
}
}
$query5 .= " ORDER BY ban_created DESC LIMIT 100";
$resource5 = mysql_query($query5) or die(mysql_error());
$exban_array = array();
$ex_bancount = 0;
while ($result5 = mysql_fetch_object($resource5)) {
$bhid = $result5->bhid;
$ex_date = dateShorttime($result5->ban_created + $timezone);
$ex_player = cp1251_to_utf8($result5->player_nick);
$ex_admin = cp1251_to_utf8($result5->admin_nick);
//$ex_reason = $result5->ban_reason;
$ex_reason = cp1251_to_utf8($result5->ban_reason);
$ex_duration = $result5->ban_length;
$ex_serverip = $result5->server_ip;
$ex_bancount = $ex_bancount + 1;
if ($ex_serverip != "") {
// // // Get the gametype for each ban
// // $query6 = "SELECT gametype FROM $config->servers WHERE address = '$ex_serverip'";
// // $resource6 = mysql_query($query6) or die(mysql_error());
// // $ex_gametype = NULL;
// // while($result6 = mysql_fetch_object($resource6)) {
$ex_gametype = $result5->gametype;
// // }
trigger_error("Can't find ban with given ID.", E_USER_NOTICE);
} else {
$result = mysql_fetch_object($resource);
// Get the AMX username of the admin if the ban was invoked from inside the server
if ($result->server_name != "website") {
$query2 = "SELECT nickname FROM {$config->amxadmins} WHERE steamid = '" . $result->admin_id . "'";
$resource2 = mysql_query($query2) or die(mysql_error());
$result2 = mysql_fetch_object($resource2);
$admin_amxname = cp1251_to_utf8($result2->nickname);
}
// Prepare all the variables
$player_name = cp1251_to_utf8($result->player_nick);
$player_id = htmlentities($result->player_id, ENT_QUOTES);
$playa_ip = $result->player_ip;
$ban_type = $result->ban_type;
$ban_start = dateShorttime($result->ban_created);
if (empty($result->ban_length) or $result->ban_length == 0) {
$ban_duration = 0;
} else {
$ban_duration = $result->ban_length;
}
$ban_reason = cp1251_to_utf8($result->ban_reason);
if ($result->server_name != "website") {
$query2 = "SELECT nickname FROM {$config->amxadmins} WHERE steamid = '" . $result->admin_id . "'";
$resource2 = mysql_query($query2) or die(mysql_error());
$result2 = mysql_fetch_object($resource2);
$admin_name = cp1251_to_utf8($result->admin_nick) . " (" . cp1251_to_utf8($result2->nickname) . ")";
//$server_name = $result->server_name;
$server_name = cp1251_to_utf8($result->server_name);
} else {
$admin_name = cp1251_to_utf8($result->admin_nick);
//$steamid = "<i><font color='#677882'>" . lang("_NOSTEAMID") . "</font></i>";
$steamid = " ";
}
$ldate = dateShorttime($result->ban_created + $timezone_correction);
$banlength = $result->ban_length;
if (empty($result->ban_length) or $result->ban_length == 0) {
$ban_duration = lang("_PERMANENT");
$ban_end = lang("_NOTAPPLICABLE");
} else {
$ban_duration = $result->ban_length . " " . lang("_MINS") . " ";
$date_and_ban = $result->ban_created + $timezone_correction + $result->ban_length * 60;
$now = date("U");
if ($now >= $date_and_ban) {
$ban_end = dateShorttime($date_and_ban) . " (" . lang("_ALREADYEXP") . ")";
} else {
$ban_end = dateShorttime($date_and_ban) . " (" . timeleft($now, $date_and_ban) . " " . lang("_REMAINING") . ")";
}
}
if ($result->ban_type == "SI") {
$ban_type = lang("_STEAMID&IP");
} else {
$ban_type = "SteamID";
}
if ($result->server_name != "website") {
//$query2 = "SELECT nickname FROM $config->amxadmins WHERE steamid = '".$result->admin_id."'";
$query2 = "SELECT nickname FROM {$config->amxadmins} WHERE username = '******' OR username = '******' OR username = '******'";
$resource2 = mysql_query($query2) or die(mysql_error());
$result2 = mysql_fetch_object($resource2);
$admin_name = htmlentities($result->admin_nick, ENT_QUOTES);
if ($result2) {
$web_admin_name = htmlentities($result2->nickname, ENT_QUOTES);
