xF1 Set user privacy options using SQL queries

  • Downloading from our site will require you to have a paid membership. Upgrade to a Premium Membership today!

    Dont forget read our Rules! Also anyone caught Sharing this content will be banned. By using this site you are agreeing to our rules so read them. Saying I did not know is simply not an excuse! You have been warned.

Radio

    ven0m

    ven0m

    Administrator
    Staff member
    Administrator
    Moderator
    Platinum
    xenForo 2.x.x
    xenForo 1.x.x
    Contributor
    vBulletin All Access Pass
    The Chest
    Verified
    Ultra Platinum VIP
    Platinum VIP
    Gold VIP
    Silver VIP
    Premium
    Member
    Jul 17, 2005
    20,503
    7,742
    321
    localhost
    Heisenberg submitted a new resource:

    You must be registered for see links
    - Set user privacy options using SQL queries

    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...
    Click to expand...

    You must be registered for see links
     
    You must log in or register to reply here.
    Thread starter Similar threads Forum Replies Date
    ven0m xF1 Rebuild user post counts (query) Tips & Guides 0
    ven0m xF1 Creating custom user group banner CSS Tips & Guides 0
    ven0m xF1 Adding a Privacy Policy page to your website Tips & Guides 0
    Similar threads
    Top Bottom