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

XF 1.2 mySQL set all members to viewable by visitors

Discussion in 'XenForo Questions and Support' started by cmeinck, Aug 27, 2013.

  1. cmeinck

    cmeinck Well-Known Member

    In my continuing efforts to battle spam, I had set the default profile view to "Members Only". I've set the members template to noindex to remove thin content from Google. The trouble here is that the member page won't render the noindex if it's viewable by members only. I think at this point, my best option would be to reset accounts to viewable by visitors, run the sitemap and have Google deindex any remaining pages from their index.

    Is there a mySQL query to set all members to be viewable by visitors?

  2. fury

    fury Member

    Looking at my own database, this ought to do it:

    UPDATE xf_user_privacy SET allow_view_profile = "everyone";

    Make a backup of that table beforehand, just in case.

Share This Page