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

Quickly and easily update all members.

  1. Brogan

    Brogan XenForo Moderator Staff Member

    Brogan submitted a new resource:

    Set user privacy options using SQL queries (version 1.0) - Quickly and easily update all members.

    Read more about this resource...
     
  2. Rudy

    Rudy Well-Known Member

    Since the import of our big board, I've noticed many of the profiles still have the default "everyone" setting, yet I do not want to upset any changes that a few members may have already made to tighten up their privacy. With that in mind, here is some altered SQL to at least get rid of the "everyone" flag:

    Code:
    UPDATE xf_user_privacy SET allow_view_profile = 'members' where allow_view_profile = 'everyone';
    UPDATE xf_user_privacy SET allow_post_profile = 'members' where allow_post_profile = 'everyone';
    UPDATE xf_user_privacy SET allow_receive_news_feed = 'members' where allow_receive_news_feed = 'everyone';
    ...and so on.
     
  3. timothy259856

    timothy259856 Active Member

    fast ND GREATE
     
  4. RoldanLT

    RoldanLT Well-Known Member

    UPDATE xf_user_privacy SET allow_view_profile = 'members';# 60835 rows affected.

    UPDATE xf_user_privacy SET allow_post_profile = 'members';# 11952 rows affected.

    UPDATE xf_user_privacy SET allow_receive_news_feed = 'members';# 60854 rows affected.

    UPDATE xf_user_privacy SET allow_send_personal_conversation = 'members';# 11954 rows affected.

    UPDATE xf_user_privacy SET allow_view_identities = 'members';# 60833 rows affected.

    :)
     

Share This Page