Add time to active members of an entire subscription?

[sub_ubi]

Had a problem with a section on my forums, and would like to give all active members of this particular subscription id a free month.

Any way to do this? I have full phpmyadmin access if that makes things easier.

--------------- Added 1229649804 at 1229649804 ---------------

Would something like this work?

UPDATE subscriptionlog
SET expirydate = expirydate + X
WHERE subscriptionid = Y

[sub_ubi]

yeah that's it. More detail:

UPDATE subscriptionlog
SET expirydate=expirydate + 86400
WHERE status=1 AND subscriptionid=2

Don't forget table prefixes if you have em. 86400 is equal to 1 day. status is if they are active, 0 is if they are inactive.