Approve all moderated profile posts (queries)

Approve all moderated profile posts (queries)

Backup first.

Here are the queries to soft delete all moderated profile posts:

Code:

DELETE

FROM xf_moderation_queue

WHERE content_type = ‘profile_post';

UPDATE xf_profile_post

SET message_state = ‘visible’

WHERE message_state = ‘moderated';

Source: Team Skull
Approve all moderated profile posts (queries)

Read
more @ www.teamskull.com