another (better) way to tighten up MovableType against comment spam

If you want, you can turn off comments on all entries older than 30 days using the following SQL:

update mt_entry set entry_allow_comments = 2 where
TO_DAYS(NOW()) - TO_DAYS(entry_created_on) >= 30;

This closes comments on all entries 30 days old or older. Most comment spams are on older content, which are also less likely to have legitimate comments so this isn’t a bad option. You can run this yourself manually every week or so, or you can add it as a cron job

from BurningBird

15 more miles, and one broken pedal

performance_forte_team_mg_atb_pedal

Well, I got out on the Burke-Gilman for about a one hour ride, did about 15 miles, but in the process dropped the spring plate from one of my new pedals. I couldn’t figure out why I wasn’t able to get clipped in properly one one side . . . . The screw you can see on the lower left controls the tension by how tight it presses the plate against a spring. When the plate fell out, there was nothing to hold those notched bits on top from holding the cleat.

It’s not a dead loss: they’re double-sided pedals so I can still lock in if I get the right side up. But still, a trip to the shop for a repair or replacement is in order.

[Posted with ecto]

what haven’t you read?

Crooked Timber: Books I Did Not Read This Year

As 2003 draws to a close, it’s time for me to reflect on all of the great books I did not read this year. This has been a particularly good year for not reading books. I would go so far as to say that there are more books I did not read this year than in any year in the recent past. Although a significant part of my job consists in sitting somewhere and reading something, I have still managed to find the time not to read a very wide range of material from many different fields.

What books didn’t you read this past year?

more software to detect currency images

Professor Ed Felten suggests you take a look and see if other software besides PhotoShop has built-in safeguards against currency duplication.

So you can look for currency-detecting software on your own computer. Just search the contents of your computer for the character string “http://www.rulesforuse.org”, and see if you find that string in any software such as an application or a printer driver.

I didn’t find anywhere on my system: update this page’s comments if you find anything.

[Posted with ecto]

one small step against comment spammers

I closed comments on all entries created prior to June 30 of last year. This was partly an exercise in using MySQL to manipulate multiple entries (in this case, 963 of them).

UPDATE `mt_entry` SET `entry_allow_comments`=2 WHERE `entry_created_on` <= "2003-06-30:00:00:00"

[Posted with ecto]

apparently, I’m a Dean backer . . .

But he’s a pretty distant second . . .

Your Results:

1. Your ideal theoretical candidate.   (100%)  Click here for info

2. Dean, Gov. Howard, VT – Democrat   (79%)  Click here for info

3. Sharpton, Reverend Al – Democrat   (77%)  Click here for info

4. Kucinich, Rep. Dennis, OH – Democrat   (76%)  Click here for info

5. Edwards, Senator John, NC – Democrat   (71%)  Click here for info

6. Clark, Retired General Wesley K., AR – Democrat   (69%)  Click here for info

7. Kerry, Senator John, MA – Democrat   (67%)  Click here for info

8. Gephardt, Rep. Dick, MO – Democrat   (65%)  Click here for info

9. Lieberman, Senator Joe, CT – Democrat   (45%)  Click here for info

10. Libertarian Candidate   (29%)  Click here for info

11. Phillips, Howard – Constitution   (12%)  Click here for info

12. Bush, President George W. – Republican   (9%)  Click here for info

(I only linked to my top three contenders: go take the test yourself and see how you do.)

[Posted with ecto]
Continue reading “apparently, I’m a Dean backer . . .”

Mars wins, Hubble loses

what going to Mars will cost

Nasa is halting all space shuttle missions to service the Hubble Space Telescope, a move that will lead to it becoming useless within four years.

Hubble may be near the end of its service life, but as we’ve seen with many of the space probes, these things often deliver long after we expect them to.

And if we can’t service Hubble, how reliable will service to the space station or the moon base(?!) be?

[Posted with ecto]