Spam bots: Difference between revisions
Jump to navigation
Jump to search
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 difference)
|
Revision as of 14:00, 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;