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

Import - mass setting of privacy details for all members

Discussion in 'XenForo Questions and Support' started by CyclingTribe, Nov 15, 2011.

  1. CyclingTribe

    CyclingTribe Well-Known Member

    I wonder if anyone can help with some queries regarding privacy settings for members once I've imported them from IPB.

    I want to change everyone's privacy settings as follows:

    • "Show day and month of birth" = off/unselected
    • "Show year of birth" = off/unselected
    • "View this user's profile page details" - Members only
    • "Post messages on this user's profile page" - Members only
    • "Receive this user's news feed" - Members only
    • "Initiate conversations with this user" - Members only
    • "View this user's identities" - Members only

    I'm not too bothered about doing them as individual queries, but if it can be done in one shot, that would be great.

    Shaun :D
  2. Brogan

    Brogan XenForo Moderator Staff Member

    UPDATE xf_user_option SET show_dob_year = 0;
    UPDATE xf_user_option SET show_dob_date = 0;
    UPDATE xf_user_privacy SET allow_view_profile = 'members';
    UPDATE xf_user_privacy SET allow_post_profile = 'members';
    UPDATE xf_user_privacy SET allow_receive_news_feed = 'members';
    UPDATE xf_user_privacy SET allow_send_personal_conversation = 'members';
    UPDATE xf_user_privacy SET allow_view_identities = 'members';
    GeeksChat likes this.
  3. CyclingTribe

    CyclingTribe Well-Known Member

    Perfect - thanks again :)

Share This Page