wolph42 wrote:curious: what % is that of the total forum population?
I ran the following SQL and got 13,106 records (there are 24,409 users in the database table):
Code: Select all
select user_id, username from phpbb_users where user_posts = 0 and (user_lastvisit = 0 or user_lastvisit - user_regdate <= 30);
That statement prints one line for each record where there are no posts for the user and their last visit is either empty (zero) or within 30 days of their registration.
Someone that has registered within the last 30 days and hasn't posted yet would be in that list, so it's not entirely fair to include them in the count. I would need to limit the registration date to be more than 12 months ago and there are probably other criteria to look at as well (usernames registered but whose activation link was never clicked).
That means approximately 11,000 (possibly valid) users, but I expect the number would be a little less after applying those other criteria. The bottom of the main page says there are ~12,000 forum members, so I'm thinking it's not excluding as many as I did above, hence there
must be criteria that I should be factoring in that would bring the number up slightly...
Since we're on the topic, here's the distribution of posts and the number of users with that many posts (excluding no posts at all). I created this report when we were talking about changing the names of the ranks on the forum.
Code: Select all
Num of Posts NumUsers
1.. 25 5416
26.. 75 381
76.. 175 180
176.. 400 96
401.. 1000 51
1001.. 2500 25
2501.. 5000 5
5001..10000 3
10001..25000 2
25001..50000 0
50001..99999 0