Miscellaneous Hacks - Subscription Notifications -- Drive paid subscriptions & renewals

vB 4 beta version: https://vborg.vbsupport.ru/showthread.php?t=241224

Paid Subscriptions are a means of driving revenue for thousands of forums but what do you do when a subscription is about to expire? On most forums, if the subscription does not recur automatically, users lose their status and only if they notice a change in benefits do they think to renew. By proactively informing users of their subscription expiration you can help increase paid subscription renewal rates and decrease support inquiries from subscribers.

Notifications Options & Customizations:

The Subscription Notifications System can appear on your Forum Home and/or User CP pages and can display the following messages:

Expired Alert
24 Hour Alert
48 Hour Alert
7 Day Alert
1 Month Alert
Long Term Membership
No Membership

All of these messages can be configured using phrases and customized with HTML code to meet your forum's needs.

Each message is enabled/ disabled through your vB control panel with a link provided to modify the message contents using the phrase system.

Modifications/ Instructions:
Template edits: 1-2
Plugins: 1 (adds 1 template and several phrases & settings)
SQL Queries Added: 1-2

This addon should take under 5 minutes to implement and customize. Note: Minor template modifications are required for this addon to show up (see instructions file for more details)!

Compatibility with 3.6.x versions:

This addon will work with 3.6.x but the admin cp phrase links will appear broken. Users of 3.6.x versions will need to manually search for the phrases to customize.

Updates:
- 12/24/2008 - Minor bug fix to support table prefixes
- 08/26/2008 - Minor bug fix to change expired subscription message.
- 06/12/2008 - Update recent subscriber feature
- 06/06/2008 - Update to fix urls to relative path
- 06/05/2008 - Update to resolve bug with date format and multiple subscriptions

Credit goes to tspore for providing the original idea for this addon.

[Ted S]

Originally Posted by vitrag24

update for vbulletin 4 plz?

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

[Drareg]

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?

[Ted S]

Originally Posted by Drareg

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?

This mod does not notify admins.

[Drareg]

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.

[Ted S]

Originally Posted by Drareg

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.

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.

[Drareg]

Thanks Ted for the effort, I will do so.

[jnmann]

Can this work on 4.2.1?

[Ted S]

Originally Posted by jnmann

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...