After getting bombarded with comment spam lately, I’ve been thinking of countermeasures. I found this interesting discussion about the problem.
At the bottom of this thread is this handy little SQL SQL statement which will close comments, which is the place most of these comment spams get planted.
update node set comment=1 where nid (less than sign) (top node number – 10)
Now I need to find which table contains the top node number so I can automate this process and run it nightly.