";
$nodes = db_result(db_query("SELECT COUNT(1) FROM {node}"));
print "Content (nodes):". $nodes ."";
$users = db_result(db_query("SELECT COUNT(1) FROM {users}"));
print "Users:". $users ."";
$comments = db_result(db_query("SELECT COUNT(1) FROM {comments}"));
print "Comments:". $comments ."";
$projects = db_result(db_query("SELECT COUNT(1) FROM {project_projects}"));
print "Total projects:". $projects ."";
$issues = db_result(db_query("SELECT COUNT(1) FROM {node} WHERE type = 'project_issue'"));
print "Total issues:". $issues ."";
$followups = db_result(db_query("SELECT COUNT(1) FROM {project_issues}"));
print "Followups on Issues:". $followups ."";
print "";
print "Search terms on Drupal.org
";
$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 'Anonymous users
';
while ($s = db_fetch_object($result)) {
preg_match('!(.*?)!', $s->message, $matches);
print '- '. $matches[1] .' ('. $s->count .')
';
}
print '
Authenticated users
';
while ($s = db_fetch_object($result)) {
preg_match('!(.*?)!', $s->message, $matches);
print '- '. $matches[1] .' ('. $s->count .')
';
}
print '