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

XF 1.1 query to set all to receive notifications

Discussion in 'XenForo Questions and Support' started by greenchicken, Oct 29, 2012.

  1. greenchicken

    greenchicken Member

    Want to reset it for my whole forum, anyone know the query? TIA Capture.JPG
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    To set it for all existing users, run this query:

    Code:
    UPDATE xf_user_option SET default_watch_state = 'watch_email'
    To set that as the default for new user registrtions... Let me check :p

    EDIT: Yep: Admin CP > Options > User Registration

    Set "Watch threads when creating or replying" to "Yes, with email"
     
  3. greenchicken

    greenchicken Member

    Thanks so
    UPDATE xf_user_option SET default_watch_state = 'watch_email'
    will reset all users to receive emails by default?
     
  4. Chris D

    Chris D XenForo Developer Staff Member

    Yes.

    And if you set default_watch_state to 'watch_no_email' that will set it to watch all threads but without emails.
     
    Jake Bunce and greenchicken like this.
  5. greenchicken

    greenchicken Member

    Done, Appreciate the help
     
    Chris D likes this.

Share This Page