Feature: Number of email / newsletter recipients

Question

It would be great if the statistics would show the number of email / newsletter recipients, I mean all users that are subscribed.

This has just to be calculated, in my opinion, when the admin opens the statistics page.

Defined is: define('QA_USER_FLAGS_NO_MAILINGS', 32);

For now, the query to get the count of subscribed users should be:

SELECT COUNT(userid)
FROM `qa_users`
WHERE BINARY flags != BINARY 32;

However, I am not sure if this is the correct bit flag comparision. Any comment appreciated.

Comments

lol, getting a "new" idea and finding my own post. God, I am overworked :)

Answer 1

How disable emails spam, account is disabled, user is terminated in mysql users options?

('QA_USER_FLAGS_NO_MAILINGS', 32);

Аccount is disabled, user is terminated auto disable email,