• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.
Set user privacy options using SQL queries

Set user privacy options using SQL queries

XenForo Rocks

Team Member
Administrator
Moderator
+Lifetime VIP+
Contributor
ViP
True Member
Suppliers
Registered
#1
XenForo Rocks submitted a new resource:

Set user privacy options using SQL queries - Quickly and easily update all members.

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...
Read more about this resource...