Home

Fix for quicky statistics for drupal.org

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