• 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

Nudaii

Well-known member
#1
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?
 

Brogan

XenForo moderator
Staff member
#2
Take a backup first.

Code:
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';