XF 1 Tip Soft delete all moderated posts (queries)

[ENXF NET]

LQD submitted a new resource:

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:

INSERT INTO xf_deletion_log (content_type, content_id, delete_date, delete_user_id, delete_username, delete_reason)
SELECT content_type, content_id, UNIX_TIMESTAMP(), 1, 'admin', 'manually moved from moderation to soft delete'
FROM xf_moderation_queue AS mq...

Read more about this resource...