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.
By the way getting all the author of an article should be a feature in
MediaWiki too.
Greetings
Jakob
P.S: How long does it take to set up a copy of the whole german (all
tables, also users!) for an endreview process? Yes it will be a fork but
only a short one to be able to delete all URVs, images without copyright
statement, portal pages and things like that.
P.P.S: If the SQL-Statement stuff for detecting the authors does not
work we could use a bot that requests the history, creates the list of
authors and puts it at the discussion page - wie do not want to include
the discussion pages at the CD in any case.