• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.3 Change Privacy options in a batch

aculate

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

XenForo developer
Staff member
#2
Code:
UPDATE xf_user_privacy SET allow_view_profile = 'members', allow_receive_news_feed = 'members', allow_view_identities = 'members'