Special:Badtitle/NS90:User talk:Olicool10/Thank you for updating so many lost files!/reply (6)

"Unused files" means something different: files that the database thinks is uploaded but which aren't used in any pages. "Wanted files" also means something different: files that are used in pages but which have never been uploaded. Neither precisely reflects the set we're trying to fix: files that the database thinks is uploaded but which don't exist in the upload folder. Category:Pages with broken file links is probably what you want but isn't updated in real time; the server operator has to  from a shell account.

Since the move to Miraheze, I've been maintaining a private backup of All The Tropes (and two much smaller wikis hosted elsewhere) in order to allow recovery should another Orain-type disaster happen. I originally wrote this tool in 2012 for creating a downloadable HTML archive of a much smaller wiki, but I know ATT is much too big for that. In fact, throughout January, I added numerous enhancements to the backup tool to make its API usage more efficient at handling wikis with hundreds of thousands of pages and scores of edits per day. About a week ago, my backup of the text of ATT became complete enough to allow running a report that guesses plausible targets for red links.

Today I finished the efficiency enhancements on the image code, which let me begin to add images to the ATT backup. A side effect is that I slowly collect statistics on which of the 52,000+ images in the database are. Depending on how much scrape time I can scrounge, I should have the report by the middle of next week at the latest.