• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Soft delete all moderated posts (queries)

Useful for clearing out a backlog of moderated posts when you don't want to permanently delete them.
You can run these queries to soft delete all moderated posts. You need to change the red pieces to attribute these deletions to a user_id and username, as well as give the reason. These things are recorded in the deletion log:

Code:
INSERT INTO xf_deletion_log (content_type, content_id, delete_date, delete_user_id...
You do not have permission to view the full content of this resource. Log in or register now.
Author
Jake Bunce
First release
Last update
Rating
5.00 star(s) 2 ratings

More resources from Jake Bunce

Latest reviews

This works exactly as advertised and also includes the query to log the actions to the database. Would highly recommend for big boards requiring bulk moderation.
Helped me clear over 600 entries out of my queue when I migrated. Very useful!