+- MyBB Codes (http://www.mybbcodes.com)
+-- Forum: Babjusi's Previous Forum General Stuff (/forumdisplay.php?fid=42)
+--- Forum: General Support (/forumdisplay.php?fid=46)
+--- Thread: Sql opening ALL threads. (/showthread.php?tid=2611)
Sql opening ALL threads. - DJNilo - 02-22-2011 02:02 PM
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?
RE: Sql opening ALL threads. - exdiogene - 02-22-2011 05:38 PM
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...
