how to turn on subscribe to thread for exisiting users?

[asimo]

Is there a sql i can run to turn on email notifications and subscribe to thread by default for existing users?

thanks

[kh99]

If you are allowed to use Exec SQL Query under Maintenance in the admincp, then there is a "canned" query to do it. The query is:

UPDATE user SET autosubscribe = 1


Edit: ...but if you want to do it so you don't change any users who already have something selected, then maybe this instead:

UPDATE vbuser SET autosubscribe = 1 WHERE autosubscribe = -1

[Lynne]

You can run the query "Instant email notification" in Maintenance > Execute SQL Query to automatically subscribe users *for now on* to any threads they create or post to. However, they will still have the option to turn that off per thread/post or in their Settings area.