Problems with advanced bans sql

Сообщения
86
Реакции
2
Предупреждения
1
Ошибка
L 06/21/2022 - 09:31:02: [AMXX] Plugin ("advanced_bans_sql.amxx") is setting itself as failed.
L 06/21/2022 - 09:31:02: [AMXX] Plugin says: Could not connect to database.
L 06/21/2022 - 09:31:02: [AMXX] Run time error 1 (plugin "advanced_bans_sql.amxx") - forced exit
ОС
Linux
Amx Mod X
1.9.0.5294
Билд
Protocol version 48
Exe version 1.1.2.7/Stdio (cstrike)
ReHLDS version: 3.11.0.776-dev
Build date: 19:37:50 Apr 20 2022 (2930)
Build from: https://github.com/dreamstalker/rehlds/commit/3dc9f8c
ReGamedll
ReGameDLL version: 5.21.0.573-dev
Build date: 15:52:32 Mar 11 2022
Build from: https://github.com/s1lentq/ReGameDLL_CS/commit/0b08d9c
Версия Metamod
Metamod-r v1.3.0.128, API (5:13)
Metamod-r build: 17:47:54 Aug 24 2018
Metamod-r from: https://github.com/theAsmodai/metamod-r/commit/0cf2f70
Список метамодулей
[ 1] AMX Mod X     RUN   -    amxmodx_mm_i386.so        v1.9.0.5294      ini  Start ANY   
[ 2] MySQL RUN - mysql_amxx_i386.so v1.9.0.5294 pl1 ANY ANY
[ 3] Fun RUN - fun_amxx_i386.so v1.9.0.5294 pl1 ANY ANY
[ 4] Engine RUN - engine_amxx_i386.so v1.9.0.5294 pl1 ANY ANY
[ 5] FakeMeta RUN - fakemeta_amxx_i386.so v1.9.0.5294 pl1 ANY ANY
[ 6] CStrike RUN - cstrike_amxx_i386.so v1.9.0.5294 pl1 ANY ANY
[ 7] Ham Sandwich RUN - hamsandwich_amxx_i386.so v1.9.0.5294 pl1 ANY ANY
[ 8]ReAPI RUN - reapi_amxx_i386.so v5.21.0.252-dev pl1 ANY Never
[9] Orpheu RUN - orpheu_amxx_i386.so v2.6.3 pl1 ANY ANY
Список плагинов
[  1] Admin Chat              1.9.0.5273  AMXX Dev Team     adminchat.amxx   running 
[ 2] MIX SYSTEM 1.5 stanciu mix.amxx debug
[ 3] Advanced Bans 0.8 Exolent advanced_bans_s debug
[ 4] Reset Objective 0.1 HamletEagle objective.amxx running
[ 5]Admin Base (SQL) 1.9.0.5263 AMXX Dev Team admins.amxx running
[ 6] Admin Commands 1.9.0.5263 AMXX Dev Team admincmd.amxx running
[ 7] Restrict Weapons 1.9.0.5271 AMXX Dev Team restmenu.amxx running
Автор плагина
Exolent
Версия плагина
0.8
Исходный код
/*
Advanced Bans

Version 0.8

by Exolent



Plugin Thread:

- http://forums.alliedmods.net/showthread.php?t=80858



Description:

- This plugin revamps the current amx_ban, amx_banip, amx_banid, amx_unban admin commands.

- It uses Real Time on the server
(Eg. Banned for 10 minutes, you will be unbanned 10 minutes later, regardless of map changing).

- It includes a list of who is banned.

- It does not use the banned.cfg or listip.cfg. It uses its own file where bans are stored.

- It saves what admin banned the player (name), the admin's steamid, the reason, the ban time,
the banned player's name, the banned player's steamid (or IP), and the estimated time of unban.

- It will load your currently banned players from the banned.cfg and listip.cfg files.
(Only if the #define below is uncommented)

- If you use the menu to ban players, you will have to type a reason after you choose a player.

- If you use the vote system to ban players, you will have to type a reason after you execute the amx_voteban command.

- You can limit the ban time for admins based on their admin flags.

- You can monitor all ban history (admins banning, unbanning, and when ban times are up) in
the addons/amxmodx/logs/BAN_HISTORY_MMDDYYYY.log (MM = month, DD = day, YYYY = year)

- If you wish to have only 1 file for ban history, uncomment the line at the top of the .sma file and recompile.

- Supports SQL for banning.



Commands:

- amx_ban <nick, #userid, authid> <time in minutes> <reason>

- amx_banip <nick, #userid, authid> <time in minutes> <reason>

- amx_addban <name> <authid or ip> <time in minutes> <reason>

- amx_unban <authid or ip>

- amx_banlist
- Shows a list of who is banned

- amx_addbanlimit <flags> <time in minutes>
- Adds a max ban time to the list
- Note: Use this command in the amxx.cfg



Cvars:

- ab_website <website>
- This is the website displayed to the banned player if you have an unban request section on your website.
- Leave blank to not show a website.
- Default: blank

- ab_immunity <0|1|2>
- 0 - Any admin can ban an immunity admin (flag 'a').
- 1 - Immunity admins (flag 'a') cannot be banned.
- 2 - Immunity admins (flag 'a') can only be banned by other immunity admins (flag 'a').
- Default: 1

- ab_bandelay <seconds>
- Delay of banned players being disconnected.
- Default: 1

- ab_unbancheck <seconds>
- Interval of checking if a player is unbanned.
- Default: 5



Requirements:

- AMX Mod X version 1.8.0 or higher



Changelog:

- Version 0.1 (with updates included)
- Initial Release
- Changed to dynamic arrays to hold ban information
- Added option #2 for ab_immunity
- Added support for banning by IP
- Added compatability for banned.cfg and listip.cfg
- Added menu support (plmenu.amxx)
- Added ML support

- Version 0.2
- Added simple max ban time feature

- Version 0.3
- Added more cvars for max ban times
- Added cvar for delay of player to disconenct after being banned
- Added cvar for interval of checking for unban time of banned players
- Added more translations

- Version 0.4
- Fixed the possible infinite loop, causing servers to crash
- Added ban history
- Removed max ban time cvars
- Added max ban times per admin flags
- Added more translations

- Version 0.5
- Fixed information not being printed into console
- Fixed "amx_addban" using the admin's name as the SteamID when saving the ban
- Added option for ban history to be one file
- Added translations

- Version 0.5b
- Fixed players not being unbanned
- Added translations

- Version 0.6
- Added small optimization for unban checking
- Changed "UnBan Time" in the logs and chat messages to "Ban Length"
- Fixed small code error where unban time was generated was used when length was 0
- Changed IsValidIP() method to use regex (Thanks to arkshine)
- Added plugin information inside the .sma file
- Added a #define option to use maximum bans for compatability for AMXX < 1.8.0
- Changed admin messages in chat to work with amx_show_activity cvar
- Added translations

- Version 0.6b
- Fixed a small bug

- Version 0.6c
- Fixed amx_banlist for server consoles
- Changed IsValidAuthid() method to use regex

- Version 0.6d
- Fixed ban limit for permanent bans

- Version 0.7
- Changed the "unlimited bans" version to be faster (Thanks to joaquimandrade)
- Added check when adding bans if the player is already banned.

- Version 0.8
- Added SQL support.



Notes:

- If you plan to use this plugin, go to the plugin's thread.

- The plugin's thread has more information about the plugin, along with the multilingual file.

- It also has a modified plmenu.amxx plugin that adds the ban reason to the menu.

- And it has a modified adminvote.amxx plugin that adds the ban reason to amx_voteban.
*/



#include <amxmodx>
#include <amxmisc>
#include <engine>
#include <regex>

#define PLUGIN_NAME "Advanced Bans"
#define PLUGIN_VERSION "0.8"
#define PLUGIN_AUTHOR "Exolent"

#pragma semicolon 1



// ===============================================
// CUSTOMIZATION STARTS HERE
// ===============================================


// uncomment the line below if you want this plugin to
// load old bans from the banned.cfg and listip.cfg files
//#define KEEP_DEFAULT_BANS


// uncomment the line below if you want the history to be in one file
//#define HISTORY_ONE_FILE


// if you must have a maximum amount of bans to be compatible with AMXX versions before 1.8.0
// change this number to your maximum amount
// if you would rather have unlimited (requires AMXX 1.8.0 or higher) then set it to 0
#define MAX_BANS 0


// if you want to use SQL for your server, then uncomment the line below
#define USING_SQL


// if you want to use threaded queries for SQL, uncomment the line below
#define THREAD_QUERIES


