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; }