Set user privacy options using SQL queries

[Bi0S Emerald Member Posts:12,183 Threads:12,128 Reputation 31]

Compatible XF Versions:

• 1.0
  
• 1.1
  
• 1.2
  
• 1.3
  
• 1.4
  
• 1.5
  

This resource is not affiliated with XenForo Ltd.

These queries will update the privacy preferences for all existing members, overriding what they have already set.

These queries would typically be used after an import to reset any incorrect or unwanted values.

Copy and paste the code below into phpMyAdmin.

The following settings will change all privacy options to members only.

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

To change it to all visitors, replace members with everyone.
To change it to followed members, replace members with followed.

To change the settings for all new registrations:
ACP -> Options -> User Registration -> Default Registration Values