// ===============================================
// CUSTOMIZATION ENDS HERE
// ===============================================



#if defined USING_SQL
#include <sqlx>

#define TABLE_NAME "advanced_bans"
#define KEY_NAME "victim_name"
#define KEY_STEAMID "victim_steamid"
#define KEY_BANLENGTH "banlength"
#define KEY_UNBANTIME "unbantime"
#define KEY_REASON "reason"
#define KEY_ADMIN_NAME "admin_name"
#define KEY_ADMIN_STEAMID "admin_steamid"
#define KEY_ID "id"

#define RELOAD_BANS_INTERVAL 1.0
#endif

#define REGEX_IP_PATTERN "\b(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\b"
#define REGEX_STEAMID_PATTERN "^^STEAM_0:(0|1):\d+$"

new Regex:g_IP_pattern;
new Regex:g_SteamID_pattern;
new g_regex_return;

/*bool:IsValidIP(const ip[])
{
return regex_match_c(ip, g_IP_pattern, g_regex_return) > 0;
}*/

#define IsValidIP(%1) (regex_match_c(%1, g_IP_pattern, g_regex_return) > 0)

/*bool:IsValidAuthid(const authid[])
{
return regex_match_c(authid, g_SteamID_pattern, g_regex_return) > 0;
}*/

#define IsValidAuthid(%1) (regex_match_c(%1, g_SteamID_pattern, g_regex_return) > 0)


enum // for name displaying
{
ACTIVITY_NONE, // nothing is shown
ACTIVITY_HIDE, // admin name is hidden
ACTIVITY_SHOW // admin name is shown
};
new const g_admin_activity[] =
{
ACTIVITY_NONE, // amx_show_activity 0 = show nothing to everyone
ACTIVITY_HIDE, // amx_show_activity 1 = hide admin name from everyone
ACTIVITY_SHOW, // amx_show_activity 2 = show admin name to everyone
ACTIVITY_SHOW, // amx_show_activity 3 = show name to admins but hide it from normal users
ACTIVITY_SHOW, // amx_show_activity 4 = show name to admins but show nothing to normal users
ACTIVITY_HIDE // amx_show_activity 5 = hide name from admins but show nothing to normal users
};
new const g_normal_activity[] =
{
ACTIVITY_NONE, // amx_show_activity 0 = show nothing to everyone
ACTIVITY_HIDE, // amx_show_activity 1 = hide admin name from everyone
ACTIVITY_SHOW, // amx_show_activity 2 = show admin name to everyone
ACTIVITY_HIDE, // amx_show_activity 3 = show name to admins but hide it from normal users
ACTIVITY_NONE, // amx_show_activity 4 = show name to admins but show nothing to normal users
ACTIVITY_NONE // amx_show_activity 5 = hide name from admins but show nothing to normal users
};


#if MAX_BANS <= 0
enum _:BannedData
{
bd_name[32],
bd_steamid[35],
bd_banlength,
bd_unbantime[32],
bd_reason[128],
bd_admin_name[64],
bd_admin_steamid[35]
};

new Trie:g_trie;
new Array:g_array;
#else
new g_names[MAX_BANS][32];
new g_steamids[MAX_BANS][35];
new g_banlengths[MAX_BANS];
new g_unbantimes[MAX_BANS][32];
new g_reasons[MAX_BANS][128];
new g_admin_names[MAX_BANS][64];
new g_admin_steamids[MAX_BANS][35];
#endif
new g_total_bans;

#if !defined USING_SQL
new g_ban_file[64];
#else
new Handle:g_sql_tuple;
#if defined THREAD_QUERIES
new bool:g_loading_bans = true;
#endif
#endif

//new ab_website;
new ab_immunity;
new ab_bandelay;
new ab_unbancheck;

new amx_show_activity;

#if MAX_BANS <= 0
new Array:g_maxban_times;
new Array:g_maxban_flags;
#else
#define MAX_BANLIMITS 30
new g_maxban_times[MAX_BANLIMITS];
new g_maxban_flags[MAX_BANLIMITS];
#endif
new g_total_maxban_times;

new g_unban_entity;

new g_max_clients;

new g_msgid_SayText;

public plugin_init()
{
register_plugin(PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_AUTHOR);
register_cvar("advanced_bans", PLUGIN_VERSION, FCVAR_SPONLY);

register_dictionary("advanced_bans.txt");

register_concmd("amx_ban", "CmdBan", ADMIN_BAN, "<nick, #userid, authid> <time in minutes> <reason>");
register_concmd("amx_banip", "CmdBanIp", ADMIN_BAN, "<nick, #userid, authid> <time in minutes> <reason>");
register_concmd("amx_addban", "CmdAddBan", ADMIN_BAN, "<name> <authid or ip> <time in minutes> <reason>");
register_concmd("amx_unban", "CmdUnban", ADMIN_BAN, "<authid or ip>");
register_concmd("amx_banlist", "CmdBanList", ADMIN_BAN, "[start] -- shows everyone who is banned");
register_srvcmd("amx_addbanlimit", "CmdAddBanLimit", -1, "<flag> <time in minutes>");

//ab_website = register_cvar("ab_website", "");
ab_immunity = register_cvar("ab_immunity", "1");
ab_bandelay = register_cvar("ab_bandelay", "1.0");
ab_unbancheck = register_cvar("ab_unbancheck", "5.0");

amx_show_activity = register_cvar("amx_show_activity", "2");

#if MAX_BANS <= 0
g_trie = TrieCreate();
g_array = ArrayCreate(BannedData);
#endif

#if !defined MAX_BANLIMITS
g_maxban_times = ArrayCreate(1);
g_maxban_flags = ArrayCreate(1);
#endif

#if !defined USING_SQL
get_datadir(g_ban_file, sizeof(g_ban_file) - 1);
add(g_ban_file, sizeof(g_ban_file) - 1, "/advanced_bans.txt");

LoadBans();
#endif

new error[2];
g_IP_pattern = regex_compile(REGEX_IP_PATTERN, g_regex_return, error, sizeof(error) - 1);
g_SteamID_pattern = regex_compile(REGEX_STEAMID_PATTERN, g_regex_return, error, sizeof(error) - 1);

g_max_clients = get_maxplayers();

g_msgid_SayText = get_user_msgid("SayText");
}

#if defined USING_SQL
public PrepareTable()
{
g_sql_tuple = SQL_MakeStdTuple();

new query[512];
formatex(query, sizeof(query) - 1,\
"CREATE TABLE IF NOT EXISTS %s (%s varchar(32), %s varchar(35), %s int(10), %s varchar(32), %s varchar(128), %s varchar(64), %s varchar(35), %s int(11));",\
TABLE_NAME, KEY_NAME, KEY_STEAMID, KEY_BANLENGTH, KEY_UNBANTIME, KEY_REASON, KEY_ADMIN_NAME, KEY_ADMIN_STEAMID, KEY_ID
);

#if defined THREAD_QUERIES
SQL_ThreadQuery(g_sql_tuple, "QueryCreateTable", query);
#else
new errcode, error[128];
new Handle:connection = SQL_Connect(g_sql_tuple, errcode, error, sizeof(error) - 1);

if( connection == Empty_Handle )
{
set_fail_state("Unable to connect to database.");
}

new Handle:result = SQL_PrepareQuery(connection, "%s", query);

if( !SQL_Execute(result) )
{
SQL_QueryError(result, error, sizeof(error) - 1);
log_amx("Failed to create table for bans: %s", error);
}

SQL_FreeHandle(connection);

LoadBans();
#endif
}

#if defined THREAD_QUERIES
public QueryCreateTable(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime)
{
if( failstate == TQUERY_CONNECT_FAILED )
{
set_fail_state("Could not connect to database.");
}
else if( failstate == TQUERY_QUERY_FAILED )
{
set_fail_state("Query failed.");
}
else if( errcode )
{
log_amx("Error on query: %s", error);
}
else
{
LoadBans();
}
}
#endif
#endif

public plugin_cfg()
{
CreateUnbanEntity();

#if defined USING_SQL
set_task(2.0, "PrepareTable");
#endif
}

public CreateUnbanEntity()
{
static failtimes;

g_unban_entity = create_entity("info_target");

if( !is_valid_ent(g_unban_entity) )
{
++failtimes;

log_amx("[ERROR] Failed to create unban entity (%i/10)", failtimes);

if( failtimes < 10 )
{
set_task(1.0, "CreateUnbanEntity");
}
else
{
log_amx("[ERROR] Could not create unban entity!");
}

return;
}

entity_set_string(g_unban_entity, EV_SZ_classname, "unban_entity");
entity_set_float(g_unban_entity, EV_FL_nextthink, get_gametime() + 1.0);

register_think("unban_entity", "FwdThink");
}

