How do I change my imported users, default USER options?

[Jet Blast]

Hello Admins!
I know I need to make a query, but my knowledge is limited when doing query's.
So I need your help.

I've imported all my useres from my crappy phpbb board, and would like to change there default options to do the following;

1-Receive Admin Emails
2-Receive Private Messages
3-Send Notification Email When a Private Message is Received
4-Pop up a Notification Box When a Private Message is Received

5-..and set "Automatic Thread Subscription Mode" to;
receive "instant email notification"

6-and..."Message Editor Interface"
to show "enhanced WYSIWYG Editor"

I have set the boards options to all of the above on new users, however imported users, which I've moved OVER to register users do not have these options set.

Could someone be so helpful, and give me the codes to paste into my query.

Thanks in advance.

[Steve Machol]

To set the defaults for new users:

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

To reset options for existing users:

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

Then choose the appropriate query from the drop-down box 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 (not username).

[Jet Blast]

WOW!!
You guys have thought of eveything!!!
I should have switched over from phpbb years ago!!

Thanks alot!!

[Steve Machol]

You're welcome.

[Jet Blast]

....and 'Roger' on changing the config. file to allow me to do query's.

Thanks again.