Develop with Drupal links

Jen has had a chance to see this code with #371970: Move Drupal.org activity block?

Commits this week is currently counting all time.

If everything is timeboxed to a set number of days, the content can be more simple:

*In the last 7 days*
1409 commits by 248 people
# issue comments by # people

Is the query for the commits/people.
select count(*), count(distinct cvs_user) from cvs_messages WHERE created > unix_timestamp() - 7*24*60*60;

I wasn't sure how to deal with all the new content with the old layout, so I just split the list on the left of the 'Develop with Drupal' box into two lists. One for "Current activity" and one for "This week". Let me know if you'd prefer something else.

A few notes:
- The API for CVS activity (#371958: Expose necessary CVS activity statitics for use on d.o) does not include the number of committers, so I left that out
- For consistency's sake, I also dropped the number of people from the "# issue comments by # people".
- The module and theme counts do not currently reflect D6 and D7 only (although crazier queries are in comments, for review)

Here's what I'm using now for all modules:

"SELECT COUNT(distinct p.nid) FROM {project_projects} p INNER JOIN {term_node} tn ON p.nid = tn.nid WHERE tn.tid = 14"

Here's something like what we'd need for just D6 and D7 modules:

SELECT COUNT(distinct prn.pid) FROM node n INNER JOIN project_release_nodes prn ON n.nid = prn.nid INNER JOIN term_node tn on prn.pid = tn.nid WHERE tn.tid = 14 AND prn.version_api_tid IN (87, 103);

If it's important to limit the number of modules to D6 and D7, I'd love another set of eyes on this query.

I think #4 is a good idea, with three small caveats: 1) I think we should start all of the first items with a #, 2) I think we should group together the "this week" #s, and 3) I think we should limit it to one # per line.

So, something like:
* 6,885 modules to choose from
* 857 themes to choose from
* 3,703 active developers this week
* 1,529 code commits this week
* 5,398 issue comments this week
* 52 new projects were created this week

Actually, after looking at that list, should we just separate out the items with "this week", so something more like:

There are currently:
* 6,885 modules
* 857 themes
This week there were:
* 52 new projects
* 3,703 active developers
* 1,529 code commits
* 5,398 issue comments

Also- I'm guessing that some of these #s are made up, as I can't see how it would be possible for 3k people to have 1500 commits...

OK- then I highly suggest not using "active developers" in the same line as "this week", since that would be a misplaced modifier and/or super confusing (currently it's the same as saying: this week there were 3k devs who had 1k commits)

Meaning we shouldn't start some lines with the number (not the # sign, sorry) rather than start some with a number and some with a description (i.e. 'there are...'), which is what you have in your last comment... ;-)

I reshuffled the layout a little and am calling it done.