Adding it on created pages is harder. Mediawiki
doesn't have any notion
of the "first edit" of a page, you'd need to query all the revisions to
get the oldest, which is not too efficient.
Yeah, but I think it could be doable. The time of first edit for an
article doesn't really change much, so it could be memcached (would
need to account for when a page is moved, or a revision deleted).
Also, the revision table is indexed on the rev_page and rev_id columns
respectively, so a query like this shouldn't be too bad:
$dbr =& wfGetDB( DB_SLAVE );
$row = $dbr->selectRow(
'revision',
'rev_timestamp',
array( 'rev_page' => $page_id ),
__METHOD__,
array( 'ORDER BY' => 'rev_id ASC' )
);
if ($row) { doWhatever($row->rev_timestamp); }
-- Jim R. Wilson (jimbojw)
On Wed, Jul 30, 2008 at 8:30 AM, Platonides <Platonides(a)gmail.com> wrote:
> Jan-Paul wrote:
>> Hello everyone,
>>
>> I am looking for a way to include the date that a page was first created on the
page. I have already found the magic word {{REVISIONTIMESTAMP}} and the other related
magic words. Are there equivalent magic words that return the timestamp for the first
revision of a page? If not, is there a way to add this information through an existing
extension?
>>
>> Thanks and kind regards,
>> Jan-Paul
>
> You could subst REVISIONTIMESTAMP on the first edit or otherwise add it
> with some hook on page creation.
Adding it on created pages is harder. Mediawiki
doesn't have any notion
of the "first edit" of a page, you'd need to query all the revisions to
get the oldest, which is not too efficient.
>
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>