greggles

<?phpprint "<dl>";$nodes = db_result(db_query("SELECT COUNT(1) FROM {node}"));print "<dt>Content (nodes):</dt><dd>". $nodes ."</dd>";$users = db_result(db_query("SELECT COUNT(1) FROM {users}"));print "<dt>Users:</dt><dd>". $users ."</dd>";$comments = db_result(db_query("SELECT COUNT(1) FROM {comments}"));print "<dt>Comments:</dt><dd>". $comments ."</dd>";$projects = db_result(db_query("SELECT COUNT(1) FROM {project_projects}"));print "<dt>Total projects:</dt><dd>". $projects ."</dd>";$issues = db_result(db_query("SELECT COUNT(1) FROM {node} WHERE type = 'project_issue'"));print "<dt>Total issues:</dt><dd>". $issues ."</dd>";$followups = db_result(db_query("SELECT COUNT(1) FROM {project_issues}"));print "<dt>Followups on Issues:</dt><dd>". $followups ."</dd>";print "</dl>";print "<h3>Search terms on Drupal.org</h3>";$result = db_query("select message, count(message) as count from watchdog where type = 'search' and uid = 0 group by message order by count desc limit 10");print '<div class="column-left"><h2>Anonymous users</h2><ul>';while ($s = db_fetch_object($result)) {  preg_match('!<em>(.*?)</em>!', $s->message, $matches);  print '<li>'. $matches[1] .' ('. $s->count .')</li>';}print '</ul></div>';$result = db_query("select message, count(message) as count from watchdog where type = 'search' and uid != 0 group by message order by count desc limit 10");print '<div class="column-right"><h2>Authenticated users</h2><ul>';while ($s = db_fetch_object($result)) {  preg_match('!<em>(.*?)</em>!', $s->message, $matches);  print '<li>'. $matches[1] .' ('. $s->count .')</li>';}print '</ul></div>';?>