[Exolent[jNr]]

Originally Posted by alexinno This time it's working just one thing , if you created allready the table in mysql with the old one chage #define KEY_NAME "victim_name" #define KEY_STEAMID "victim_steamid" with #define KEY_NAME "name" #define KEY_STEAMID "steamid"

You can't do that because "name" is a reserved SQL term.
Also, with my previous versions, the table couldn't have been created because the syntax was wrong or the database couldn't be connected.

[alexinno]

Originally Posted by alexinno yes, it's working now just a little anoying error , i don't know why it shows this because the table is there , i think it's trying to create it one more time or something like that L 05/29/2009 - 21:26:48: [advanced_bans_sql.amxx] Failed to create table for ban s: You have an error in your SQL syntax; check the manual that corresponds to yo ur MySQL server version for the right syntax to us

i don't know then how the table was created but it was there!



I attached a little php script for advanced bans , it is very simple so don't expect much.
If anybody wants to update it or add any new functions feel free to do so.

Install is very simple

Unzip the archive , change the settings in config.php then upload the files to your webserver and you're done

Screen:
http://img194.**************/my.php?image=banlist.png

07.08.2011
- Did some cleanup on the web interface requested by modernatur
02.10.2012
- Added missing error function reported by guipatinador
27.12.2012
- More cleanup: removed inline styling
- Fixed sql injection vulnerability.
[IMG]http://img194.**************/my.php?image=banlist.png[/IMG]

[Exolent[jNr]]

Try this version.
It uses threaded queries which will be executed with the server, instead of at the exact time they were executed.

[alexinno]

Originally Posted by Exolent[jNr] Try this version. It uses threaded queries which will be executed with the server, instead of at the exact time they were executed.

works

[Exolent[jNr]]

Originally Posted by alexinno works

Thanks for being my tester
You'd receive lots of +karma if it still existed

[alexinno]

you're wellcome & thx for taking the time to do this sql thing it's really hepful for those who run more then just one server (and not just them)

[Kukulis :*]

Lithuanian translation

[lt]
AB_BAN_INFORMATION = Bano Informacija
AB_NAME = Vardas
AB_IP = IP
AB_STEAMID = SteamoID
AB_REASON = Pirezastis
AB_BAN_LENGTH = Bano Ilgis
AB_UNBAN_TIME = Atbaninimo Laikas
AB_ADMIN_NAME = Admino Vardas
AB_ADMIN_STEAMID = Admino SteamoID
AB_WEBSITE = Jei jus manote, kad jus buvote uzbanintas neteisingai, praneskite visa tai musu svetainei:
AB_NOT_AUTHORIZED = Tikslas neigaliojo su serveriu! Negalima uzbaninti!
AB_ALREADY_BANNED_STEAMID = Sio zaidejo SteamoID jau yra uzbanintas!
AB_ALREADY_BANNED_IP = Sio zaidejo IP jau yra uzbanintas!
AB_PERMANENT_BAN = Nuolatinis Banas
AB_INVALID_STEAMID = Blogas SteamoID!
AB_VALID_STEAMID_FORMAT = Teisingas formatas: STEAM_0:X:XXXXXXX
AB_INVALID_IP = Blogas IP!
AB_NOT_IN_BAN_LIST = Negalejo surasti %s terpt banu saraso!
AB_NO_BANS = Nera nieko uzbaninto siuo metu.
AB_BAN_LIST_NUM = Uzbanintu zaideju sarasas %i - %i.
AB_BAN_LIST_NEXT = Naudok amx_banlist %i pamatyti kitiems zmonems sarase.
AB_MAX_BAN_TIME = Maksimalus leidziamas bano laikas yra %i.

[Thrill]

I'm requesting this for amx_voteban command: amx_voteban "id/name" "minutes", hope you will consider it! When i voteban ppl i dont want to permanently ban them each time.

[Meathead~MBG~]

Running this plugin in dod, amx_unban not working for me.

[alexinno]

Originally Posted by Meathead~MBG~ Running this plugin in dod, amx_unban not working for me.

if remember correctly it doesn't print anything in console when you use the unban command , did you checked the banlist to see if the banned steamid wasn't removed ?