Hide bot's upload in Special:Newimages
Closed, ResolvedPublic

Description

Author: foenyx

Description:
Add a checkbox in Special:Newimages to hide file uploaded by bots (especially on
commons with MarketDataBot spamming ;)


Version: 1.4.x
Severity: enhancement

bzimport added a project: MediaWiki-Special-pages.Via ConduitNov 21 2014, 8:18 PM
bzimport added a subscriber: wikibugs-l.
bzimport set Reference to bz1956.
bzimport created this task.Via LegacyApr 23 2005, 11:22 AM
AndreasPraefcke added a comment.Via ConduitJul 12 2005, 8:07 AM

especially for the dreadful Weather Bot on Commons

bzimport added a comment.Via ConduitJul 18 2005, 9:20 PM

avarab wrote:

The query needed for getting the latest non-bot uploads is:

SELECT
img_size,img_name,img_user,ug_group,img_user_text,img_description,img_timestamp
FROM image LEFT OUTER JOIN user_groups ON img_user=ug_user AND ug_group='bot'
WHERE ug_group IS NULL LIMIT 49;

And the old query is:

SELECT img_size,img_name,img_user,img_user_text,img_description,img_timestamp
FROM image ORDER BY img_timestamp DESC LIMIT 49;

I can't be bothered to implement this now, maybe later.

Add Comment