Import went well - need to do some user account cleanup

[pjcnlv]

My import from FudForum is going well.

However, I need to do the following to speed the cleanup of a few things and need some help.

* Change all users time zone to Pacific Time with DST active.
* Change all user prefered editor to 'Show Standard Editor toolbar'.
* Change "automatic thread subscription mode" to "Do not subscribe".
* Send Notification Email Email when PM received to "yes"
* Set Style to "Default".

Jerry, can you help?

[Kerry-Anne]

Backup your database before doing anything else.

Go to AdminCP > Maintenance > Execute SQL Query

Run the following automatic queries

Yes - Send a notification email when a private message is received
Do not subscribe
Show standard editor toolbar

To set the users timezone, run the following manual query

UPDATE user SET timezoneoffset ='-8';

To set all users to use the default style set for your forums, run this query

UPDATE user SET styleid = '0';

You can run queries in the SQL tab in phpMyAdmin. Or to run queries from the Admin CP:
Admin CP -> Maintenance -> Execute SQL Query -> Manual Query
Then enter your query in the Manual Query 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.

[pjcnlv]

Thanks much!