MOD Request - Birthday E-Mail

I am not sure if this is possible but I would like to have a mod that would read the DB to see if a members b-day was on that day and then send them a pre-made email to say Happy B-Day. 

Would this be a difficult request?

The difficulty with that is, you would need to set it up your server to run that check each day.

email notifications are triggered by someone physically posting. There's no built in facility in IIS to automatically trigger something on most web hosts. But with access to the server, you can use the windows scheduler to run an asp script that hits the db and tthen sends the email.

If it's set up for it, you can also use ms sql mail to send something direcly from the db server.


Edited by dpyers - 27 July 2006 at 10:19pm

Someone doesn't have to 'physically' post, they can just be browsing a page, and the page could do a logic test for birthdays. You can fake an automatic birthday email by creating a script on the common.asp page, or make a new page and include it in the common.asp page.

In theory, whenever any page in the forum is loaded the script would execute by checking for any birthdays on the current date, check to see if a flag has been setup yet saying when the last birthday email was sent, if there is none or its from last year then execute a block of code that emails a preset birthday message to the user who's birthday it is. The script would then set the mentioned flag for the Date/Time that the email was sent; this would prevent the script from emailing a user multiple times, since anyone that accesses your forum will basically make that script run.