Spam bots: Difference between revisions
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..." |
No edit summary |
||
| 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) | |||
Latest revision as of 14:04, 28 August 2013
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;
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)