change User CP settings to default

[Aurous]

I imported users from phpbb 2.0.8 and checked the USER CP settings of a few users and find them to not have the default board settings. For example, Private Messaging was disabled, Thread display options, data & time options, Miscellaneous Options etc. What table should I alter in the DB to change the settings for all imported users and what query should I use?

[Steve Machol]

To set these for all users:

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

Then choose the appropriate query 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:

// ****** 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.
$canrunqueries = 'x';

...with x being your userid number.

[Aurous]

Thanks a lot! That was a quick reply

[Jerry]

UPDATE user SET options=3159 WHERE usergroupid=2;

2 being the usergroup for registered users, seeing as its from an import you'll need to change that to what ever the normal usergroupid is for your board.