3 include_once( "QueryPage.php" );
5 class AncientPagesPage
extends QueryPage
{
11 function isExpensive() {
12 return parent
::isExpensive() ;
15 function getSQL( $offset, $limit ) {
16 return "SELECT cur_title, cur_timestamp " .
17 "FROM cur USE INDEX (cur_timestamp) " .
18 "WHERE cur_namespace=0 AND cur_is_redirect=0 " .
19 " ORDER BY cur_timestamp LIMIT {$offset}, {$limit}";
22 function formatResult( $skin, $result ) {
25 $d = $wgLang->timeanddate( $result->cur_timestamp
, true );
26 $link = $skin->makeKnownLink( $result->cur_title
, "" );
27 return "{$link} ({$d})";
31 function wfSpecialAncientpages()
33 list( $limit, $offset ) = wfCheckLimits();
35 $app = new AncientPagesPage();
37 $app->doQuery( $offset, $limit );