Resource icon

XF 1 Tip Set user privacy options using SQL queries

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
24,438
Points
823

Reputation:

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.

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

Read more about this resource...
 
Top