• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Approve all moderated profile posts (queries)

Compatible XF 1.x versions
1.4
License
BSD License
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';
Likes: maszd
Author
dono
First release
Last update
Rating
0.00 star(s) 0 ratings