12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 |
- <?php
- /**
- * @file
- * @ingroup SpecialPage
- */
- /**
- * Implements Special:Ancientpages
- * @ingroup SpecialPage
- */
- class AncientPagesPage extends QueryPage {
- function getName() {
- return "Ancientpages";
- }
- function isExpensive() {
- return true;
- }
- function isSyndicated() { return false; }
- function getSQL() {
- global $wgDBtype;
- $db = wfGetDB( DB_SLAVE );
- $page = $db->tableName( 'page' );
- $revision = $db->tableName( 'revision' );
- $epoch = $wgDBtype == 'mysql' ? 'UNIX_TIMESTAMP(rev_timestamp)' :
- 'EXTRACT(epoch FROM rev_timestamp)';
- return
- "SELECT 'Ancientpages' as type,
- page_namespace as namespace,
- page_title as title,
- $epoch as value
- FROM $page, $revision
- WHERE page_namespace=".NS_MAIN." AND page_is_redirect=0
- AND page_latest=rev_id";
- }
- function sortDescending() {
- return false;
- }
- function formatResult( $skin, $result ) {
- global $wgLang, $wgContLang;
- $d = $wgLang->timeanddate( wfTimestamp( TS_MW, $result->value ), true );
- $title = Title::makeTitle( $result->namespace, $result->title );
- $link = $skin->makeKnownLinkObj( $title, htmlspecialchars( $wgContLang->convert( $title->getPrefixedText() ) ) );
- return wfSpecialList($link, $d);
- }
- }
- function wfSpecialAncientpages() {
- list( $limit, $offset ) = wfCheckLimits();
- $app = new AncientPagesPage();
- $app->doQuery( $offset, $limit );
- }
|