ALERT!
Click here to register with a few steps and explore all our cool stuff we have to offer!
Home
Upgrade
Credits
Help
Search
Awards
Achievements
 9026

Approve all moderated posts (queries)

by Bi0S - 05-04-2017 - 03:08 AM
#1
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 the moderator bar:
Code:
DELETE
FROM xf_data_registry
WHERE data_key = 'moderationCounts';

Backup first.
Reply
#2
thanks for this very useful guide
Reply
#3
Thank you very much brother
Reply

Users browsing: 1 Guest(s)