PDA

View Full Version : Auto approve threads


ThinkingBig
06-15-2012, 09:47 PM
Hello,

I want approve all threads which actually in moderation queue, how to do this? anyone can post me the magic method or sql query?

Thanks,
P.

borbole
06-15-2012, 10:09 PM
Hello,

I want approve all threads which actually in moderation queue, how to do this? anyone can post me the magic method or sql query?

Thanks,
P.

To approve all threads in the moderation queue run this query:

UPDATE thread
SET visible = 1
WHERE visible = 0;

If you are using a custom prefix for your db tables, append it to the table name in the query above. Hope it helps.

ThinkingBig
06-16-2012, 12:00 PM
Thanks, works great ;)

borbole
06-16-2012, 05:10 PM
Thanks, works great ;)

You are welcome :)