No announcement yet.

Query to run to change everyone to wysiwg?

  • Filter
  • Time
  • Show
Clear All
new posts

  • Query to run to change everyone to wysiwg?

    I've just imported 200 users from a phpbb board ... however they are all set to the basic text editor rather than the wysiwyg (the forum default)

    Is there a simple SQL query I could run that would convert all users to wysiwyg?

    Also, is there a query that could turn off default thread subscriptions in member options? (I mean change back the one's who already have default subs)

  • #2
    To set the defaults for new users:

    Admin CP -> vBulletin Options -> User Registration Options -> Default Registration Options

    To reset options for existing users:

    Admin CP -> Import & Maintenance -> Execute SQL Query -> Automatic Query

    Then choose the appropriate query from the drop-down box and click on 'Continue'.

    To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

    // The users specified here will be allowed to run queries from the control panel.
    // See the above entries for more information on the format.
    // Please note that the ability to run queries is quite powerful. You may wish
    // to remove all user IDs from this list for security reasons.
    $canrunqueries = 'x';

    ...with x being your userid number (not username).
    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.


    • #3
      Thank You

      It's easy when you know how


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