I would not want to claim the credit. :-)
This was done the wiki-way, as an interesting tangent from discussion at < https://commons.wikimedia.org/wiki/Commons:Village_pump#Better_watchlisting%.... The final SQL is mostly Bawolff's experience, and I happen to be playing around with SQL to support the Wellcome Images upload project I'm spending most of my volunteer time on, thanks to some prompting to get more value from the wiki database from Steinsplitter. When communities use wikis to work together, it sure speeds up this sort of response compared to working it all out by yourself.
Fae
On 17 October 2014 15:02, Risker risker.wp@gmail.com wrote:
Thanks very much for developing this Fae, it's a great idea.
Risker/Anne
On 17 October 2014 03:37, Fæ faewik@gmail.com wrote:
Due to recent vandalism a new report on Commons for page patrollers has been started at https://commons.wikimedia.org/wiki/User:F%C3%A6/BLP_overwrites.
This page shows images actively used on English Wikipedia biography articles, where a new upload has overwritten the original by a "newbie"* account. The report should be automatically refreshed within 15 minutes of a new image upload/overwrite of this type.
Instances of deliberate image vandalism of this type are rare, but important to handle promptly. If you have suggestions for improvement of this report, I would be happy to do my best to accommodate them.
Notes:
- For convenience newbie accounts have been arbitrarily taken as
accounts with fewer than 200 edits on the English Wikipedia or fewer than 100 edits on Wikimedia Commons.
- The report is maintained by Faebot and should be considered in a
draft state as it may be moved to a more 'official' location or be taken on by more skilled bot operators.
Cheers, Fae -- faewik@gmail.com https://commons.wikimedia.org/wiki/User:Fae
Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/wiki/Mailing_lists/Guidelines Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe
Wikimedia-l mailing list, guidelines at: https://meta.wikimedia.org/wiki/Mailing_lists/Guidelines Wikimedia-l@lists.wikimedia.org Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe