MyBB Community Forums

Full Version: Send mass mail to user with 0 posts
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
How can send email to the users with 0 posts? At the Recipients condition page when I am selecting nothing in the Post Count field its selection 597 users, when I am selection less than 1 its selecting 544 users, when I put exactly 0 in the post count field its selecting 597 users. But none of them are right.

The actual numbers of the users having 0 post count is 448, any solution?
In "Post Count is" option, select "Is Exactly" and add zero in the option field (Not the number, it should be a word "zero" without quotes).
Putting the word "zero" selecting 544 users.
I just tested it on my test forum, and its selecting only zero posters.

Edit: I just tested it on yaldaram.com and yes its selecting only zero posters.
How can count the users with 0 posts from phpmyadmin?
Wait please, I'll write you query after testing.
SELECT * FROM `mybb_users` WHERE postnum = '0'
Run this;
SELECT COUNT(*) FROM `mybb_users` WHERE postnum = '0';
It'll return a count of rows effected with this query having postnum = zero.
(2011-05-19, 01:20 PM)Yaldaram Wrote: [ -> ]Run this;
SELECT COUNT(*) FROM `mybb_users` WHERE postnum = '0';
It'll return a count of rows effected with this query having postnum = zero.

Count is 556 in phpmyadmin but in Admin CP when I put "Zero"(without the quote) in post count section its selecting 544 users, why the difference?

Run the Recount and Rebuild Tools.
Pages: 1 2