logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

[Documentation feature] update book contributors to show pages created and : msg#00074

Subject: [Documentation feature] update book contributors to show pages created and revisions created
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

--
Pending work: http://drupal.org/project/issues/documentation/
List archives: http://lists.drupal.org/pipermail/documentation/



<Prev in Thread] Current Thread [Next in Thread>