8 * Implements Special:Ancientpages
11 class AncientPagesPage
extends QueryPage
{
14 return "Ancientpages";
17 function isExpensive() {
21 function isSyndicated() { return false; }
25 $db = wfGetDB( DB_SLAVE
);
26 $page = $db->tableName( 'page' );
27 $revision = $db->tableName( 'revision' );
31 $epoch = 'UNIX_TIMESTAMP(rev_timestamp)';
34 // TODO implement proper conversion to a Unix epoch
35 $epoch = 'rev_timestamp';
38 $epoch = '((trunc(rev_timestamp) - to_date(\'19700101\',\'YYYYMMDD\')) * 86400)';
41 $epoch = 'rev_timestamp';
44 $epoch = 'EXTRACT(epoch FROM rev_timestamp)';
48 "SELECT 'Ancientpages' as type,
49 page_namespace as namespace,
53 WHERE page_namespace=".NS_MAIN
." AND page_is_redirect=0
54 AND page_latest=rev_id";
57 function sortDescending() {
61 function formatResult( $skin, $result ) {
62 global $wgLang, $wgContLang;
64 $d = $wgLang->timeanddate( wfTimestamp( TS_MW
, $result->value
), true );
65 $title = Title
::makeTitle( $result->namespace, $result->title
);
66 $link = $skin->linkKnown(
68 htmlspecialchars( $wgContLang->convert( $title->getPrefixedText() ) )
70 return wfSpecialList($link, htmlspecialchars($d) );
74 function wfSpecialAncientpages() {
75 list( $limit, $offset ) = wfCheckLimits();
77 $app = new AncientPagesPage();
79 $app->doQuery( $offset, $limit );