Drupal.org user statistics

Events happening in the community are now at Drupal community events on www.drupal.org.
Amazon's picture
Posted by Amazon on June 29, 2007 at 4:29am

I don't believe these include anonymous users.

3637 - 1-day unique users
9380 - 7 -day unique users 9380
21916 - 30 day unique users
154677 -All unique users

Comments

I just started doing similar

Posted by catch on July 5, 2007 at 10:58pm
catch's picture

I just started doing similar for my site, is this:

$time_period = (time()-2592000);
$active_users = db_result(db_query('SELECT DISTINCT COUNT(uid) FROM {users} u where u.access >= %d', $time_period));

roughly how it was worked out? Or apache logs/awstats?

Roughly the same, but

Posted by drumm on July 15, 2007 at 4:24am
drumm's picture

Roughly the same, but directly at a DB prompt, no DISTINCT, and users.access is in a separate table since it is updated so often. There is probably a patch for that last bit on the issue queue, but I have no idea where.