Stop Notifications email

[Manoel J?nior]

How do I stop all notifications subscriptions are sent by email to users. I would do this through a SQL query.

[John Lester]

Thread subscriptions for all users? Or other email notifications (if so which ones)?

[Manoel J?nior]

Originally Posted by Manoel J?nior

How do I stop all notifications subscriptions are sent by email to users. I would do this through a SQL query.

Hello John,

I want Thread subscriptions for all users!

[John Lester]

Ok this should (my hard drive crashed so I can't test it on the libraries computer ) set everyone's thread subscriptions to "through control panel only". If you want to change them to "do not subscribe" replace 0 with -1.

UPDATE subscribethread SET emailupdate = 0 WHERE emailupdate IN (1, 2, 3)

[Manoel J?nior]

Thanks dude, i'll test!