-<?php\r
-\r
-/**\r
- * This script fixes timestamp corruption caused by one or more webservers \r
- * temporarily being set to the wrong time. The time offset must be known and\r
- * consistent. Start and end times (in 14-character format) restrict the search, \r
- * and must bracket the damage. There must be a majority of good timestamps in the \r
- * search period.\r
- */\r
-\r
-require_once( 'commandLine.inc' );\r
-\r
-if ( count( $args ) < 3 ) {\r
- echo "Usage: php fixTimestamps.php <offset in hours> <start time> <end time>\n";\r
- exit(1);\r
-}\r
-\r
-$offset = $args[0] * 3600;\r
-$start = $args[1];\r
-$end = $args[2];\r
-$fname = 'fixTimestamps.php';\r
-$grace = 60; // maximum normal clock offset\r
-\r
-# Find bounding revision IDs\r
-$dbw =& wfGetDB( DB_MASTER );\r
-$revisionTable = $dbw->tableName( 'revision' );\r
-$res = $dbw->query( "SELECT MIN(rev_id) as minrev, MAX(rev_id) as maxrev FROM $revisionTable " .\r
- "WHERE rev_timestamp BETWEEN '{$start}' AND '{$end}'", $fname );\r
-$row = $dbw->fetchObject( $res );\r
-\r
-if ( is_null( $row->minrev ) ) {\r
- echo "No revisions in search period.\n";\r
- exit(0);\r
-}\r
-\r
-$minRev = $row->minrev;\r
-$maxRev = $row->maxrev;\r
-\r
-# Select all timestamps and IDs\r
-$sql = "SELECT rev_id, rev_timestamp FROM $revisionTable " .\r
- "WHERE rev_id BETWEEN $minRev AND $maxRev";\r
-if ( $offset > 0 ) {\r
- $sql .= " ORDER BY rev_id DESC";\r
- $expectedSign = -1;\r
-} else {\r
- $expectedSign = 1;\r
-}\r
-\r
-$res = $dbw->query( $sql, $fname );\r
-\r
-$lastNormal = 0;\r
-$badRevs = array();\r
-$numGoodRevs = 0;\r
-\r
-while ( $row = $dbw->fetchObject( $res ) ) {\r
- $timestamp = wfTimestamp( TS_UNIX, $row->rev_timestamp );\r
- $delta = $timestamp - $lastNormal;\r
- $sign = $delta == 0 ? 0 : $delta / abs( $delta );\r
- if ( $sign == 0 || $sign == $expectedSign ) {\r
- // Monotonic change\r
- $lastNormal = $timestamp;\r
- ++ $numGoodRevs;\r
- continue;\r
- } elseif ( abs( $delta ) <= $grace ) {\r
- // Non-monotonic change within grace interval\r
- ++ $numGoodRevs;\r
- continue;\r
- } else {\r
- // Non-monotonic change larger than grace interval\r
- $badRevs[] = $row->rev_id;\r
- }\r
-}\r
-$dbw->freeResult( $res );\r
-\r
-$numBadRevs = count( $badRevs );\r
-if ( $numBadRevs > $numGoodRevs ) {\r
- echo \r
-"The majority of revisions in the search interval are marked as bad.\r
-\r
-Are you sure the offset ($offset) has the right sign? Positive means the clock \r
-was incorrectly set forward, negative means the clock was incorrectly set back.\r
-\r
-If the offset is right, then increase the search interval until there are enough \r
-good revisions to provide a majority reference.\r
-";\r
-\r
- exit(1);\r
-} elseif ( $numBadRevs == 0 ) {\r
- echo "No bad revisions found.\n";\r
- exit(0);\r
-}\r
-\r
-printf( "Fixing %d revisions (%.2f%% of revisions in search interval)\n", \r
- $numBadRevs, $numBadRevs / ($numGoodRevs + $numBadRevs) * 100 );\r
-\r
-$fixup = -$offset;\r
-$sql = "UPDATE $revisionTable " .\r
- "SET rev_timestamp=DATE_FORMAT(DATE_ADD(rev_timestamp, INTERVAL $fixup SECOND), '%Y%m%d%H%i%s') " .\r
- "WHERE rev_id IN (" . $dbw->makeList( $badRevs ) . ')';\r
-//echo "$sql\n";\r
-$dbw->query( $sql, $fname );\r
-echo "Done\n";\r
-\r
-?>\r
+<?php
+/**
+ * Fixes timestamp corruption caused by one or more webservers temporarily
+ * being set to the wrong time.
+ * The time offset must be known and consistent. Start and end times
+ * (in 14-character format) restrict the search, and must bracket the damage.
+ * There must be a majority of good timestamps in the search period.
+ *
+ * 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 Maintenance
+ */
+
+require_once( dirname( __FILE__ ) . '/Maintenance.php' );
+
+/**
+ * Maintenance script that fixes timestamp corruption caused by one or
+ * more webservers temporarily being set to the wrong time.
+ *
+ * @ingroup Maintenance
+ */
+class FixTimestamps extends Maintenance {
+ public function __construct() {
+ parent::__construct();
+ $this->mDescription = "";
+ $this->addArg( 'offset', '' );
+ $this->addArg( 'start', 'Starting timestamp' );
+ $this->addArg( 'end', 'Ending timestamp' );
+ }
+
+ public function execute() {
+ $offset = $this->getArg( 0 ) * 3600;
+ $start = $this->getArg( 1 );
+ $end = $this->getArg( 2 );
+ $grace = 60; // maximum normal clock offset
+
+ # Find bounding revision IDs
+ $dbw = wfGetDB( DB_MASTER );
+ $revisionTable = $dbw->tableName( 'revision' );
+ $res = $dbw->query( "SELECT MIN(rev_id) as minrev, MAX(rev_id) as maxrev FROM $revisionTable " .
+ "WHERE rev_timestamp BETWEEN '{$start}' AND '{$end}'", __METHOD__ );
+ $row = $dbw->fetchObject( $res );
+
+ if ( is_null( $row->minrev ) ) {
+ $this->error( "No revisions in search period.", true );
+ }
+
+ $minRev = $row->minrev;
+ $maxRev = $row->maxrev;
+
+ # Select all timestamps and IDs
+ $sql = "SELECT rev_id, rev_timestamp FROM $revisionTable " .
+ "WHERE rev_id BETWEEN $minRev AND $maxRev";
+ if ( $offset > 0 ) {
+ $sql .= " ORDER BY rev_id DESC";
+ $expectedSign = -1;
+ } else {
+ $expectedSign = 1;
+ }
+
+ $res = $dbw->query( $sql, __METHOD__ );
+
+ $lastNormal = 0;
+ $badRevs = array();
+ $numGoodRevs = 0;
+
+ foreach ( $res as $row ) {
+ $timestamp = wfTimestamp( TS_UNIX, $row->rev_timestamp );
+ $delta = $timestamp - $lastNormal;
+ $sign = $delta == 0 ? 0 : $delta / abs( $delta );
+ if ( $sign == 0 || $sign == $expectedSign ) {
+ // Monotonic change
+ $lastNormal = $timestamp;
+ ++ $numGoodRevs;
+ continue;
+ } elseif ( abs( $delta ) <= $grace ) {
+ // Non-monotonic change within grace interval
+ ++ $numGoodRevs;
+ continue;
+ } else {
+ // Non-monotonic change larger than grace interval
+ $badRevs[] = $row->rev_id;
+ }
+ }
+
+ $numBadRevs = count( $badRevs );
+ if ( $numBadRevs > $numGoodRevs ) {
+ $this->error(
+ "The majority of revisions in the search interval are marked as bad.
+
+ Are you sure the offset ($offset) has the right sign? Positive means the clock
+ was incorrectly set forward, negative means the clock was incorrectly set back.
+
+ If the offset is right, then increase the search interval until there are enough
+ good revisions to provide a majority reference.", true );
+ } elseif ( $numBadRevs == 0 ) {
+ $this->output( "No bad revisions found.\n" );
+ exit( 0 );
+ }
+
+ $this->output( sprintf( "Fixing %d revisions (%.2f%% of revisions in search interval)\n",
+ $numBadRevs, $numBadRevs / ( $numGoodRevs + $numBadRevs ) * 100 ) );
+
+ $fixup = -$offset;
+ $sql = "UPDATE $revisionTable " .
+ "SET rev_timestamp=DATE_FORMAT(DATE_ADD(rev_timestamp, INTERVAL $fixup SECOND), '%Y%m%d%H%i%s') " .
+ "WHERE rev_id IN (" . $dbw->makeList( $badRevs ) . ')';
+ $dbw->query( $sql, __METHOD__ );
+ $this->output( "Done\n" );
+ }
+}
+
+$maintClass = "FixTimestamps";
+require_once( RUN_MAINTENANCE_IF_MAIN );
dépôts / lhc / web / wiklou.git / blobdiff