Talad at 14:04, 28 August 2013

2013-08-28T14:04:20Z

← Older revision		Revision as of 14:04, 28 August 2013
Line 9:		Line 9:
	To massively change the article names:		To massively change the article names:
	* update pswiki_recentchanges set rc_title='spam prevention' where rc_log_action='delete' and rc_user_text='Talad' and rc_namespace=0;		* update pswiki_recentchanges set rc_title='spam prevention' where rc_log_action='delete' and rc_user_text='Talad' and rc_namespace=0;


			== 27 August 2013 IPs ==

			Only the ones with "hacker" in the descriptions are the ones I've confirmed to be spambots as I checked the content that particular IP added to the wiki. All the others are very likely anyway.


			5.10.83.69 (netherlands)

			5.9.162.178 (germany)

			5.135.167.150 (france, hacker)

			36.248.163.149 (china)

			37.59.87.47 (france)

			27.153.205.153 (china, hacker)

			59.57.212.63 (china)

			59.58.148.43 (china, hacker)

			69.175.89.218 (USA, hacker)

			110.85.100.228 (china, hacker)

			110.85.115.111 (china)

			117.25.106.152 (china)

			117.26.220.174 (china)

			120.36.144.21 (china, hacker)

			120.36.151.168 (china)

			121.204.171.83 (china)

			121.207.142.4 (china)

			175.44.32.52 (china)

			184.154.74.139 (USA)

			184.154.189.110 (USA, singlehop, hacker)

			192.95.16.22 (USA)

			192.210.208.221 (USA, hacker)

			218.6.9.101 (china)

			218.6.8.168 (china)

			218.6.12.69 (china)

			220.161.102.222 (china, hacker)

			222.76.199.138 (china)

			222.247.36.189 (china)

Talad: Created page with "Here my notes on spam bots. To see the blocked IPs: * select * from pswiki_ipblocks; To see the delete articles names: * select rc_title from pswiki_recentchanges where rc_l..."

2013-08-28T14:00:20Z

Created page with "Here my notes on spam bots. To see the blocked IPs: * select * from pswiki_ipblocks; To see the delete articles names: * select rc_title from pswiki_recentchanges where rc_l..."

New page

Here my notes on spam bots.

To see the blocked IPs:
* select * from pswiki_ipblocks;

To see the delete articles names:
* select rc_title from pswiki_recentchanges where rc_log_action='delete' and rc_user_text='Talad' and rc_namespace=0;

To massively change the article names:
* update pswiki_recentchanges set rc_title='spam prevention' where rc_log_action='delete' and rc_user_text='Talad' and rc_namespace=0;

Spam bots - Revision history

Talad at 14:04, 28 August 2013

Talad: Created page with "Here my notes on spam bots. To see the blocked IPs: * select * from pswiki_ipblocks; To see the delete articles names: * select rc_title from pswiki_recentchanges where rc_l..."