Announcement

Collapse
No announcement yet.

Closing forum without the admin

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

  • Closing forum without the admin

    Hi all, for my config script im making an easy to acces on/off marker.

    What is the mysql code to close and open the forum? Ive tried some search and tried those solutions

    mysql_query("UPDATE datastore SET data=REPLACE(data,'\"bbactive\";s:1:"1"','\"bbactive\";s:1:\"0\"') WHERE title='options'");
    mysql_query("UPDATE setting SET value=0 WHERE varname='bbactive'");

    But they give this error:

    Parse error: parse error, unexpected T_LNUMBER

  • #2
    Run both these queries to turn your forums off:

    UPDATE datastore SET data=REPLACE(data,'"bbactive";s:1:"1"','"bbactive";s:1:"0"') WHERE title='opti
    ons';

    UPDATE setting SET value=0 WHERE varname='bbactive';


    Run both these queries to turn your forums back on:

    UPDATE datastore SET data=REPLACE(data,'"bbactive";s:1:"0"','"bbactive";s:1:"1"') WHERE title='opti
    ons';

    UPDATE setting SET value=1 WHERE varname='bbactive';
    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
      Ok thanks that works, remember you have to add vb3_ or something infront of the db :P
      Last edited by Megamind; Tue 24 May '05, 11:22pm.

      Comment


      • #4
        Small kick.

        This does not seem to work anymore for the latest VBulletin. Any solution for this?

        Comment


        • #5
          Post a new thread in the appropriate forum for your version.
          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

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