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

XF 1.4 Mass Unsubscribe Users from Receiving Admin Emails?

Discussion in 'XenForo Questions and Support' started by UserMatt, Feb 15, 2015.

  1. UserMatt

    UserMatt Member


    Is there a way/command to mass unsubscribe a list of users (email addresses) from receiving admin emails?


  2. Brogan

    Brogan XenForo Moderator Staff Member

    There is no option for that so it would require running a query directly against the database.
    UserMatt likes this.
  3. UserMatt

    UserMatt Member

    That makes sense, thanks. Do you have any idea what the query would be?

    In vBulletin I used:

    UPDATE user SET options = options - 16 WHERE options & 16 AND email IN (
  4. Brogan

    Brogan XenForo Moderator Staff Member

    It would be:
    UPDATE xf_user_option SET receive_admin_email = 0;
    That would do it for all users though, so you would need to factor in the user IDs to the query.

Share This Page