Some 1 time changes to users

[AuroraAlpha]

Well I moved my board over from PHPBB and lets just say I messed up some things, and vB messed up some things.

I wanna set all users to the following:
Receive Private Messages (Yes)
Send Notification Email When a Private Message is Received (Yes)
Pop up a Notification Box When a Private Message is Received (No)
Receive Admin Emails (Yes)
Invisible Mode (No)

The only way I have found to do this though vB is one by one, but this takes a huge amount of time since there are at least 230 members effected. I want to load this into some vB file (or a new one) and run it, then remove the code and everyone will have the settings. I don't want ot leave this code intact.

Thanks for any help in advance.

[ericgtr]

You must first give yourself the ability to run queries if you haven't already, find this section in your /includes/config.php file:
****** USERS WITH QUERY RUNNING PERMISSIONS ******
and put your userid in there.

Then go to Maintenance > Execute SQL Query > then drop down the Automatic Query box and you will find most (if not all) of those actions in there that you can set for all users.

[AuroraAlpha]

Originally Posted by ericgtr

You must first give yourself the ability to run queries if you haven't already, find this section in your /includes/config.php file:
****** USERS WITH QUERY RUNNING PERMISSIONS ******
and put your userid in there.

Then go to Maintenance > Execute SQL Query > then drop down the Automatic Query box and you will find most (if not all) of those actions in there that you can set for all users.

Perfect!

Thank you, everything is already done, I would never amagin it could be so easy.

[ericgtr]

Great! I remember first importing and being thrilled to find that too.