xF1 Soft delete all moderated posts (queries)

[ven0m]

Heisenberg submitted a new resource:

You must be registered for see links

- Soft delete all moderated posts (queries)

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...

You must be registered for see links