Miscellaneous Hacks - Mass Subscription Extender

Easier Version
~~~~~https://vborg.vbsupport.ru/showthread.php?t=248232~~~~


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/

[abdobasha2004]

nice idea
thanks

[ThePhoneGuy]

Thank you .

[Da-Vinci]

Wish I'd know aboutthis 2 weeks ago lol. Thanks for this it will make lfe easier.

[ThePhoneGuy]

lol yeah we have about 500 subscribers and i wasnt about to do it by hand :P. and you are welcome. If this becomes fairly popular i will make it into an addon.

[customcolor]

im not able to run a sql...why..?? i am the admin of the site!

[customcolor]

i should say...what is phpmyadmin?

[merk_aus]

Thanks for this a fantastic option to have - although I don't need it at the moment I will need it in about a weeks time so have taken down the sql querie.

Much appreciated.

[customcolor]

ok i found out....now if i have a few diff types of subscriptions...how do i just change just one of them

[ThePhoneGuy]

Thanks everyone. Also about the question with multiple subscriptions. I am not totally sure. I would have to it in php. I wouldnt know where to start in mysql. You would need to find out what the subscription id is for sure though :P.