vb.org Archive - Miscellaneous Hacks - Subscription Notifications -- Drive paid subscriptions & renewals

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - Miscellaneous Hacks - Subscription Notifications -- Drive paid subscriptions & renewals (https://vborg.vbsupport.ru/showthread.php?t=179864)

Haha.

No pressure Ted, but I'm another person who will be using this when it's updated for VB4 :)

Aha, just here to add my two cents for this one to be ported on vb4... Thanks!

waiting for vb4 version

plz update to 4.0 soon.

Quote:

Originally Posted by Ted S (Post 1940576)

vb4 support will be added in the next couple of weeks.

Thanks Ted ... :)

This particular mod has really helped our site ..

Regards,
Badger

Would love vB 4.x support as well!

This mod has been very helpful!

Sorry for those waiting for a vb4 version.

You can find a beta version at https://vborg.vbsupport.ru/showthread.php?t=241224.

Hey Ted...

I know you may not be working on this 3.7 version any more, but in regards to showing or not showing the EXPIRED message, here is my thought....

Add an option for how many days after the last subscription date for the user has expired to show the EXPIRED message (if that message is turned on). Thus the logic for this EXPIRED message would be (With a setting of 5 in the # of days to show after subscription has expired)...

Show EXPIRED MESSAGE, YES or NO?
IF NO, end.
If YES, is the expired date older than 5 days ago?
If YES, END (Do not show message)
If NO, Show EXPIRED message.

You more or less do this kind of thing already seeing you show a given message based on the date of the subscription.

If you could add this...It would be GREAT. As right now I do not have it show the EXPIRED message as it would just stay on the persons screen all the time if they were ever a paid subscriber.

Regards,

update for vbulletin 4 plz?

Quote:

Originally Posted by vitrag24 (Post 2162704)

update for vbulletin 4 plz?

It's been out for over almost a year... https://vborg.vbsupport.ru/showthread.php?t=241224

A question, users are notified when a subscription will expire, but what about notifying an Admin when a users subscription will expire?

I could not find anything about this, just a simple email to the admin to notify him or is this just a silly question?

Does this mod also work on 3.8.4?

Quote:

Originally Posted by Drareg (Post 2421360)

This mod does not notify admins.

I thought so. We do not use PayPal or anything else, just members pay per bank. But when the member gets an expire email, it would just be nice that the Admin also gets a notification of this. I could not find anything so far about this, suggestions?

Maybe it's simpel by coding the subscriptions.php in includes/cron and add the Admins email address, but I'm not a coder unfortunatly.

PHP Code:


		
			
    vbmail_start();

    while ($subscriptions_reminder = $vbulletin->db->fetch_array($subscriptions_reminders))

    {

        require_once(DIR . '/includes/functions_misc.php');

        $subscription_title = fetch_phrase('sub' . $subscriptions_reminder['subscriptionid'] . '_title', 'subscription', '', true, true, $subscriptions_reminder['languageid']);



        $username = unhtmlspecialchars($subscriptions_reminder['username']);

        eval(fetch_email_phrases('paidsubscription_reminder', $subscriptions_reminder['languageid']));

        vbmail($subscriptions_reminder['email'], $subject, $message);

    }

    vbmail_end();

Something else, below in subscriptions.php is this line:

PHP Code:


		
			
// time for the reminders

    $subscriptions_reminders = $vbulletin->db->query_read("

        SELECT subscriptionlog.subscriptionid, subscriptionlog.userid, subscriptionlog.expirydate, user.username, user.email, user.languageid

        FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog

        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = subscriptionlog.userid)

        WHERE subscriptionlog.expirydate >= " . (TIMENOW + (86400 * 2)) . "

            AND subscriptionlog.expirydate <= " . (TIMENOW + (86400 * 3)) . "

            AND status = 1

    ");

Can I change TIMENOW + (86400 * 2) and TIMENOW + (86400 * 3) to longer periods without problems? For example TIMENOW + (86400 * 7) and TIMENOW + (86400 * 14)

Thanks.

Quote:

Originally Posted by Drareg (Post 2421500)

PHP Code:


		
			
    vbmail_start();
    while ($subscriptions_reminder = $vbulletin->db->fetch_array($subscriptions_reminders))
    {
        require_once(DIR . '/includes/functions_misc.php');
        $subscription_title = fetch_phrase('sub' . $subscriptions_reminder['subscriptionid'] . '_title', 'subscription', '', true, true, $subscriptions_reminder['languageid']);

        $username = unhtmlspecialchars($subscriptions_reminder['username']);
        eval(fetch_email_phrases('paidsubscription_reminder', $subscriptions_reminder['languageid']));
        vbmail($subscriptions_reminder['email'], $subject, $message);
    }
    vbmail_end();

Something else, below in subscriptions.php is this line:

PHP Code:


		
			
// time for the reminders
    $subscriptions_reminders = $vbulletin->db->query_read("
        SELECT subscriptionlog.subscriptionid, subscriptionlog.userid, subscriptionlog.expirydate, user.username, user.email, user.languageid
        FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = subscriptionlog.userid)
        WHERE subscriptionlog.expirydate >= " . (TIMENOW + (86400 * 2)) . "
            AND subscriptionlog.expirydate <= " . (TIMENOW + (86400 * 3)) . "
            AND status = 1
    ");

Can I change TIMENOW + (86400 * 2) and TIMENOW + (86400 * 3) to longer periods without problems? For example TIMENOW + (86400 * 7) and TIMENOW + (86400 * 14)

Thanks.

You'll need to write a script to query the susbcriptions, generate an email and save it as a cron. Questions on coding like that are far better directed to the coding forum here where you get access to all sorts of individuals rather than a support thread like this one which is visited by very few developers.

Thanks Ted for the effort, I will do so.

Can this work on 4.2.1?

Quote:

Originally Posted by jnmann (Post 2481547)

Can this work on 4.2.1?

3.x mods do not work on 4.x

Of course the 4.x version will work fine...

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (18)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01262 seconds Memory Usage 1,783KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (18)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: