update book contributors to show pages created and revisions created [#81344]

On http://drupal.org/node/14205 there is a list of users who have created pages in the handbook. I think it would be more complete to know how many pages they've created and how many pages they've edited (e.g. revisions with them as the uid). The following query creates such a list of revision counts, uid, and name:

SELECT COUNT(1), nr.uid, users.name FROM node_revisions nr INNER JOIN node ON nr.nid = node.nid INNER JOIN users ON nr.uid = users.uid WHERE node.type = 'book' GROUP BY nr.uid, users.name;

I'm posting this as an issue because I'd like to update/edit that page but I'm not a php editor (and this is not an attempt to request php editor access). If someone with proper permissions can send me the php inside that node than I'd be happy to edit/update it and resubmit.

Comments

Comment #1

michelle

she/her

English

Wisconsin, USA

commented 26 October 2006 at 21:32

+1 from me. I keep losing track of pages I've worked on. They don't show up in my tracker unless I created the node, even if all that was there before was a simple stub. I'd love to have a list of pages that I've contributed to for my own reference, even if they don't want to make that public.

Michelle

Comment #2

greggles

he/him

English

Denver, Colorado, USA

commented 27 January 2007 at 19:16

Just to clarify (michelle and I discussed this in IRC, but that doesn't help others) this would only show the number of nodes edited, not the nid/title of them.