MyBB Codes

Full Version: Sql opening ALL threads.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hi i made a mistake by installing a plugin (Auto Lock Thread‎) based on days.

Ok. I removed the plugin from the forum becuse it closed almost all threads in the forum so thats way i had to remove it.

Anyway the threads are locked and i need to open all again.

So are there any sql code i can run to open closed threads in the forum?
You could use :

"update mybb_threads set closed=0 where closed=1"

But be awared that all threads will be unlocked, you will have to lock them back individually afterward if needed. Always do a backup before doing any change on your tables or installing a plugin, if you had done one you would not be in this situation... Wink
Reference URL's