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

How to Remove Everyone from Mailing Site List

Discussion in 'XenForo Questions and Support' started by wickedstangs, Feb 10, 2011.

  1. wickedstangs

    wickedstangs Well-Known Member

    How to Remove everyone from Receiving site mailings as a default?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    You can do it with an SQL query if you're comfortable doing that.

    UPDATE xf_user_option SET receive_admin_email = 0;

    To change it for any new users, set it in the ACP -> Options -> User Registration: Receive site mailings
    ProCom likes this.
  3. wickedstangs

    wickedstangs Well-Known Member

    1606 row(s) affected. ( Query took 0.1930 sec ) does that look right?
  4. Brogan

    Brogan XenForo Moderator Staff Member

    That means 1606 members had site mailings set to yes (1) and now it is set to 0 for all of them.
  5. wickedstangs

    wickedstangs Well-Known Member

    sweet thanks.. I sent a mass email to all my members and got shut down from my hosting:( only a 1000 an hour allowed.. Going to post up who wants to receive my junk emails:)

    Acceptable Use Policy
    Bulk Mailings: Bulk mailings of any kind are not permitted to be sent from our shared (Personal, Business, Reseller) servers. This line item applies to mailings sent within the 1000 emails per hour limit as well.
  6. James

    James Well-Known Member

    You might want to remove it from the default registration options too, just to make sure that new users don't register and receive site mailings by default.
    wickedstangs likes this.
  7. Brogan

    Brogan XenForo Moderator Staff Member

    wickedstangs and James like this.
  8. wickedstangs

    wickedstangs Well-Known Member

    Thanks everyone..

Share This Page