auto notification based on time

[dodo]

hi, i'm writing a script to run advertising for members. i want to know if there's a way to send members emails before their accounts expire. like 5 day advance email and 1 day advance email. since the date will be different for all members, i don't want to make cron jobs to run the script every day.. is there another way to do it? thanks.

[mogster]

Well, if you have some members at your site, so that you know that the index.php will be loaded at least once a-day, you could let anonymous users do it.

Just add the code on top of the page, and each time it loads it will check if expirees exist and mail the users in question. You'll have to add a field to your member-db, though - so that the poor member don't recieves a mail each time the page loads after the time has expired 😃
If you add two SET-fields, you can call them warning_one and warning_two, and use them for control by setting them to y or n.

You'll probably want to check the mail-code closely to avoid misuse of the script.

Let your users do the work!

knutm 😉

[dodo]

yea that's an idea but no one can gaurentee the script is loaded as least once a day tho.

[Tracer]

Since MySQL doesn't have triggers you will have to either take the above approach, or run a cron job......

if not on a linux box...

On a windows box you could create your php file....create a link to that php file...set the scheduler to open that php file daily in ie....I have never tried this but it might work?