I would not want to claim the credit. :-)
This was done the wiki-way, as an interesting tangent from discussion at <
gt;.
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(a)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(a)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(a)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(a)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(a)lists.wikimedia.org
Unsubscribe:
https://lists.wikimedia.org/mailman/listinfo/wikimedia-l,
<mailto:wikimedia-l-request@lists.wikimedia.org?subject=unsubscribe>