Soft delete all moderated threads and posts

[benFF]

benFF submitted a new resource:

Soft delete all moderated threads and posts - Quickly clear your moderation queue by soft deleting everything using mySQL queries

These are the updated queries originally posted by @Jake Bunce to now work with XF 2.2

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

Read more about this resource...

 

[dougdirac]

How would one modify this to soft delete posts earlier than a particular time stamp.

Also perhaps dump a record of which posts this action occurred into a CSV file.