User list post count filters?

Zeaks

I'm trying to deal with a massive amount of spam on my forums and I can't find an easy way to remove it al. Roughly 75,000 threads were made in the past day. There are no legitimate users with more than 1000 posts on my forums, so if I could filter users with more than 1000 posts and then delete/delete user content, it would clean up most of it but I see no way to filters users by post count.

I checked for aplugin that could do this but I was unable to find one.

peregrine

Backup your database first and try this.

do you want to delete the user as well?

if so you could use the cleanser plugin, and select members,

and modify class.cleansermodel.php

from

  ->Join('User u', 'ur.UserID = u.UserID')
                ->Where('ur.RoleId', $therole);

to

  ->Join('User u', 'ur.UserID = u.UserID')
                ->Where('u.CountComments >', 999)
                ->Where('ur.RoleId', $therole);




if its discussions created


from

  ->Join('User u', 'ur.UserID = u.UserID')
                ->Where('ur.RoleId', $therole);

to

  ->Join('User u', 'ur.UserID = u.UserID')
                ->Where('u.CountDiscussions >', 999)
                ->Where('ur.RoleId', $therole);

peregrine

I would upgrade to vanilla 2.1 also. since you seem to be using vanilla 2.0, based on your posting in the vanilla 2.0 help category.

not sure if you solved your issue... since this discussion is posted later than the other one

http://vanillaforums.org/discussion/comment/216864/#Comment_216864