public client_authorized(client)
{
static authid[35];
get_user_authid(client, authid, sizeof(authid) - 1);

static ip[35];
get_user_ip(client, ip, sizeof(ip) - 1, 1);

#if MAX_BANS > 0
static banned_authid[35], bool:is_ip;
for( new i = 0; i < g_total_bans; i++ )
{
copy(banned_authid, sizeof(banned_authid) - 1, g_steamids[i]);

is_ip = bool:(containi(banned_authid, ".") != -1);

if( is_ip && equal(ip, banned_authid) || !is_ip && equal(authid, banned_authid) )
{
static name[32], reason[128], unbantime[32], admin_name[32], admin_steamid[64];
copy(name, sizeof(name) - 1, g_names[i]);
copy(reason, sizeof(reason) - 1, g_reasons[i]);
new banlength = g_banlengths[i];
copy(unbantime, sizeof(unbantime) - 1, g_unbantimes[i]);
copy(admin_name, sizeof(admin_name) - 1, g_admin_names[i]);
copy(admin_steamid, sizeof(admin_steamid) - 1, g_admin_steamids[i]);

PrintBanInformation(client, name, banned_authid, reason, banlength, unbantime, admin_name, admin_steamid, true, true);

set_task(get_pcvar_float(ab_bandelay), "TaskDisconnectPlayer", client);
break;
}
}
#else
static array_pos;

if( TrieGetCell(g_trie, authid, array_pos) || TrieGetCell(g_trie, ip, array_pos) )
{
static data[BannedData];
ArrayGetArray(g_array, array_pos, data);

PrintBanInformation(client, data[bd_name], data[bd_steamid], data[bd_reason], data[bd_banlength], data[bd_unbantime], data[bd_admin_name], data[bd_admin_steamid], true);

set_task(get_pcvar_float(ab_bandelay), "TaskDisconnectPlayer", client);
}
#endif
}

public CmdBan(client, level, cid)
{
if( !cmd_access(client, level, cid, 4) ) return PLUGIN_HANDLED;

static arg[128];
read_argv(1, arg, sizeof(arg) - 1);

new target = cmd_target(client, arg, GetTargetFlags(client));
if( !target ) return PLUGIN_HANDLED;

static target_authid[35];
get_user_authid(target, target_authid, sizeof(target_authid) - 1);

if( !IsValidAuthid(target_authid) )
{
console_print(client, "[FIREON] %L", client, "AB_NOT_AUTHORIZED");
return PLUGIN_HANDLED;
}

#if MAX_BANS <= 0
if( TrieKeyExists(g_trie, target_authid) )
{
console_print(client, "[FIREON] %L", client, "AB_ALREADY_BANNED_STEAMID");
return PLUGIN_HANDLED;
}
#else
for( new i = 0; i < g_total_bans; i++ )
{
if( !strcmp(target_authid, g_steamids[i], 1) )
{
console_print(client, "[FIREON] %L", client, "AB_ALREADY_BANNED_STEAMID");
return PLUGIN_HANDLED;
}
}
#endif

read_argv(2, arg, sizeof(arg) - 1);

new length = str_to_num(arg);
new maxlength = GetMaxBanTime(client);

if( maxlength && (!length || length > maxlength) )
{
console_print(client, "[FIREON] %L", client, "AB_MAX_BAN_TIME", maxlength);
return PLUGIN_HANDLED;
}

static unban_time[64];
if( length == 0 )
{
formatex(unban_time, sizeof(unban_time) - 1, "%L", client, "AB_PERMANENT_BAN");
}
else
{
GenerateUnbanTime(length, unban_time, sizeof(unban_time) - 1);
}

read_argv(3, arg, sizeof(arg) - 1);

static admin_name[64], target_name[32];
get_user_name(client, admin_name, sizeof(admin_name) - 1);
get_user_name(target, target_name, sizeof(target_name) - 1);

static admin_authid[35];
get_user_authid(client, admin_authid, sizeof(admin_authid) - 1);

AddBan(target_name, target_authid, arg, length, unban_time, admin_name, admin_authid);

PrintBanInformation(target, target_name, target_authid, arg, length, unban_time, admin_name, admin_authid, true);
PrintBanInformation(client, target_name, target_authid, arg, length, unban_time, admin_name, admin_authid, false);

set_task(get_pcvar_float(ab_bandelay), "TaskDisconnectPlayer", target);

GetBanTime(length, unban_time, sizeof(unban_time) - 1);

PrintActivity(admin_name, "^x04[FIREON] $name^x01 :^x03 banned %s. Reason: %s. Ban Length: %s", target_name, arg, unban_time);

Log("%s <%s> banned %s <%s> || Reason: ^"%s^" || Ban Length: %s", admin_name, admin_authid, target_name, target_authid, arg, unban_time);

return PLUGIN_HANDLED;
}

public CmdBanIp(client, level, cid)
{
if( !cmd_access(client, level, cid, 4) ) return PLUGIN_HANDLED;

static arg[128];
read_argv(1, arg, sizeof(arg) - 1);

new target = cmd_target(client, arg, GetTargetFlags(client));
if( !target ) return PLUGIN_HANDLED;

static target_ip[35];
get_user_ip(target, target_ip, sizeof(target_ip) - 1, 1);

#if MAX_BANS <= 0
if( TrieKeyExists(g_trie, target_ip) )
{
console_print(client, "[FIREON] %L", client, "AB_ALREADY_BANNED_IP");
return PLUGIN_HANDLED;
}
#else
for( new i = 0; i < g_total_bans; i++ )
{
if( !strcmp(target_ip, g_steamids[i], 1) )
{
console_print(client, "[FIREON] %L", client, "AB_ALREADY_BANNED_IP");
return PLUGIN_HANDLED;
}
}
#endif

read_argv(2, arg, sizeof(arg) - 1);

new length = str_to_num(arg);
new maxlength = GetMaxBanTime(client);

if( maxlength && (!length || length > maxlength) )
{
console_print(client, "[FIREON] %L", client, "AB_MAX_BAN_TIME", maxlength);
return PLUGIN_HANDLED;
}

static unban_time[32];

if( length == 0 )
{
formatex(unban_time, sizeof(unban_time) - 1, "%L", client, "AB_PERMANENT_BAN");
}
else
{
GenerateUnbanTime(length, unban_time, sizeof(unban_time) - 1);
}

read_argv(3, arg, sizeof(arg) - 1);

static admin_name[64], target_name[32];
get_user_name(client, admin_name, sizeof(admin_name) - 1);
get_user_name(target, target_name, sizeof(target_name) - 1);

static admin_authid[35];
get_user_authid(client, admin_authid, sizeof(admin_authid) - 1);

AddBan(target_name, target_ip, arg, length, unban_time, admin_name, admin_authid);

PrintBanInformation(target, target_name, target_ip, arg, length, unban_time, admin_name, admin_authid, true);
PrintBanInformation(client, target_name, target_ip, arg, length, unban_time, admin_name, admin_authid, false);

set_task(get_pcvar_float(ab_bandelay), "TaskDisconnectPlayer", target);

GetBanTime(length, unban_time, sizeof(unban_time) - 1);

PrintActivity(admin_name, "^x04[FIREON] $name^x01 :^x03 banned %s. Reason: %s. Ban Length: %s", target_name, arg, unban_time);

Log("%s <%s> banned %s <%s> || Reason: ^"%s^" || Ban Length: %s", admin_name, admin_authid, target_name, target_ip, arg, unban_time);

return PLUGIN_HANDLED;
}

