SQL query to set certain options

[fredrikse]

Hi,

I wonder what SQL query I can use to enable all options below, for each and every user?

 

[fredrikse]

Here's another option that I would like to enable and set to "member" with a query:

 

[Jake Bunce]

For the default watch state:

UPDATE xf_user_option
SET default_watch_state = 'watch_email';

Or:

UPDATE xf_user_option
SET default_watch_state = 'watch_no_email';

Depending on if you want emails too. Note that this preference is not retroactive to existing threads.

For the rich editor:

UPDATE xf_user_option
SET enable_rte = 1;

For showing signatures:

UPDATE xf_user_option
SET content_show_signature = 1;

For online status:

UPDATE xf_user
SET visible = 1;

You can set the default prefs for new users here:

Admin CP -> Home -> Options -> User Registration -> Default Registration Values

 

[Jake Bunce]

For "accept conversations":

UPDATE xf_user_privacy
SET allow_send_personal_conversation = 'members';

 

[fredrikse]

Jake, you're the man!

Thanks a lot for your help. This was exactly what I was looking for. This weekend I'm about to migrate my vBulletin forum and my intention is to set a few of these values for all members and then hide them to prevent them from being altered again. Some of these options might come back later on in a different membership package.

 

[fredrikse]

I just discovered a problem. When I use TMS to control the visibility of certain settings with permission groups it also effects what information is being stored in the database. Those settings that are not visible when I save a visible setting, is not getting stored. How can I handle this?

 

[Jake Bunce]

You probably want to turn those fields into hidden input fields so their values are still present in the form:

<input type="hidden" name="fieldname" value="value" />

 

[fredrikse]

That did it!

<input type="hidden" name="fieldname" value="value" />

I also added this code to prevent these hidden fields from being active when a user is member of a group that will allow these options to be set:

en:if is="!{xen:helper ismemberof, $visitor, 12}">
<input type="hidden" name="allow_view_profile" value="members" />
<input type="hidden" name="allow_post_profile" value="members" />
<input type="hidden" name="allow_receive_news_feed" value="members" />
<input type="hidden" name="allow_send_personal_conversation" value="members" />
<input type="hidden" name="allow_view_identities" value="members" />
</xen:if>

 

[rosal]

This sql for the option Show your current activity

UPDATE xf_user 
SET activity_visible = 1;