summaryrefslogtreecommitdiff
path: root/maintenance/cleanupSpam.php
blob: 65d6bc4d34bef472542dfc72e24e44ba63ed7607 (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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php

require_once( 'commandLine.inc' );
require_once( "$IP/includes/LinkFilter.php" );

function cleanupArticle( $id, $domain ) {
	$title = Title::newFromID( $id );
	if ( !$title ) {
		print "Internal error: no page for ID $id\n";
		return;
	}

	print $title->getPrefixedDBkey() . " ...";
	$rev = Revision::newFromTitle( $title );
	$reverted = false;
	$revId = $rev->getId();
	$currentRevId = $revId;
	$regex = LinkFilter::makeRegex( $domain );
	
	while ( $rev && preg_match( $regex, $rev->getText() ) ) {
		# Revision::getPrevious can't be used in this way before MW 1.6 (Revision.php 1.26)
		#$rev = $rev->getPrevious();
		$revId = $title->getPreviousRevisionID( $revId );
		if ( $revId ) {
			$rev = Revision::newFromTitle( $title, $revId );
		} else {
			$rev = false;
		}
	}
	if ( $revId == $currentRevId ) {
		// The regex didn't match the current article text
		// This happens e.g. when a link comes from a template rather than the page itself
		print "False match\n";
	} else {
		$dbw =& wfGetDB( DB_MASTER );
		$dbw->immediateBegin();
		if ( !$rev ) {
			// Didn't find a non-spammy revision, blank the page
			print "blanking\n";
			$article = new Article( $title );
			$article->updateArticle( '', wfMsg( 'spam_blanking', $domain ),
				false, false );

		} else {
			// Revert to this revision
			print "reverting\n";
			$article = new Article( $title );
			$article->updateArticle( $rev->getText(), wfMsg( 'spam_reverting', $domain ), false, false );
		}
		$dbw->immediateCommit();
		wfDoUpdates();
	}
}
//------------------------------------------------------------------------------




$username = wfMsg( 'spambot_username' );
$fname = $username;
$wgUser = User::newFromName( $username );
// Create the user if necessary
if ( !$wgUser->getID() ) {
	$wgUser->addToDatabase();
}

if ( !isset( $args[0] ) ) {
	print "Usage: php cleanupSpam.php <hostname>\n";
	exit(1);
}
$spec = $args[0];
$like = LinkFilter::makeLike( $spec );
if ( !$like ) {
	print "Not a valid hostname specification: $spec\n";
	exit(1);
}

$dbr =& wfGetDB( DB_SLAVE );

if ( $options['all'] ) {
	// Clean up spam on all wikis
	$dbr =& wfGetDB( DB_SLAVE );
	print "Finding spam on " . count($wgLocalDatabases) . " wikis\n";
	$found = false;
	foreach ( $wgLocalDatabases as $db ) {
		$count = $dbr->selectField( "`$db`.externallinks", 'COUNT(*)', 
			array( 'el_index LIKE ' . $dbr->addQuotes( $like ) ), $fname );
		if ( $count ) {
			$found = true;
			passthru( "php cleanupSpam.php $db $spec | sed s/^/$db:  /" );
		}
	}
	if ( $found ) {
		print "All done\n";
	} else {
		print "None found\n";
	}
} else {
	// Clean up spam on this wiki
	$res = $dbr->select( 'externallinks', array( 'DISTINCT el_from' ), 
		array( 'el_index LIKE ' . $dbr->addQuotes( $like ) ), $fname );
	$count = $dbr->numRows( $res );
	print "Found $count articles containing $spec\n";
	while ( $row = $dbr->fetchObject( $res ) ) {
		cleanupArticle( $row->el_from, $spec );
	}
	if ( $count ) {
		print "Done\n";
	}
}

?>