public CmdAddBan(client, level, cid)
{
if( !cmd_access(client, level, cid, 5) ) return PLUGIN_HANDLED;

static target_name[32], target_authid[35], bantime[10], reason[128];
read_argv(1, target_name, sizeof(target_name) - 1);
read_argv(2, target_authid, sizeof(target_authid) - 1);
read_argv(3, bantime, sizeof(bantime) - 1);
read_argv(4, reason, sizeof(reason) - 1);

new bool:is_ip = bool:(containi(target_authid, ".") != -1);

if( !is_ip && !IsValidAuthid(target_authid) )
{
console_print(client, "[FIREON] %L", client, "AB_INVALID_STEAMID");
console_print(client, "[FIREON] %L", client, "AB_VALID_STEAMID_FORMAT");

return PLUGIN_HANDLED;
}
else if( is_ip )
{
new pos = contain(target_authid, ":");
if( pos > 0 )
{
target_authid[pos] = 0;
}

if( !IsValidIP(target_authid) )
{
console_print(client, "[FIREON] %L", client, "AB_INVALID_IP");

return PLUGIN_HANDLED;
}
}

#if MAX_BANS <= 0
if( TrieKeyExists(g_trie, target_authid) )
{
console_print(client, "[FIREON] %L", client, is_ip ? "AB_ALREADY_BANNED_IP" : "AB_ALREADY_BANNED_STEAMID");
return PLUGIN_HANDLED;
}
#else
for( new i = 0; i < g_total_bans; i++ )
{
if( !strcmp(target_authid, g_steamids[i], 1) )
{
console_print(client, "[FIREON] %L", client, is_ip ? "AB_ALREADY_BANNED_IP" : "AB_ALREADY_BANNED_STEAMID");
return PLUGIN_HANDLED;
}
}
#endif

new length = str_to_num(bantime);
new maxlength = GetMaxBanTime(client);

if( maxlength && (!length || length > maxlength) )
{
console_print(client, "[FIREON] %L", client, "AB_MAX_BAN_TIME", maxlength);
return PLUGIN_HANDLED;
}

if( is_user_connected(find_player(is_ip ? "d" : "c", target_authid)) )
{
client_cmd(client, "amx_ban ^"%s^" %i ^"%s^"", target_authid, length, reason);
return PLUGIN_HANDLED;
}

static unban_time[32];
if( length == 0 )
{
formatex(unban_time, sizeof(unban_time) - 1, "%L", client, "AB_PERMANENT_BAN");
}
else
{
GenerateUnbanTime(length, unban_time, sizeof(unban_time) - 1);
}

static admin_name[64], admin_authid[35];
get_user_name(client, admin_name, sizeof(admin_name) - 1);
get_user_authid(client, admin_authid, sizeof(admin_authid) - 1);

AddBan(target_name, target_authid, reason, length, unban_time, admin_name, admin_authid);

PrintBanInformation(client, target_name, target_authid, reason, length, unban_time, "", "", false);

GetBanTime(length, unban_time, sizeof(unban_time) - 1);

PrintActivity(admin_name, "^x04[FIREON] $name^x01 :^x03 banned %s %s. Reason: %s. Ban Length: %s", is_ip ? "IP" : "SteamID", target_authid, reason, unban_time);

Log("%s <%s> banned %s <%s> || Reason: ^"%s^" || Ban Length: %s", admin_name, admin_authid, target_name, target_authid, reason, unban_time);

return PLUGIN_HANDLED;
}

public CmdUnban(client, level, cid)
{
if( !cmd_access(client, level, cid, 2) ) return PLUGIN_HANDLED;

static arg[35];
read_argv(1, arg, sizeof(arg) - 1);

#if MAX_BANS > 0
static banned_authid[35];
for( new i = 0; i < g_total_bans; i++ )
{
copy(banned_authid, sizeof(banned_authid) - 1, g_steamids[i]);

if( equal(arg, banned_authid) )
{
static admin_name[64];
get_user_name(client, admin_name, sizeof(admin_name) - 1);

static name[32], reason[128];
copy(name, sizeof(name) - 1, g_names[i]);
copy(reason, sizeof(reason) - 1, g_reasons[i]);

PrintActivity(admin_name, "^x04[FIREON] $name^x01 :^x03 unbanned %s^x01 [%s] [Ban Reason: %s]", name, arg, reason);

static authid[35];
get_user_authid(client, authid, sizeof(authid) - 1);

Log("%s <%s> unbanned %s <%s> || Ban Reason: ^"%s^"", admin_name, authid, name, arg, reason);

RemoveBan(i);

return PLUGIN_HANDLED;
}
}
#else
if( TrieKeyExists(g_trie, arg) )
{
static array_pos;
TrieGetCell(g_trie, arg, array_pos);

static data[BannedData];
ArrayGetArray(g_array, array_pos, data);

static unban_name[32];
get_user_name(client, unban_name, sizeof(unban_name) - 1);

PrintActivity(unban_name, "^x04[FIREON] $name^x01 :^x03 unbanned %s^x01 [%s] [Ban Reason: %s]", data[bd_name], data[bd_steamid], data[bd_reason]);

RemoveBan(array_pos, data[bd_steamid]);

return PLUGIN_HANDLED;
}
#endif

console_print(client, "[FIREON] %L", client, "AB_NOT_IN_BAN_LIST", arg);

return PLUGIN_HANDLED;
}

public CmdBanList(client, level, cid)
{
if( !cmd_access(client, level, cid, 1) ) return PLUGIN_HANDLED;

if( !g_total_bans )
{
console_print(client, "[FIREON] %L", client, "AB_NO_BANS");
return PLUGIN_HANDLED;
}

static start;

if( read_argc() > 1 )
{
static arg[5];
read_argv(1, arg, sizeof(arg) - 1);

start = min(str_to_num(arg), g_total_bans) - 1;
}
else
{
start = 0;
}

new last = min(start + 10, g_total_bans);

if( client == 0 )
{
server_cmd("echo ^"%L^"", client, "AB_BAN_LIST_NUM", start + 1, last);
}
else
{
client_cmd(client, "echo ^"%L^"", client, "AB_BAN_LIST_NUM", start + 1, last);
}

for( new i = start; i < last; i++ )
{
#if MAX_BANS <= 0
static data[BannedData];
ArrayGetArray(g_array, i, data);

PrintBanInformation(client, data[bd_name], data[bd_steamid], data[bd_reason], data[bd_banlength], data[bd_unbantime], data[bd_admin_name], data[bd_admin_steamid], true);
#else
static name[32], steamid[35], reason[128], banlength, unbantime[32], admin_name[32], admin_steamid[35];

copy(name, sizeof(name) - 1, g_names[i]);
copy(steamid, sizeof(steamid) - 1, g_steamids[i]);
copy(reason, sizeof(reason) - 1, g_reasons[i]);
banlength = g_banlengths[i];
copy(unbantime, sizeof(unbantime) - 1, g_unbantimes[i]);
copy(admin_name, sizeof(admin_name) - 1, g_admin_names[i]);
copy(admin_steamid, sizeof(admin_steamid) - 1, g_admin_steamids[i]);

PrintBanInformation(client, name, steamid, reason, banlength, unbantime, admin_name, admin_steamid, true, false);
#endif
}

if( ++last < g_total_bans )
{
if( client == 0 )
{
server_cmd("echo ^"%L^"", client, "AB_BAN_LIST_NEXT", last);
}
else
{
client_cmd(client, "echo ^"%L^"", client, "AB_BAN_LIST_NEXT", last);
}
}

return PLUGIN_HANDLED;
}

public CmdAddBanLimit()
{
if( read_argc() != 3 )
{
log_amx("amx_addbanlimit was used with incorrect parameters!");
log_amx("Usage: amx_addbanlimit <flags> <time in minutes>");
return PLUGIN_HANDLED;
}

static arg[16];

read_argv(1, arg, sizeof(arg) - 1);
new flags = read_flags(arg);

read_argv(2, arg, sizeof(arg) - 1);
new minutes = str_to_num(arg);

#if !defined MAX_BANLIMITS
ArrayPushCell(g_maxban_flags, flags);
ArrayPushCell(g_maxban_times, minutes);
#else
if( g_total_maxban_times >= MAX_BANLIMITS )
{
static notified;
if( !notified )
{
log_amx("The amx_addbanlimit has reached its maximum!");
notified = 1;
}
return PLUGIN_HANDLED;
}

g_maxban_flags[g_total_maxban_times] = flags;
g_maxban_times[g_total_maxban_times] = minutes;
#endif
g_total_maxban_times++;

return PLUGIN_HANDLED;
}

