[Any Version] How To Set Defaults for New and Existing Users

[Steve Machol]

You can set the default for new registrations in your:

vB4.x:

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

vB3.x:

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

You can mass update the preferences of exsiting users in your:

Admin CP -> Maintenance -> Execute SQL Query

There is a menu with predefined queries.

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:

    //    ****** 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'] = 'x';

...with x being your userid number.