The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
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?
|
#2
|
|||
|
|||
Not tested (so try on testboard first) but the following might add 31 days:
[sql]UPDATE subscriptionlog SET expirydate = expirydate + 2678400;[/sql] |
#3
|
||||
|
||||
I'd add active=1
|
#4
|
||||
|
||||
Quote:
What does this mean and how do I do it? |
#5
|
|||
|
|||
It will prevent not active sub's from having the expiry date changed.
|
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
Quote:
SET expirydate = expirydate + 2678400 WHERE active='1'; |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|