Automatic Thread Subscription Mode, How to set it up so all previous members....

[vividbreeze]

I have thousands of members and would like to switch this: Automatic Thread Subscription Mode - to WEEKLY NOTIFICATION.

I just changed it but is this only for new registrations?

If it is, then how can I set this mode for ALL my previous thousands of members?

Thanks!

[Lynne]

I believe you can change it for everyone in maintenace > SQL Query > automatic database query (make sure you have given your user permissions to run queries in the config.php first)

[vividbreeze]

Okay, i clicked on the weekly for auto and it came up with this:

Query (Weekly email notification)
UPDATE user SET autosubscribe = 3
(RESTART BUTTON HERE)

Confirm Query Execution
This query may modify data in your database. If this change is done in error, it is possible that you will not be able to recover from this change. Are you sure you wish to continue?

(CONTINUE / GO BACK BUTTON HERE)

Which one so I choose so my usergroup REGISTERED USERS (2) is all set to auto-weekly notifications of the posts/threads they make...