Subscription Expiry email / notification

[arossphoto]

Thanks for figuring this out. I was also wondering when the emails went out.

For anyone else here's the code you need to edit:

WHERE subscriptionlog.expirydate >= " . (TIMENOW + (86400 * 2)) . "
			AND subscriptionlog.expirydate <= " . (TIMENOW + (86400 * 3)) . "

Are you sure you can just change the 2 and 3 to anything you want? What's the 86400 for?

Some of my members pay by cheque, so I want to give them sufficient notice to send their payment. It would be ideal if vB sent a couple of reminders a few weeks apart.

I also edited the email that gets sent and if anyone else wants to do this I found it in the phrase: paidsubscription_reminder

Thanks,

Andrew