Mass Subscription Extender
Mod Version: 1.00, by ThePhoneGuy
| vB Version: 4.0.2 | Rating:  (1 vote - 5.00 average) |
Installs: 7 |
| Released: 07 Apr 2010 | Last Update: Never | Downloads: 0 |
 Not Supported
 DB Changes
|
||
Easier Version
~~~~~Subscription Extender BETA~~~~
Hey i noticed that i needed to update end dates for all my subscription users at once. Took me a while to figure out and the is 0 documentation on how to do this so run this as an sql query in phpmyadmin
UPDATE `DATABASE_NAME`.`subscriptionlog` SET `expirydate` = `expirydate` + '430000'
430000 = 5 days in epoch time
epoch time is just seconds that have elapsed since January 1, 1970
Hope that helps someone who was as frustrated as me
.
http://www.epochconverter.com/
~~~~~Subscription Extender BETA~~~~
Hey i noticed that i needed to update end dates for all my subscription users at once. Took me a while to figure out and the is 0 documentation on how to do this so run this as an sql query in phpmyadmin
UPDATE `DATABASE_NAME`.`subscriptionlog` SET `expirydate` = `expirydate` + '430000'
430000 = 5 days in epoch time
epoch time is just seconds that have elapsed since January 1, 1970
Hope that helps someone who was as frustrated as me
.http://www.epochconverter.com/
Download
No files for download.