Import - mass setting of privacy details for all members


Formerly CyclingTribe
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


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