Resource icon

XF 1 Tip Soft delete all moderated posts (queries)

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
19,124
Points
823

Reputation:

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:

Code:
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...
 
Top