Difference between revisions of "Meta:Spam Blocking"

From Perplex City Wiki
Jump to: navigation, search
m (Plugin)
Line 1: Line 1:
 
This is most notes for myself. [[User:BrianEnigma|BrianEnigma]] 18:10, 26 September 2006 (PDT)
 
This is most notes for myself. [[User:BrianEnigma|BrianEnigma]] 18:10, 26 September 2006 (PDT)
==Plugin==
+
==Spam Blacklist Plugin==
 
* Homepage: http://meta.wikimedia.org/wiki/SpamBlacklist_extension
 
* Homepage: http://meta.wikimedia.org/wiki/SpamBlacklist_extension
 
* Source code: http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/SpamBlacklist/
 
* Source code: http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/SpamBlacklist/
 
* The actual regex list: http://meta.wikimedia.org/wiki/Spam_blacklist
 
* The actual regex list: http://meta.wikimedia.org/wiki/Spam_blacklist
 
* Our own local extension to the blacklist file is at [[Meta:Spam Blacklist]]
 
* Our own local extension to the blacklist file is at [[Meta:Spam Blacklist]]
 +
 +
==Bad-Behavior Plugin==
 +
* [http://www.bad-behavior.ioerror.us/download/ Bad-Behavior 2]
 +
* [http://www.bad-behavior.ioerror.us/2007/01/26/bad-behavior-on-php-520/#comment-1144 plus database tweak]
 +
* [http://wiki.evernex.com/index.php?title=Bad_Behavior_2_Extended Support for Special:BadBehavior]
 +
* View results at [[Special:BadBehavior]]
  
 
==SQL to Block "6 Hex Digit" Spammers==
 
==SQL to Block "6 Hex Digit" Spammers==

Revision as of 20:33, 12 June 2007

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

Spam Blacklist Plugin

Bad-Behavior Plugin

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

Execute the resulting SQL.