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?).
- 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)