Home

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.  
  14. $projects = db_result(db_query("SELECT count(1) FROM {project_projects}"));
  15. print "<dt>Total projects:</dt><dd>". $projects ."</dd>";
  16.  
  17. $issues = db_result(db_query("SELECT COUNT(1) FROM {node} WHERE type = 'project_issue'"));
  18. print "<dt>Total issues:</dt><dd>". $issues ."</dd>";
  19.  
  20. $followups = db_result(db_query("SELECT COUNT(1) FROM {project_issues}"));
  21. print "<dt>Followups on Issues:</dt><dd>". $followups ."</dd>";
  22.  
  23.  
  24. ?>
  25. </dl>