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.

[Puntoboy]

I enabled this mod and suddenly database errors occured.

[Ted S]

Originally Posted by Puntoboy

I enabled this mod and suddenly database errors occured.

Then disable it and post the actual error here so I can diagnose your forum's issue.

[Lovinmysailor]

Works great!!!!

Is there a way to make it so you can pick which subscription shows up?

[Ted S]

Originally Posted by Lovinmysailor

Is there a way to make it so you can pick which subscription shows up?

What do you mean?

[Puntoboy]

Originally Posted by Ted S

Then disable it and post the actual error here so I can diagnose your forum's issue.

I did that immediately.

Was unable to post the error at the time, but here it is.

Database error in vBulletin 3.7.3:

Invalid SQL:

						SELECT s.subscriptionid,s.userid,s.expirydate,u.username
						FROM vb3_subscriptionlog as s
						LEFT JOIN user as u ON s.userid = u.userid 
						ORDER BY subscriptionid DESC
						LIMIT 5;

MySQL Error   : Table 'puntosp_dbvb3forum.user' doesn't exist
Error Number  : 1146
Request Date  : Tuesday, December 23rd 2008 @ 10:15:21 PM
Error Date    : Tuesday, December 23rd 2008 @ 10:15:21 PM
Script        : http://www.puntosports.co.uk/forums/index.php?
Referrer      : 
IP Address    : 92.19.88.66
Username      : Nod
Classname     : vB_Database
MySQL Version :

[Ted S]

Originally Posted by Puntoboy

I did that immediately.

Was unable to post the error at the time, but here it is.

Thanks! The issue was with table prefixes and has been resolved. Please install the new plugin file.

[Ted S]

An update version of this addon has been released to address a small bug in querying data when database table prefixes are activated.

Users not experiencing issues or who are not using table prefixes do not need to upgrade.

To upgrade simply install the new plugin file allowing overrides.

[Puntoboy]

Nice one. I'll give it a go now. Thank you.

[snoopy5]

Does it work with vb3.8?

[Mum]

i'm using it on 3.8