Default Privacy Settings

I have searched the site and seem to have no luck.. I saw one post saying its under default_group but still can't find it.

I would like every member who signs up to have their privacy settings set to 'Friends' but I can't do it.

In MySQL I have changed: 

_ps_view_block to 5 - no luck.

and

bx_groups_privacy_view_group - no luck

Anyone know how I can do it?

Hello

You may change the default group on My Account -> Privacy Settings -> Default Privacy Group block. But this change with be done for current member only. 

If you want that Friends was a privacy setting selected by default for all newly joined members then you need to do the following. I will give an example for "Who can view my profile page".

1. You need to go to Dolphin database using phpMyAdmin.

2. Open structure of Profiles table and edit "allow_view_to" field. 

3. Change the default value 3 to 5 and save it. 

So, all newly goined members will have Friends in "Who can view my profile page". You may check it on Profile Edit page, 

If you need you may do the same for the other content like Albums (sys_albums table -> AllowAlbumView setting) and so on.

@Anton

is there a way to make the albums as default public.

What I mean is that if someone post a photo at groups, wall etc then it shows that lock icon and I want to get it away.

Thanks :-)

at the sql sys_albums at Null is set to NO. If I set to yes is then the value default 3 no matter what?

or is there a way to run UPDATE sys_albums SET     AllowAlbumView = '3' WHERE AllowAlbumView = '5' automatically?

Would be nice if there was an add-on module to provide Admin's with a way to set the Default Privacy Settings, wherever they can be set, for all NEW members.  Thereafter each member can adjust them as they wish.  As far as I can see the core modules don't provide such a tool and I've yet to see an add-on modules that can do it.

 I changed my mind... Anton's solution (stated above) works just fine... no special mod is needed.

I was looking in the database to adjust the privacy of all the new albums, but can't find it.
I want that the privacy level of all the new members is set to friends. ( so all the photo's are as default viewable for friends )

I looked in sys_albums but there are a lot of albums ( i think from all the current members ).
But i found no where a place to adjust the privacy level to friends incept of me only ( currently it's set to me only )

How can i do that?