On Mon, 24 Feb 2003, Anthere wrote:
Ok, if nobody wants to help me on that, could someone just tell me...a sort of sql query...which would allow me to get a list of the last deletions, with direct access to the article in the bin (something like the deletion log but with access to the deleted articles)
The archive table (which holds deleted pages) does not keep track of when articles were deleted. Currently the only way to see when a page was deleted was to look in the deletion log, which currently provides no connection to the undelete system.
Yeah, it sucks.
What I've suggested before, and if I have time I'll try to implement it, but it'd be lovely if someone else got to it because I'm stretched a little thin right now, is to have a deletion log _table_. (Or perhaps a general 'event log' which also keeps track of bans, protections, unbans, unprotections, creation of user accounts, sysopization, etc; of which we can extract just deletions for purposes of showing a deletion log).
This could then be easily sorted by timestamp or by deleting user, and for sysops a link to the undelete could be made instantly available.
-- brion vibber (brion @ pobox.com)