Last modified: 2010-05-15 15:33:55 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T3956, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 1956 - Hide bot's upload in Special:Newimages
Hide bot's upload in Special:Newimages
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
1.4.x
All All
: Lowest enhancement with 2 votes (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2005-04-23 11:22 UTC by FoeNyx
Modified: 2010-05-15 15:33 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description FoeNyx 2005-04-23 11:22:13 UTC
Add a checkbox in Special:Newimages to hide file uploaded by bots (especially on
commons with MarketDataBot spamming ;)
Comment 1 Andreas Praefcke 2005-07-12 08:07:57 UTC
especially for the dreadful Weather Bot on Commons
Comment 2 Ævar Arnfjörð Bjarmason 2005-07-18 21:20:10 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links