Cyril DANGERVILLE wrote:
I encountered a few issues listed below, regarding the
timestamps in a
mediawiki database (I am running MediaWiki 1.6.7), when writing an
extension that looks for the user that added a specific category link.
This can't really be done reliably. Even if you trawl through all previous
revisions, the link may have been introduced by a change in an included
template, and thus not related to any revision at all. It may also have been
removed and returned multiple names.
Indeed, the only efficient way I've found is to
compare cl_timestamp
and rev_timestamp in the database (any better idea?).
1) Is there a specific reason why the *cl_timestamp* column of the
*categorylinks* table has a different type from the *rev_timestamp*
column of the *revision* table (or page_touched of the page table)?
cl_timestamp was experimental, and is probably more or less useless for any
non-trivial purpose. Likely it will be removed in the future.
It doesn't necessarily have any relation to any particular revision, since link
status is based on the combined state of all included resources (primary page,
included templates, extension parsing).
-- brion vibber (brion @
pobox.com)