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

Unwatch Threads

Discussion in 'XenForo Questions and Support' started by mrb1972, Jul 5, 2011.

  1. mrb1972

    mrb1972 Active Member

    Is it possible for an Admin to bulk clear users "watch thread" and "and receive email notifications" settings?
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    You can do it with SQL queries if you're comfortable doing that and have access to e.g. phpMyAdmin.
     
  3. mrb1972

    mrb1972 Active Member

    Yes thats no problem, its a test site so not critical if it goes wrong, if you could let me know the queries that would be helpful.. thanks
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Code:
    UPDATE xf_user_option SET email_on_conversation = 0;
    UPDATE xf_user_option SET default_watch_state = '';
    truncate table xf_thread_watch;
    That should do it.
     
    maszd and sylwester like this.
  5. mrb1972

    mrb1972 Active Member

    thanks, I will give it a try
     

Share This Page