stats script

$fid = array();$result = db_query("SELECT fid, name FROM {profile_fields} WHERE category = 'drupal'");while ($field = db_fetch_object($result)) {  $fid[$field->name] = $field->fid;}$quarters = array(993970800,1001860032,1009749263,1017638495,1025527726,1033416958,1041306189,1049195421,1057084652,1064973884,1072863115,1080752347,1088641578,1096530810,1104420041,1112309273,1120198504,1128087736,1135976967,1143866199,1151755430,1159644662);$headers = array('Date', 'Nodes', 'Projects', 'Users', 'Comments', 'Developing Users', 'Support Users', 'Service Providers');$rows = array();foreach ($quarters as $timestamp) {  $row = array();  $row[] = format_date($timestamp);  $result = db_query('SELECT COUNT(nid) as count FROM {node} WHERE created < %d', $timestamp);  $query = db_fetch_object($result);  $row[] = $query->count;  $result = db_query("SELECT COUNT(nid) as count FROM {node} WHERE TYPE = 'project' AND created < %d", $timestamp);  $query = db_fetch_object($result);  $row[] = $query->count;  $result = db_query("SELECT COUNT(uid) as count FROM {users} WHERE created < %d", $timestamp);  $query = db_fetch_object($result);  $row[] = $query->count;  $result = db_query("SELECT COUNT(cid) as count FROM {comments} WHERE timestamp < %d", $timestamp);  $query = db_fetch_object($result);  $row[] = $query->count;  // these could be expanded for more interesting demographics  $result = db_query("SELECT COUNT(u.uid) as count FROM {users} u INNER JOIN {profile_values} p ON u.uid = p.uid WHERE u.created < %d AND (p.fid = %d OR p.fid = %d) AND p.value = 1", $timestamp, $fid['drupal-module-developer'], $fid['drupal-theme-developer']);  $query = db_fetch_object($result);  $row[] = $query->count;  $result = db_query("SELECT COUNT(u.uid) as count FROM {users} u INNER JOIN {profile_values} p ON u.uid = p.uid WHERE u.created < %d AND p.fid = %d AND p.value = 1", $timestamp, $fid['drupal-support']);  $query = db_fetch_object($result);  $row[] = $query->count;  $result = db_query("SELECT COUNT(u.uid) as count FROM {users} u INNER JOIN {profile_values} p ON u.uid = p.uid WHERE u.created < %d AND p.fid = %d AND p.value = 1", $timestamp, $fid['drupal-services']);  $query = db_fetch_object($result);  $row[] = $query->count;  $rows[] = $row;}echo theme('table', $header, $rows);