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:
[sql]UPDATE subscriptionlog SET expirydate = expirydate + 2678400;[/sql]

[Andreas]

I'd add active=1

[rinkrat]

Originally Posted by KirbyDE

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]

Originally Posted by 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

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