vBulletin Tutorials

How to mass extend forum subscriptions

Submitted by H, , Thread ID: 9919

Thread Closed
H
y u so shit
Level:
0
Reputation:
91
Posts:
4.07K
Likes:
145
Credits:
5.54K
11-09-2015, 11:19 AM
This post was last modified: 11-09-2015, 11:19 AM by H
#1
It's easy, just requires the following SQL Query

Code:
UPDATE subscriptionlog
SET expirydate = expirydate + TIME_IN_SECONDS
WHERE subscriptionid = SUB_ID

With this, all you need to do is edit the 'TIME_IN_SECONDS' with a period of time in seconds. Use websites like http://www.convertunits.com/from/year/to/second to find out the period of time.

Enjoy :yus:
The Pengest Turkey

[Image: The-Chicken-Connoisseur-PENGEST-TURKEY-1-1.gif]


Users browsing this thread: 1 Guest(s)