public FwdThink(entity)
{
if( entity != g_unban_entity ) return;

#if defined USING_SQL && defined THREAD_QUERIES
if( g_total_bans > 0 && !g_loading_bans )
#else
if( g_total_bans > 0 )
#endif
{
static _hours[5], _minutes[5], _seconds[5], _month[5], _day[5], _year[7];
format_time(_hours, sizeof(_hours) - 1, "%H");
format_time(_minutes, sizeof(_minutes) - 1, "%M");
format_time(_seconds, sizeof(_seconds) - 1, "%S");
format_time(_month, sizeof(_month) - 1, "%m");
format_time(_day, sizeof(_day) - 1, "%d");
format_time(_year, sizeof(_year) - 1, "%Y");

// c = current
// u = unban

new c_hours = str_to_num(_hours);
new c_minutes = str_to_num(_minutes);
new c_seconds = str_to_num(_seconds);
new c_month = str_to_num(_month);
new c_day = str_to_num(_day);
new c_year = str_to_num(_year);

static unban_time[32];
static u_hours, u_minutes, u_seconds, u_month, u_day, u_year;

for( new i = 0; i < g_total_bans; i++ )
{
#if MAX_BANS <= 0
static data[BannedData];
ArrayGetArray(g_array, i, data);

if( data[bd_banlength] == 0 ) continue;
#else
if( g_banlengths[i] == 0 ) continue;
#endif

#if MAX_BANS <= 0
copy(unban_time, sizeof(unban_time) - 1, data[bd_unbantime]);
#else
copy(unban_time, sizeof(unban_time) - 1, g_unbantimes[i]);
#endif
replace_all(unban_time, sizeof(unban_time) - 1, ":", " ");
replace_all(unban_time, sizeof(unban_time) - 1, "/", " ");

parse(unban_time,\
_hours, sizeof(_hours) - 1,\
_minutes, sizeof(_minutes) - 1,\
_seconds, sizeof(_seconds) - 1,\
_month, sizeof(_month) - 1,\
_day, sizeof(_day) - 1,\
_year, sizeof(_year) - 1
);

u_hours = str_to_num(_hours);
u_minutes = str_to_num(_minutes);
u_seconds = str_to_num(_seconds);
u_month = str_to_num(_month);
u_day = str_to_num(_day);
u_year = str_to_num(_year);

if( u_year < c_year
|| u_year == c_year && u_month < c_month
|| u_year == c_year && u_month == c_month && u_day < c_day
|| u_year == c_year && u_month == c_month && u_day == c_day && u_hours < c_hours
|| u_year == c_year && u_month == c_month && u_day == c_day && u_hours == c_hours && u_minutes < c_minutes
|| u_year == c_year && u_month == c_month && u_day == c_day && u_hours == c_hours && u_minutes == c_minutes && u_seconds <= c_seconds )
{
#if MAX_BANS <= 0
Log("Ban time is up for: %s [%s]", data[bd_name], data[bd_steamid]);

Print("^x04[FIREON]^x03 %s^x01[^x04%s^x01]^x03 ban time is up!^x01 [Ban Reason: %s]", data[bd_name], data[bd_steamid], data[bd_reason]);

RemoveBan(i, data[bd_steamid]);
#else
Log("Ban time is up for: %s [%s]", g_names[i], g_steamids[i]);

Print("^x04[FIREON]^x03 %s^x01[^x04%s^x01]^x03 ban time is up!^x01 [Ban Reason: %s]", g_names[i], g_steamids[i], g_reasons[i]);

RemoveBan(i);
#endif

i--; // current pos was replaced with another ban, so we need to check it again.
}
}
}

entity_set_float(g_unban_entity, EV_FL_nextthink, get_gametime() + get_pcvar_float(ab_unbancheck));
}

public TaskDisconnectPlayer(client)
{
server_cmd("kick #%i ^"You are banned from this server. Check your console^"", get_user_userid(client));
}

AddBan(const target_name[], const target_steamid[], const reason[], const length, const unban_time[], const admin_name[], const admin_steamid[])
{
#if MAX_BANS > 0
if( g_total_bans == MAX_BANS )
{
log_amx("Ban list is full! (%i)", g_total_bans);
return;
}
#endif

#if defined USING_SQL
static target_name2[32], reason2[128], admin_name2[32];
MakeStringSQLSafe(target_name, target_name2, sizeof(target_name2) - 1);
MakeStringSQLSafe(reason, reason2, sizeof(reason2) - 1);
MakeStringSQLSafe(admin_name, admin_name2, sizeof(admin_name2) - 1);

static query[512];
formatex(query, sizeof(query) - 1,\
"INSERT INTO %s (%s, %s, %s, %s, %s, %s, %s) VALUES ('%s', '%s', '%i', '%s', '%s', '%s', '%s');",\
TABLE_NAME, KEY_NAME, KEY_STEAMID, KEY_BANLENGTH, KEY_UNBANTIME, KEY_REASON, KEY_ADMIN_NAME, KEY_ADMIN_STEAMID,\
target_name2, target_steamid, length, unban_time, reason2, admin_name2, admin_steamid
);

#if defined THREAD_QUERIES
SQL_ThreadQuery(g_sql_tuple, "QueryAddBan", query);
#else
static errcode, error[128];
new Handle:connection = SQL_Connect(g_sql_tuple, errcode, error, sizeof(error) - 1);

if( connection == Empty_Handle )
{
set_fail_state("Unable to connect to database.");
}

new Handle:result = SQL_PrepareQuery(connection, "%s", query);

if( !SQL_Execute(result) )
{
SQL_QueryError(result, error, sizeof(error) - 1);
log_amx("Failed to add ban: %s", error);
}

SQL_FreeHandle(connection);
#endif
#else
new f = fopen(g_ban_file, "a+");

fprintf(f, "^"%s^" ^"%s^" %i ^"%s^" ^"%s^" ^"%s^" ^"%s^"^n",\
target_steamid,\
target_name,\
length,\
unban_time,\
reason,\
admin_name,\
admin_steamid
);

fclose(f);
#endif

#if MAX_BANS <= 0
static data[BannedData];
copy(data[bd_name], sizeof(data[bd_name]) - 1, target_name);
copy(data[bd_steamid], sizeof(data[bd_steamid]) - 1, target_steamid);
data[bd_banlength] = length;
copy(data[bd_unbantime], sizeof(data[bd_unbantime]) - 1, unban_time);
copy(data[bd_reason], sizeof(data[bd_reason]) - 1, reason);
copy(data[bd_admin_name], sizeof(data[bd_admin_name]) - 1, admin_name);
copy(data[bd_admin_steamid], sizeof(data[bd_admin_steamid]) - 1, admin_steamid);

TrieSetCell(g_trie, target_steamid, g_total_bans);
ArrayPushArray(g_array, data);
#else
copy(g_names[g_total_bans], sizeof(g_names[]) - 1, target_name);
copy(g_steamids[g_total_bans], sizeof(g_steamids[]) - 1, target_steamid);
g_banlengths[g_total_bans] = length;
copy(g_unbantimes[g_total_bans], sizeof(g_unbantimes[]) - 1, unban_time);
copy(g_reasons[g_total_bans], sizeof(g_reasons[]) - 1, reason);
copy(g_admin_names[g_total_bans], sizeof(g_admin_names[]) - 1, admin_name);
copy(g_admin_steamids[g_total_bans], sizeof(g_admin_steamids[]) - 1, admin_steamid);
#endif

g_total_bans++;

#if MAX_BANS > 0
if( g_total_bans == MAX_BANS )
{
log_amx("Ban list is full! (%i)", g_total_bans);
}
#endif
}

#if defined USING_SQL
#if defined THREAD_QUERIES
public QueryAddBan(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime)
{
if( failstate == TQUERY_CONNECT_FAILED )
{
set_fail_state("Could not connect to database.");
}
else if( failstate == TQUERY_QUERY_FAILED )
{
set_fail_state("Query failed.");
}
else if( errcode )
{
log_amx("Error on query: %s", error);
}
else
{
// Yay, ban was added! We can all rejoice!
}
}

public QueryDeleteBan(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime)
{
if( failstate == TQUERY_CONNECT_FAILED )
{
set_fail_state("Could not connect to database.");
}
else if( failstate == TQUERY_QUERY_FAILED )
{
set_fail_state("Query failed.");
}
else if( errcode )
{
log_amx("Error on query: %s", error);
}
else
{
// Yay, ban was deleted! We can all rejoice!
}
}

public QueryLoadBans(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime)
{
if( failstate == TQUERY_CONNECT_FAILED )
{
set_fail_state("Could not connect to database.");
}
else if( failstate == TQUERY_QUERY_FAILED )
{
set_fail_state("Query failed.");
}
else if( errcode )
{
log_amx("Error on query: %s", error);
}
else
{
SQL_GetResults(query);
}
}
#endif

