• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 2.0 How to set "Watched" Content to "yes, with email" for all users


Active member
After importing my IPBoard database, all the users were set to "No" for receiving email/alerts for content they create or interact with. Are there a couple of SQL Queries I could run to change them from "No" to "Yes, with email". I have set the registration for future users to this, but all of my imported users have "No" listed at present.

watch content.png