Meta:Spam Blocking - Revision history

BrianEnigma: /* SQL to Block "6 Hex Digit" Spammers */

2007-07-10T00:25:09Z

SQL to Block "6 Hex Digit" Spammers

← Older revision		Revision as of 00:25, 10 July 2007
Line 21:		Line 21:
	ALTERNATIVE: reset their password		ALTERNATIVE: reset their password

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

	Execute the resulting SQL.		Execute the resulting SQL.

BrianEnigma: /* SQL to Block "6 Hex Digit" Spammers */

2007-07-10T00:16:21Z

SQL to Block "6 Hex Digit" Spammers

← Older revision		Revision as of 00:16, 10 July 2007
Line 18:		Line 18:

	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		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.		Execute the resulting SQL.

BrianEnigma at 20:33, 12 June 2007

2007-06-12T20:33:42Z

← Older revision		Revision as of 20:33, 12 June 2007
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==

BrianEnigma: /* Plugin */

2006-11-25T22:12:38Z

Plugin

← Older revision		Revision as of 22:12, 25 November 2006
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==		==Plugin==
			* 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

BrianEnigma: /* Plugin */

2006-10-16T22:21:51Z

Plugin

← Older revision		Revision as of 22:21, 16 October 2006
Line 3:		Line 3:
	* 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]]

	==SQL to Block "6 Hex Digit" Spammers==		==SQL to Block "6 Hex Digit" Spammers==

BrianEnigma at 01:10, 27 September 2006

2006-09-27T01:10:52Z

New page

This is most notes for myself. [[User:BrianEnigma|BrianEnigma]] 18:10, 26 September 2006 (PDT)
==Plugin==
* Source code: http://svn.wikimedia.org/viewvc/mediawiki/trunk/extensions/SpamBlacklist/
* The actual regex list: http://meta.wikimedia.org/wiki/Spam_blacklist

==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.