]> scripts.mit.edu Git - autoinstalls/mediawiki.git/blobdiff - includes/specials/SpecialAncientpages.php
MediaWiki 1.17.0
[autoinstalls/mediawiki.git] / includes / specials / SpecialAncientpages.php
index 92192435014513345ae8c994adf2a674cdabcb9d..2d5047d2d23adcb664c50f94e1cbe0affa90856b 100644 (file)
@@ -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,