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

 

[Oralgutan]

Hello,

If i understand your message, the simple way:

UPDATE `forum`.`vb_thread` SET `visible` = '1' WHERE `vb_thread`.`threadid` [B]>[/B] 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