deleting all topics created by a user
Quote from JAM on June 20, 2019, 7:40 amHi, we have been having this crazy spam attack on our forums where about 3000 new topics were created in a matter of minutes.
I would like to find out if there is a way to firstly delete all posts made by this user and any ideas on how to prevent this in the future.
thanks
Hi, we have been having this crazy spam attack on our forums where about 3000 new topics were created in a matter of minutes.
I would like to find out if there is a way to firstly delete all posts made by this user and any ideas on how to prevent this in the future.
thanks
Quote from Asgaros on June 20, 2019, 8:33 amHello @jam
I suggest you to use a plugin like Google Captcha to protect your sites against spam-bots. You can check out the following two extensions:
https://wordpress.org/plugins/google-captcha/
https://wordpress.org/plugins/recaptcha-for-asgaros-forum/
To delete all the topics of that user, you have to execute a SQL-query directly on your database with a tool like phpMyAdmin (dont forget to make a backup before):
DELETE p, t FROM wp_forum_posts p JOIN wp_forum_topics t ON p.parent_id = t.id WHERE p.author_id = 123;
Hello @jam
I suggest you to use a plugin like Google Captcha to protect your sites against spam-bots. You can check out the following two extensions:
https://wordpress.org/plugins/google-captcha/
https://wordpress.org/plugins/recaptcha-for-asgaros-forum/
To delete all the topics of that user, you have to execute a SQL-query directly on your database with a tool like phpMyAdmin (dont forget to make a backup before):
DELETE p, t FROM wp_forum_posts p JOIN wp_forum_topics t ON p.parent_id = t.id WHERE p.author_id = 123;