1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 Change Privacy options in a batch

Discussion in 'Installation, Upgrade, and Import Support' started by aculate, Apr 23, 2014.

  1. aculate

    aculate Well-Known Member

    When I’ve imported from vb3.8.4, all of the users inherited the default privacy options. I need to update some default options:

    I want the option ‘View this user's profile page details’ to be ‘Members only’

    same for ‘Receive this user's news feed’ and ‘View this user's identities’. They all need to be changed to ‘Members only’


    How do I do that in a batch? Or, what are the queries I need to launch?


    Thanks
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    Code:
    UPDATE xf_user_privacy SET allow_view_profile = 'members', allow_receive_news_feed = 'members', allow_view_identities = 'members'
     
    aculate likes this.
  3. aculate

    aculate Well-Known Member

    worked like a charm! thanks
     

Share This Page