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";
|
