We are looking for a developer to create a website that will offer statistics on airline upgrades. Visitors and registered users will be able to view this information. We will collect registered users upgrade information from emails they receive from their airline. They will be instructed to forward this email to our email address which will then process their information.
The email will contain specific fields we want to capture including email address to validate that the forwarded email is from a registered user (if not reject email), process fields contained in the email and pipe this data to the website database.
1. Web form to allow visitors to sign up. There should be some type of email validation/captcha. This can be in ASP or PHP. We are OK with using an open source type system; however, we should be able to customize the database by adding additional tables
2. An email processor. We want some type of way to process forwarded emails. We currently have a rough prototype done by using Outlook 2003/Gmail POP3/VBA to process received emails. We have written VBA which will lookup the "from" address (which should be a registered user) and then processes additional fields that are in the email. We want this processed information to be written to the website database so that a user can see their own statistics, as well as, an aggregate of other registered users. You are free to develop your own method for processing emails.
We have a virtual lab with VMs and expect all work to be done in this "test" lab.
We are not looking for pretty-ness just a working system. We don't care what language or system you use; however, it must be scalable and web friendly.