Add this to .htaccess to ban an IP

order allow,deny
deny from 111.111.111.111
allow from all

You can [u]disable anonymous comments[/u] in Basic antispam plugin settings, [u]install reCaptcha[/u] plugin or [url=http://forums.b2evolution.net//viewtopic.php?t=21622]reject all comments with author URL[/url]

Back on subject. I created a "Mass comments delete" plugin long time ago. It's not perfect and I don't even know if it works in b2evo 4.

I can post it if you want to play with it.

sam2kb wrote:

Back on subject. I created a "Mass comments delete" plugin long time ago. It's not perfect and I don't even know if it works in b2evo 4. I can post it if you want to play with it.

Hey, if you're still around and have that, I would LOVE to try it out. I'm currently sitting here with 1500+ comments that are about 98% spam. Fake email addresses, advertisements, off topic, the works. I'm using the current version and all that, but this is really getting out of hand.

I've searched the forums, docs, but although this question seems to be asked a lot, I don't see a concrete answer short of turning off the comments... which is my next step if I can't solve this.

Thanks in advance for any help or leads anyone can provide.

Mark

I added an option to recheck all comments against antispam blacklist in b2evo 4.1.0. Do you have antispam blacklist enabled at all?

I will post the plugin later.

b2evo 4.1 allows you to delete spam comments with ONE click per comment.

If you need less than one click per comment, then you need to add blacklisted string to your antispam blacklist and you'll have the option to delete all matching comments.

Does that fulfill your mass deletion desires? ;)

Whilst the last post would seem to be spam, I would like to take this opportunity to plug my plugin submitted which takes the comment details (name, email and IP) and checks them with the stop forum spam list. http://plugins.b2evolution.net/index.php/2011/09/23/stop_forum_spam

When asking is there a way to Mass Delete comments from b2evo...the short answer is 'no'. The actual answer is yes...if you know how to use phpMyAdmin to get into your database. From within the database you set the blog up with go to the comments table. Next check any comments you would like to delete and delete them all at once...please be careful and create a backup of the db first to be on the safe side...anyway that's how I do it.

You can do want you want with a small change to 2 files.

1.
inc/antispam/views/_antispam_ban.form.php

Search for T_comment around line 105 (version 4.1.3) open a new line above the "ORDER BY" clause and enter:

OR comment_author_IP = '.$DB->quote($keyword).'

2.
inc/antispam/antispam.ctrl.php

Search for "select banned comments" around line 105 (spooky!) open a line below "$keyword_cond = " and enter:

OR comment_author_IP = '.$DB->quote($keyword).'

This will check the keyword against the commenter IP address and will allow you to use antispam in the same way as normal.

@fplanque: for example, which string can be use to delete all comment generated by the tool "Create sample comments for testing moderation" ?

Delete 20 comments from #500 to #520

DELETE FROM evo_comments WHERE comment_ID > 500 AND comment_ID < 520

Delete all comments posted at May 9th 2012

DELETE FROM evo_comments WHERE comment_date LIKE "2012-05-09%"

If we delete the whole entry which was hit by spam comments, will it clear all the whole mass of comment from the database? I'm thinking of re-write the post for those badly hit by thousands of comments.

Yes it should work.
Alternatively, in v5 there is a feature to delete all new (draft) comments (without needing to delete your post)