How to do a notification configuration for all users

[Gabriel Torres]

Is there a way to set a given notification configuration to all users in the database?

For instance (just an example), I want to change the "When someone likes something I posted" notification from all users to "notification list" instead of "email". How can I do that? Maybe through an SQL query?

[MADMAN32395]

Could start by changing the setting in Members>Member Settings> Notifications ; change the ones you want to notification instead of email. making sure to disable end user editing.

[Gabriel Torres]

@MADMAN32395 already did that, but that only applies to new members. I want to change that for all current members.

[MADMAN32395]

4 minutes ago, Gabriel Torres said:

@MADMAN32395 already did that, but that only applies to new members. I want to change that for all current members.

something like this?

UPDATE core_notification_preferences SET preference='inline' WHERE notification_key='new_likes';    

that should target everything for new likes, applying to onsite notifications to all users.

 

would recommend backup before running queries directly. 

[Gabriel Torres]

Yes, exactly this, I just needed to know the name of the table!