XF 1 Tip Set user privacy options using SQL queries

[ENXF NET]

LQD 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.

UPDATE xf_user_privacy SET allow_view_profile = 'members';
UPDATE xf_user_privacy SET...

Read more about this resource...