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.
I’ve been meaning to weigh on in T. A. leaving the Pack. While he’s got the skills, and the guts to play when he’s injured, he does get injured a lot. And he fumbles at the most inopportune moments.
I know he’s hoping to guard against a potential injury wrecking his chances of joining the NFL, but I think he’s leaving too soon. If he stayed and worked on his ball handling, he’d have a much brighter future with the NFL. I wish him well, though.
Also today, the news that Doc Holliday is jumping ship to Florida. I hope we can still recruit in the post-Doc era. The next few seasons promise to be defining for the future of Wolfpack football.
