I need a perl script that can be run using crontab on a Linux system. The script will need to connect to a pop3 email server and check the new messages. If a new message exists with a subject like “MyCompanyName Sales Receipt - 62214-R99999999?? (mycompany name will be replaced and the 9’s will be random numbers) it will need to take certain values out of the database and insert them into a database. An example email is included: Selling Company: MyCompany ( [url removed, login to view] ) [url removed, login to view] Order Number: 62214-R99999999 ID# Description Interval Charge Windows ZestDevelope ZestDeveloper (windows) Every 1 Year(s) $ 30.00 Start Up Cost One Time $ 0.00 Total Billed Today $ 30.00 The order was billed to: NEW CUSTOMER Payment Method - Visa customersemailaddress 0222 222 333 2639 Long Street New York, NA 20111 USA IP Address: [url removed, login to view] IP Location: New York, , United States Card Type: Visa AVS Code: YY Code Explanation CVV Code: Matched Bank Records 2co_ip: [url removed, login to view] Using this data it would have to insert the following into a MySQL database (field name : value): name : NEW CUSTOMER 2checkout : R99999999 startdate : (date email received yyyy-mm-dd) lastpaydate : (date email received yyyy-mm-dd) expiresdate : (date email received + 1 year yyyy-mm-dd) email : customersemailaddress domain : ? username : ? WINDOWS paymentamount : 30 totalpaid : 30 It will then need to send a standard welcome email to customersemailaddress (I will provide the text and subject for this email). The script will also have to check before inserting the new order into the database if the order R99999999 already exists in the database - the 2checkout field is a unique key field. If it already exists it should just ignore the email but it must leave all emails intact on the server as this email account is also used for other emails.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
Linux, Redhat, Perl