Approve All Moderated Profile Posts Queries

Oxygen · 23-12-2015, 02:01 PM

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';

scann · 28-04-2016, 07:21 PM

thanks for this i need its Smile

Approve All Moderated Profile Posts Queries

Submitted by Oxygen, 23-12-2015, 02:01 PM, Thread ID: 16053

RE: Approve All Moderated Profile Posts Queries