Email Members On Events
This job should be really easy for a coder who knows what he is doing. I want functions creating to email the members when certain events occur in the script. The “events” themselves already happen, I just want you to send specific emails when certain events occur.
Like this…
select from article_master
When article status changes from 0 – 3 if member subscribed = 1 send email #1
When article status changes from 0 – 2 if if member subscribed = 1 send email #2
When article status changes from 3 – 1 if member subscribed = 1 send email #3
When article status changes from 1 – 2 if member subscribed = 1 send email #4
select from pro_userad
When article credits = 1000 if member subscribed = 1 send email #5
When article creddits = 10000 if member subscribed = 1 send email #6
When article ads status changes from 0 – 1 if member subscribed = 1 send email #7
When article ad status changes if member subscribed from 1 – 0 send email #8
There is currently no table for the emails, but everything else is
already in the database. It’s just a case of writing the functions to send the emails, adding the emails table and testing it works.
