[Help] Chat spammer

08/24/2018 05:12 trysten#1
#Close
08/24/2018 08:04 dejillas234#2
The Only One solution of this problem is to ip ban that kind of players....
08/24/2018 14:08 dejillas234#3
And the other way of that. Is that you have to make your game for nice and good so that player will not break your server
08/24/2018 14:43 [DEV]Wan#4
ok then you need to make a delay in your chatlog's so

ue que servidor é esse
08/25/2018 14:27 hronolight#5
You can add checking to chatlog insert procedure, and kick the spammer by Sql PSM Manager
08/25/2018 15:56 trysten#6
Quote:
Originally Posted by hronolight View Post
You can add checking to chatlog insert procedure, and kick the spammer by Sql PSM Manager

could you help me do this, I do not have much notion of how to do such a thing.
08/26/2018 12:27 [DEV]Elessar#7
filter.txt change you can
08/28/2018 13:04 elitonfarol9#8
If it does the spam always with the same message, open the filter.txt and record the spam message, it is something simple, but it will soften...
08/29/2018 11:12 JujiPoli#9
Hello, sorry for taking time, did not saw this post
My skype is mikejack931 if you need help

I will try to help you with a little query to add in usp_Insert_Chat_Log_E

You will need this [Only registered and activated users can see links. Click Here To Register...] for kick the player in game.

If you want a better script, you will need a cheat engine that control the spam time between each chat.
08/29/2018 13:10 Eric-Dutra16#10
If you want to use [Only registered and activated users can see links. Click Here To Register...], you can edit the procedure (as JujiPoli and hronolight suggested), or create a simple Trigger in ChatLog, like this one. I have not tested it, but it should work.
08/29/2018 15:01 hronolight#11
Quote:
Originally Posted by JujiPoli View Post
Hello, sorry for taking time, did not saw this post
My skype is mikejack931 if you need help

I will try to help you with a little query to add in usp_Insert_Chat_Log_E

You will need this [Only registered and activated users can see links. Click Here To Register...] for kick the player in game.

If you want a better script, you will need a cheat engine that control the spam time between each chat.
[Only registered and activated users can see links. Click Here To Register...]
I think you forgot to replace one thing
08/29/2018 16:19 JujiPoli#12
Fixed sorry ...
08/31/2018 05:18 Eric-Dutra16#13
Quote:
Originally Posted by vinnystyler18 View Post
The procedures worked perfectly for normal names, the player and kicked the game, but will already find a fault, which can not be kicked.
he uses cheat engine or any other program and creates characters with names that can not be kicked

1º
image of spam done inside the server
[Only registered and activated users can see links. Click Here To Register...]

2º Test done by me

[Only registered and activated users can see links. Click Here To Register...]
Sorry, I should have anticipated this. Try this script. If you've already deleted the old Trigger, change that part:
Code:
ALTER TRIGGER [dbo].[SimpleAntiSpam]
To:
Code:
CREATE TRIGGER [dbo].[SimpleAntiSpam]