ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 26,859
- Points
- 823
Reputation:
LQD submitted a new resource:
Approve all moderated profile posts (queries) - approve all porfile posts
Read more about this resource...
Approve all moderated profile posts (queries) - approve all porfile posts
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';
Read more about this resource...