Not signed in (Sign In)

SkillShare - A place to discuss Web Standards and Web Design topics

Categories

Vanilla 1.1.9 is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthormista3
    • CommentTimeApr 5th 2007
     permalink
    Hello peeps,

    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?

    Cheers

    3stripe
    • CommentAuthorMatt
    • CommentTimeApr 5th 2007
     permalink
    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.
    • CommentAuthormista3
    • CommentTimeApr 5th 2007
     permalink
    GoogleMail - nice idea! Not sure how this would work but it could do...
    • CommentAuthormista3
    • CommentTimeApr 5th 2007 edited
     permalink
    http://www.kode.de/pop2mail/ is meant to be a POP3 -> MySQL script.. but there's no code! :(

    also http://www.derickrethans.nl/parsing_mail_with_php.php
    • CommentAuthorvarland
    • CommentTimeApr 5th 2007
     permalink
    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.
Add your comments
    Username Password
  • Format comments as (Help)