[sami_spt]

you need to create your own php script.

[quark]

Hey guys, my admin_sql.amxx is working and sql.cfg information is correct, but this plugin just wont work.

[pepe_thugs]

My admin_sql is working to me and i give the ban in the server with this plugin the plugin save it by sql but i restart the server and he dont kicks me when i try to connect.
Someone can help please ?


EDIT: Someone can edit this plugin and add cvars to connect database and change the function client_authorized (client) to verify only in column "steamid" if exists the authid who are connects ?
Please

[sami_spt]

maybe he got unbanned?

anything in the log folder?

[pepe_thugs]

Originally Posted by sami_spt maybe he got unbanned? anything in the log folder?

I tested with my ID steam and i dont unbanned and try to connect to the server and the dont kick.
Nothing in logs.

[deadflush]

Originally Posted by pepe_thugs I tested with my ID steam and i dont unbanned and try to connect to the server and the dont kick. Nothing in logs.

Ban yourself again and post a screenshot of your console here so I can see.

[pepe_thugs]

Originally Posted by deadflush Ban yourself again and post a screenshot of your console here so I can see.

It banned and in my console show all information the Ban. But when i change the map i connected with the server without problem and the ban continue in DB.
My sql.cfg so that :


amx_sql_host "IP"
amx_sql_user "User"
amx_sql_pass "Pw"
amx_sql_db "Db"
amx_sql_table "table"
amx_sql_type "mysql"


If cvar amx_sql_table is "advanced_bans" the plugin run normally but admin_sql dont works but if i have amx_sql_table "admins" the plugin advanced_bans works in same and admin_sql work too. That will the problem ?

[sami_spt]

oohh god.

why did you post your sql info..


IF you are having issues with this, someone might help you because the author is offline from 2012.
You can use AMXBans system, which is the same as advanced bans, but the bans saves in a website

[GordonFreeman (RU)]

Why u reloads all bans from SQL? What happens if ban table contains 100500 entires and table update sets to 10 secs? Its generate so huge traffic between server and mysql.

Im think the better way is just get only expired bans from database. Like:

formatex(query,255,"SELECT `%s`,`%s`,`%s` FROM `%s` WHERE `%s` <= DATE_FORMAT(NOW(),'%%H:%%i:%%s %%m/%%d/%%Y')",
                KEY_STEAMID,KEY_NICK,KEY_REASON,TABLE_NAME,KEY_UNBANTIME)

[WaSaAa1]

It does not work any SQL version with the latest version (6027), any solution please.