Subscription Expiry email / notification

[PVO_Dave]

Hi,

From what I understand VB Auto emails 2 days before a sub is about to expire, for me thats not really enough notice, was thinking more like 2 weeks lol

I have tried searching this forum a lot today, but had no luck, can this be easily changed?

Have also replied to another thread to see if there is any kind of hack yet to display the expiry date for the members for 3.5!

Thanks
Dave.

[PVO_Dave]

No one?

You have all left the subscription reminders wait until 2 days before?!

[PVO_Dave]

Hello??

[ChurchMedia]

I have one that isn't quite ready to release, but you shouldn't have any problems. It will send an email to the admin and user when someone pays for a subscription and then also send an email to the admin and user when it expires (at midnight it sends out the expiration emails).

Just go through the code and customize it for your needs. Then add it as a product.

I'm using it with no problems.

[kyrnel]

Thanks for the plugin. It is certainly helpful to get an email when a new subscriber signs up and when they expire.

Any ideas on how to modify this to send a reminder to the user 30 days before the paid subscription expires? Right now, you are using the "paidsub_delete" hook that triggers the day of expiration. Right now, vB sends a reminder 2-3 days in advance, but I would like to change that to around 2-3 weeks.

[kyrnel]

I found the answer. You can just edit /includes/cron/subscriptions.php

There is very little code in the file. So you can easily see the '2' and '3' in the code. This means that the email notice goes out between 2 and 3 days from expiration.

I simply changed this to 30 and 31.

It would be nice for this to be an control panel option in the future.

[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

[arossphoto]

Originally Posted by arossphoto

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

Can anyone confirm that it is okay to just change the 2 and 3? If I change this to 30 and 31 will they receive the notification in 30 days?

I'd just like to make sure it works before I start messing with the code.

Thanks,

Andrew

[PVO_Dave]

86400 is how many seconds in a day right? so this should work! Thanks! Will change it now

[kontrabass]

Originally Posted by ChurchMedia

I have one that isn't quite ready to release, but you shouldn't have any problems. It will send an email to the admin and user when someone pays for a subscription and then also send an email to the admin and user when it expires (at midnight it sends out the expiration emails).

Just go through the code and customize it for your needs. Then add it as a product.

I'm using it with no problems.

To date this is the only mod that will send an email to a user when they subscribe (ie, THANK YOU!). It worked great for me in 3.5, but it doesn't work in 3.6. I mean it works, but the subscription name is blank:

"test1026 has subscribed to . "

Would you be able to do a 3.6 fix? TIA!!