XF 1.5 MySQL Query to Mass Unsubscribe Users From Admin Emails

[NURV]

Hi, I'd like to mass unsubscribe all of my users with less than X posts from receiving admin emails. The mass user edit page didn't have the admin email setting as an option I can change, so I'm needing to do this with a direct database query.

What would that query be? I'm not familiar enough with XenForo's database storage to know where this setting resides.

Thanks!

 

[Jake Bunce]

Run this query on your database:

UPDATE xf_user_option AS uo
SET uo.receive_admin_email = 0
WHERE uo.user_id IN (
	SELECT u.user_id
	FROM xf_user AS u
	WHERE u.message_count < 10
);

 

[NURV]

Thanks a lot!

 

[Sal Collaziano]

Would this same query apply for 2.1 as well?

 

[Kirby]

Yes.

 

[Sal Collaziano]

Yes.

Thank you!

 

[Chromaniac]

admin mails are basically sent through this section right? admin.php?users/email or is applies to other forms of mails as well? (i have never used this feature so just wondering)