XF 1.5 Receive Site Mailing Setting in Database?

[Joe Blow]

Where is the Receive Site mailings setting located in the Xenforo database?

Thanks for your help.

 

[Joe Blow]

OK, let me explain in a little more details what it is I would like to do.

I want to execute a SQL query that will change the Receive Site Mailings setting to off for members of a particular user group (#19).

Thanks to anyone who is able to assist.

 

[Joe Blow]

OK, I'm trying this

UPDATE xf_user_option
SET receive_admin_email = 0
WHERE user_group_id = 19

But getting this error message:

#1054 - Unknown column 'user_group_id' in 'where clause'

Is it because user_group_id is in another database table?

 

[Paul B]

Is it because user_group_id is in another database table?

Correct.
It's not as simple as that as user groups are stored as an array in a single field.

Why not just ask the members to update their preferences?

 

[Joe Blow]

Why not just ask the members to update their preferences?

Because it's an unsubscribed user group where users have basically left the forum and I don't want them getting any admin emails.

Is there any way to achieve this with a query?