summaryrefslogtreecommitdiff
path: root/maintenance/deleteRevision.php
blob: 0c203ab050c8a3747bf98a49c3ac00de05ea5601 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
<?php
/**
 * Delete one or more revisions by moving them to the archive table.
 *
 * @file
 * @ingroup Maintenance
 */

require_once( 'commandLine.inc' );

$dbw = wfGetDB( DB_MASTER );

if ( count( $args ) == 0 ) {
	echo "Usage: php deleteRevision.php <revid> [<revid> ...]\n";
	exit(1);
}

echo "Deleting revision(s) " . implode( ',', $args ) . " from ".wfWikiID()."...\n";

$affected = 0;
foreach ( $args as $revID ) {
	$dbw->insertSelect( 'archive', array( 'page', 'revision' ),
		array(
			'ar_namespace'  => 'page_namespace',
			'ar_title'      => 'page_title',
			'ar_comment'    => 'rev_comment',
			'ar_user'       => 'rev_user',
			'ar_user_text'  => 'rev_user_text',
			'ar_timestamp'  => 'rev_timestamp',
			'ar_minor_edit' => 'rev_minor_edit',
			'ar_rev_id'     => 'rev_id',
			'ar_text_id'    => 'rev_text_id',
		), array(
			'rev_id' => $revID,
			'page_id = rev_page'
		), $fname
	);
	if ( !$dbw->affectedRows() ) {
		echo "Revision $revID not found\n";
	} else {
		$affected += $dbw->affectedRows();
		$dbw->delete( 'revision', array( 'rev_id' => $revID ) );
	}
}

print "Deleted $affected revisions\n";