diff options
Diffstat (limited to 'includes/specials/SpecialAncientpages.php')
-rw-r--r-- | includes/specials/SpecialAncientpages.php | 38 |
1 files changed, 19 insertions, 19 deletions
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 @@ <?php /** + * Implements Special:Ancientpages + * + * This program is free software; you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation; either version 2 of the License, or + * (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License along + * with this program; if not, write to the Free Software Foundation, Inc., + * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. + * http://www.gnu.org/copyleft/gpl.html + * * @file * @ingroup SpecialPage */ /** * Implements Special:Ancientpages + * * @ingroup SpecialPage */ class AncientPagesPage extends QueryPage { @@ -21,28 +39,10 @@ class AncientPagesPage extends QueryPage { function isSyndicated() { return false; } function getSQL() { - global $wgDBtype; $db = wfGetDB( DB_SLAVE ); $page = $db->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, |