You can run these two queries to approve all moderated posts:
And here are the queries...Code:DELETE FROM xf_moderation_queue WHERE content_type = 'post'; UPDATE xf_post SET message_state = 'visible' WHERE message_state = 'moderated';
Registration Email Allowed In Our Database : Yahoo * Gmail * Hotmail * Outlook * yandex * live * are allowed to register in our database. [ We Will Approve Manually After Review It ]
Tips & Guides Approve all moderated posts (queries)
Useful when you have a backlog of moderated posts.