Posted 5 years ago #
99.5% of my spam has had the words "i'm agree with you, i think..." at the start. Is there some way that Akismet could apapt to that, as a lot with these words still gets through.
Also, I want to find all the spam with that phrase, then delete it, but I can't see a "select all" button on the results page (over 3,000 results!).
Thanks
Why not just click on the Delete All button?
Posted 5 years ago #
Sorry, perhaps I didn't make the original point clear enough.
99.5% of my spam is spam. On very rare conditions, there's spam that DOESN'T contain those words, and of that, occasionally, a genuine comment gets through.
I currently have 28951 bits of spam to look through, and get roughly 4 spams per minute. By deleting all the "i'm agree with you" spam, I could narrow it down to probably a handful to check through.
So, to clarify again, I want to delete all the RESULTS and not all of what Akismet thinks is spam.
Otherwise, why would there be searches if it wasn't to exclude stuff?
Posted 5 years ago #
Well, after a couple of hours I managed to work out roughly how to reduce the spam to something manageable, checking after each one to see if it was a sensible size yet.
After running this lot, I was down to 545 spams, which I could at least page through.
DELETE FROM wp_comments WHERE comment_content LIKE '%agree%with%you,%i%think...%' AND comment_approved = 'spam'
DELETE FROM wp_comments WHERE comment_content LIKE '%[url=http://%' AND comment_approved = 'spam'
DELETE FROM wp_comments WHERE comment_content LIKE '%viagra%' AND comment_approved = 'spam'
DELETE FROM wp_comments WHERE comment_content LIKE '%cialis%' AND comment_approved = 'spam'
DELETE FROM wp_comments WHERE comment_content LIKE '%http://%' AND comment_approved = 'spam'
This topic has been closed to new replies.
