XF 1.2 mySQL set all members to viewable by visitors

[cmeinck]

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?

Thanks.

 

[fury]

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.