• 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

CyclingTribe

Well-known member
#1
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.

Thanks,
Shaun :D
 

Brogan

XenForo moderator
Staff member
#2
Code:
UPDATE xf_user_option SET show_dob_year = 0;
UPDATE xf_user_option SET show_dob_date = 0;
Code:
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';