X-Git-Url: https://scripts.mit.edu/gitweb/autoinstalls/mediawiki.git/blobdiff_plain/87219ebd28426c6d21cb545233ee52f5f7af7dfd..18a6620945d02687fbcfc4c27355d952fd748b41:/includes/specials/SpecialAncientpages.php diff --git a/includes/specials/SpecialAncientpages.php b/includes/specials/SpecialAncientpages.php index 92192435..2d5047d2 100644 --- a/includes/specials/SpecialAncientpages.php +++ b/includes/specials/SpecialAncientpages.php @@ -1,11 +1,29 @@ tableName( 'page' ); $revision = $db->tableName( 'revision' ); - - switch ($wgDBtype) { - case 'mysql': - $epoch = 'UNIX_TIMESTAMP(rev_timestamp)'; - break; - case 'ibm_db2': - // TODO implement proper conversion to a Unix epoch - $epoch = 'rev_timestamp'; - break; - case 'oracle': - $epoch = '((trunc(rev_timestamp) - to_date(\'19700101\',\'YYYYMMDD\')) * 86400)'; - break; - case 'sqlite': - $epoch = 'rev_timestamp'; - break; - default: - $epoch = 'EXTRACT(epoch FROM rev_timestamp)'; - } + $epoch = $db->unixTimestamp( 'rev_timestamp' ); return "SELECT 'Ancientpages' as type,