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