Last modified: 2014-11-02 23:53:28 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-215. Summary: List of JavaScript/CSS editors Issue type: Task - A task that needs to be done. Priority: Major Status: Open Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Federico Leva <federicoleva@tiscali.it> Date: Tue, 03 Dec 2013 15:22:02 ------------------------------------------------------------------------------- For trivia and possibly concrete outreach/notification use, I'd like to have a query/script listing 1) all users on all wikis who edited pages of namespace 8 with title ending in .js or .css, 2) sorted by wiki and (if possible) number of edits, 3) ideally, in table format with current flag, e.g. Jalo itwiki 9999 sysop -
This query request is old. If you no longer require this query to be run, please close this bug as WONTFIX. Thanks!
This is still relevant. It would be easy to do, if only I knew how to list all dbnames with a query: a bash loop similar to for dbname in $WIKIS; do sql $dbname "select user_name from user JOIN user_groups on user_id = ug_user WHERE ug_group = 'sysop';" done; etc.
I'm interested to work on this. If you can provide a format (like "{| ! Username !! wiki !! edits !! rights |- | $username || $wiki || $edits || rights", please excuse me if that format isn't correct, but I don't really understand the one you provided), I'll try to generate a list.
(In reply to Southparkfan from comment #3) > I'm interested to work on this. Thanks! > If you can provide a format (like "{| ! > Username !! wiki !! edits !! rights |- | $username || $wiki || $edits || > rights", please excuse me if that format isn't correct, but I don't really > understand the one you provided), I'll try to generate a list. Any format is fine, a table as in your example is perfect.
Stats for all Wikipedias + Wiktionaries + Wikisources + Wikiquotes and Wikinews are done, see http://tools.wmflabs.org/southparkfan/w/index.php?title=Bug_59498 - I'll do the others soon.
@Nemo: all wikis done at http://tools.wmflabs.org/southparkfan/w/index.php?title=Bug_59498. Please let me know if you need something extra, or close this bug as fixed.
(In reply to Southparkfan from comment #6) > @Nemo: all wikis done at > http://tools.wmflabs.org/southparkfan/w/index.php?title=Bug_59498. Please > let me know if you need something extra, or close this bug as fixed. Thank you! There is something wrong in your counts, I'm pretty sure "MediaWiki message delivery" doesn't edit ns8; you probably counted ns9 too. If possible, it would be really helpful to have the wiki name repeated in each row, as you had proposed in comment 3. Otherwise I'll have to add it myself.
(In reply to Nemo from comment #7) > (In reply to Southparkfan from comment #6) > > @Nemo: all wikis done at > > http://tools.wmflabs.org/southparkfan/w/index.php?title=Bug_59498. Please > > let me know if you need something extra, or close this bug as fixed. > > Thank you! There is something wrong in your counts, I'm pretty sure > "MediaWiki message delivery" doesn't edit ns8; you probably counted ns9 too. It counted User(_talk):*.(css|js), so both ns8 and ns9.. fixing this. > If possible, it would be really helpful to have the wiki name repeated in > each row, as you had proposed in comment 3. Otherwise I'll have to add it > myself. Doing.
(In reply to Southparkfan from comment #8) > It counted User(_talk):*.(css|js), so both ns8 and ns9.. fixing this. Not really any of my business, but just pointing out that ns8 is MediaWiki:. User/User talk are ns2/ns3.