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 turn off alerts for imported members

Discussion in 'XenForo Questions and Support' started by Nudaii, Feb 29, 2012.

  1. Nudaii

    Nudaii Well-Known Member

    will be importing a large forum on sunday, after having been on vb since ..well forever basically

    beta feedback reports that members would prefer all their alerts set to off, and then they can manually go in and select those they wish to enable

    is there a query to default Off alerts?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Take a backup first.

    UPDATE xf_user_option
    SET alert_optout = 'post_insert,post_insert_attachment,post_like,post_quote,profile_post_comment_other_commenter,profile_post_comment_your_post,profile_post_comment_your_profile,profile_post_insert,profile_post_like,user_following,user_trophy';
  3. Nudaii

    Nudaii Well-Known Member


Share This Page