The Arcive of Official vBulletin Modifications Site.

Mass Subscription Extender · **Released**: 04-06-2010

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 · #2 04-07-2010, 08:54 AM

nice idea
thanks

ThePhoneGuy · #3 04-08-2010, 04:41 AM

Thank you

.

Da-Vinci · #4 04-11-2010, 05:18 PM

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

ThePhoneGuy · #5 04-12-2010, 11:12 AM

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 · #6 06-27-2010, 05:18 AM

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

customcolor · #7 06-27-2010, 05:26 AM

i should say...what is phpmyadmin?

merk_aus · #8 06-27-2010, 05:28 AM

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 · #9 06-27-2010, 05:34 AM

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

ThePhoneGuy · #10 07-07-2010, 07:22 PM

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05112 seconds Memory Usage 2,293KB Queries Executed 24 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!