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
- 26,860
- Points
- 823
Reputation:
LQD submitted a new resource:
Approve all moderated posts (queries) - Useful when you have a backlog of moderated posts.
Read more about this 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:
And here are the queries to approve all moderated threads:Code:DELETE FROM xf_moderation_queue WHERE content_type = 'post'; UPDATE xf_post SET message_state = 'visible' WHERE message_state = 'moderated';
You also need to run this query to reset the count in...Code:DELETE FROM xf_moderation_queue WHERE content_type = 'thread'; UPDATE xf_thread SET discussion_state = 'visible' WHERE discussion_state = 'moderated';
Read more about this resource...