Automatic ban?

theallan · February 2012

Hello,

I'm really loving the spam / moderation options with the Akismet plug-in, but I'm wondering how it might be possible to "enhance" it slightly? What would be nice is if a user is found to have 5 posts (or whatever) in the spam moderation queue, their role would automatically be changed to banned. Is that possible? Any suggestions on how to do it would be very welcome!

Thanks, Allan

jungica · February 2012

try to put its IP into .htaccess ban

theallan · February 2012

Yeah I guess that would work given that I could scan the DB and check the posting rate. But really it would be nice to be able to change the user name to being banned as that is part of the forum software. Is there an API for doing that?

Allan

Stewartiee · February 2012

It's probably really easy to do, although i'm not sure how you would incorporate it as a plugin and therefore you'd have to change the core files.

You're best just waiting for something like this to be included in later releases.

theallan · February 2012

Figured I should stop being lazy and have a peak at the code (should have done that in the first instance rather than wasting everyone's time - sorry about that!).

This is my solution - add the following to the "CheckAkismet" plug-in for the Akismet spam detection:

  if ( $Result ) {
     $spamCount = Gdn::SQL()->GetCount('GDN_Log', array('Operation'=>'Spam', 'InsertUserID'=>$UserId));
     // Three messages already in Spam queue, and this now will be a forth so ban the sucker
     if ( $spamCount >= 3 ) {
        Gdn::SQL()->Update('GDN_User', array('Banned'=>1), array('UserID'=>$UserId));
     }
  }

I suspect that there are a few defines that should be used to make it integrate with the system fully, and ultimately it would be nice to have it as a configuration option for the plug-in I guess, but this is fine for my use atm :-)

Regards, Allan

theallan · March 2012

Actually - a couple of errors in the above code... Here is the correct code should anyone else be interested in this:

  if ( $Result ) {
     $spamCount = Gdn::SQL()->GetCount('Log', array('Operation'=>'Spam', 'InsertUserID'=>$UserID));
     // Three messages already in Spam queue, and this now will be a forth so ban the sucker
     if ( $spamCount >= 3 ) {
        Gdn::SQL()->Update('User')->Set('Banned', '1', FALSE)->Where('UserID', $UserID)->Put();
     }
  }

Allan

Howdy, Stranger!

Categories

In this Discussion

Automatic ban?

Answers