-<?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
+/**
+ * This script 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.
+ *
+ * @file
+ * @ingroup Maintenance
+ */
+
+require_once( 'commandLine.inc' );
+
+if ( count( $args ) < 3 ) {
+ echo "Usage: php fixTimestamps.php <offset in hours> <start time> <end time>\n";
+ exit(1);
+}
+
+$offset = $args[0] * 3600;
+$start = $args[1];
+$end = $args[2];
+$fname = 'fixTimestamps.php';
+$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}'", $fname );
+$row = $dbw->fetchObject( $res );
+
+if ( is_null( $row->minrev ) ) {
+ echo "No revisions in search period.\n";
+ exit(0);
+}
+
+$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, $fname );
+
+$lastNormal = 0;
+$badRevs = array();
+$numGoodRevs = 0;
+
+while ( $row = $dbw->fetchObject( $res ) ) {
+ $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;
+ }
+}
+$dbw->freeResult( $res );
+
+$numBadRevs = count( $badRevs );
+if ( $numBadRevs > $numGoodRevs ) {
+ echo
+"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.
+";
+
+ exit(1);
+} elseif ( $numBadRevs == 0 ) {
+ echo "No bad revisions found.\n";
+ exit(0);
+}
+
+printf( "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 ) . ')';
+//echo "$sql\n";
+$dbw->query( $sql, $fname );
+echo "Done\n";
+
+
dépôts / lhc / web / wiklou.git / blobdiff