Announcement

Collapse
No announcement yet.

Open & Close Forums Using MySQL Code

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

  • Open & Close Forums Using MySQL Code

    I know I have seen this somehwere but I can't for the life of me find it again.

    I would like to know what MySQL code I would need to use to open and close my forums.

    Tmod

  • #2
    See this:

    http://www.vbulletin.com/forum/showt...21#post1016921
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      That doesn't have what I am looking for.

      I am looking for the code to turn the forums on and off like you do from the vbulletin options Turn your vbulletin on and off.

      No code for that there.

      Unless I am totally blind.

      Tmod

      Comment


      • #4
        Darn, I could have sworn those queires were there. Sorry but I don't know the exact queries. I'll let you know if I find them.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          I could only find the queries for 3.0.x and 3.5.x and they didn't work for 3.6.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment


          • #6
            Where are the ones for v3.5?

            I will take a look at those and see if I can do anything with them.

            Thanks

            Tmod

            Comment


            • #7
              The queries have changed to these, as the setting is now an integer and not a string:

              (to turn off)

              Code:
              UPDATE datastore SET data=REPLACE(data,'s:8:"bbactive";i:1;','s:8:"bbactive";i:0;') WHERE title='options';
               
              UPDATE setting SET value=0 WHERE varname='bbactive';
              (to turn on)

              Code:
              UPDATE datastore SET data=REPLACE(data,'s:8:"bbactive";i:0;','s:8:"bbactive";i:1;') WHERE title='options';
               
              UPDATE setting SET value=1 WHERE varname='bbactive';
              Want to take your board beyond the standard vBulletin features?
              Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

              Comment


              • #8
                Thanks but

                i want to know what s:8 in quey means ? or other text ?

                Comment


                • #9
                  That is part of how PHP stores a serialized array. In this case it means that the next entry is a 8-byte characterstring.

                  For more info http://nl3.php.net/manual/en/function.serialize.php
                  Want to take your board beyond the standard vBulletin features?
                  Visit the official Member to Member support site for vBulletin Modifications: www.vbulletin.org

                  Comment


                  • #10
                    Thanks Marco!

                    Tmod

                    Comment


                    • #11
                      I tried
                      UPDATE setting SET value=0 WHERE varname='bbactive';
                      but couldn't figure out why my forum was still running. Then it occured to me that maybe I have to do something in the datastore too. But I have no clue how to poke around in the datastore.

                      I'm more of a concept man than an implementation man.

                      If I need to close my forum, I set an .htaccess password.

                      Comment

                      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                      Working...
                      X