Way to globally update user options?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rockjeep44
    New Member
    • Apr 2007
    • 24

    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
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    #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

    • rockjeep44
      New Member
      • Apr 2007
      • 24

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

      Comment

      • rockjeep44
        New Member
        • Apr 2007
        • 24

        #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

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #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

          • rockjeep44
            New Member
            • Apr 2007
            • 24

            #6
            You're on the ball Steve. Thanks
            http://www.rebelrockrunners.org

            Comment

            • rockjeep44
              New Member
              • Apr 2007
              • 24

              #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

              • Steve Machol
                Former Customer Support Manager
                • Jul 2000
                • 154488

                #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

                • WielerArchieven
                  Member
                  • Apr 2007
                  • 51
                  • 3.6.x

                  #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

                  • rockjeep44
                    New Member
                    • Apr 2007
                    • 24

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

                    Comment

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