how to stop email notification

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

XenForo moderator
Staff member
Run this query to disable email notifications for all of your currently watched threads:

Rich (BB code):
UPDATE xf_thread_watch
SET email_subscribe = 0
WHERE user_id = 1;
You need to specify your user_id.