Approve All Moderated Profile Posts Queries

by Oxygen - 23-12-2015, 02:01 PM
<div class="postbit-usertitle">
Posts:
646
Joined:
Feb 2015
Likes:
50
Credits:
1,198
Reputation:
35
2 Years of Service
#1
OP
Posted: 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';

[Image: UeTXrZ5.png]
Novice
Prime
Posts:
36
Joined:
Sep 2015
Likes:
2
Credits:
9
Reputation:
0
1 Year of Service
#2
Posted: 28-04-2016, 07:21 PM
thanks for this i need its Smile
The last reply on this thread is older than a month. Please do not unnecessarily bump it.
Register an account or login to reply
Create an account
Create a free account today and start posting right away. It only takes a few seconds.
Login
Log into an existing account.
1 Guest(s)