Deleting A Spam Attack

[comhlamh]

Hi guys

Just had a load of spam viagra events set up on my calendar

theres loike 1800 of them.

you can get a sense of them over at this iamge here:@ https://www.anony.ws/image/Dy5x

Whats best way to delete em, going page by page will kill me.

[Barry]

Hi @comhlamh,

I’m assuming this relates to Community Events and will move the topic to that forum – but the topic URL should remain the same 🙂

Firstly, though I appreciate this won’t help with the clean up process, I just wanted to mention (partly for the benefit of others coming across this topic) that there are options to help avoid this sort of scenario, including setting a requirement for users to login before submitting events or requiring them to complete a CAPTCHA challenge when that isn’t possible.

To the problem at hand, if all these posts have something in common – like the keyword viagra – and you know with certainty that no legitimate posts on your site contain that same keyword – you could potentially wrap this up quite quickly by running a custom crafted piece of SQL along these lines:

DELETE FROM wp_posts WHERE post_content LIKE "%viagra%";

However, I’d recommend this only if you are familiar with and comfortable interfacing directly with your database (remember to take all the usual precautions, such as making a backup and familiarizing yourself with the process for restoring that backup!).

Doing this would also result in “orphaned” post meta data and again that can be removed with a further query or two (an example of doing so can be found here).

Other than that, perhaps there are some third party plugins which cater to this kind of scenario – however based on a quick search I wasn’t able to identify any and have no recommendations to make on that count.

Sorry for the inconvenience and I hope the above at least gives you a few ideas you can explore.

[Support Droid]

This topic has not been active for quite some time and will now be closed.

If you still need assistance please simply open a new topic (linking to this one if necessary)
and one of the team will be only too happy to help.

[Author]

Posts