XF 1.3 Change Privacy options in a batch

[aculate]

When I’ve imported from vb3.8.4, all of the users inherited the default privacy options. I need to update some default options:

I want the option ‘View this user's profile page details’ to be ‘Members only’

same for ‘Receive this user's news feed’ and ‘View this user's identities’. They all need to be changed to ‘Members only’


How do I do that in a batch? Or, what are the queries I need to launch?


Thanks

 

[Chris D]

UPDATE xf_user_privacy SET allow_view_profile = 'members', allow_receive_news_feed = 'members', allow_view_identities = 'members'

 

[aculate]

UPDATE xf_user_privacy SET allow_view_profile = 'members', allow_receive_news_feed = 'members', allow_view_identities = 'members'

worked like a charm! thanks