Heisenberg submitted a new resource:
You must be registered for see links
- Approve all moderated posts (queries)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...
You must be registered for see links