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

Assigned To
None
Priority
Lowest
Author
bzimport
Subscribers
wikibugs-l
Projects
Reference
bz1956
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
bzimport added a comment.Via ConduitJul 12 2005, 8:07 AM

mail wrote:

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

Column Prototype
This is a very early prototype of a persistent column. It is not expected to work yet, and leaving it open will activate other new features which will break things. Press "\" (backslash) on your keyboard to close it now.