XenForo Tutorials

Approve All Moderated Profile Posts Queries

Submitted by Oxygen, , Thread ID: 16053

Thread Closed
Oxygen
<div class="postbit-usertitle">
Prime
Level:
0
Reputation:
35
Posts:
608
Likes:
62
Credits:
1.47K
23-12-2015, 02:01 PM
#1
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]

RE: Approve All Moderated Profile Posts Queries

scann
Novice
Level:
0
Reputation:
0
Posts:
36
Likes:
6
Credits:
13
28-04-2016, 07:21 PM
#2
thanks for this i need its Smile

Users browsing this thread: 1 Guest(s)