On Fri, Aug 27, 2004 at 09:50:01AM +0200, Jakob Voss wrote:
Hi,
seems like nobody is interested in providing the users of a offline CD version with a list of authors for each article like required by GFDL?
I wrote
All users should be listed - but not the IP-numbers of anonymous posts! ... INSERT INTO has_edited SELECT DISTINCT old_user_text AS user, old_title AS article FROM old WHERE old_namespace=0
INSERT INTO has_edited SELECT cur_user_text AS user, cur_title AS article FROM cur WHERE cur_namespace=0
SELECT DISTINCT user FROM has_edited WHERE article='ArticleYouWantTheAuthorListFor'
Should work, but IPs need to be filtered out. I still do not know how to count the number of edits by anonymous users.
Why do you need an extra table?
SELECT DISTINCT old_user_text FROM old WHERE old_namespace=0 AND old_title='ArticleYouWantTheAuthorListFor' AND old_user_id != 0;
should do the job. (IP's have old_user_id=0)
Regards,
jens