MySQL Banning - Single DB - Cover Multiple Servers V3.0 [10 Jun 08] - Page 23

naris

Quote:

Originally Posted by YoMan

Can you please do not only ban IP or ID but some komand mysql_banname to ban name

Banning by name is a pointless exercise. It only takes someone 2 seconds to change their name and rejoin the server...

cezars · *Last edited by cezars; 11-14-2010 at 11:37.*

Quote:

Originally Posted by cezars

The Counter-Strike 1.6 and if it`s posible only owner can have acces to ban/unban people on db i dont want the admin to have acces to this plugin only owner so both plugin will work this one and normal ban plugin or advanced_ban or wathever plugin is on server

can you make it for cstrike ?

i know im on sm thx

naris · *Last edited by naris; 11-14-2010 at 09:42.*

Quote:

Originally Posted by cezars

can you make it for cstrike ?

No. It is not an option for the old HL1 based CS 1.6 since SourceMod is only for the source Engine. You would need an AMX Mod X plugin for "1.6"

You are in the wrong forums, you need to look in the AMX Mod X forums for cstrike 1.6 plugins.

YoMan

I have cheaters with dynamic IP
And they are to stupid to change nick...

naris

Quote:

Originally Posted by YoMan

I have cheaters with dynamic IP
And they are to stupid to change nick...

Then ban them by SteamID, which is a MUCH better way to identify them anyways.

Jumpman · *Last edited by Jumpman; 01-14-2011 at 18:44.*

Forgot to download socket.exe :-(

kwski43

I wonder why the issue when admin name contain " ' " string isn't fixed?

Code:

L 06/05/2011 - 00:53:56: [mysql_bans.smx] Unable to REPLACE ban into DB,You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fail', 'STEAM_1:1:xxxxxxxxx', 'asd', 30240, CURRENT_' at line 1, query=REPLACE INTO mysql_bans (steam_id, banned_by, banned_by_id, ban_reason, ban_length, timestamp) VALUES ('STEAM_1:1:xxxxxxxxx', 'I'fail', 'STEAM_1:1:xxxxxxxxx', 'asd', 30240, CURRENT_TIMESTAMP)

Jumpman

Quote:

Originally Posted by kwski43

I wonder why the issue when admin name contain " ' " string isn't fixed?

Code:

L 06/05/2011 - 00:53:56: [mysql_bans.smx] Unable to REPLACE ban into DB,You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'fail', 'STEAM_1:1:xxxxxxxxx', 'asd', 30240, CURRENT_' at line 1, query=REPLACE INTO mysql_bans (steam_id, banned_by, banned_by_id, ban_reason, ban_length, timestamp) VALUES ('STEAM_1:1:xxxxxxxxx', 'I'fail', 'STEAM_1:1:xxxxxxxxx', 'asd', 30240, CURRENT_TIMESTAMP)

Yes that would be great but to that happens you can use this code save it as es_autokick.txt and move it to addons/eventscripts/autokick folder then open your autoexec.cfg and add this line es_load autokick

es_autokick.txt

Code:

event player_connect
{
    if("'" in event_var(name)) then es kickid event_var(userid) Please take the apostrophe away from your name in order to play in this Server
}
event player_changename
{
    if("'" notin event_var(oldname)) do
    {
        es_cexec event_var(userid) name event_var(oldname)
    }
    else do
    {
        es kickid event_var(userid) Please take the apostrophe away from your name in order to play in this Server.
    }
}

gavintlgold

This isn't the Eventscripts forum so we can't assume everyone uses Eventscripts. In addition, it certainly is a problem in the bans plugin. Kicking people for having apostrophes in their names is an ugly hack around a security risk in this plugin. It should use the function documented here to escape strings: http://docs.sourcemod.net/api/index....d=show&id=838&

Jumpman

It would be nice if we could get this plugin updated then :-)