SQL_GetResults(Handle:query)
{
if( SQL_NumResults(query) )
{
#if MAX_BANS <= 0
static data[BannedData];
while( SQL_MoreResults(query) )
#else
while( SQL_MoreResults(query) && g_total_bans < MAX_BANS )
#endif
{
#if MAX_BANS <= 0
SQL_ReadResult(query, 0, data[bd_name], sizeof(data[bd_name]) - 1);
SQL_ReadResult(query, 1, data[bd_steamid], sizeof(data[bd_steamid]) - 1);
data[bd_banlength] = SQL_ReadResult(query, 2);
SQL_ReadResult(query, 3, data[bd_unbantime], sizeof(data[bd_unbantime]) - 1);
SQL_ReadResult(query, 4, data[bd_reason], sizeof(data[bd_reason]) - 1);
SQL_ReadResult(query, 5, data[bd_admin_name], sizeof(data[bd_admin_name]) - 1);
SQL_ReadResult(query, 6, data[bd_admin_steamid], sizeof(data[bd_admin_steamid]) - 1);

ArrayPushArray(g_array, data);
TrieSetCell(g_trie, data[bd_steamid], g_total_bans);
#else
SQL_ReadResult(query, 0, g_names[g_total_bans], sizeof(g_names[]) - 1);
SQL_ReadResult(query, 1, g_steamids[g_total_bans], sizeof(g_steamids[]) - 1);
g_banlengths[g_total_bans] = SQL_ReadResult(query, 2);
SQL_ReadResult(query, 3, g_unbantimes[g_total_bans], sizeof(g_unbantimes[]) - 1);
SQL_ReadResult(query, 4, g_reasons[g_total_bans], sizeof(g_reasons[]) - 1);
SQL_ReadResult(query, 5, g_admin_names[g_total_bans], sizeof(g_admin_names[]) - 1);
SQL_ReadResult(query, 6, g_admin_steamids[g_total_bans], sizeof(g_admin_steamids[]) - 1);
#endif

g_total_bans++;

SQL_NextRow(query);
}
}

set_task(RELOAD_BANS_INTERVAL, "LoadBans");

#if defined THREAD_QUERIES
g_loading_bans = false;
#endif
}
#endif

#if MAX_BANS > 0
RemoveBan(remove)
{
#if defined USING_SQL
static query[128];
formatex(query, sizeof(query) - 1,\
"DELETE FROM %s WHERE %s = '%s';",\
TABLE_NAME, KEY_STEAMID, g_steamids[remove]
);

#if defined THREAD_QUERIES
SQL_ThreadQuery(g_sql_tuple, "QueryDeleteBan", query);
#else
static errcode, error[128];
new Handle:connection = SQL_Connect(g_sql_tuple, errcode, error, sizeof(error) - 1);

if( connection == Empty_Handle )
{
set_fail_state("Unable to connect to database.");
}

new Handle:result = SQL_PrepareQuery(connection, "%s", query);

if( !SQL_Execute(result) )
{
SQL_QueryError(result, error, sizeof(error) - 1);
log_amx("Failed to remove ban: %s", error);
}

SQL_FreeHandle(connection);
#endif
#endif

for( new i = remove; i < g_total_bans; i++ )
{
if( (i + 1) == g_total_bans )
{
copy(g_names[i], sizeof(g_names[]) - 1, "");
copy(g_steamids[i], sizeof(g_steamids[]) - 1, "");
g_banlengths[i] = 0;
copy(g_unbantimes[i], sizeof(g_unbantimes[]) - 1, "");
copy(g_reasons[i], sizeof(g_reasons[]) - 1, "");
copy(g_admin_names[i], sizeof(g_admin_names[]) - 1, "");
copy(g_admin_steamids[i], sizeof(g_admin_steamids[]) - 1, "");
}
else
{
copy(g_names[i], sizeof(g_names[]) - 1, g_names[i + 1]);
copy(g_steamids[i], sizeof(g_steamids[]) - 1, g_steamids[i + 1]);
g_banlengths[i] = g_banlengths[i + 1];
copy(g_unbantimes[i], sizeof(g_unbantimes[]) - 1, g_unbantimes[i + 1]);
copy(g_reasons[i], sizeof(g_reasons[]) - 1, g_reasons[i + 1]);
copy(g_admin_names[i], sizeof(g_admin_names[]) - 1, g_admin_names[i + 1]);
copy(g_admin_steamids[i], sizeof(g_admin_steamids[]) - 1, g_admin_steamids[i + 1]);
}
}

g_total_bans--;

#if !defined USING_SQL
new f = fopen(g_ban_file, "wt");

static name[32], steamid[35], banlength, unbantime[32], reason[128], admin_name[32], admin_steamid[35];
for( new i = 0; i < g_total_bans; i++ )
{
copy(name, sizeof(name) - 1, g_names[i]);
copy(steamid, sizeof(steamid) - 1, g_steamids[i]);
banlength = g_banlengths[i];
copy(unbantime, sizeof(unbantime) - 1, g_unbantimes[i]);
copy(reason, sizeof(reason) - 1, g_reasons[i]);
copy(admin_name, sizeof(admin_name) - 1, g_admin_names[i]);
copy(admin_steamid, sizeof(admin_steamid) - 1, g_admin_steamids[i]);

fprintf(f, "^"%s^" ^"%s^" %i ^"%s^" ^"%s^" ^"%s^" ^"%s^"^n",\
steamid,\
name,\
banlength,\
unbantime,\
reason,\
admin_name,\
admin_steamid
);
}

fclose(f);
#endif
}
#else
RemoveBan(pos, const authid[])
{
TrieDeleteKey(g_trie, authid);
ArrayDeleteItem(g_array, pos);

g_total_bans--;

#if defined USING_SQL
static query[128];
formatex(query, sizeof(query) - 1,\
"DELETE FROM %s WHERE %s = '%s';",\
TABLE_NAME, KEY_STEAMID, authid
);

#if defined THREAD_QUERIES
SQL_ThreadQuery(g_sql_tuple, "QueryDeleteBan", query);
#else
static errcode, error[128];
new Handle:connection = SQL_Connect(g_sql_tuple, errcode, error, sizeof(error) - 1);

if( connection == Empty_Handle )
{
set_fail_state("Unable to connect to database.");
}

new Handle:result = SQL_PrepareQuery(connection, "%s", query);

if( !SQL_Execute(result) )
{
SQL_QueryError(result, error, sizeof(error) - 1);
log_amx("Failed to remove ban: %s", error);
}

SQL_FreeHandle(connection);
#endif

new data[BannedData];
for( new i = 0; i < g_total_bans; i++ )
{
ArrayGetArray(g_array, i, data);
TrieSetCell(g_trie, data[bd_steamid], i);
}
#else
new f = fopen(g_ban_file, "wt");

new data[BannedData];
for( new i = 0; i < g_total_bans; i++ )
{
ArrayGetArray(g_array, i, data);
TrieSetCell(g_trie, data[bd_steamid], i);

fprintf(f, "^"%s^" ^"%s^" %i ^"%s^" ^"%s^" ^"%s^" ^"%s^"^n",\
data[bd_steamid],\
data[bd_name],\
data[bd_banlength],\
data[bd_unbantime],\
data[bd_reason],\
data[bd_admin_name],\
data[bd_admin_steamid]
);
}

fclose(f);
#endif
}
#endif

#if defined KEEP_DEFAULT_BANS
LoadOldBans(filename[])
{
if( file_exists(filename) )
{
new f = fopen(filename, "rt");

static data[96];
static command[10], minutes[10], steamid[35], length, unban_time[32];

while( !feof(f) )
{
fgets(f, data, sizeof(data) - 1);
if( !data[0] ) continue;

parse(data, command, sizeof(command) - 1, minutes, sizeof(minutes) - 1, steamid, sizeof(steamid) - 1);
if( filename[0] == 'b' && !equali(command, "banid") || filename[0] == 'l' && !equali(command, "addip") ) continue;

length = str_to_num(minutes);
GenerateUnbanTime(length, unban_time, sizeof(unban_time) - 1);

AddBan("", steamid, "", length, unban_time, "", "");
}

fclose(f);

static filename2[32];

// copy current
copy(filename2, sizeof(filename2) - 1, filename);

// cut off at the "."
// banned.cfg = banned
// listip.cfg = listip
filename2[containi(filename2, ".")] = 0;

// add 2.cfg
// banned = banned2.cfg
// listip = listip2.cfg
add(filename2, sizeof(filename2) - 1, "2.cfg");

// rename file so that it isnt loaded again
while( !rename_file(filename, filename2, 1) ) { }
}
}
#endif

