XF 1 Tip Approve all moderated profile posts (queries)

[ENXF NET]

LQD submitted a new resource:

Approve all moderated profile posts (queries) - approve all porfile posts

Backup first.

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

DELETE
FROM xf_moderation_queue
WHERE content_type = 'profile_post';

UPDATE xf_profile_post
SET message_state = 'visible'
WHERE message_state = 'moderated';

Read more about this resource...