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);
$smarty->assign("comments_count", $comments_count);
//get files
$demos_count = 0;
$demos = sql_get_files($bid, $files_count);
$smarty->assign("demos", $demos);
$smarty->assign("demos_count", $files_count);
$smarty->assign("msg_banedit", $msg_banedit);
$smarty->assign("msg_demo", $msg_demo);
$smarty->assign("msg_comment", $msg_comment);
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;
}