Announcement

Collapse
No announcement yet.

What is the MySQL query for...

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

  • What is the MySQL query for...

    Changing all of my forums to allowhtml in posts?

    I can't for the life of me come up with the correct query.

    forum.allowhtml is the table I need to update for 25 forums.
    There are only 10 types of people in the world: Those who understand binary, and those who don't


  • #2
    UPDATE forum SET allowhtml = 1

    Backup your database first!

    Comment


    • #3
      Originally posted by Cary
      UPDATE forum SET allowhtml = 1

      Backup your database first!
      Muchos gracias. Im testing it on a test forum first.
      There are only 10 types of people in the world: Those who understand binary, and those who don't

      Comment


      • #4
        Originally posted by WizyWyg
        Muchos gracias. Im testing it on a test forum first.
        Don't enable HTML! It causes security problems, and allows people to use XSS easily and 'hack' your forums.

        Comment


        • #5
          Originally posted by MUG
          Don't enable HTML! It causes security problems, and allows people to use XSS easily and 'hack' your forums.
          Hehe, I know the consequences. This is for an intranet site anyway, so no outside access whatsoever. If any of the 50 employees messes up, I can personally walk over to them and kick their @$$
          There are only 10 types of people in the world: Those who understand binary, and those who don't

          Comment

          Loading...
          Working...
          X