Import - mass setting of privacy details for all members

[CTXMedia]

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

 

[Paul B]

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

 

[CTXMedia]

Perfect - thanks again