Announcement

Collapse
No announcement yet.

SQL to turn on/off vbulletin

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

  • SQL to turn on/off vbulletin

    May i know what is the sql to turn on/off vbulletin?

    i've set the bbactive at the setting table but it is insufficient to reflect on the forum.

    i think need to set datastore too. not sure how to change the value at datastore table.

  • #2
    I've found the sql.

    for others who interested to know.

    Turn On vBulletin Forum

    UPDATE setting SET value=1 WHERE varname='bbactive'

    UPDATE datastore SET data=REPLACE(data,'"bbactive";i:0;','"bbactive";i:1;') WHERE title='options'
    Turn Off vBulletin Forum

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

    UPDATE datastore SET data=REPLACE(data,'"bbactive";i:1;','"bbactive";i:0;') WHERE title='options'

    Comment

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