public LoadBans()
{
if( g_total_bans )
{
#if MAX_BANS <= 0
TrieClear(g_trie);
ArrayClear(g_array);
#endif

g_total_bans = 0;
}

#if defined USING_SQL
static query[128];
formatex(query, sizeof(query) - 1,\
"SELECT * FROM %s;",\
TABLE_NAME
);

#if defined THREAD_QUERIES
SQL_ThreadQuery(g_sql_tuple, "QueryLoadBans", query);

g_loading_bans = true;
#else
static errcode, error[128];
new Handle:connection = SQL_Connect(g_sql_tuple, errcode, error, sizeof(error) - 1);

if( connection == Empty_Handle )
{
set_fail_state("Unable to connect to database.");
}

new Handle:result = SQL_PrepareQuery(connection, "%s", query);

if( !SQL_Execute(result) )
{
SQL_QueryError(result, error, sizeof(error) - 1);
log_amx("Failed to load bans: %s", error);
}
else
{
SQL_GetResults(result);
}

SQL_FreeHandle(connection);
#endif
#else
if( file_exists(g_ban_file) )
{
new f = fopen(g_ban_file, "rt");

static filedata[512], length[10];

#if MAX_BANS <= 0
static data[BannedData];
while( !feof(f) )
#else
while( !feof(f) && g_total_bans < MAX_BANS )
#endif
{
fgets(f, filedata, sizeof(filedata) - 1);

if( !filedata[0] ) continue;

#if MAX_BANS <= 0
parse(filedata,\
data[bd_steamid], sizeof(data[bd_steamid]) - 1,\
data[bd_name], sizeof(data[bd_name]) - 1,\
length, sizeof(length) - 1,\
data[bd_unbantime], sizeof(data[bd_unbantime]) - 1,\
data[bd_reason], sizeof(data[bd_reason]) - 1,\
data[bd_admin_name], sizeof(data[bd_admin_name]) - 1,\
data[bd_admin_steamid], sizeof(data[bd_admin_steamid]) - 1
);

data[bd_banlength] = str_to_num(length);

ArrayPushArray(g_array, data);
TrieSetCell(g_trie, data[bd_steamid], g_total_bans);
#else
static steamid[35], name[32], unbantime[32], reason[128], admin_name[32], admin_steamid[35];

parse(filedata,\
steamid, sizeof(steamid) - 1,\
name, sizeof(name) - 1,\
length, sizeof(length) - 1,\
unbantime, sizeof(unbantime) - 1,\
reason, sizeof(reason) - 1,\
admin_name, sizeof(admin_name) - 1,\
admin_steamid, sizeof(admin_steamid) - 1
);

copy(g_names[g_total_bans], sizeof(g_names[]) - 1, name);
copy(g_steamids[g_total_bans], sizeof(g_steamids[]) - 1, steamid);
g_banlengths[g_total_bans] = str_to_num(length);
copy(g_unbantimes[g_total_bans], sizeof(g_unbantimes[]) - 1, unbantime);
copy(g_reasons[g_total_bans], sizeof(g_reasons[]) - 1, reason);
copy(g_admin_names[g_total_bans], sizeof(g_admin_names[]) - 1, admin_name);
copy(g_admin_steamids[g_total_bans], sizeof(g_admin_steamids[]) - 1, admin_steamid);
#endif

g_total_bans++;
}

fclose(f);
}
#endif

// load these after, so when they are added to the file with AddBan(), they aren't loaded again from above.

#if defined KEEP_DEFAULT_BANS
LoadOldBans("banned.cfg");
LoadOldBans("listip.cfg");
#endif
}

