Auto approve threads

[ThinkingBig]

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]

Originally Posted by ThinkingBig

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]

Thanks, works great

[borbole]

Originally Posted by ThinkingBig

Thanks, works great

You are welcome