Approve all moderated posts (queries)

by Bi0S - 05-04-2017 - 03:08 AM
Posts:
12,184

Reputation:
30

Credits:

GoldDiamondEmeraldKnightCredit WhoreRich BitchActiveAddictedTop BananaLeaker
Emerald Member
Emerald
Posts:
12,184

Threads:
12,128

Joined:
May 2017

Likes:
39

Credits:

Reputation:
30

Warning Level:

2 Years Of Service
GoldDiamondEmeraldKnightCredit WhoreRich BitchActiveAddictedTop BananaLeaker
#1
OP
Posted: 05-04-2017 - 03:08 AM
You can run these two queries to approve all moderated posts:
Code:
DELETE
FROM xf_moderation_queue
WHERE content_type = 'post';

UPDATE xf_post
SET message_state = 'visible'
WHERE message_state = 'moderated';

And here are the queries to approve all moderated threads:
Code:
DELETE
FROM xf_moderation_queue
WHERE content_type = 'thread';

UPDATE xf_thread
SET discussion_state = 'visible'
WHERE discussion_state = 'moderated';

You also need to run this query to reset the count in the moderator bar:
Code:
DELETE
FROM xf_data_registry
WHERE data_key = 'moderationCounts';

Backup first.
Posts:
16

Reputation:
0

Credits:

Rookie User
Posts:
16

Threads:
1

Joined:
Nov 2017

Likes:
0

Credits:

Reputation:
0

Warning Level:

1 Year Of Service
#2
Posted: 11-05-2017 - 06:45 AM
thanks for this very useful guide
Posts:
15

Reputation:
0

Credits:

Rookie User
Posts:
15

Threads:
0

Joined:
May 2018

Likes:
0

Credits:

Reputation:
0

Warning Level:

1 Year Of Service
#3
Posted: 05-06-2018 - 02:25 AM
Thank you very much brother




USERS BROWSING THIS THREAD:  1 Guest(s)
"Join for the content, stay for the community."
© All Rights Reserved DemonForums.
© 2015-2019 / DemonForums
Server time: 05-26-2019, 05:15 PM (1309 Days Online)