Last modified: 2010-05-15 15:33:55 UTC
Add a checkbox in Special:Newimages to hide file uploaded by bots (especially on commons with MarketDataBot spamming ;)
especially for the dreadful Weather Bot on Commons
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.