Free one month subscription
 

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?

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

I'd add active=1 :)

What does this mean and how do I do it?

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

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';