Last modified: 2007-05-14 21:54:41 UTC
When investigating problematic users, or users with OTRS complaints about deleted articles with incorrectly remembered titles, it would be very useful to be able to review (either separately or within the user's edit history) edits to deleted articles. Obviously this is only of any use to sysops, and should probably not even appear as an option for others, but it would make a lot of user issues much easier to investigate and control.
I've already written an extension for this, but there is one problem. The archive table is not indexed by username, so any queries would just time out and crash the site. Only small wikis, it would be OK, but not a large one like en wikipedia. *What* can be done is a hack, would be to borrow the checkuser RC table (which keeps deleted entries) and join where cuc_namespace,cuc_title has no corresponding page_namespace,page_title.
*** This bug has been marked as a duplicate of 1699 ***