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:
...with x being your userid number.
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:
Code:
// ****** 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';