[Balage74]

Error: amx_unban not working


bug in row between 1210-1216. search:

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]
        );

replace:

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]
        );

('%s' ------ `%s` in mysql row)


suggestion:
- add contactinfo
when ban the player in console print reason, and I'd like add the contact info (website or email) from cvar

[RazeRole]

pls exolent help me...when im banning a steam player he can come again in my server!!what i must to do for that??

[bloodrage_16]

pls.. help.. i got this error

advanced_bans.sql.amxx setting its self as failed.

query failed...

pls help.. i have enabled sqlite and disabled mysql in modules.ini, and i hve also setup my sql type to sqlite in sql.cfg

[bloodrage_16]

HELP!!!! i got this fucking error..


L 10/02/2012 - 06:16:47: [AMXX] Plugin ("advanced_bans_sql.amxx") is setting itself as failed.
L 10/02/2012 - 06:16:47: [AMXX] Plugin says: Query failed.
L 10/02/2012 - 06:16:47: [AMXX] Run time error 1 (plugin "advanced_bans_sql.amxx") - forced exit
Executing AMX Mod X Configuration File
[AMX Super] AMX_Super.cfg has been executed
*********************************


here's my plugins.ini

; AMX Mod X plugins

; Admin Base - Always one has to be activated
admin.amxx ; admin base (required for any admin-related)
;admin_sql.amxx ; admin base - SQL version (comment admin.amxx)

; Basic
admincmd.amxx ; basic admin console commands
adminhelp.amxx ; help command for admin console commands
adminslots.amxx ; slot reservation
multilingual.amxx ; Multi-Lingual management

; Menus
menufront.amxx ; front-end for admin menus
cmdmenu.amxx ; command menu (speech, settings)
plmenu.amxx ; players menu (kick, ban, client cmds.)
;telemenu.amxx ; teleport menu (Fun Module required!)
mapsmenu.amxx ; maps menu (vote, changelevel)
pluginmenu.amxx ; Menus for commands/cvars organized by plugin

; Chat / Messages
adminchat.amxx ; console chat commands
antiflood.amxx ; prevent clients from chat-flooding the server
scrollmsg.amxx ; displays a scrolling message
imessage.amxx ; displays information messages
adminvote.amxx ; vote commands

; Map related
nextmap.amxx ; displays next map in mapcycle
mapchooser.amxx ; allows to vote for next map
timeleft.amxx ; displays time left on map

; Configuration
pausecfg.amxx ; allows to pause and unpause some plugins
statscfg.amxx ; allows to manage stats plugins via menu and commands

; Counter-Strike
restmenu.amxx ; restrict weapons menu
statsx.amxx ; stats on death or round end (CSX Module required!)
miscstats.amxx ; bunch of events announcement for Counter-Strike
;stats_logging.amxx ; weapons stats logging (CSX Module required!)

; Enable to use AMX Mod plugins
;amxmod_compat.amxx ; AMX Mod backwards compatibility layer

; Custom - Add 3rd party plugins here

advanced_bans_sql.amxx



here's my sql.cfg
// SQL configuration file
// File location: $moddir/addons/amxmodx/configs/sql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1"
// We recommend using your server IP address instead of its name

// *NOTE* amx_sql_type specifies the DEFAULT database type which admin.sma will use.

amx_sql_host "127.0.0.1"
amx_sql_user "root"
amx_sql_pass ""
amx_sql_db "amx"
amx_sql_table "admins"
amx_sql_type "sqlite"

here's my modules.ini

;;;
; To enable a module, remove the semi-colon (;) in front of its name.
; If it's not here, simply add it its name, one per line.
; You don't need to write the _amxx part or the file extension.
;;;

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;
;; SQL Modules usually need to be enabled manually ;;
;; You can have any number on at a time. Use ;;
;; amx_sql_type in sql.cfg to specify the default ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;

;mysql
sqlite

;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;
;; Put third party modules below here. ;;
;; You can just list their names, without the _amxx ;;
;; or file extension. ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;



;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;
;; These modules will be auto-detected and loaded ;;
;; as needed. You do not need to enable them here ;;
;; unless you have problems. ;;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;;

fun
engine
fakemeta
geoip
sockets
regex
;nvault
cstrike
csx
hamsandwich


PLS HELP!!! I REALLY WANT THIS PLUGIN , i really dont know how fix dis....

[brlight]

Like you I´ve tried this plugin but as soon as I needed some help/support I didn´t get none.My recomendation is:try amxbans, better support, better menu with more options and works very good, my opinion of course.

[deadman909]

