Resource icon

XF 1 Tip Approve all moderated posts (queries)

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
8,763
Points
698

Reputation:

LQD submitted a new resource:

Approve all moderated posts (queries) - Useful when you have a backlog of moderated posts.

You can run these two queries to approve all moderated posts:

Code:
DELETE
FROM xf_moderation_queue
WHERE content_type = 'post';

UPDATE xf_post
SET message_state = 'visible'
WHERE message_state = 'moderated';
And here are the queries to approve all moderated threads:

Code:
DELETE
FROM xf_moderation_queue
WHERE content_type = 'thread';

UPDATE xf_thread
SET discussion_state = 'visible'
WHERE discussion_state = 'moderated';
You also need to run this query to reset the count in...
Read more about this resource...
 
Top