if ($_GET['kicks']) {
$query = mysql_query("SELECT ba.*, se.gametype,se.timezone_fixx, aa.nickname FROM `" . $config->db_prefix . "_bans` AS ba\n LEFT JOIN `" . $config->db_prefix . "_serverinfo` AS se ON ba.server_ip=se.address\n LEFT JOIN `" . $config->db_prefix . "_amxadmins` AS aa ON (aa.steamid=ba.admin_nick OR aa.steamid=ba.admin_ip OR aa.steamid=ba.admin_id)\n WHERE ba.expired=0 AND ban_kicks > 1 ORDER BY ban_kicks DESC LIMIT " . $min . "," . $config->bans_per_page) or die(mysql_error());
} else {
$query = mysql_query("SELECT ba.*, se.gametype,se.timezone_fixx, aa.nickname FROM `" . $config->db_prefix . "_bans` AS ba\n LEFT JOIN `" . $config->db_prefix . "_serverinfo` AS se ON ba.server_ip=se.address\n LEFT JOIN `" . $config->db_prefix . "_amxadmins` AS aa ON (aa.steamid=ba.admin_nick OR aa.steamid=ba.admin_ip OR aa.steamid=ba.admin_id)\n WHERE ba.expired=0 ORDER BY ban_created DESC LIMIT " . $min . "," . $config->bans_per_page) or die(mysql_error());
}
//build ban list array
$ban_list = array();
while ($result = mysql_fetch_object($query)) {
if ($result->expired == 1) {
continue;
}
$steamid = "";
$steamcomid = "";
if (!empty($result->player_id)) {
$steamid = htmlentities($result->player_id, ENT_QUOTES);
$steamcomid = GetFriendId($steamid);
}
$gi = "";
$cc = "";
$cn = "";
if (!empty($result->player_ip)) {
$gi = geoip_open($config->path_root . "/include/GeoIP.dat", GEOIP_STANDARD);
$cc = geoip_country_code_by_addr($gi, $result->player_ip);
$cn = geoip_country_name_by_addr($gi, $result->player_ip);
geoip_close($gi);
}
$ban_row = array("bid" => $result->bid, "player_ip" => $result->player_ip, "player_id" => $result->player_id, "player_comid" => $steamcomid, "player_nick" => htmlspecialchars($result->player_nick), "admin_ip" => $result->admin_ip, "admin_id" => $result->admin_id, "admin_nick" => htmlspecialchars($result->admin_nick), "ban_type" => $result->ban_type, "ban_reason" => $result->ban_reason, "ban_created" => $result->ban_created + $result->timezone_fixx * 60 * 60, "ban_length" => $result->ban_length, "ban_end" => $result->ban_created + $result->ban_length * 60 + $result->timezone_fixx * 60 * 60, "server_ip" => $result->server_ip, "server_name" => htmlspecialchars($result->server_name), "cc" => $cc, "cn" => $cn);
// get previous offences if any
$query2 = mysql_query("SELECT count(player_id) as count FROM `" . $config->db_prefix . "_bans` WHERE player_id = '" . $result->player_id . "' AND " . $ban_row["ban_end"] . " < '" . time() . "'") or die(mysql_error());
while ($result2 = mysql_fetch_object($query2)) {
$ban_row["bancount"] = $result2->count;
$ban_details = sql_get_ban_details($bid);
//aktive bans holen
$activ_count = 0;
$ban_details_activ = sql_get_ban_details_activ($ban_details["player_id"], $activ_count, $bid);
//abgelaufene bans holen
$exp_count = 0;
$ban_details_exp = sql_get_ban_details_exp($ban_details["player_id"], $exp_count, $bid);
//ban edits holen
$query = mysql_query("SELECT * FROM " . $config->db_prefix . "_bans_edit WHERE bid=" . $bid);
while ($row = mysql_fetch_assoc($query)) {
$edit_count++;
$ban_details_edits[] = $row;
}
//generate steamcomid
if (!empty($ban_details["player_id"])) {
$ban_details["player_comid"] = GetFriendId($ban_details["player_id"]);
}
$smarty->assign("ban_detail", $ban_details);
$smarty->assign("ban_details_activ", $ban_details_activ);
$smarty->assign("ban_details_exp", $ban_details_exp);
$smarty->assign("ban_details_edits", $ban_details_edits);
$smarty->assign("edit_count", $edit_count);
$smarty->assign("activ_count", $activ_count);
$smarty->assign("exp_count", $exp_count);
$smarty->assign("type_output", array("SteamID", "SteamID & IP"));
$smarty->assign("type_values", array("S", "SI"));
$smarty->assign("site", $site);
//get comments
$comments_count = 0;
$comments = sql_get_comments($bid, $comments_count);
$smarty->assign("comments", $comments);
$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 = cp1251_to_utf8($result->server_name);
} else {
$admin_name = cp1251_to_utf8($result->admin_nick);
$server_name = lang("_WEBSITE");
}
if (isset($_GET["bid"])) {
$id_type = "bid";
$id = $_GET["bid"];
} else {
$id_type = "bhid";
$id = $_GET["bhid"];
}
$ban_info = array("id_type" => $id_type, "map_name" => $map_name, "bid" => $id, "player_name" => $player_name, "player_id" => $player_id, "player_comid" => GetFriendId($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" => "Зомби сервер (x_x(O_o)x_x) Go Zombie !!!");
if (isset($_GET["bhid"])) {
$unban_info = array("verify" => TRUE, "unban_start" => dateShorttime($result->unban_created), "unban_reason" => cp1251_to_utf8($result->unban_reason), "admin_name" => cp1251_to_utf8($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;
function sql_get_search_bans($search, $active = 1, &$count = 0)
{
global $config;
$query = mysql_query("SELECT * FROM `" . $config->db_prefix . "_bans` WHERE " . $search . " AND `expired`=" . ($active == 1 ? 0 : 1) . " ORDER BY `ban_created` DESC") or die(mysql_error());
//Array aufbereiten
while ($result = mysql_fetch_object($query)) {
if (!empty($result->player_id)) {
$steamid = htmlentities($result->player_id, ENT_QUOTES);
$steamcomid = GetFriendId($steamid);
$query2 = mysql_query("SELECT COUNT(*) FROM `" . $config->db_prefix . "_bans` WHERE `player_id`='" . $result->player_id . "' AND `expired`=1");
$bancount = mysql_result($query2, 0);
}
$ban_row = array("bid" => $result->bid, "player_ip" => $result->player_ip, "player_id" => $result->player_id, "player_comid" => $steamcomid, "player_nick" => html_safe($result->player_nick), "admin_ip" => $result->admin_ip, "admin_id" => $result->admin_id, "admin_nick" => html_safe($result->admin_nick), "ban_type" => $result->ban_type, "ban_reason" => html_safe($result->ban_reason), "ban_created" => $result->ban_created, "ban_length" => $result->ban_length, "ban_end" => $result->ban_created + $result->ban_length * 60, "server_ip" => $result->server_ip, "server_name" => html_safe($result->server_name), "bancount" => $bancount);
if ($config->show_kick_count == "1") {
$ban_row["kick_count"] = $result->ban_kicks;
$ban_page["show_kicks"] = 1;
}
if ($config->show_demo_count == "1") {
$file_count = 0;
sql_get_files($result->bid, $file_count);
$ban_row["demo_count"] = $file_count;
$ban_page["show_demos"] = 1;
}
if ($config->show_comment_count == "1") {
$comment_count = 0;
sql_get_comments($result->bid, $comment_count);
$ban_row["comment_count"] = $comment_count;
$ban_page["show_comments"] = 1;
}
$count++;
$ban_list[] = $ban_row;
}
return $ban_list;
}