Originally Posted by bloodrage_16 HELP!!!! i got this fucking error.. L 10/02/2012 - 06:16:47: [AMXX] Plugin ("advanced_bans_sql.amxx") is setting itself as failed. L 10/02/2012 - 06:16:47: [AMXX] Plugin says: Query failed. L 10/02/2012 - 06:16:47: [AMXX] Run time error 1 (plugin "advanced_bans_sql.amxx") - forced exit Executing AMX Mod X Configuration File [AMX Super] AMX_Super.cfg has been executed ********************************* here's my plugins.ini ; AMX Mod X plugins ; Admin Base - Always one has to be activated admin.amxx ; admin base (required for any admin-related) ;admin_sql.amxx ; admin base - SQL version (comment admin.amxx) ; Basic admincmd.amxx ; basic admin console commands adminhelp.amxx ; help command for admin console commands adminslots.amxx ; slot reservation multilingual.amxx ; Multi-Lingual management ; Menus menufront.amxx ; front-end for admin menus cmdmenu.amxx ; command menu (speech, settings) plmenu.amxx ; players menu (kick, ban, client cmds.) ;telemenu.amxx ; teleport menu (Fun Module required!) mapsmenu.amxx ; maps menu (vote, changelevel) pluginmenu.amxx ; Menus for commands/cvars organized by plugin ; Chat / Messages adminchat.amxx ; console chat commands antiflood.amxx ; prevent clients from chat-flooding the server scrollmsg.amxx ; displays a scrolling message imessage.amxx ; displays information messages adminvote.amxx ; vote commands ; Map related nextmap.amxx ; displays next map in mapcycle mapchooser.amxx ; allows to vote for next map timeleft.amxx ; displays time left on map ; Configuration pausecfg.amxx ; allows to pause and unpause some plugins statscfg.amxx ; allows to manage stats plugins via menu and commands ; Counter-Strike restmenu.amxx ; restrict weapons menu statsx.amxx ; stats on death or round end (CSX Module required!) miscstats.amxx ; bunch of events announcement for Counter-Strike ;stats_logging.amxx ; weapons stats logging (CSX Module required!) ; Enable to use AMX Mod plugins ;amxmod_compat.amxx ; AMX Mod backwards compatibility layer ; Custom - Add 3rd party plugins here advanced_bans_sql.amxx here's my sql.cfg // SQL configuration file // File location: $moddir/addons/amxmodx/configs/sql.cfg // *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1" // We recommend using your server IP address instead of its name // *NOTE* amx_sql_type specifies the DEFAULT database type which admin.sma will use. amx_sql_host "127.0.0.1" amx_sql_user "root" amx_sql_pass "" amx_sql_db "amx" amx_sql_table "admins" amx_sql_type "sqlite" here's my modules.ini ;;; ; To enable a module, remove the semi-colon (;) in front of its name. ; If it's not here, simply add it its name, one per line. ; You don't need to write the _amxx part or the file extension. ;;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;; ;; SQL Modules usually need to be enabled manually ;; ;; You can have any number on at a time. Use ;; ;; amx_sql_type in sql.cfg to specify the default ;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;; ;mysql sqlite ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;; ;; Put third party modules below here. ;; ;; You can just list their names, without the _amxx ;; ;; or file extension. ;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;; ;; These modules will be auto-detected and loaded ;; ;; as needed. You do not need to enable them here ;; ;; unless you have problems. ;; ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;;;;;;;;; fun engine fakemeta geoip sockets regex ;nvault cstrike csx hamsandwich PLS HELP!!! I REALLY WANT THIS PLUGIN , i really dont know how fix dis....

Move advanced_bans_sql.amxx
to the very top of your plugins.

You have it at the bottom so the Advance Bans its not overwriting the default ban plugin.

Also make sure to - Overwrite your old plmenu.amxx and adminvote.amxx files.

[johnally]

Mauritian Creole

[mu] AB_BAN_INFORMATION = Informasion Ban AB_NAME = Nom AB_IP = IP AB_STEAMID = SteamID AB_REASON = Raison AB_BAN_LENGTH = Longuer Ban AB_UNBAN_TIME = Temps Unban AB_ADMIN_NAME = Nom Admin AB_ADMIN_STEAMID = SteamID Admin AB_WEBSITE = Si zot penC zot ine gagne ban dan fosse, raport sa informasion la lor site: AB_NOT_AUTHORIZED = Target la pane authorize ar server! Pa kav ban! AB_ALREADY_BANNED_STEAMID = Sa zouere la so SteamID deza ban! AB_ALREADY_BANNED_IP = Sa zouere la so IP deza ban! AB_PERMANENT_BAN = Ban Permanent AB_INVALID_STEAMID = Fosse SteamID! AB_VALID_STEAMID_FORMAT = Format Korek: STEAM_0:X:XXXXXXX AB_INVALID_IP = Fosse IP! AB_NOT_IN_BAN_LIST = Pane kav truve %s dan la liste ban! AB_NO_BANS = Pena personne ine ban a ce moment! AB_BAN_LIST_NUM = P Lister bane zouere kine ban %i - %i. AB_BAN_LIST_NEXT = Servi amx_banlist %i pu prochain zouere dan la liste. AB_MAX_BAN_TIME = Maximum temps ban c %i.

[fysiks]

"Permanent," "ban" and "admin" are the same in English and Mauritian Creole?

[johnally]

indeed..
Mauritian Creole = mixture of french and english with some slight change ;)

and also because us MU players we refer (even while speaking) to keywords in cs in English more than creole.
e.g
Round (should be 'parti')
Restart (should be 'recoumancer')
Auto-team (should be 'balance lekip')
Server (should be 'serveur')
Join (should be 'rentrer')
Leave (should be 'aler')
etc etc ;)

[Artizy]

Hi,

I want to delete admin_name and admin_steamid , it's good plugin but is not useful. Steamid admin should remain private.