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