ALERT!
Click here to register with a few steps and explore all our cool stuff we have to offer!
Home
Upgrade
Credits
Help
Search
Awards
Achievements
 7838

Set user privacy options using SQL queries

by Bi0S - 05-04-2017 - 03:09 AM
#1
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
Reply

Users browsing: 1 Guest(s)