#if defined USING_SQL
MakeStringSQLSafe(const input[], output[], len)
{
copy(output, len, input);
replace_all(output, len, "'", "*");
replace_all(output, len, "^"", "*");
replace_all(output, len, "`", "*");
}
#endif

GetBanTime(const bantime, length[], len)
{
new minutes = bantime;
new hours = 0;
new days = 0;

while( minutes >= 60 )
{
minutes -= 60;
hours++;
}

while( hours >= 24 )
{
hours -= 24;
days++;
}

new bool:add_before;
if( minutes )
{
formatex(length, len, "%i minute%s", minutes, minutes == 1 ? "" : "s");

add_before = true;
}
if( hours )
{
if( add_before )
{
format(length, len, "%i hour%s, %s", hours, hours == 1 ? "" : "s", length);
}
else
{
formatex(length, len, "%i hour%s", hours, hours == 1 ? "" : "s");

add_before = true;
}
}
if( days )
{
if( add_before )
{
format(length, len, "%i day%s, %s", days, days == 1 ? "" : "s", length);
}
else
{
formatex(length, len, "%i day%s", days, days == 1 ? "" : "s");

add_before = true;
}
}
if( !add_before )
{
// minutes, hours, and days = 0
// assume permanent ban
copy(length, len, "Permanent Ban");
}
}

GenerateUnbanTime(const bantime, unban_time[], len)
{
static _hours[5], _minutes[5], _seconds[5], _month[5], _day[5], _year[7];
format_time(_hours, sizeof(_hours) - 1, "%H");
format_time(_minutes, sizeof(_minutes) - 1, "%M");
format_time(_seconds, sizeof(_seconds) - 1, "%S");
format_time(_month, sizeof(_month) - 1, "%m");
format_time(_day, sizeof(_day) - 1, "%d");
format_time(_year, sizeof(_year) - 1, "%Y");

new hours = str_to_num(_hours);
new minutes = str_to_num(_minutes);
new seconds = str_to_num(_seconds);
new month = str_to_num(_month);
new day = str_to_num(_day);
new year = str_to_num(_year);

minutes += bantime;

while( minutes >= 60 )
{
minutes -= 60;
hours++;
}

while( hours >= 24 )
{
hours -= 24;
day++;
}

new max_days = GetDaysInMonth(month, year);
while( day > max_days )
{
day -= max_days;
month++;
}

while( month > 12 )
{
month -= 12;
year++;
}

formatex(unban_time, len, "%i:%02i:%02i %i/%i/%i", hours, minutes, seconds, month, day, year);
}

GetDaysInMonth(month, year=0)
{
switch( month )
{
case 1: return 31; // january
case 2: return ((year % 4) == 0) ? 29 : 28; // february
case 3: return 31; // march
case 4: return 30; // april
case 5: return 31; // may
case 6: return 30; // june
case 7: return 31; // july
case 8: return 31; // august
case 9: return 30; // september
case 10: return 31; // october
case 11: return 30; // november
case 12: return 31; // december
}

return 30;
}

GetTargetFlags(client)
{
static const flags_no_immunity = (CMDTARGET_ALLOW_SELF|CMDTARGET_NO_BOTS);
static const flags_immunity = (CMDTARGET_ALLOW_SELF|CMDTARGET_NO_BOTS|CMDTARGET_OBEY_IMMUNITY);

switch( get_pcvar_num(ab_immunity) )
{
case 1: return flags_immunity;
case 2: return access(client, ADMIN_IMMUNITY) ? flags_no_immunity : flags_immunity;
}

return flags_no_immunity;
}

GetMaxBanTime(client)
{
if( !g_total_maxban_times ) return 0;

new flags = get_user_flags(client);

for( new i = 0; i < g_total_maxban_times; i++ )
{
#if !defined MAX_BANLIMITS
if( flags & ArrayGetCell(g_maxban_flags, i) )
{
return ArrayGetCell(g_maxban_times, i);
}
#else
if( flags & g_maxban_flags[i] )
{
return g_maxban_times[i];
}
#endif
}

return 0;
}

PrintBanInformation(client, const target_name[], const target_authid[], const reason[], const length, const unban_time[], const admin_name[], const admin_authid[], bool:show_admin)
{
static ban_length[64];
if( client == 0 )
{
server_print("************************************************");
server_print("%L", client, "AB_BAN_INFORMATION");
server_print("%L: %s", client, "AB_NAME", target_name);
server_print("%L: %s", client, IsValidAuthid(target_authid) ? "AB_STEAMID" : "AB_IP", target_authid);
server_print("%L: %s", client, "AB_REASON", reason);
if( length > 0 )
{
GetBanTime(length, ban_length, sizeof(ban_length) - 1);
server_print("%L: %s", client, "AB_BAN_LENGTH", ban_length);
}
server_print("%L: %s", client, "AB_UNBAN_TIME", unban_time);
if( show_admin )
{
server_print("%L: %s", client, "AB_ADMIN_NAME", admin_name);
//server_print("%L: %s", client, "AB_ADMIN_STEAMID", admin_authid);
}
server_print("%L", client, "AB_WEBSITE");
// if( show_website )
// {
// get_pcvar_string(ab_website, website, sizeof(website) - 1);
// if( website[0] )
// {
// server_print("");
// server_print("%L", client, "AB_WEBSITE");
// server_print("%s", website);
// }
// }
server_print("************************************************");
}
else
{
client_cmd(client, "echo ^"************************************************^"");
client_cmd(client, "echo ^"%L^"", client, "AB_BAN_INFORMATION");
client_cmd(client, "echo ^"%L: %s^"", client, "AB_NAME", target_name);
client_cmd(client, "echo ^"%L: %s^"", client, IsValidAuthid(target_authid) ? "AB_STEAMID" : "AB_IP", target_authid);
client_cmd(client, "echo ^"%L: %s^"", client, "AB_REASON", reason);
if( length > 0 )
{
GetBanTime(length, ban_length, sizeof(ban_length) - 1);
client_cmd(client, "echo ^"%L: %s^"", client, "AB_BAN_LENGTH", ban_length);
}
client_cmd(client, "echo ^"%L: %s^"", client, "AB_UNBAN_TIME", unban_time);
if( show_admin )
{
client_cmd(client, "echo ^"%L: %s^"", client, "AB_ADMIN_NAME", admin_name);
//client_cmd(client, "echo ^"%L: %s^"", client, "AB_ADMIN_STEAMID", admin_authid);
}
client_cmd(client, "echo ^"%L^"", client, "AB_WEBSITE");
// if( show_website )
// {
// get_pcvar_string(ab_website, website, sizeof(website) - 1);
// if( website[0] )
// {
// client_cmd(client, "echo ^"^"");
// client_cmd(client, "echo ^"%L^"", client, "AB_WEBSITE");
// client_cmd(client, "echo ^"%s^"", website);
// }
// }
client_cmd(client, "echo ^"************************************************^"");
}
}

PrintActivity(const admin_name[], const message_fmt[], any:...)
{
if( !get_playersnum() ) return;

new activity = get_pcvar_num(amx_show_activity);
if( !(0 <= activity <= 5) )
{
set_pcvar_num(amx_show_activity, (activity = 2));
}

static message[192], temp[192];
vformat(message, sizeof(message) - 1, message_fmt, 3);

for( new client = 1; client <= g_max_clients; client++ )
{
if( !is_user_connected(client) ) continue;

switch( is_user_admin(client) ? g_admin_activity[activity] : g_normal_activity[activity] )
{
case ACTIVITY_NONE:
{

}
case ACTIVITY_HIDE:
{
copy(temp, sizeof(temp) - 1, message);
replace(temp, sizeof(temp) - 1, "$name", "ADMIN");

message_begin(MSG_ONE_UNRELIABLE, g_msgid_SayText, _, client);
write_byte(client);
write_string(temp);
message_end();
}
case ACTIVITY_SHOW:
{
copy(temp, sizeof(temp) - 1, message);
replace(temp, sizeof(temp) - 1, "$name", admin_name);

message_begin(MSG_ONE_UNRELIABLE, g_msgid_SayText, _, client);
write_byte(client);
write_string(temp);
message_end();
}
}
}
}

Print(const message_fmt[], any:...)
{
if( !get_playersnum() ) return;

static message[192];
vformat(message, sizeof(message) - 1, message_fmt, 2);

for( new client = 1; client <= g_max_clients; client++ )
{
if( !is_user_connected(client) ) continue;

message_begin(MSG_ONE_UNRELIABLE, g_msgid_SayText, _, client);
write_byte(client);
write_string(message);
message_end();
}
}

Log(const message_fmt[], any:...)
{
static message[256];
vformat(message, sizeof(message) - 1, message_fmt, 2);

static filename[96];
#if defined HISTORY_ONE_FILE
if( !filename[0] )
{
get_basedir(filename, sizeof(filename) - 1);
add(filename, sizeof(filename) - 1, "/logs/ban_history.log");
}
#else
static dir[64];
if( !dir[0] )
{
get_basedir(dir, sizeof(dir) - 1);
add(dir, sizeof(dir) - 1, "/logs");
}

format_time(filename, sizeof(filename) - 1, "%m%d%Y");
format(filename, sizeof(filename) - 1, "%s/BAN_HISTORY_%s.log", dir, filename);
#endif

log_amx("%s", message);
log_to_file(filename, "%s", message);
}
/* AMXX-Studio Notes - DO NOT MODIFY BELOW HERE
*{\\ rtf1\\ ansi\\ deff0{\\ fonttbl{\\ f0\\ fnil Tahoma;}}\n\\ viewkind4\\ uc1\\ pard\\ lang1033\\ f0\\ fs16 \n\\ par }
*/
Hi. I've a question a problem with my ban plugin. Sometimes i get this error and i don't know why and i don't have problems with database because admins are good. If i change the map is good, the plugin is reloading and working but is there something to do without changing the map?

I know that my amxx version is 1.9 but it has nothing to do with that. The problem is with the ban plugin not amxx
 
Сообщения
859
Реакции
144
Помог
25 раз(а)
Where does the plugin get the data to connect to the database? with sql.cfg?
 
Сообщения
859
Реакции
144
Помог
25 раз(а)
Try disabling all plugins that interact with the database and leave only Advanced Bans.
 
Сообщения
859
Реакции
144
Помог
25 раз(а)
Can you show me your school.tsfg? No password to the database and no IP address.
 
Сообщения
859
Реакции
144
Помог
25 раз(а)
Try change cvar amx_sql_table "admins" -> amx_sql_table "advanced_bans"
 
Сообщения
86
Реакции
2
Предупреждения
1
You use admin_sql.amxx plugin for load admin from sql?
Benzogang_BabyTape I'm using admins.amxx wich is this one
Код:
#define USING_SQL

#include <amxmodx>
#include <amxmisc>
#if defined USING_SQL
#include <sqlx>
#endif

//new Vector:AdminList;

new AdminCount;

new PLUGINNAME[] = "ADMINS"

#define ADMIN_LOOKUP    (1<<0)
#define ADMIN_NORMAL    (1<<1)
#define ADMIN_STEAM        (1<<2)
#define ADMIN_IPADDR    (1<<3)
#define ADMIN_NAME        (1<<4)

new g_cmdLoopback[16]
new bool:g_CaseSensitiveName[33];

// pcvars
new amx_mode;
new amx_password_field;
new amx_default_access;

public plugin_init()
{
#if defined USING_SQL
    register_plugin("Admin Base (SQL)", AMXX_VERSION_STR, "AMXX Dev Team")
#else
    register_plugin("Admin Base", AMXX_VERSION_STR, "AMXX Dev Team")
#endif
    register_dictionary("admin.txt")
    register_dictionary("common.txt")
    amx_mode=register_cvar("amx_mode", "1")
    amx_password_field=register_cvar("amx_password_field", "_pw")
    amx_default_access=register_cvar("amx_default_access", "")

    register_cvar("amx_vote_ratio", "0.02")
    register_cvar("amx_vote_time", "10")
    register_cvar("amx_vote_answers", "1")
    register_cvar("amx_vote_delay", "60")
    register_cvar("amx_last_voting", "0")
    register_cvar("amx_show_activity", "2")
    register_cvar("amx_votekick_ratio", "0.40")
    register_cvar("amx_voteban_ratio", "0.40")
    register_cvar("amx_votemap_ratio", "0.40")

    set_cvar_float("amx_last_voting", 0.0)

#if defined USING_SQL
    register_srvcmd("amx_sqladmins", "adminSql")
    register_cvar("amx_sql_table", "admins")
#endif
    register_cvar("amx_sql_host", "127.0.0.1")
    register_cvar("amx_sql_user", "root")
    register_cvar("amx_sql_pass", "")
    register_cvar("amx_sql_db", "amx")
    register_cvar("amx_sql_type", "mysql")

    register_concmd("amx_reloadadmins", "cmdReload", ADMIN_MENU)
    register_concmd("amx_addadmin", "addadminfn", ADMIN_MENU, "<playername|auth> <accessflags> [password] [authtype] - add specified player as an admin to users.ini")

    format(g_cmdLoopback, 15, "amxauth%c%c%c%c", random_num('A', 'Z'), random_num('A', 'Z'), random_num('A', 'Z'), random_num('A', 'Z'))

    register_clcmd(g_cmdLoopback, "ackSignal")

    remove_user_flags(0, read_flags("z"))        // Remove 'user' flag from server rights

    new configsDir[64]
    get_configsdir(configsDir, 63)
   
    server_cmd("exec %s/amxx.cfg", configsDir)    // Execute main configuration file
    server_cmd("exec %s/sql.cfg", configsDir)

    // Create a vector of 5 cells to store the info.
    //AdminList=vector_create(5);

   
#if defined USING_SQL
    server_cmd("amx_sqladmins")
#else
    format(configsDir, 63, "%s/users.ini", configsDir)
    loadSettings(configsDir)                    // Load admins accounts
#endif
}
 

Пользователи, просматривающие эту тему

Сейчас на форуме нет ни одного пользователя.
Сверху Снизу