Mensajes: 375
Temas: 55
Registro en: Jan 2016
Reputación:
9
26/10/2018, 12:40 PM
(Última modificación: 17/02/2019, 12:03 AM por Cristian' . Edited 1 time in total.)
Sistema de Ban SQLite3
• Créditos: • Descripción:
Un sistema de ban que interactúa con una base de datos, tiene la posibilidad de agregar IP's, SteamID's y HID's por un tiempo establecido en minutos, baneando al usuario y facilitando así la exclusión del mismo.
• Cambios:
-
Optimización del código
-
Reducción de tablas
-
Ahora se puede ver la información del usuario baneado en la lista de ban.
-
Corregido algunos errores.
-
Ahora se crea un log por cada acción realizada: ban, unban, etc... • Comandos: • Características del menú principal
-
Expulsar usuarios: Expulsar a un usuario del servidor
-
Banear usuarios: Banea a un usuario del servidor: El ban puede ser por (IP / STEAMID / HWIWD [sXe necesario]).
-
Banear IP: Agrega una IP a la base de datos.
-
Banear STEAMID: Agrega un STEAMID a la base de datos.
-
Lista de usuarios baneados con su descripción del ban:
-
Lista de ban: Permite ver los usuarios baneados, así mismo el NOMBRE DE USUARIO, IP, STEAMID y HID de los últimos diez que se desconectaron.
• Menú de ban
-
Calcular días en minutos: Permite calcular los minutos que equivalen a x días.
-
Calcular horas en minutos: Permite calcular los minutos que equivalen a x horas.
-
Introducir minutos: Introduce los minutos del ban.
-
Introducir razón: Introduce la razón del ban.
-
Minutos en total: Calcula los minutos introducidos de los días y las horas.
-
Tipo de ban: Introduce el tipo de ban (IP / STEAMID / HID).
-
Ejecutar el ban: Ejecuta el ban al usuario.
• Imágenes • Lista de usuarios desconectados
- Permite visualizar los últimos diez usuarios que se desconectaron del servidor, el cual obtiene su NOMBRE DE USUARIO, IP, STEAMID y HID.
- Puede visualizarse a través de consola o en un menú.
Archivos adjuntos sql_ban_database.sq3 (Tamaño: 7 KB / Descargas: 134)
Descargar AMXX / ban_system.sma (Tamaño: 53.58 KB / Descargas: 223)
Mensajes: 4,637
Temas: 73
Registro en: Oct 2013
Reputación:
44
Una buena pregunta sería, por qué interactúa con 2 bases de datos
O al menos eso da a entender el título
Mensajes: 375
Temas: 55
Registro en: Jan 2016
Reputación:
9
(26/10/2018, 12:46 PM) Neeeeeeeeeel.- escribió:
En realidad el título se refiere a que tiene para
MySQL y
SQLite3 (?
Mensajes: 7,178
Temas: 93
Registro en: Aug 2014
Reputación:
63
Por qué no hacer directamente algo como 'amx_add_ban "ip/steamid/hid" "tiempo" "razon"'?
Mensajes: 7
26/10/2018, 03:49 PM
(Última modificación: 26/10/2018, 03:54 PM por heNK' .)
En Breaking Gaming, usabamos el Advanced Bans vía MySQL.
Edito: (Trae UnBan Menú, Ban Menú). Y MySQL Threads de Destro.
Código del AMX:
Código PHP:
#include <amxmodx> new const Datos_MySQLt [ ] [ ] = { "" , //Web "" , //User "" , //Pass "" //Db }; #define TABLE_NAME "advanced_bans" new Regex : g_IP_pattern ; Regex : g_SteamID_pattern ; g_regex_return ; /*bool:IsValidIP(const ip[]) enum // for name displaying { ACTIVITY_NONE , // nothing is shown ACTIVITY_HIDE , // admin name is hidden ACTIVITY_SHOW // admin name is shown }; 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 }; 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 ] Trie : g_trie ; g_array ; #else new g_names [ MAX_BANS ][ 32 ]; g_steamids [ MAX_BANS ][ 35 ]; g_banlengths [ MAX_BANS ]; g_unbantimes [ MAX_BANS ][ 32 ]; g_reasons [ MAX_BANS ][ 128 ]; g_admin_names [ MAX_BANS ][ 64 ]; g_admin_steamids [ MAX_BANS ][ 35 ]; #endif new g_total_bans ; #if !defined USING_SQL new g_ban_file [ 64 ]; #else new Handle : g_iHost ; Handle : g_sql_tuple ; bool : g_loading_bans = true ; #endif new ab_immunity ; ab_bandelay ; ab_unbancheck ; amx_show_activity ; #if MAX_BANS <= 0 new Array: g_maxban_times ; g_maxban_flags ; #else new g_maxban_times [ MAX_BANLIMITS ]; g_maxban_flags [ MAX_BANLIMITS ]; #endif new g_total_maxban_times ; g_unban_entity ; g_max_clients ; g_msgid_SayText ; g_iSelectedPlayer [ 33 ]; enum _ : TypeData { Tiempo_Name [ 32 ], Tiempo_Tiempo }; szRazones [][] = { "Wall Hack" , "Stopear Screen" , "Insultar" , "Spammear" , "Molestar / Flood" , "Tirar Servidor" , "Cheat" }; szTiempos [][] = { "5 Minutos" , 5 }, "10 Minutos" , 10 }, "20 Minutos" , 20 }, "30 Minutos" , 30 }, "40 Minutos" , 40 }, "50 Minutos" , 50 }, "1 Hora" , 60 }, "1 Dia" , 1440 }, "Permanente" , 0 } 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>" ); register_clcmd ( "amx_bans_menu" , "CmdBanMenu" , ADMIN_BAN , "muestra un menu con los players" ); register_clcmd ( "amx_unbanmenu" , "CmdUnBanMenu" , ADMIN_BAN , "muestra un menu con los players banneados" ); register_clcmd ( "INGRESAR_TIEMPO" , "Messagemode_Tiempo" ); register_clcmd ( "INGRESAR_RAZON" , "Messagemode_Razon" ); 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 g_maxban_times = ArrayCreate ( 1 ); g_maxban_flags = ArrayCreate ( 1 ); #endif get_datadir ( g_ban_file , sizeof ( g_ban_file ) - 1 ); add ( g_ban_file , sizeof ( g_ban_file ) - 1 , "/advanced_bans.txt" ); LoadBans (); #else g_iHost = mysql_makehost ( Datos_MySQLt [ 0 ], Datos_MySQLt [ 1 ], Datos_MySQLt [ 2 ], Datos_MySQLt [ 3 ] ); error1 [ 32 ], errnum ; g_sql_tuple = mysql_connect ( g_iHost , errnum , error1 , sizeof ( error1 ) ); errnum ){ log_to_file ( "MySQLt_AB_init.log" , "Error: [%d] - [%s]" , errnum , error1 ); pause ( "a" ); mysql_performance ( 25 , 25 , 1 ); 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" ); PLUGIN_CONTINUE ; plugin_cfg () CreateUnbanEntity (); CreateUnbanEntity () failtimes ; g_unban_entity = create_entity ( "info_target" ); is_valid_ent ( g_unban_entity ) ) failtimes ; log_amx ( "[ERROR] Failed to create unban entity (%i/10)" , failtimes ); failtimes < 10 ) set_task ( 1.0 , "CreateUnbanEntity" ); log_amx ( "[ERROR] Could not create unban entity!" ); 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" ); client_authorized ( client ) authid [ 35 ]; get_user_authid ( client , authid , sizeof ( authid ) - 1 ); ip [ 35 ]; get_user_ip ( client , ip , sizeof ( ip ) - 1 , 1 ); #if MAX_BANS > 0 static banned_authid [ 35 ], bool : is_ip ; i = 0 ; i < g_total_bans ; i ++ ) copy ( banned_authid , sizeof ( banned_authid ) - 1 , g_steamids [ i ]); is_ip = bool :( containi ( banned_authid , "." ) != - 1 ); is_ip && equal ( ip , banned_authid ) || ! is_ip && equal ( authid , banned_authid ) ) 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 ]); 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 ); #else static array_pos ; TrieGetCell ( g_trie , authid , array_pos ) || TrieGetCell ( g_trie , ip , array_pos ) ) 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 , true ); set_task ( get_pcvar_float ( ab_bandelay ), "TaskDisconnectPlayer" , client ); #endif } CmdBanMenu ( id ){ get_user_flags ( id ) & ADMIN_BAN )){ ColorChat ( id , GREEN , "^4[AdvancedBans] ^1No tienes acceso al ban menú." ); PLUGIN_HANDLED ; iMenu = menu_create ( "\r[AdvancedBans] \wBan Menu" , "HandlerBanMenu" ); iUsers [ 12 ]; i = 1 ; i <= g_max_clients ; i ++ ) { is_user_connected ( i ) ) { name [ 33 ]; get_user_name ( i , name , 32 ); num_to_str ( get_user_userid ( i ), iUsers , sizeof ( iUsers ) ); menu_additem ( iMenu , name , iUsers ); menu_setprop ( iMenu , MPROP_BACKNAME , "Atras" ); menu_setprop ( iMenu , MPROP_NEXTNAME , "Siguiente" ); menu_setprop ( iMenu , MPROP_EXITNAME , "Salir" ); menu_display ( id , iMenu ); PLUGIN_HANDLED ; HandlerBanMenu ( id , menu , item ){ item == MENU_EXIT ){ menu_destroy ( menu ); PLUGIN_HANDLED ; iAccess , callback ; szData [ 64 ], szName [ 64 ]; menu_item_getinfo ( menu , item , iAccess , szData , sizeof ( szData ), szName , sizeof ( szName ), callback ); g_iSelectedPlayer [ id ] = str_to_num ( szData ); client_cmd2 ( id , "messagemode ^" INGRESAR_TIEMPO ^ "" ); PLUGIN_HANDLED ; Tiempo [ 33 ][ 32 ]; Razon [ 64 ][ 32 ]; Messagemode_Tiempo ( id ){ //get_user_name(id, g_iSelectedPlayer[id], sizeof(g_iSelectedPlayer[])); ColorChat ( id , GREEN , "^4[AdvancedBans] ^1Ingresa el tiempo a banear" ); read_args ( Tiempo [ id ], sizeof ( Tiempo [])); remove_quotes ( Tiempo [ id ]); arg [ 33 ]; read_argv ( 1 , arg , 32 ); remove_quotes ( arg ); is_str_num ( arg ) || ! is_str_num ( Tiempo [ id ])){ ColorChat ( id , GREEN , "^4[AdvancedBans] ^1Sólo números" ); client_cmd2 ( id , "messagemode ^" INGRESAR_TIEMPO ^ "" ); PLUGIN_HANDLED ; client_cmd2 ( id , "messagemode ^" INGRESAR_RAZON ^ "" ); PLUGIN_CONTINUE ; Messagemode_Razon ( id ){ ColorChat ( id , GREEN , "^4[AdvancedBans] ^1Ingresa la razon!" ); ColorChat ( id , GREEN , "^4[AdvancedBans] ^1Una vez dado al enter, el player se banear automaticamente" ); read_args ( Razon [ id ], sizeof ( Razon [])); remove_quotes ( Razon [ id ]); arg [ 33 ]; read_argv ( 1 , arg , 32 ); remove_quotes ( arg ); strlen ( arg ) || ! strlen ( Razon [ id ])){ ColorChat ( id , GREEN , "^4[AdvancedBans] ^1No puedes dejar un espacio en blanco" ); client_cmd2 ( id , "messagemode ^" INGRESAR_RAZON ^ "" ); PLUGIN_HANDLED ; client_cmd2 ( id , "amx_ban ^" #%d^" ^"%s^" ^"%s^"", g_iSelectedPlayer[id], Tiempo[id], Razon[id]); return PLUGIN_CONTINUE ; CmdBan ( client , level , cid ) cmd_access ( client , level , cid , 4 ) ) return PLUGIN_HANDLED ; arg [ 128 ]; read_argv ( 1 , arg , sizeof ( arg ) - 1 ); target = cmd_target ( client , arg , GetTargetFlags ( client )); target ) return PLUGIN_HANDLED ; target_authid [ 35 ]; get_user_authid ( target , target_authid , sizeof ( target_authid ) - 1 ); IsValidAuthid ( target_authid ) ) console_print ( client , "[AdvancedBans] %L" , client , "AB_NOT_AUTHORIZED" ); PLUGIN_HANDLED ; #if MAX_BANS <= 0 if( TrieKeyExists ( g_trie , target_authid ) ) console_print ( client , "[AdvancedBans] %L" , client , "AB_ALREADY_BANNED_STEAMID" ); PLUGIN_HANDLED ; #else for( new i = 0 ; i < g_total_bans ; i ++ ) strcmp ( target_authid , g_steamids [ i ], 1 ) ) console_print ( client , "[AdvancedBans] %L" , client , "AB_ALREADY_BANNED_STEAMID" ); PLUGIN_HANDLED ; #endif if( is_user_admin ( target ) || client == target ){ console_print ( client , "[AdvancedBans] No puedes banear a un ADMIN o a ti mismo" ); PLUGIN_HANDLED ; read_argv ( 2 , arg , sizeof ( arg ) - 1 ); length = str_to_num ( arg ); maxlength = GetMaxBanTime ( client ); maxlength && (! length || length > maxlength ) ) console_print ( client , "[AdvancedBans] %L" , client , "AB_MAX_BAN_TIME" , maxlength ); PLUGIN_HANDLED ; unban_time [ 64 ]; length == 0 ) formatex ( unban_time , sizeof ( unban_time ) - 1 , "%L" , client , "AB_PERMANENT_BAN" ); GenerateUnbanTime ( length , unban_time , sizeof ( unban_time ) - 1 ); read_argv ( 3 , arg , sizeof ( arg ) - 1 ); 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 ); 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 , true ); PrintBanInformation ( client , target_name , target_authid , arg , length , unban_time , admin_name , admin_authid , false , false ); set_task ( get_pcvar_float ( ab_bandelay ), "TaskDisconnectPlayer" , target ); GetBanTime ( length , unban_time , sizeof ( unban_time ) - 1 ); PrintActivity ( admin_name , "^x04[AdvancedBans] $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 ); PLUGIN_HANDLED ; CmdBanIp ( client , level , cid ) cmd_access ( client , level , cid , 4 ) ) return PLUGIN_HANDLED ; arg [ 128 ]; read_argv ( 1 , arg , sizeof ( arg ) - 1 ); target = cmd_target ( client , arg , GetTargetFlags ( client )); target ) return PLUGIN_HANDLED ; 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 , "[AdvancedBans] %L" , client , "AB_ALREADY_BANNED_IP" ); PLUGIN_HANDLED ; #else for( new i = 0 ; i < g_total_bans ; i ++ ) strcmp ( target_ip , g_steamids [ i ], 1 ) ) console_print ( client , "[AdvancedBans] %L" , client , "AB_ALREADY_BANNED_IP" ); PLUGIN_HANDLED ; #endif if( is_user_admin ( target ) || client == target ){ console_print ( client , "[AdvancedBans] No puedes banear a un ADMIN o a ti mismo" ); PLUGIN_HANDLED ; read_argv ( 2 , arg , sizeof ( arg ) - 1 ); length = str_to_num ( arg ); maxlength = GetMaxBanTime ( client ); maxlength && (! length || length > maxlength ) ) console_print ( client , "[AdvancedBans] %L" , client , "AB_MAX_BAN_TIME" , maxlength ); PLUGIN_HANDLED ; unban_time [ 32 ]; length == 0 ) formatex ( unban_time , sizeof ( unban_time ) - 1 , "%L" , client , "AB_PERMANENT_BAN" ); GenerateUnbanTime ( length , unban_time , sizeof ( unban_time ) - 1 ); read_argv ( 3 , arg , sizeof ( arg ) - 1 ); 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 ); 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 , true ); PrintBanInformation ( client , target_name , target_ip , arg , length , unban_time , admin_name , admin_authid , false , false ); set_task ( get_pcvar_float ( ab_bandelay ), "TaskDisconnectPlayer" , target ); GetBanTime ( length , unban_time , sizeof ( unban_time ) - 1 ); PrintActivity ( admin_name , "^x04[AdvancedBans] $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 ); PLUGIN_HANDLED ; CmdAddBan ( client , level , cid ) cmd_access ( client , level , cid , 5 ) ) return PLUGIN_HANDLED ; 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 ); bool : is_ip = bool :( containi ( target_authid , "." ) != - 1 ); is_ip && ! IsValidAuthid ( target_authid ) ) console_print ( client , "[AdvancedBans] %L" , client , "AB_INVALID_STEAMID" ); console_print ( client , "[AdvancedBans] %L" , client , "AB_VALID_STEAMID_FORMAT" ); PLUGIN_HANDLED ; is_ip ) pos = contain ( target_authid , ":" ); pos > 0 ) target_authid [ pos ] = 0 ; IsValidIP ( target_authid ) ) console_print ( client , "[AdvancedBans] %L" , client , "AB_INVALID_IP" ); PLUGIN_HANDLED ; #if MAX_BANS <= 0 if( TrieKeyExists ( g_trie , target_authid ) ) console_print ( client , "[AdvancedBans] %L" , client , is_ip ? "AB_ALREADY_BANNED_IP" : "AB_ALREADY_BANNED_STEAMID" ); PLUGIN_HANDLED ; #else for( new i = 0 ; i < g_total_bans ; i ++ ) strcmp ( target_authid , g_steamids [ i ], 1 ) ) console_print ( client , "[AdvancedBans] %L" , client , is_ip ? "AB_ALREADY_BANNED_IP" : "AB_ALREADY_BANNED_STEAMID" ); PLUGIN_HANDLED ; #endif new length = str_to_num ( bantime ); maxlength = GetMaxBanTime ( client ); maxlength && (! length || length > maxlength ) ) console_print ( client , "[AdvancedBans] %L" , client , "AB_MAX_BAN_TIME" , maxlength ); PLUGIN_HANDLED ; is_user_connected ( find_player ( is_ip ? "d" : "c" , target_authid )) ) client_cmd ( client , "amx_ban ^" % s ^ " %i ^" % s ^ "" , target_authid , length , reason ); PLUGIN_HANDLED ; unban_time [ 32 ]; length == 0 ) formatex ( unban_time , sizeof ( unban_time ) - 1 , "%L" , client , "AB_PERMANENT_BAN" ); GenerateUnbanTime ( length , unban_time , sizeof ( unban_time ) - 1 ); 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 , false ); GetBanTime ( length , unban_time , sizeof ( unban_time ) - 1 ); PrintActivity ( admin_name , "^x04[AdvancedBans] $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 ); PLUGIN_HANDLED ; CmdUnBanMenu ( id ){ get_user_flags ( id ) & ADMIN_BAN )){ ColorChat ( id , GREEN , "^4[AdvancedBans] ^1No tienes acceso al ban menú." ); PLUGIN_HANDLED ; read_argc ()){ ColorChat ( id , GREEN , "^4[AdvancedBans] ^1Player Name ^3| ^1Razón del Ban ^3| ^1Admin Name" ); ColorChat ( id , GREEN , "^4[AdvancedBans] ^1Una vez seleccionado el player se baneara automaticamente" ); iMenu = menu_create ( "\r[AdvancedBans] \wUnban Menu:^n\wNombre \d| \wRazon \d| \wAdmin Name" , "HandlerUnBanMenu" ); g_total_bans ) ColorChat ( id , GREEN , "^4[AdvancedBans] ^1No hay banneados en este momento" ); i = 0 ; i < g_total_bans ; i ++ ){ data [ BannedData ]; ArrayGetArray ( g_array , i , data ); iLen [ 127 ]; formatex ( iLen , 126 , "%s \r[%s] \d[%s]" , data [ bd_name ], data [ bd_reason ], data [ bd_admin_name ]); menu_additem ( iMenu , iLen ); menu_setprop ( iMenu , MPROP_BACKNAME , "Atras" ); menu_setprop ( iMenu , MPROP_NEXTNAME , "Siguiente" ); menu_setprop ( iMenu , MPROP_EXITNAME , "Salir" ); menu_display ( id , iMenu ); PLUGIN_HANDLED ; HandlerUnBanMenu ( id , menu , item ){ item == MENU_EXIT ){ menu_destroy ( menu ); PLUGIN_HANDLED ; iAccess , callback ; szData [ 64 ], szName [ 64 ]; menu_item_getinfo ( menu , item , iAccess , szData , sizeof ( szData ), szName , sizeof ( szName ), callback ); data [ BannedData ]; ArrayGetArray ( g_array , item , data ); client_cmd2 ( id , "amx_unban ^" % s ^ "" , data [ bd_steamid ]); //new admin_name[33]; menu_destroy ( menu ); PLUGIN_HANDLED ; CmdUnban ( client , level , cid ) cmd_access ( client , level , cid , 2 ) ) return PLUGIN_HANDLED ; arg [ 35 ]; read_argv ( 1 , arg , sizeof ( arg ) - 1 ); #if MAX_BANS > 0 static banned_authid [ 35 ]; i = 0 ; i < g_total_bans ; i ++ ) copy ( banned_authid , sizeof ( banned_authid ) - 1 , g_steamids [ i ]); equal ( arg , banned_authid ) ) admin_name [ 64 ]; get_user_name ( client , admin_name , sizeof ( admin_name ) - 1 ); name [ 32 ], reason [ 128 ]; copy ( name , sizeof ( name ) - 1 , g_names [ i ]); copy ( reason , sizeof ( reason ) - 1 , g_reasons [ i ]); PrintActivity ( admin_name , "^x04[AdvancedBans] $name ^x01 :^x03 unbanned %s^x01 [%s] [Ban Reason: %s]" , name , arg , reason ); 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 ); PLUGIN_HANDLED ; #else if( TrieKeyExists ( g_trie , arg ) ) array_pos ; TrieGetCell ( g_trie , arg , array_pos ); data [ BannedData ]; ArrayGetArray ( g_array , array_pos , data ); unban_name [ 32 ]; get_user_name ( client , unban_name , sizeof ( unban_name ) - 1 ); PrintActivity ( unban_name , "^x04[AdvancedBans] $name ^x01 :^x03 unbanned %s^x01 [%s] [Ban Reason: %s]" , data [ bd_name ], data [ bd_steamid ], data [ bd_reason ]); admin_name [ 64 ]; get_user_name ( client , admin_name , sizeof ( admin_name ) - 1 ); authid [ 35 ]; get_user_authid ( client , authid , sizeof ( authid ) - 1 ); Log ( "%s <%s> unbanned %s <%s> || Ban Reason: ^" % s ^ "" , admin_name , authid , data [ bd_name ], data [ bd_steamid ], data [ bd_reason ]); RemoveBan ( array_pos , data [ bd_steamid ]); PLUGIN_HANDLED ; #endif console_print ( client , "[AdvancedBans] %L" , client , "AB_NOT_IN_BAN_LIST" , arg ); PLUGIN_HANDLED ; CmdBanList ( client , level , cid ) cmd_access ( client , level , cid , 1 ) ) return PLUGIN_HANDLED ; g_total_bans ) console_print ( client , "[AdvancedBans] %L" , client , "AB_NO_BANS" ); PLUGIN_HANDLED ; start ; read_argc () > 1 ) arg [ 5 ]; read_argv ( 1 , arg , sizeof ( arg ) - 1 ); start = min ( str_to_num ( arg ), g_total_bans ) - 1 ; start = 0 ; last = min ( start + 10 , g_total_bans ); client == 0 ) server_cmd ( "echo ^" % L ^ "" , client , "AB_BAN_LIST_NUM" , start + 1 , last ); client_cmd ( client , "echo ^" % L ^ "" , client , "AB_BAN_LIST_NUM" , start + 1 , last ); 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 , false ); #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 } last < g_total_bans ) client == 0 ) server_cmd ( "echo ^" % L ^ "" , client , "AB_BAN_LIST_NEXT" , last ); client_cmd ( client , "echo ^" % L ^ "" , client , "AB_BAN_LIST_NEXT" , last ); PLUGIN_HANDLED ; CmdAddBanLimit () read_argc () != 3 ) log_amx ( "amx_addbanlimit was used with incorrect parameters!" ); log_amx ( "Usage: amx_addbanlimit <flags> <time in minutes>" ); PLUGIN_HANDLED ; arg [ 16 ]; read_argv ( 1 , arg , sizeof ( arg ) - 1 ); flags = read_flags ( arg ); read_argv ( 2 , arg , sizeof ( arg ) - 1 ); 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 ) notified ; notified ) log_amx ( "The amx_addbanlimit has reached its maximum!" ); notified = 1 ; PLUGIN_HANDLED ; g_maxban_flags [ g_total_maxban_times ] = flags ; g_maxban_times [ g_total_maxban_times ] = minutes ; #endif g_total_maxban_times ++; PLUGIN_HANDLED ; FwdThink ( entity ) entity != g_unban_entity ) return; #if defined USING_SQL if( g_total_bans > 0 && ! g_loading_bans ) #else if( g_total_bans > 0 ) #endif { _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 new c_hours = str_to_num ( _hours ); c_minutes = str_to_num ( _minutes ); c_seconds = str_to_num ( _seconds ); c_month = str_to_num ( _month ); c_day = str_to_num ( _day ); c_year = str_to_num ( _year ); unban_time [ 32 ]; u_hours , u_minutes , u_seconds , u_month , u_day , u_year ; i = 0 ; i < g_total_bans ; i ++ ) #if MAX_BANS <= 0 static data [ BannedData ]; ArrayGetArray ( g_array , i , data ); data [ bd_banlength ] == 0 ) continue; #else if( g_banlengths [ i ] == 0 ) continue; #endif 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 ); 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 ]); "^x04[AdvancedBans]^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 ]); "^x04[AdvancedBans]^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 )); TaskDisconnectPlayer ( client ) server_cmd ( "kick #%i ^" Fuiste banneado del Servidor . Mira tu consola ^ "" , get_user_userid ( 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 ); #endif 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 ); 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 ); //SQL_ThreadQuery(g_sql_tuple, "QueryAddBan", query); mysql_query ( g_sql_tuple , "QueryAddBan" , query ); #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 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 public QueryAddBan ( failstate , error [], errnum , data [], size , Float : queuetime ) failstate == TQUERY_CONNECT_FAILED ) set_fail_state ( "Could not connect to database." ); failstate == TQUERY_QUERY_FAILED ) set_fail_state ( "Query failed." ); errnum ) log_amx ( "Error on query: %s" , error ); // Yay, ban was added! We can all rejoice! } //public QueryDeleteBan(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime) public QueryDeleteBan ( failstate , error [], errnum , data [], size , Float : queuetime ) failstate == TQUERY_CONNECT_FAILED ) set_fail_state ( "Could not connect to database." ); failstate == TQUERY_QUERY_FAILED ) set_fail_state ( "Query failed." ); errnum ) log_amx ( "Error on query: %s" , error ); // Yay, ban was deleted! We can all rejoice! } //public QueryLoadBans(failstate, Handle:query, error[], errcode, data[], datasize, Float:queuetime) public QueryLoadBans ( failstate , error [], errnum , data [], size , Float : queuetime ) failstate == TQUERY_CONNECT_FAILED ) set_fail_state ( "Could not connect to database." ); failstate == TQUERY_QUERY_FAILED ) set_fail_state ( "Query failed." ); errnum ) log_amx ( "Error on query: %s" , error ); //if( SQL_NumResults(query) ) if ( mysql_num_results ( ) ) #if MAX_BANS <= 0 static data [ BannedData ]; //while( SQL_MoreResults(query) ) while ( mysql_more_results ( ) ) #else while ( mysql_more_results ( ) && g_total_bans < MAX_BANS ); #endif { #if MAX_BANS <= 0 mysql_read_result ( 0 , data [ bd_name ], sizeof ( data [ bd_name ])- 1 ); mysql_read_result ( 1 , data [ bd_steamid ], sizeof ( data [ bd_steamid ])- 1 ); data [ bd_banlength ] = mysql_read_result ( 2 ); mysql_read_result ( 3 , data [ bd_unbantime ], sizeof ( data [ bd_unbantime ])- 1 ); mysql_read_result ( 4 , data [ bd_reason ], sizeof ( data [ bd_reason ])- 1 ); mysql_read_result ( 5 , data [ bd_admin_name ], sizeof ( data [ bd_admin_name ]) - 1 ); mysql_read_result ( 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 mysql_read_result ( 0 , g_names [ g_total_bans ], charsmax ( g_names [ ] ) ); mysql_read_result ( 1 , g_steamids [ g_total_bans ], charsmax ( g_steamids [ ] ) ); g_banlengths [ g_total_bans ] = mysql_read_result ( 2 ); mysql_read_result ( 3 , g_unbantimes [ g_total_bans ], charsmax ( g_unbantimes [ ] ) ); mysql_read_result ( 4 , g_reasons [ g_total_bans ], charsmax ( g_reasons [ ] ) ); mysql_read_result ( 5 , g_admin_names [ g_total_bans ], charsmax ( g_admin_names [ ] ) ); mysql_read_result ( 6 , g_admin_steamids [ g_total_bans ], charsmax ( g_admin_steamids [ ] ) ); #endif g_total_bans ++; mysql_next_row ( ); /* } set_task ( RELOAD_BANS_INTERVAL , "LoadBans" ); g_loading_bans = false ; #endif 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 ] mysql_query ( g_sql_tuple , "QueryDeleteBan" , query ); //SQL_ThreadQuery(g_sql_tuple, "QueryDeleteBan", query); for( new i = remove ; i < g_total_bans ; i ++ ) 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 , "" ); 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" ); name [ 32 ], steamid [ 35 ], banlength , unbantime [ 32 ], reason [ 128 ], admin_name [ 32 ], admin_steamid [ 35 ]; 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 ); //SQL_ThreadQuery(g_sql_tuple, "QueryDeleteBan", query); mysql_query ( g_sql_tuple , "QueryDeleteBan" , query ); data [ BannedData ]; 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" ); data [ BannedData ]; 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 LoadOldBans ( filename []) file_exists ( filename ) ) f = fopen ( filename , "rt" ); data [ 96 ]; command [ 10 ], minutes [ 10 ], steamid [ 35 ], length , unban_time [ 32 ]; feof ( f ) ) fgets ( f , data , sizeof ( data ) - 1 ); data [ 0 ] ) continue; parse ( data , command , sizeof ( command ) - 1 , minutes , sizeof ( minutes ) - 1 , steamid , sizeof ( steamid ) - 1 ); 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 ); filename2 [ 32 ]; // copy current copy ( filename2 , sizeof ( filename2 ) - 1 , filename ); // cut off at the "." filename2 [ containi ( filename2 , "." )] = 0 ; // add 2.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 () 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 ); //SQL_ThreadQuery(g_sql_tuple, "QueryLoadBans", query); mysql_query ( g_sql_tuple , "QueryLoadBans" , query ); g_loading_bans = true ; #else if( file_exists ( g_ban_file ) ) f = fopen ( g_ban_file , "rt" ); filedata [ 512 ], length [ 10 ]; #if MAX_BANS <= 0 static data [ BannedData ]; feof ( f ) ) #else while( ! feof ( f ) && g_total_bans < MAX_BANS ) #endif { fgets ( f , filedata , sizeof ( filedata ) - 1 ); 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 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 , "^"", " * "); ` ", "*"); $name ", "ADMIN"); $name ", admin_name);
PHP: (Créditos Lemon)
Código PHP:
< style > sxeUl { style - type : none ; margin : 0 ; padding : 0 ; overflow : hidden ; background - color : #333333; } sxeButton { font - weight : 500 ; font - family : 'Montserrat' ; text - transform : uppercase ; text - align : center ; text - decoration : none ; text - shadow : none ; white - space : nowrap ; vertical - align : middle ; border - radius : 3px ; border : 1px solid rgba ( 0 , 0 , 0 , 0.1 ); transition : 0.1s all linear ; user - select : none ; sxeButton_medium { font - size : 13px ; line - height : 38px ; padding : 0 20px ; sxeButton_important { color : #ffffff; } tdclass { background - color : #013ADF; } sxeLi { float : left ; sxeLi a { display : block ; color : white ; text - align : center ; padding : 16px ; text - decoration : none ; sxeLi a : hover { background - color : #111111; } style > script src = "https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js" ></ script > br >< br > div > $Group = \ IPS \ Member :: loggedIn ()-> groups ; $host_db = "localhost" ; $usuario_db = "" ; $clave_db = "" ; $admin_db = "" ; $conex = mysqli_connect ( $host_db , $usuario_db , $clave_db , $admin_db ); $Group [ 0 ] == 9 || $Group [ 0 ] == 4 ){ $STEAMID = $_GET [ 'steamid' ]; strlen ( $STEAMID )){ $STEAMID = mysqli_real_escape_string ( $conex , $STEAMID ); $consulta = sprintf ( "DELETE FROM advanced_bans WHERE steamid=\"%s\"" , $STEAMID ); $query = mysqli_query ( $conex , $consulta ); mysqli_free_result ( $query ); "" ); $query = mysqli_query ( $conex , "SELECT COUNT(*) AS total FROM advanced_bans" ); $row = mysqli_fetch_assoc ( $query ); $total = $row [ 'total' ]; mysqli_free_result ( $query ); $limit = 13 ; $pages = ceil ( $total / $limit ); $page = min ( $pages , filter_input ( INPUT_GET , 'page' , FILTER_VALIDATE_INT , array( 'options' => array( 'default' => 1 , 'min_range' => 1 , $offset = ( $page - 1 ) * $limit ; $start = $offset + 1 ; $end = min (( $offset + $limit ), $total ); '<ul class="sxeUl">' ; $pagemin = 1 ; '<li class="sxeLi"><a href="?ban=normal&page=' . $pagemin . '"><i class="fa fa-angle-double-left" style="font-size:18px"></i></a></li>' ; '<li class="sxeLi"><a href="?ban=normal&page=' . $pagemin . '"><strong>Anterior</strong></a></li>' ; $i = $pagemin - 2 ; $i < $page ; $i ++){ $i < 1 ) '<li class="sxeLi"><a href="??ban=normal&page=' . $i . '">' . $i . '</a></li>' ; '<li class="sxeLi"><a class="sxeButton sxeButton_important" style="background-color:#f9a519" href="??ban=normal&page=' . $page . '">' . $page . '</a></li>' ; //rgb(66,186,255) if( $page < $pages ){ $pagemax = $page + 1 ; $i = $pagemax ; $i <= $pages && $i < $pagemax + 3 ; $i ++){ '<li class="sxeLi"><a href="?ban=normal&page=' . $i . '">' . $i . '</a></li>' ; '<li class="sxeLi"><a href="?ban=normal&page=' . $pagemax . '"><strong>Siguiente</strong></a></li>' ; '<li class="sxeLi"><a href="?ban=normal&page=' . $pages . '"><i class="fa fa-angle-double-right" style="font-size:18px"></i></a></li>' ; ?> </ul><?php = sprintf ( " , $limit , $offset ); ?> <?php = mysqli_query ( $conex , $consulta ); $row = mysqli_fetch_assoc ( $query )){ $STEAMID = $row [ "steamid" ]; ?> <li class='cForumRow ipsDataItem ipsDataItem_responsivePhoto ipsClearfix' id='<? echo 'li' . $STEAMID ; ?> '><? echo $row [ "name" ]; ?> </dd></dd></dl></div><? echo $row [ "reason" ]; ?> </dd></dd></dl></div><? echo $row [ "banlength" ]; ?> </dd></dl></div><? echo $row [ "steamid" ]; ?> </dd></dl></div><? echo $row [ "admin_name" ]; ?> </dd></dl></div><? echo $page ; ?> &steamid=<? echo $STEAMID ; ?> " style="width:100%">Remover Ban</a></dd></dl></div></li><? } mysqli_free_result ( $query ); ?> </ol><? echo '</tr></table><br><br>' ; '<ul class="sxeUl">' ; '<li class="sxeLi"><a href="?ban=normal&bans=normal&page=' . $pagemin . '"><i class="fa fa-angle-double-left" style="font-size:18px"></i></a></li>' ; '<li class="sxeLi"><a href="?ban=normal&page=' . $pagemin . '"><strong>Anterior</strong></a></li>' ; $i = $pagemin - 2 ; $i < $page ; $i ++){ $i < 1 ) '<li class="sxeLi"><a href="?ban=normal&page=' . $i . '">' . $i . '</a></li>' ; '<li class="sxeLi"><a class="sxeButton sxeButton_important" style="background-color:rgb(66,186,255)" href="?ban=normal&page=' . $page . '">' . $page . '</a></li>' ; $page < $pages ){ $i = $pagemax ; $i <= $pages && $i < $pagemax + 3 ; $i ++){ '<li class="sxeLi"><a href="?ban=normal&page=' . $i . '">' . $i . '</a></li>' ; '<li class="sxeLi"><a href="?ban=normal&page=' . $pagemax . '"><strong>Siguiente</strong></a></li>' ; '<li class="sxeLi"><a href="?ban=normal&page=' . $pages . '"><i class="fa fa-angle-double-right" style="font-size:18px"></i></a></li>' ; mysqli_close ( $conex ); ?>
Mensajes: 4,637
Temas: 73
Registro en: Oct 2013
Reputación:
44
(26/10/2018, 12:48 PM) Cristian escribió: MySQL SQLite3 Ahí miré el código. Si usa SQLite, el código PHP que está escrito no tiene soporte para eso, perdiendo el sentido del plguin ya que se podría usar el advanced bans que está recontra probado.
Mensajes: 375
Temas: 55
Registro en: Jan 2016
Reputación:
9
(26/10/2018, 04:41 PM) Neeeeeeeeeel.- escribió: (26/10/2018, 12:48 PM) Cristian escribió: MySQL SQLite3
El sentido del plugin es excluir al usuario. Justamente el motd en PHP es para la versión MySQL para ponerlo en algún foro o algo por el sentido. La versión SQLite obviamente no soporta PHP.
Mensajes: 2,094
Temas: 59
Registro en: Feb 2015
Reputación:
15
26/10/2018, 06:11 PM
(Última modificación: 26/10/2018, 06:17 PM por OsweRRR .)
si se necesita de la flag ADMIN_RCON para banear porque en el main messagemode solo chequeas si es admin o no igual que en los menus, allí podría haber un bug
edit: no es necesario pero puede ser opcional de ponerle un filtro de comandos especiales delete, insert, etc aunque es al p2
(18/11/2014, 05:47 PM) Neeeeeeeeeel.- escribió: (16/05/2016, 11:08 PM) kikizon2 escribió:
Mensajes: 642
Temas: 25
Registro en: Feb 2014
Reputación:
17
Horrible la forma de como chequeas si sigue o no baneado y la forma de desbanear(que feo es el spanglish). Y en vez de hacer tan repetitivo todo, podrías hacer una consulta que seleccione y guarde en un Trie, los usuarios cuyo (ban_time < tiempo_del_mapa*2) y ahí manjearlo sin consultas, solo check; así no chequeas todos, aunque generalmente son pocos los usuarios baneados. Pero podrías evitar todo este dolor de cabeza con funciones propias de mysql, con sqlite tenes que hacerlo de la forma que actualmente usas.
(19/06/2014, 11:08 PM) 01011001 escribió: No tiene niveles infinitos, llega hasta 2147483648 (Y despues hace un integer overflow) (19/06/2014, 11:08 PM) [R]ak escribió: 500%
Mensajes: 375
Temas: 55
Registro en: Jan 2016
Reputación:
9
(26/10/2018, 06:26 PM) Kane escribió:
Gracias por comentar y por tus críticas constructivas.
1) ¿Cómo verificarías vos si el usuario está baneado o no?. Lo hice de esa forma por que hay como 4 tablas para cada almacenamiento, cabe destacar que hay varias formas que están muy mal echas, quizás por el hecho que no tengo tanto conocimiento en estos temas. Pero de seguro hay formas mejores y mucho más por aprender.
2) Lo de los
Tries no lo había pensado, es una buena opción.
Mensajes: 4,637
Temas: 73
Registro en: Oct 2013
Reputación:
44
Qué ventajas tiene sobre el Advanced Bans?
Mensajes: 375
Temas: 55
Registro en: Jan 2016
Reputación:
9
(14/11/2018, 04:58 PM) Neeeeeeeeeel.- escribió:
Por ahora ninguna, lo único y quizás es que tiene más control a la hora de manejar el sistema de ban, es decir, introducir minutos, razón, una mayor facilidad y acceso a la hora de restringir a un usuario, ya que prácticamente se puede banear a través de menú y consola, igual hay bastantes cosas que mejorar en el código y en las consultas.
Mensajes: 791
Temas: 84
Registro en: Sep 2016
Reputación:
6
(14/11/2018, 09:16 PM) Cristian escribió: (14/11/2018, 04:58 PM) Neeeeeeeeeel.- escribió:
El soporte de Mysql y Sqlite es una ventaja, el advanced bans no lo tiene, También podés banear por HWID otra cosa que el Advanced Bans no tiene y lo de los calculos también, diría yo, no sé.
Mensajes: 1
Temas: 0
Registro en: Nov 2018
Reputación:
0
26/11/2018, 08:21 PM
(Última modificación: 26/11/2018, 09:26 PM por ptaha525 . Edited 1 time in total.)
L 11/27/2018 - 02:22:56: String formatted incorrectly - parameter 3 (total 2)
Mensajes: 375
Temas: 55
Registro en: Jan 2016
Reputación:
9
(26/11/2018, 08:21 PM) ptaha525 escribió:
Perdón, no pude darle soporte al proyecto debido a una mudanza, no tengo ni luz en casa, y estoy del teléfono. Ese error se debe a que hay un %s en la parte en donde se detiene la función cuyas funciones son
concmd_ban_add_ip, concmd_ban_add_steamid, concmd_ban_add_hid . Por otro lado, ya pude fixear gran parte del código y las tablas reduciéndolas a 1 sola. Cuando vuelva todo a la normalidad lo publico.
Mensajes: 375
Temas: 55
Registro en: Jan 2016
Reputación:
9
Mensajes: 9
Temas: 3
Registro en: Jun 2020
Reputación:
0
07/06/2020, 06:44 AM
(Última modificación: 07/06/2020, 06:51 AM por Infamous2020 . Edited 1 time in total.)
( 14) Error: Access denied for user 'surfmod'@'%' to database 'sql_ban_database'
Mensajes: 6,664
Temas: 81
Registro en: Jan 2014
Reputación:
68
(07/06/2020, 06:44 AM) Infamous2020 escribió:
SQLite != SQL...
This forum is for spanish users only
► NO DOY AYUDA VIA MENSAJE PRIVADO ◄
* Si requieres algún servicio de pago puedes contactarme vía MP facebook
Mensajes: 19
Temas: 0
Registro en: Aug 2019
Reputación:
0
no me compila, es como que queda cargando y nunca avanza ni da errores, primera vez que me pasa con un plugin
Mensajes: 7,178
Temas: 93
Registro en: Aug 2014
Reputación:
63
capas tenes una línea muy grande y aun usas el amx studio xd
puedes revisar eso
Aunque existe el amxbans también
Mensajes: 21
Temas: 8
Registro en: Jul 2021
Reputación:
0
A mi me compilo sin ningún problema con la versión 1.8.3
![[Imagen: l933TMx.png]](https://i.imgur.com/l933TMx.png)
![[Imagen: 0aGhuSU.png]](https://i.imgur.com/0aGhuSU.png)
![[Imagen: CwdOnrm.png]](https://i.imgur.com/CwdOnrm.png)
![[Imagen: jVbi4S3.png]](https://i.imgur.com/jVbi4S3.png)
![[Imagen: NpBlLm0.png]](https://i.imgur.com/NpBlLm0.png)
![[Imagen: d0tsxOL.png]](https://i.imgur.com/d0tsxOL.png)
![[Imagen: CVM5E6z.png]](https://i.imgur.com/CVM5E6z.png)
![[Imagen: T9dPnqH.png]](https://i.imgur.com/T9dPnqH.png)
![[Imagen: NwBjwVq.png]](https://i.imgur.com/NwBjwVq.png)
![[Imagen: HD8KajN.png]](https://i.imgur.com/HD8KajN.png)
![[Imagen: cjyiC5b.png]](https://i.imgur.com/cjyiC5b.png)
![[Imagen: paypalqr.png]](https://amxmodx-es.com/images/paypalqr.png)
![[Imagen: zcsztw-4.png]](https://valid.x86.fr/cache/banner/zcsztw-4.png)
![[Imagen: 6u5fj2-4.png]](https://valid.x86.fr/cache/banner/6u5fj2-4.png)
![[Imagen: linkedin_thumb_image.png]](https://images.credly.com/images/00634f82-b07f-4bbd-a6bb-53de397fc3a6/linkedin_thumb_image.png)
![[Imagen: 76561198283253977.png]](https://www.steamidfinder.com/signature/76561198283253977.png)
![[Imagen: linkedin_thumb_image.png]](https://images.credly.com/images/b9feab85-1a43-4f6c-99a5-631b88d5461b/linkedin_thumb_image.png)
![[Imagen: b_350_20_323957_202743_f19a15_111111.png]](http://cache.gametracker.com/server_info/45.32.174.155:27015/b_350_20_323957_202743_f19a15_111111.png)
![[Imagen: bvpq9q-6.png]](https://valid.x86.fr/cache/banner/bvpq9q-6.png)
