using this together with [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam https://vborg.vbsupport.ru/showthread.php?t=248042
helped with nearly complete removal of spam problems

my only small wishes
+ adminCP statistics page which covers all types of violations and theirs amount (e.g. #2b021b1f : 65535 times)
+ public forum statistics similar to SOM (on bottom of main forum page)

also i think the automatic database prune / cleanup don't work properly/at all

my thanks to author

p.s. any reason this isn't listed inside Anti-Spam section of modifications? https://vborg.vbsupport.ru/forumdisp...i-Spam+Options

This indeed belongs in the anti-spam section.

Yeah, something is going on with that. Every so often I'll see it running a LOT of DELETE and INSERT statements on the log records.

well since i installed this plugin it not correctly cleaned it once
be it 3.8.x version same as 4.x.x version ...

for 3.8.x i tried several workarounds w/o any success so i gave up
if needed manual sql wipe of the db entries must be done

make yourself a super admin and you will be able to do it from the admincp

what and where exactly You got in mind?

you can do this from the config file

Getting a whole lot of these one day a week:

DELETE FROM `vb_badbehavior` WHERE `date` < DATE_SUB('27-02-2012 22:22:40', INTERVAL 7 DAY)
INSERT INTO `vb_badbehavior` (`ip`, `date`, `request_method`, `request_uri`, `server_protocol`, `ht...

The inserts are building up because the vb_badbehavior table is locking.

make sure you are a super admin then you can prune when needed

Just to ask, can I just download newer versions of bad behavior (current is 2.2.2) and just upload bad-behavior directory in includes/bad-behavior directory on my server? Or there needs to be done something more?

EDIT: I mean, last bad behavior directory, as there are two named this way.