I have a requirement for possibly the world's smallest CMS, to update a single line of text on a Flash website.
Because the user of this will not be tech-savy, I was wondering, could you build a system to allow changes to the text by email.
Eg. Send an email to a secret address (much like Flickr's upload by email system), the subject line of which would be saved to a MySQL database or textfield, and displayed on the Flash website. The sysytem would probably send a reply to the sender to confirm that the change had been made.
What do you reckon? Easily done on a Windows server?
I forgot the site, but it basically lets you run cron jobs on windows servers by pinging the file containing the cron jobs every x minutes. Google lets you check your email via rss which should be a heck of a lot easier than pop3 email checking. You could then look for a secret "code" in the subject line or something. I THINK file_get_contents lets you specify the http username/password (ex. https://USERNAME:PASSWORD@gmail.google.com/gmail/feed/atom) and then if the line is short just scrape that. The one thing I am sad about is it looks like gmail doesn't give you the full message when using the feed, so if longer I don't know of any other way besides pop3.
I'd look to Rails... There are plenty of tutorials on how to check mail, and inserting data into MySQL doesn't get any easier than with Rails. I'd try this. From there, it's just a matter of setting up a cron job to run a Ruby script.