Superesponder Email System
What I am trying to do is make a query that would tell the user how many emails the system sent today, in the past week, month to date and total emails sent. I am attaching 2 excel files from the tables and 2 scrips [login to view URL] and [login to view URL] script
Table: aptiresrecipients
owner = User account name
nexttime = time the next email should go out
nextmail = number of days from the first email that this email goes out (first email is an autoresponder goes out ASAP)
realname = Name given by client
urlfrom = If our form is used the url form the form submit
httpfrom = IP address of lead from form submit
reference = custom imputs from form submit
timesubscribed = time when the lead first hit the database
email = email address of the lead
bounces = number of times the email has bounced when trying to send
Table: aptiresresponses
owner = User account name
days = number of days from the first message
messageloc = username + the number of days from the first message
subject subject of the email
messagetype = code to know how to send (text, html or both)
textmessage = message body put into text field
htmlmessage = html code put into html field
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Linux Perl and Mysql