The number of active installations is going to be really hard to get right, at least if others behave as I do. I have 14 installs that are probably in your count but only 7 of them are real sites with outside users. The others are all test or build sites. They aren't even visible enough to attract spammers. But perhaps I only get a count of one, because I have a copy of 5.7 that I ftp to a site to get it started. I don't get a new copy for each site. Perhaps there could be some module that is installed as part of core that makes something visible enough to Google that you can use a count of it to count active installs. Then ask people who install test accounts to turn off that module. Put a message in the Status report that forces admins to at least visit a page and given the opportunity to get it right. -----Original Message----- From: development-bounces@drupal.org [mailto:development-bounces@drupal.org] On Behalf Of Angela Byron Sent: Sunday, May 18, 2008 1:42 AM To: development@drupal.org Subject: [development] Compiling Drupal statistics As tends to happen every 6 months or so, I got asked to compile some statistics about Drupal: number of active installations, number of users on drupal.org, stuff like that. Each time I try to figure this out it's a time-sink of hours and hours and hours. :( And I think most of us get asked to compile this information from time to time as well, either on behalf of our bosses or because we're giving a presentation somewhere, or whatever. So this time, I threw all the queries I was running into a .php file @ tricks/drupal_org_statistics. Per killes, I did not create a new permanent PHP page for these statistics on drupal.org, but I did run this in a PHP node preview and it came up with the following: http://cvs.drupal.org/viewvc.py/drupal/contributions/tricks/drupal_org_stats /output-2008-05-18.html?revision=1.1&content-type=text%2Fhtml NOTE: There's a bug in the "# of active Drupal installations" query... the query that's giving me the list of most used modules reports about 486,000 active Drupal installations. Feel free to fix it if you figure out what the bug is. If you want to help improve this script, grab a copy of the drupal.org testing installation profile (http://drupal.org/project/drupalorg_testing) and commit any additional queries that you feel would be helpful for admins to compile on a semi-regular basis (SELECTs only, naturally :P). Incidentally, the module/Drupal usage stats will become publicly visible as soon as http://drupal.org/node/165380 has been reviewed and committed. Anyone who wants to become the next Drupal hero might want to jump on that. -Angie