-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Guess Who? wrote:
--- On Wed, 10/29/08, Brion Vibber wrote:
Figuring out how to get something other than a raw list of thousands of editors for a "nice" author list remains a harder task. :)
wouldn't that be a snap using the group_by function? sorry, I don't know the database structure, but generically:
SELECT contributors, COUNT(*) FROM database GROUP BY contributors
would return a list of all contributors and the number of contributions they've made; it could be tweaked to return only those contributors who've made over X contributions. of course, I've only worked on small databases, so I have no idea what the overhead on this would be...
Making a lot of edits to the page doesn't necessarily mean you've contributed a lot of text to it. It might mean you've vandalized it a lot (always reverted) or that you've reverted a lot of vandalism.
- -- brion