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

Change all users privacy settings

Discussion in 'XenForo Questions and Support' started by daveo82, Jun 4, 2011.

  1. daveo82

    daveo82 Member

    What would be the database query where I could change all members privacy settings to:

    Post messages on your profile page: Members Only

    What's happened is I converted from vBulletin where I didn't have users visitor messages switched on, I'm guessing because of that when I moved all users privacy settings have this option unticked. All new users I have the settings sorted, just need to update all the older members.

  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Use this query:

    UPDATE xf_user_privacy
    SET allow_post_profile = 'members';
  3. Brogan

    Brogan XenForo Moderator Staff Member

    A few queries here for you.

    UPDATE xf_user_privacy SET allow_view_profile = 'members';
    UPDATE xf_user_privacy SET allow_post_profile = 'members';
    UPDATE xf_user_privacy SET allow_send_personal_conversation = 'members';
    UPDATE xf_user_privacy SET allow_view_identities = 'members';
    UPDATE xf_user_privacy SET allow_receive_news_feed = 'members';

    Bah! Ninja'ed
    Fuhrmann likes this.
  4. daveo82

    daveo82 Member

    That's great, cheers!

Share This Page