how to stop email notification

[aiman.h.kallaf]

i just made more than 500 topic and want to stop the email notification . is there a way to select all the topics at once and chose disable email notification , because it boring to go over 30 pages of topics selecting the one by one . tried to look for an option ( select all ) but did not find any

 

[Jake Bunce]

Run this query to disable email notifications for all of your currently watched threads:

UPDATE xf_thread_watch
SET email_subscribe = 0
WHERE user_id = 1;

You need to specify your user_id.

 

[aiman.h.kallaf]

Thank you Jacke