![]() |
Mass Subscription Extender
1 Attachment(s)
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 :D. http://www.epochconverter.com/ |
nice idea
thanks |
Thank you :D.
|
Wish I'd know aboutthis 2 weeks ago lol. Thanks for this it will make lfe easier.
|
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.
|
im not able to run a sql...why..?? i am the admin of the site!
|
i should say...what is phpmyadmin?
|
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. |
ok i found out....now if i have a few diff types of subscriptions...how do i just change just one of them
|
:) 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.
|
All times are GMT. The time now is 04:55 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|