How to mass extend forum subscriptions

by H - 11-09-2015, 11:19 AM
y u so shit
Posts:
6,599
Joined:
Feb 2015
Likes:
137
Credits:
5,871
Reputation:
93
2 Years of Service
#1
OP
Posted: 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]

The last reply on this thread is older than a month. Please do not unnecessarily bump it.
Register an account or login to reply
Create an account
Create a free account today and start posting right away. It only takes a few seconds.
Login
Log into an existing account.
1 Guest(s)