On Thu, 31 Mar 2005 04:44:05 -0800, Brion Vibber brion@pobox.com wrote:
- Deleted revisions will remain listed in the contributions history
(though greyed out and in strike-through), making it easier to track serial offenders.
- Deleted revisions will be listed in the regular page history (again,
grayed out and in strike-through). In cases where individual revisions have been struck from a page for eg copyright reasons this will make it easier to see where portions were removed.
I think this will be a bit confusing. I suggest only showing them if *any* of these conditions are true: * The user has set deleted revisions to appear in their preferences (i.e. they are very much into anti-vandalism and editing) * The user is a sysop (since they ought to be looking at that sort of thing often, and it's functional to them as they can read the deleted revision) * The user or anonymous user has written one of the deleted revisions
The third query might be expensive. Something like
SELECT 1 FROM `revision` WHERE `rev_page` = {int} AND `rev_deleted` = 1 AND `rev_user` = {string} LIMIT 1
(taking the number of rows)
So, um, depending on how this is indexed, it migh not be worth it, in which case show everybody these revisions.
Will a deleted page simply have every revision marked with rev_deleted? Will you add page_deleted to speed things up (such as checking whether an article exists)? Is there still an archive tablem, solving that problem somewhat?