I need a script(s) to connect to an SSL secured mail server, authenticate itself and send e-mail's in a mysql database table called MailQueue, the table should contain:
Number int auto incremental //The primary key for the table
FromAddress //From which address to come
FromName //From which name to come
ToAddress //Receivers e-mail address
ToName //Receivers e-mail Name
Subject //The subject of the
MailInHTML //May be null if not html e-mail
MailInTEXT //Always has a value for text/html emails
MailSent enum('yes','no') //Has the mail been sent
DateSent //This is a datetime field for when the mail is sent
ApplicableErrors //Contains any errors from sending the mail
The MailSent should be set to yes once the mail has been sent, the Format specifies whether the e-mail is MailInHTML will contain a value if the client specifies that HTML is preferred, TEXT will always contain a value and should be sent with HTML e-mails to or one it's own as a TEXT e-mail. The script will be called from a cronjob to sent the e-mails (where MailSent field is 'no') in the queue.
A form should also be built to allow a text and/or html e-mail to be entered into the table, The html need only be the html code no html frontend editor required. The project must be your own and you may not use or derive from any GPL or php coding from a licensed project.
Thank you for looking at the project, your bid is welcomed!