Hi!!
I'm having a HUGE problem with the spamming in my wiki (
http://www.realzaragozapedia.es). I've installed the Confirm Edit and set
up the User Registration to "false"...but the wiki don't have much sense
with these parameters.
Also I'm using the "Merge and Delete" extension, wich is a tedious an
very
slow way to delete all of the 7000 spam accounts registered in my wiki.
Is
there any faster way to do that? (I mean, preserving the database
integrity
).
Thanks for your help and sorry for my english.
Juan
I've had good luck with this sort of addition to LocalSettings.php
require_once "$IP/extensions/ConfirmEdit/QuestyCaptcha.php";
$wgCaptchaClass = 'QuestyCaptcha';
$wgCaptchaQuestions[] = array( 'question' => "Four score and seven
is?",
'answer' => "87" );
$wgCaptchaQuestions[] = array( 'question' => '3 lustrum are?',
'answer'
=> '15 years' );
$wgCaptchaQuestions[] = array( 'question' => "There are 24 hours in
a?",
'answer' => "day" );
$wgCaptchaQuestions[] = array( 'question' => "Deutsch means what in
English?", 'answer' => "German" );
$wgCaptchaQuestions[] = array( 'question' => "If TX is Texas CO is
",
'answer' => "Colorado" );
$wgCaptchaQuestions[] = array( 'question' => "If United States is US
United Kingdom is", 'answer' => "UK" );
$wgCaptchaQuestions[] = array( 'question' => "Symbol for US dollar",
'answer' => "$" );
$wgCaptchaQuestions[] = array( 'question' => "If minus is - plus
is",
'answer' => "+" );
$wgGroupPermissions['*' ]['skipcaptcha'] = false;
$wgGroupPermissions['user' ]['skipcaptcha'] = false;
$wgGroupPermissions['autoconfirmed']['skipcaptcha'] = true;
$wgGroupPermissions['bot' ]['skipcaptcha'] = true; // registered
bots
$wgGroupPermissions['sysop' ]['skipcaptcha'] = true;
$wgGroupPermissions['emailconfirmed']['skipcaptcha'] = true;
$ceAllowConfirmedEmail = true;
$wgCaptchaTriggers['edit'] = true;
$wgCaptchaTriggers['create'] = true;
$wgCaptchaTriggers['addurl'] = true;
$wgCaptchaTriggers['createaccount'] = true;
$wgCaptchaTriggers['badlogin'] = true;
Use questions which which have simple unambiguous answers for your
audience and change them when the spammers begin programing their bots to
answer them.
If you can access your database with phpMyAdmin you can manually delete
spam users from table user. This sounds easy, but can be quite confusing
as it is hard to remember or determine which of the 7,000 users are
actual users who made an account in good faith, although the strange
sy87XVisabelgodfrey type names offer a clue. This can also be done with
mysql itself, but there is no GUI and you have to know to use mysql
commands to manually delete the rows in the table; trying to figure this
out can break your brain, or at least produce a mild headache...
If you can't do that at your present host, assuming you have money and
time to do so, back up your wiki, lease a host for a month that has the
Parallels Plesk Panel with support for phpMyAdmin (some have it disabled)
import your database and work on it then reimport it into your present
host. Email me privately for one host and configuration which I know has
this.
Fred