WordPress database error: [Table 'cognitoy_com_blog.wp_comments' doesn't exist]
SELECT COUNT(*) FROM wp_comments WHERE comment_approved='spam' AND comment_author_IP='209.234.171.42'

WordPress database error: [Table 'cognitoy_com_blog.wp_comments' doesn't exist]
select a.ID as ID, max(b.comment_date_gmt) as LastCommentTime from wp_posts a inner join wp_comments b on a.ID = b.comment_post_id where (a.comment_status = 'open' or a.ping_status = 'open') and b.comment_approved='1' and a.ID >= 18 and a.ID <= 21 group by a.ID

Global Warming Can Be Fun

Saving the planet one game at a time.

Archive for 2006/10


A valuable lunch

I had lunch today with my new friend (a friend of old friends) Henry Olds and his friend Mark Bowen.
Mark is the author of a really good book called Thin Ice. Well I have to admit that my opinion is only half-baked, because I haven’t finished it yet. When I do, I will write […]

A perfect fall day in New England

Wow. My wife and I got on our bikes and rode to the top of Mt. Wachusett today (round trip was 63 miles, about 4800 feet of vertical climb).
The temperature was 55-75 degrees, depending on where we were at the time. It can get pretty chilly when you ride near a lake or a […]

Python keeps surprising me

So one of the things that’s always bugged me about Python and other languages with ‘foreach’ sorts of iteration are those times when you iterate over a list and need to do something that requires an index, or that requires you to iterate it back-to-front, or that requires you to iterate multiple lists simultaneously.I used […]

The importance of meeting Ernest

One day last week, I spent several hours with Ernest Adams, the game designer. We’ve been casual friends for many years, generally bumping into one another at the Game Developer’s Conference and sharing a beer. This time, I was paying for his services.
I’ve been struggling with some of the issues I’ve had with game design […]