Meta:Spam Blocking

This is most notes for myself. BrianEnigma 18:10, 26 September 2006 (PDT)

Spam Blacklist Plugin

• Homepage: http://meta.wikimedia.org/wiki/SpamBlacklist_extension
• Source code: http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/SpamBlacklist/
• The actual regex list: http://meta.wikimedia.org/wiki/Spam_blacklist
• Our own local extension to the blacklist file is at Meta:Spam Blacklist

Bad-Behavior Plugin

• Bad-Behavior 2
• plus database tweak
• Support for Special:BadBehavior
• View results at Special:BadBehavior

SQL to Block "6 Hex Digit" Spammers

mysql -B -uusername -ppassword -hhost databasename -e 'select user_id,user_name from user where user_name regexp "^[0-9A-Fa-f]{6}$";' > bad_users.txt

TODO for next time: where user_id not already in ipblocks table

cat bad_users.txt | perl -pne 's/(.*)\t(.*)/insert into ipblocks (ipb_address,ipb_user,ipb_by,ipb_reason,ipb_timestamp,ipb_expiry) values ("$2",$1,178,"Automated Spammer","20060926180300","20200101000000");/' > spammers.sql

ALTERNATIVE: reset their password

cat bad_users.txt | perl -pne 's/(.*)\t.*/update user set user_password="*" where user_id=$1;/' > spammers.sql

Execute the resulting SQL.