Validate all topics

[MR.KiDO]

How do I validate all the topics in vBulletin 4.1.x using sql. I have query but it only works for 1 i need to validate for more than 1000!!!

Here is the code that works with one

UPDATE `forum`.`vb_thread` SET `visible` = '1' WHERE `vb_thread`.`threadid` =1;

I think If I am able to change that threadid =1 to something like autoincremeant it should work out

MR.KiDO Reviewed by MR.KiDO on 20th Sep 2012. Validate all topics How do I validate all the topics in vBulletin 4.1.x using sql. I have query but it only works for 1 i need to validate for more than 1000!!! Here is the code that works with one UPDATE `forum`.`vb_thread` SET `visible` = '1' WHERE `vb_thread`.`threadid` =1; I think If I am able to change that threadid =1 to something like autoincremeant it should work out Rating: 5

[Oralgutan]

Hello,

If i understand your message, the simple way:

UPDATE `forum`.`vb_thread` SET `visible` = '1' WHERE `vb_thread`.`threadid` > 1;

OR

UPDATE `forum`.`vb_thread` SET `visible` = '1'

(Update all threads)

Regards,
P.

[Oralgutan]

Np, If you have other questions about vb let me know