Topic on Project:Support desk

No existing extension but can be done using MySQL.

Is is possible to either:

• Show a list of contributors (including IP addresses) with links to their user contributions pages.
• Show an entire list of non-admin/sysop contributors (including IP addresses) with all their contributions shown on the one page. (Non-sysop because on my wiki it otherwise would be too large a list...)

I used to have Extension:Contribution Scores but from memory it only took account of registered users.

Thanks.

this is specific enough, you would probably have to make it yourself.

Closest built un is special:activeusers

Thanks. That's helpful. I'll try to make a special page based on that one. I "just" need to get it to look for users since the year dot, and include IP addresses :-)

I don't need to look at this information regularly, so went for the easier option of saving a MySQL query to run periodically and paste into a wiki page.

SELECT CONCAT ("*[[Special:Contributions/", rev_user_text, "|", rev_user_text, "]] - {{#time:j/n/y|", 
rev_timestamp, "}} - ", COUNT(*), " edit(s) to [[{{namespace|", page_namespace, "}}", page_title, "]]")
FROM wm_revision  
INNER JOIN wm_page ON wm_page.page_id = wm_revision.rev_page
WHERE rev_user_text <> "MY USERNAME"  
GROUP BY CONCAT (rev_user_text, "-", rev_page)
ORDER BY rev_user_text, rev_timestamp

I had to create Template:Namespace using a #switch to convert the page_namespace numbers into their text equivalent.

note: the above query will probably stop working in 1.34 due to schema changes.

Thanks for the warning! :-)