[documentation] [Documentation feature] update book contributors to show pages created and revisions created

greggles drupal-docs at drupal.org
Tue Aug 29 17:15:43 UTC 2006


Issue status update for 
http://drupal.org/node/81344
Post a follow up: 
http://drupal.org/project/comments/add/81344

 Project:      Documentation
 Version:      <none>
 Component:    Misc
 Category:     feature requests
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  greggles
 Updated by:   greggles
 Status:       active

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.




greggles



More information about the documentation mailing list