vBulletin Tutorials

How to mass extend forum subscriptions

Submitted by H, 11-09-2015, 11:19 AM, Thread ID: 9919

Thread Closed

11-09-2015, 11:19 AM

This post was last modified: 11-09-2015, 11:19 AM by H

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: 2 Guest(s)