The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Mysql: Change status of posts waiting moderation
Hi,
i have several thousand posts awaiting moderation ("Threads to Moderate"), please can anyone share mysql command to turn all these posts into approved/deleted? |
#2
|
|||
|
|||
If you do it from the admincp you can do many at the same time it would be the best way
|
#3
|
||||
|
||||
Most shared hosting servers will not let you process more than 1000 at a time. So, you will need to approve them in batches of only 1000. (Maybe, that is. It could be your host doesn't have it set like that.)
|
#4
|
|||
|
|||
3.8.4, shared host, memory exhausted, blank screen. please anyone can share mysql command to achieve that? or any alternative way to achieve?
|
#5
|
||||
|
||||
Did you try doing this in smaller batches?
If you do it via mysql, you could screw other things up, which is why anyone is reluctant to give the command. I mean, the *exact* command you ask for is to just change post.visible from 0 to 1 in the post table. But there are other tables this could affect and so I don't know that anybody wants to go through and figure all those out. |
#6
|
|||
|
|||
This can be done from frontend of the forum when loged in as admin, there is moderator panel and one can do 200 threads on page..
A way to delete all awaiting moderation at once is to go to AdminCP/Threads & Posts / Prune and select to prune only awaiting moderation. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|