Consider images that are currently nominated for deletion as patrolled

[nicolas-raoul]

They have obviously been seen by an experienced user already, so they should be considered as patrolled.

[Steinsplitter]

Files seen by an experienced users are marked as patrolled.

[nicolas-raoul]

If a file has already been nominated for deletion, showing it in newbie-uploads is not useful, right?

Let's consider a scenario where among the 50 first images, 10 are clearly bad. I open the 10 clearly bad images, and discover that all 10 have already been nominated for deletion. In that scenario, I wasted my time checking these 10 images. The tool should have hidden these already nominated images, so that I can focus on the other images. Am I being clearer?

[zhuyifei1999]

@Steinsplitter WHERE rc_cur_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_namespace = 10 AND tl_title IN (<speedy template>, <dr template>, <no source/license/permission templates>) LIMIT 1)?

[Steinsplitter]

@zhuyifei1999: The problem is that it will make the tool slower.

[nicolas-raoul]

How much time does the query for 30 images take before/after this addition, on average?

#13 would make newbie-uploads feel much faster, so implementing both #4 and #13 at the same time would make it both faster and more useful.

[Steinsplitter]

you'r welcome to submit pull requests :-)

[nicolas-raoul]

I would love to participate in the coding!
I am already developing for so many open source projects, though (mostly Java/C# rather than web/PHP), so I thought I would just write down some ideas, hoping that some volunteers would jump in :-)

Similar possible enhancement: Hide deleted files. No need to patrol them, obviously. I don't know whether that is easy to detect via SQL, but they seem to appear like this: