Announcement

Collapse
No announcement yet.

anyone know how? :)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • anyone know how? :)

    I have a lot of forums. Most of them are set
    Can Have Password? = Yes
    in the admincp. Instead of setting each to "no", is there an sql query that I can run that will set all forums to
    Can Have Password? = no
    ?

    Thanks.


  • #2
    This is the query to set all forums to no:
    Code:
    UPDATE forum SET options=options - 8192 WHERE (options & 8192);
    Best Regards,
    Andy Huang

    Comment


    • #3
      Thank you so much! Worked great.

      Comment

      Loading...
      Working...
      X