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