Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+2 votes
657 views
in Q2A Core by
edited by
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.
Q2A version: 1.7.1
by
lol, getting a "new" idea and finding my own post. God, I am overworked :)

1 Answer

0 votes
by
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,
...