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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
#!/usr/bin/perl
#
# Nuke idle wiki accounts from the wiki's user database.
#
# Copyright (C) 2005 Ralf Baechle (ralf@linux-mips.org)
#
# 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 SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED
# WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
# MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN
# NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT,
# INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT
# NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
# USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
# ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
# (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
# THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
#
# 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.,
# 675 Mass Ave, Cambridge, MA 02139, USA.
#
my $database = "DBI:mysql:database=wikidb;host=localhost";
my $dbuser = "wikiuser";
my $dbpasswd = "password";
use strict;
use DBI();
my $verbose = 0;
my $for_real = 1;
sub do_db_op
{
my ($dbh, $sql) = @_;
if ($verbose >= 3) {
print $sql . ";\n"
}
if ($for_real == 1) {
$dbh->do($sql);
}
}
sub undo_user
{
my ($ref, $dbh, $sth, $killed);
# Connect to the database.
$dbh = DBI->connect($database, $dbuser, $dbpasswd, {RaiseError => 1});
$sth = $dbh->prepare("SELECT * FROM user");
$sth->execute();
$ref = $sth->fetchrow_hashref();
if ($sth->rows == 0) {
print "There is no user in this wiki.\n";
return;
}
while ($ref = $sth->fetchrow_hashref()) {
my ($user_id, $user_name, $cph, $oph, $edits);
$user_name = $ref->{user_name};
$user_id = $ref->{user_id};
if ($verbose >= 2) {
print "Annihilating user " . $user_name .
" has user_id " . $user_id . ".\n";
}
$cph = $dbh->prepare("SELECT * FROM cur where " .
"cur_user = $user_id" .
" AND " .
"cur_user_text = " . $dbh->quote("$user_name"));
$cph->execute();
$oph = $dbh->prepare("SELECT * FROM old where " .
"old_user = $user_id" .
" AND " .
"old_user_text = " . $dbh->quote("$user_name"));
$oph->execute();
$edits = $cph->rows + $oph->rows;
$cph->finish();
$oph->finish();
if ($edits == 0) {
if ($verbose >= 2) {
print "Keeping user " . $user_name .
", user_id " . $user_id . ".\n";
}
do_db_op($dbh,
"DELETE FROM user WHERE user_name = " .
$dbh->quote("$user_name") .
" AND " .
"user_id = $user_id");
$killed++;
}
}
$sth->finish();
$dbh->disconnect();
if ($verbose >= 1) {
print "Killed " . $killed . " users\n";
}
}
my (@users, $user, $this, $opts);
@users = ();
$opts = 1;
foreach $this (@ARGV) {
if ($opts == 1 && $this eq '-v') {
$verbose++;
} elsif ($opts == 1 && $this eq '--verbose') {
$verbose = 1;
} elsif ($opts == 1 && $this eq '--') {
$opts = 0;
} else {
push(@users, $this);
}
}
undo_user();
|
