Announcement

Collapse
No announcement yet.

Way to globally update user options?

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

  • Way to globally update user options?

    All the users I imported into my board defaulted to the standard editor interface. I'd like to change them to the enhanced WYSIWYG editor. Is there a way to globally update all users?

    I've changed the setting so that new users default to the WYSIWYG editor but need to update all the old users. Thanks
    http://www.rebelrockrunners.org

  • #2
    You can change a lot of the options under Maintenance -> Execute SQL Query. There is a section at the top called "Automatic Queries". Choose what you want from the drop down.

    To run Queries in the Admin Control Panel you need to edit your config.php file and add your user ID to the Can Run Queries section. It looks like:

    // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    // 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.
    $config['SpecialUsers']['canrunqueries'] = '';

    Place your user id between the single quotes.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment


    • #3
      Worked like a charm. Thanks
      http://www.rebelrockrunners.org

      Comment


      • #4
        Another question, I don't see a built in script to globally change time zone for users. Does anyone know what the syntax would be to change all users to the eastern time zone setting? Thanks
        http://www.rebelrockrunners.org

        Comment


        • #5
          What is the Eastern timezone offset: -4 or -5?

          Anyway here is the query:

          UPDATE user SET timezoneoffset='x';

          ...with 'x' being the appropriate GMT offset.
          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
            You're on the ball Steve. Thanks
            http://www.rebelrockrunners.org

            Comment


            • #7
              Tried the query but got this error

              An error occurred while attempting to execute your query. The following information was returned.
              error number: 1146
              error desc: Table 'rebesorg_forum.user' doesn't exist
              http://www.rebelrockrunners.org

              Comment


              • #8
                You are probably using a table prefix. You have to add that prefix in from of 'user'.
                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


                • #9
                  check the tableprefix as defined in your config.php file.
                  Last edited by WielerArchieven; Sat 28 Apr '07, 9:09am. Reason: beat by two minutes, Steve is blazing fast :-)

                  Comment


                  • #10
                    Worked. Thanks
                    http://www.rebelrockrunners.org

                    Comment

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