--- 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
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.8 (Darwin)
Comment: Using GnuPG with Mozilla -
http://enigmail.mozdev.org
iEYEARECAAYFAkkLQMsACgkQwRnhpk1wk472twCfVfr4chZnBPS/MBP31H7zI+p7
r/kAoKd40ULM0rBBMPF8ZwxqyHNO//hK
=NdkQ
-----END PGP SIGNATURE-----