Spam bots

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;