extend the expiration date

tto
OFFLINE
Posts: 82
Thanks: 4
Karma: 0

6 years 2 months ago #308359 by tto

extend the expiration date was created by tto

Hello

My site went down for some time, and I want to extend the expiration date for all active memberships by adding 15 days to cover the downtime.

I have three plans in CBSubs, how can I do that?

Thanks,

Regards,

Tariq

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48675
Thanks: 8313
Karma: 1446

6 years 2 months ago #308379 by krileon

Replied by krileon on topic extend the expiration date

As long as they're not recurring subscriptions you can extend all their expiration dates manually within the _cbsubs_subscriptions database table. Example as follows.

Code:

UPDATE `jos_cbsubs_subscriptions` SET DATE_ADD( `expiry_date`, INTERVAL 15 DAY ) WHERE `status` = 'A'

If they are recurring subscriptions then there is no means of adding time to their subscription and best I can suggest is provide them a coupon for a maybe 10% off their next renewal.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon