MyBB Community Forums

(2011-05-19, 06:33 PM)Sukanjan.K Wrote: [ -> ]

(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?

Mass mail only selects users who have enabled to receive emails. So to get an accurate count the same as mass mail try this query:

SELECT COUNT(*) FROM `mybb_users` WHERE postnum = '0' AND allownotices=1;

Also the post count field expects numbers only. If you enter any text there like zero or whatever else, it will change to 0 since the value is intval'd

In the first post you said that the # of users with 0 posts is actually 448, where did you count that from? If it was from a custom view its probably skipping banned or awaiting activation users.