Home

Fix for quicky statistics for drupal.org

November 9, 2007 - 2:22pm — Anonymous
  1. <?php
  2. print "<dl>";
  3. $nodes = db_result(db_query("SELECT COUNT(1) FROM {node}"));
  4. print "<dt>Content (nodes):</dt><dd>". $nodes ."</dd>";
  5.  
  6. $users = db_result(db_query("SELECT COUNT(1) FROM {users}"));
  7. print "<dt>Users:</dt><dd>". $users ."</dd>";
  8.  
  9. $comments = db_result(db_query("SELECT COUNT(1) FROM {comments}"));
  10. print "<dt>Comments:</dt><dd>". $comments ."</dd>";
  11.  
  12. $projects = db_result(db_query("SELECT COUNT(1) FROM {project_projects}"));
  13. print "<dt>Total projects:</dt><dd>". $projects ."</dd>";
  14.  
  15. $issues = db_result(db_query("SELECT COUNT(1) FROM {node} WHERE type = 'project_issue'"));
  16. print "<dt>Total issues:</dt><dd>". $issues ."</dd>";
  17.  
  18. $followups = db_result(db_query("SELECT COUNT(1) FROM {project_issues}"));
  19. print "<dt>Followups on Issues:</dt><dd>". $followups ."</dd>";
  20. print "</dl>";
  21.  
  22. ?>