Dec 312012
 

I this special idea about banning spammers:

echo "select comment_author_IP from wp_comments where comment_approved = 'spam'" | \
   mysql --skip-column-names -u root wordpress_danlangilleorg | \
   xargs -n 1 -J % sudo pfctl -t idiots -T add %

Anyone care to explain how this works?

Website Pin Facebook Twitter Myspace Friendfeed Technorati del.icio.us Digg Google StumbleUpon Premium Responsive