Activity Stream
48,167 MEMBERS
6873 ONLINE
besthostingforums On YouTube Subscribe to our Newsletter besthostingforums On Twitter besthostingforums On Facebook besthostingforums On facebook groups

Results 1 to 3 of 3

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1.     
    #1
    Member
    Website's:
    ReckonsTeam.com

    Default 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
    MR.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

  2.   Sponsored Links

  3.     
    #2
    Member
    Website's:
    oralgutan.com links.oralgutan.com
    Hello,

    If i understand your message, the simple way:
    Code: 
    
    UPDATE `forum`.`vb_thread` SET `visible` = '1' WHERE `vb_thread`.`threadid` > 1;
    OR

    Code: 
    UPDATE `forum`.`vb_thread` SET `visible` = '1'
    (Update all threads)

    Regards,
    P.

  4.     
    #3
    Member
    Website's:
    oralgutan.com links.oralgutan.com
    Np, If you have other questions about vb let me know

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Validate Email before send message {php}
    By AliMadkour in forum Web Development Area
    Replies: 5
    Last Post: 4th Jul 2012, 02:04 PM
  2. validate wordpress website with Oron?
    By Zeposed in forum File Host Discussion
    Replies: 0
    Last Post: 15th Jan 2012, 06:34 PM
  3. How to validate blogger for Oron?
    By donrambo in forum Webmasters, Money Making
    Replies: 2
    Last Post: 23rd Oct 2011, 02:04 PM
  4. XHTML Validate?
    By Sun!l in forum Web Development Area
    Replies: 9
    Last Post: 17th Jun 2010, 10:34 AM
  5. Warez Forum - Validate Email After Register?
    By c0rrup in forum Polling Plaza
    Replies: 11
    Last Post: 27th May 2010, 02:05 AM

Tags for this Thread

BE SOCIAL