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

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
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