Free one month subscription

[rinkrat]

My site has been down for a week (thanks to Dell's fine "new" server) and I'd like to welcome my subscribers back with a free month of service. My site is still offline so I can't check now, but is there an easy way to just add a month to all subscriptions?

[Marco van Herwaarden]

Not tested (so try on testboard first) but the following might add 31 days:
UPDATE subscriptionlog SET expirydate = expirydate + 2678400;

[Andreas]

I'd add active=1 :)

[rinkrat]

I'd add active=1 :)


What does this mean and how do I do it?

[Marco van Herwaarden]

It will prevent not active sub's from having the expiry date changed.

[rinkrat]

Oh that sounds good, so how do I package it all up with the active=1 part added? I can run queries, just need to know what to type in there :)

Thanks for the help :)

[saxonian]

Oh that sounds good, so how do I package it all up with the active=1 part added? I can run queries, just need to know what to type in there :)

Thanks for the help :)

UPDATE subscriptionlog
SET expirydate = expirydate + 2678400
WHERE active='1';