XF 1.3 Change Privacy options in a batch


Well-known member
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?


Chris D

XenForo developer
Staff member
UPDATE xf_user_privacy SET allow_view_profile = 'members', allow_receive_news_feed = 'members', allow_view_identities = 'members'