Results 1 to 3 of 3
-
20th Sep 2012, 07:46 PM #1OPMemberWebsite's:
ReckonsTeam.comValidate 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 outMR.KiDO Reviewed by MR.KiDO on . 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
-
3rd Oct 2012, 07:45 PM #2MemberWebsite's:
oralgutan.com links.oralgutan.comHello,
If i understand your message, the simple way:
Code:UPDATE `forum`.`vb_thread` SET `visible` = '1' WHERE `vb_thread`.`threadid` > 1;
Code:UPDATE `forum`.`vb_thread` SET `visible` = '1'
Regards,
P.
-
3rd Oct 2012, 07:48 PM #3MemberWebsite's:
oralgutan.com links.oralgutan.comNp, If you have other questions about vb let me know
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
Validate Email before send message {php}
By AliMadkour in forum Web Development AreaReplies: 5Last Post: 4th Jul 2012, 02:04 PM -
validate wordpress website with Oron?
By Zeposed in forum File Host DiscussionReplies: 0Last Post: 15th Jan 2012, 06:34 PM -
How to validate blogger for Oron?
By donrambo in forum Webmasters, Money MakingReplies: 2Last Post: 23rd Oct 2011, 02:04 PM -
XHTML Validate?
By Sun!l in forum Web Development AreaReplies: 9Last Post: 17th Jun 2010, 10:34 AM -
Warez Forum - Validate Email After Register?
By c0rrup in forum Polling PlazaReplies: 11Last Post: 27th May 2010, 02:05 AM
themaManager - edit and manage...
Version 4.04 released. Open older version (or...