Mass delete some topics

#1 · September 7, 2023, 2:45 pm

Hi all,

I refer to another post from someone who was requesting how to delete all the posts created by a user:

https://asgaros.com/support/topic/deleting-all-topics-created-by-a-user/

My need is very similar but I’m not comfortable at all with sql-queries syntax, and a bit afraid of doing something wrong !

Can someone help me in defining the right phrase in order to mass delete all the topics that are older than 3 months (whoever is the author) in certain categories only ?

Probably something starting by

DELETE p, t FROM wp_forum_posts p JOIN wp_forum_topics t ON ...

Thank you in advance 😉

#2 · September 20, 2023, 2:04 pm

Up!

My Asgaros forum plugin was updated to v2.7.0 but unfortunately no new option to allow that without having to play with sql queries…

Could Asgaros developers consider this as a new functionality to improve the plugin ?

Thanks !

#3 · September 21, 2023, 4:30 am

Hello @fredfit

I think a simple SQL query would be not enough because you also have to take care of removing uploads, subscriptions, reactions, and more. So I guess it is better to wait until I add this functionality to the plugin in the future (no timeline yet).

If you want to support the development of Asgaros Forum, you can leave a good review or donate. Thank you very much!