Subscription Notifications -- Drive paid subscriptions & renewals

[Ted S]

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]

Reserved for future use. Please submit your real life examples for inclusion here!

[TOGUIMASTER]

Perfect! Installed!:D

[Ted S]

Perfect! Installed!:D

Geeze! That was fast... Let me know how it's working...

[tspore]

Very nice work Ted,
I love it, 1 note - the link back to this mod in the install.html doesn't seem to work. For me this mod is invaluable.
I hope many kick in a few bucks to support more of these mods.

[Ted S]

link back to this mod in the install.html doesn't seem to work. For me this mod is invaluable.

Thanks. This has been fixed and an update posted. A reinstall/ upgrade is not necessary.

[billt928]

how can this be added to the new post page?

[Endurer]

Excellent, definitely installed.

[amc]

Does the notification include the "Name of the Subscription" also?

For example:

Your Paid Subscription to "Name of the Subscription" expires in less than two days.

This woud be helpful when a foum has different types of subscription.

Thank You.

[Mum]

I want to use this but my user cp doesn't have $header in it, can you tell me where to enter $submessage please?

[Ted S]

I want to use this but my user cp doesn't have $header in it, can you tell me where to enter $submessage please?


As explained in the install file, the user cp template should be modified to include this variable at or near the top. Where exactly is a function of where you want it go show up.

[jasculs]

I think I love you....lol...Great hack...something I've been looking for.

[Ted S]

how can this be added to the new post page?

You would need to modify the xml file adding a new plugin for the hook newthread_start. You can more or less copy the plugin for forumhome_start to accomplish this.

[Ted S]

I think I love you....lol...Great hack...something I've been looking for.

You're welcome... I think... :p

[Ted S]

An updated version has been released. This version provides access to one variable in the phrases. An update is not required unless you wish to access this variable.

[Mum]

As explained in the install file, the user cp template should be modified to include this variable at or near the top. Where exactly is a function of where you want it go show up.Yes, what it says in the install file is place it under $header - what i said was i don't have $header in my user cp file, so where should i enter it.

Sorry i wasn't clear that i WAS following the instructions of the install file.

[Ted S]

Yes, what it says in the install file is place it under $header - what i said was i don't have $header in my user cp file, so where should i enter it.

Sorry i wasn't clear that i WAS following the instructions of the install file.

No, it says to place it in under $header in the forumhome template and at the TOP of the file in user cp. But again, you put it where you want it to show up... at top, the bottom, anywhere you like.

As a side note, I've rewritten this step in the install file to make it easier to understand when just glancing through the step.

[Ted S]

Does the notification include the "Name of the Subscription" also?

At this time this is not possible although it is something I am working on.

[Mum]

Thank you, installed and working now :)

[amc]

At this time this is not possible although it is something I am working on.

Thank You, Ted!

Looking forward to it.

[Antivirus]

nice job Ted! I was planning on doing something similar using the PM system, however the alert message is likely much more effective. Kudos!

[Silver_2000_)!]

nice job Ted! I was planning on doing something similar using the PM system, however the alert message is likely much more effective. Kudos!

PM system would be a nice addition

Im surprised that more features like this that help people monetize their forums

[Ted S]

How do you see the PM system working?

[Silver_2000_)!]

How do you see the PM system working?

To be able to easily mass PM the folks whos Subscription has expired would be great. TO have the system PM the members who had subscribed in the past but are no longer active - would be great. One of the sites I help with is transitioning from manaul maintenance of a Club Membership system to trying to use the Subscription system for the payments and the status - It would be awsome to me able to better use the systems for that purpose. Off topic a little but its surprising that the members whos subscription recently expired cant see the expired status. Can see that the subscription was active last month for example. Current subscribers can see thier status and expired subscribers can resubscribe BUT they cant see the date when their last subscription ended

[UnNaTuRaL]

Thanks alot, very useful addon!

But it seems like if a member had a paid subscription before which expired, and now has a different one it always shows the 'Less than one day'-message. Is there any way to fix this?

[Mum]

Something isn't working properly - one of my members gets this message 'Your subscription expires on Sat, Nov 47 2008. Thank you for supporting Mummybrain.com.'

Her real expiry date is 22 Nov 2008.

[Ted S]

Thanks alot, very useful addon!

But it seems like if a member had a paid subscription before which expired, and now has a different one it always shows the 'Less than one day'-message. Is there any way to fix this?

Try this file and let me know if it works properly for this issue.

[afullcup]

Yeah, I got one of those today too:

Your Supporting Membership expires on Tue, Oct 41 2008.

[SVTOA]

Works great for me Ted... Nice work!

[regitbull]

uuhm i cant get this mod to work on 3.6.8
I installed it and put that $submessage under $header but it just show a blank box on the forum home.

And my $submessage template was called sub_expirations and not submessage.
So i think there is a problem with it to not work on 3.6.8

[Ted S]

uuhm i cant get this mod to work on 3.6.8
I installed it and put that $submessage under $header but it just show a blank box on the forum home.

And my $submessage template was called sub_expirations and not submessage.
So i think there is a problem with it to not work on 3.6.8

The template name is not related to the variable. Have you enabled any of the messages to show up? Are the phrases in your phrase manager?

[regitbull]

yes i turnt the guest message and the all time expire messsage on but they are not showing up.

Like i said only a blank box.

And yes the phrases are in phrase manager.

[SVTCobraLTD]

Yeah, I got one of those today too:

Your Supporting Membership expires on Tue, Oct 41 2008.

Is this problem resolved? I would like to install this great addition.

[regitbull]

ok strange.
i installed the mod on my live board to test it there and now its works.
Its strange that it didint work on my test board.

Anyway the box and the message shows up now last problem/but is the problem every1 has.
That the expire date is wrong.

[Mum]

Is this problem resolved? I would like to install this great addition.No it's not.

[Ted S]

No it's not.

Can you (or anyone else with this error) give the attached file a whirl? I've made an update but don't have time to test right now...

[regitbull]

Can you (or anyone else with this error) give the attached file a whirl? I've made an update but don't have time to test right now...

yes that fixt the problem.
Its working great now.

I clicked installed :)

And about any new updates you want to make you can maby use this mod:
https://vborg.vbsupport.ru/showthread.php?t=124740

Its almost the same mod as you made only a few more things like a subsciption title phrase and a .. days left till your subscription expires phrase.

I would like to see this to in your mod if you have time to do that.

Anyway good job and i clicked installed :D


Edit: ok i just discover that the already reported bug about the first subscription showing isint fix in the last xml you send.
So there is 1 last bug to fix :)

[Ted S]

Edit: ok i just discover that the already reported bug about the first subscription showing isint fix in the last xml you send.
So there is 1 last bug to fix :)

Can you explain exactly what is happening with your users for this? Ive had a few different reports and want to narrow this down more...

[regitbull]

Can you explain exactly what is happening with your users for this? Ive had a few different reports and want to narrow this down more...

I use the paid subscription systeem to sell vip on my site.

Ok a user bought 1 month vip first and after that expire he bought 6 months vip.
The box is showing the expire date of the fist subscription ( the 1 month vip )

So lets say the 1 month vip expire on 22-04-2008 and 1 day later he bought 6 months vip.
The message is now saying thanks for buying vip your vip membership expired on 22-04-2008 but it must be the expire date if the 6 months vip.

Thats the only last bug i have on the moment.

[jaymzz]

Thanks for add on. :D Clicked installed

[wacnstac]

Any chance of getting "Latest Subscribers" added to this product?

[nizzie]

amazing mod thanks for this. i will leave feedback on if it increase my paid member status

[Ted S]

Any chance of getting "Latest Subscribers" added to this product?

That would be a bit different than the intention of this addon. That said I can probably still help you... where would you want this to appear?

[wacnstac]

Top of FORUMHOME

[Ted S]

Please Note: An updated version of this addon has been posted which addresses the two known bugs. Users should now see the properly formatted expiration date for their subscription as well as show data from the farthest away expiring subscription. If your users have multiple active subscriptions this means the one that expires in the longest amount of time will be what the system uses to key messages.

An upgrade is recommended. To preform an upgrade, simply upload the new product file with the option "Allow Overwrite" enabled. This upgrade will only change the plugin code and will not alter customized phrases.

[R1lover]

Well the standard vb does send out a notice on subscriptions... I'm surprised nobody has mentioned this?

[|Jordan|]

Something weird is happening with the new version of this mod. In the top left corner of all my styles is the word "no". When i disable the mod, "no" goes away and when i enable it, it comes back. I've done this back and forth many times and its the same thing every time i enable it.

Why is it doing this?

[Ted S]

Something weird is happening with the new version of this mod. In the top left corner of all my styles is the word "no". When i disable the mod, "no" goes away and when i enable it, it comes back. I've done this back and forth many times and its the same thing every time i enable it.

Why is it doing this?

Sorry about that... I left my debug mode on. Please download the new version.

[Ted S]

Well the standard vb does send out a notice on subscriptions... I'm surprised nobody has mentioned this?

The email is wonderful but it's only one touchpoint and comes out just before the susbcription ends. Reminding people via email gets them thinking but they may forget to act... seeing it again when they're on the site is just another way of reinforcing the message. For some forums all the messages make sense, for others just one or two and of course for some, none.

[Tom_S]

It seems there are some path issues. It thinks it is in the root directory of my website when it isn't so therefore the link is not correct on the "Click Here". I don't see any place to adjust this for the path so I am assuming I need to do that within the xml itself?

[Tom_S]

Lack of sleep makes one not see things clearly LOL...I figured it out easy enough. ;)
Excellent mod! Thanks!

[jdebler]

Ted, thank you very very much for this!


And about any new updates you want to make you can maby use this mod:
https://vborg.vbsupport.ru/showthread.php?t=124740

Its almost the same mod as you made only a few more things like a subsciption title phrase and a .. days left till your subscription expires phrase.

I would like to see this to in your mod if you have time to do that.

I had that mod installed. It was awesome but doesn't seem to work on 3.7 and is evidently outdated/in the graveyard. Counted down the days, had an optional checkbox to not show the message again, etc. Not bad. Ted, if you want to evolve yours, might want to look into it. I can send you the code to review, I have it somewhere.

Which brings me to this question for this mod...

How long does the notice stay on the screen for the person viewing it?

If I do:
24 Hour Alert
48 Hour Alert
7 Day Alert
1 Month Alert

Does that mean the 1 month message will remain until the 7 day one replaces it, etc.? Or do the messages show just for that visit? Sorry if this has been answered, I looked.

[Ted S]

Good question Jason. At this point the messages show up until they are no longer relevant (i.e. the next one takes over). I'll likely add something to let the user close them down soon.

[Tom_S]

Ted I like the idea of adding something for the user to be able to add an ignore but only if that is admin adjustable. Certain users only if you know what I mean. Again thanks for this mod. I love it brother!

[Ted S]

Ted I like the idea of adding something for the user to be able to add an ignore but only if that is admin adjustable. Certain users only if you know what I mean. Again thanks for this mod. I love it brother!

Tom, you can put them into a usergroup and ignore that group all through the admin options.

[Mum]

It seems there are some path issues. It thinks it is in the root directory of my website when it isn't so therefore the link is not correct on the "Click Here". I don't see any place to adjust this for the path so I am assuming I need to do that within the xml itself?Has this been rectified? I had to uninstall in the meantime.

[Ted S]

Has this been rectified? I had to uninstall in the meantime.

This is not a bug to be fixed... urls are setup using the standard but you can edit any of the phrases/ links to match the individual forum needs.

[DssCrazy]

Ok guys i fixed the path problem.

if you have your path set to www.xxxxx.com/forum then download the xml with the title subexpires1.

If you have it set to www.xxxxx.com/forums then download the xml that has the title subexpires

Thanks

[Ted S]

Ok guys i fixed the path problem.

if you have your path set to www.xxxxx.com/forum (http://www.xxxxx.com/forum) then download the xml with the title subexpires1.

If you have it set to www.xxxxx.com/forums (http://www.xxxxx.com/forums) then download the xml that has the title subexpires

Thanks

Note: Downloading this version may not give you the latest changes as they are released. Using third party versions of addons is not recommended and may not be supported.

The latest version of this addon uses relative urls to point the user to the same path they are already in. If you wish to customize your urls beyond the defaults you can easily do through your admin control panel by visiting the Subscription Notices System.

[wacnstac]

Any word on getting "latest subscribers" added to this?

[Ted S]

Any word on getting "latest subscribers" added to this?
The purpose of this addon is to notify people about the status of their subscription which is what it does. While I see some interesting value to your suggestion, it's not something I see including in this particular addon.

[csquare016]

hi, this is very nice.
do you know if it will work with 3.6?

[Ted S]

hi, this is very nice.
do you know if it will work with 3.6?

It's not 3.6 tested nor do I support it with 3.6 but odds are it will work... I would encourage you to install it and see what happens.

[UK-Biker]

Installed

BUT

I would encourage "latest Subscribers" to be included to make this mod worthy of MOTM.

Great mod with loads of potential, so why not exploit it's potential ???

[regitbull]

its working perfect on 3.6.8 level 2 !!!

[Ted S]

Installed


BUT

I would encourage "latest Subscribers" to be included to make this mod worthy of MOTM.


Great mod with loads of potential, so why not exploit it's potential ???

Thanks for your feedback. As I mentioned before, I don't see the relation of one to the other but while i had been considering a separate hack, I'm very well aware that my opinion is not the only one that matters. :D

So with that in mind, for those of you who want to show the latest subscribers, where would this appear (in a message block? elsewhere?) and how would it function ideally for you.

Right now I'm thinking a list with an admin defined number of members that can be included with any of the other messages or with one for non-subscribers. Anything else you'd like to see it do?

[wacnstac]

I would love for it to be added to any template, but more specifically FORUMHOME, would be an ideal place for me. To get members to subscribe and resubscribe, they have to be able to SEE that others are subscribing as well IMHO.

[Ted S]

wacnstac, UK-Biker & others who want the recent subscriber function...

I've built out a new version of the addon which I think you'll like. Recent subscribers can be set for each/ any of the messages as can the number of subscribers shown and the date of each one's subscription. While I'm comfortable with how this works more testing and feedback would be great.

Please use the attached code on your test boards and let me know if it meets your needs. You can customize the list contents from the vBulletin options or phrase manager.

Note: You will need to enable the option for one or more messages to see it!

Second Note: For those who don't want this option, don't worry, it is disabled by default and queries are only executed if you enable it.

[UK-Biker]

Great News :D:up:


Will install the new code over the weekend and test it for a while and then leave feedback.


Thanks Ted

[wacnstac]

Can the recent subcribers be seen my non-subscribers as well? I'll try to get this installed tomorrow. Just saw it now.

[Ted S]

Can the recent subcribers be seen my non-subscribers as well? I'll try to get this installed tomorrow. Just saw it now.

Yup. Just use the notice for "non subscribers".

[wacnstac]

This is a fantastic hack. Does everything I could have ever wanted from it. Thank you!

[wacnstac]

What is the order of the names that are displayed in the latest subscribers part of this hack? My name always seems to be up first even though there are others who have subscribed after I did.

[Namaless]

Hook: usercp_complete
Code:

eval('$template_hook[usercp_main_pos1] .= "$submessage";');


[hr]

Hook: forumhome_complete
Code:

$vbulletin->templatecache['FORUMHOME'] = str_replace('<!-- main -->', '$submessage' . '<!-- main -->', $vbulletin->templatecache['FORUMHOME']);


Regards.

Regards.

[Ted S]

What is the order of the names that are displayed in the latest subscribers part of this hack? My name always seems to be up first even though there are others who have subscribed after I did.

Whoops... it was ordering by expiration date. This has been changed to the id #. Please download the newest version if you use the recent subscriber feature.

[SVTCobraLTD]

Good question Jason. At this point the messages show up until they are no longer relevant (i.e. the next one takes over). I'll likely add something to let the user close them down soon.

Has this been changed yet?

[Ted S]

Has this been changed yet?

It's not listed in the update log or features list... so no. :D

[imedic]

I have already installed the previous version and want to upgrade. Should I uninstall previous version and then install new one or just install?
If I uninstall it first would I lose the texts I have inputed ? Should I backup ?

[Ted S]

I have already installed the previous version and want to upgrade. Should I uninstall previous version and then install new one or just install?
If I uninstall it first would I lose the texts I have inputed ? Should I backup ?

To upgrade just upload the new product file and allow it to override what you have now. This way only new or updated information is applied and your old settings remain in place.

You should always backup addons before upgrading.

[vitrag24]

thanks.

[vitrag24]

https://vborg.vbsupport.ru/attachment.php?attachmentid=80996&d=1211241423
this notification is for all members or only for paid subscribers?

how this mod decide paid subscribers? as i've created 2 new usergroup for paid subscribers and also vb promotion system for same usergroup on certain posts..
will this mod show notice to all or only paid subscriber of that usergroup?

====================
One mopre question:
if one paid subscription is monthly based and other is 6monthly and annualy, and i keep 30days reminder on then will it show reminder to all subscribers including monthly or only to 6 monthly and annual subscribers?

===========
Bug:

--It's showing message of expiry to subscribers whose subscription is disabled.

--It's showing 24hours expiry message to users whose subscriptions is expired.
===========

One suggestion when u update mod:

-- one more option for users, whose subscription has been expired,not renewed will see message your sub scription has been expired click here to purchase again.

=============

[vitrag24]

check my last post..
updated..some bugs and suggestions.

[Ted S]

It's hard to follow your post but I'll try to respond best I can...

https://vborg.vbsupport.ru/attac...6&d=1211241423 (https://vborg.vbsupport.ru/attachment.php?attachmentid=80996&d=1211241423)
this notification is for all members or only for paid subscribers?

This message is for people not yet subscribing.

how this mod decide paid subscribers?

It looks at data in the subscription table. Usergroups are not relevant to this process.

if one paid subscription is monthly based and other is 6monthly and annualy, and i keep 30days reminder on then will it show reminder to all subscribers including monthly or only to 6 monthly and annual subscribers?


The mod looks for the newest subscription but really isn't meant for sites offering different levels that people would want to sign up for actively at the same time.

One suggestion when u update mod:

This message already exists in the modification and can be enabled through your ACP.

It's showing message of expiry to subscribers whose subscription is disabled.

If someone has an active or inactive subscription it finds it; if you've changed their usergroup to get them to not be "enabled" it will still show the messages. This mod queries based on data from the subscriptions table.

It's showing 24hours expiry message to users whose subscriptions is expired.

Please provide an example from your expiration database.

[SVTCobraLTD]

Any chance of this being updated to resolve the problem listed below?

Good question Jason. At this point the messages show up until they are no longer relevant (i.e. the next one takes over). I'll likely add something to let the user close them down soon.

I think the hack is a great idea and has great potentional.

[Ted S]

Any chance of this being updated to resolve the problem listed below?

I wouldn't call this a problem (the hack works it just keeps showing up) but it's something I still plan to address... I'm still trying to think of the best way to do it without adding a query.

Any other suggestions/ requests for the next version?

[infernow]

Thanks this will be usefull

[Sal Collaziano]

For some reason, this didn't work for me. It only displayed the message showing the last 5 subscribers who signed up for two specific levels. I have several different support usergroups and I need all the latest subscribers to appear here. If there's a way to edit which groups appear (preferrably, all of them), let me know.

[Mathew7000]

ever think about adding a "recently subscribed users" box down near the "currently active users" area on the forum home? like something everyone can see, just like seeing whos online on the forum home...Just a thought

[Ted S]

For some reason, this didn't work for me. It only displayed the message showing the last 5 subscribers who signed up for two specific levels. I have several different support usergroups and I need all the latest subscribers to appear here. If there's a way to edit which groups appear (preferrably, all of them), let me know.

Usergroups are not involved in this addon what so ever. All that matters is if the person appears in the Paid Membership database. Are you using that to manage your subscriptions?

[Ted S]

ever think about adding a "recently subscribed users" box down near the "currently active users" area on the forum home? like something everyone can see, just like seeing whos online on the forum home...Just a thought

Interesting idea and something I could spin out into a different addon for sure. Any other interest?

[Mum]

Yes Ted S - i'd use that feature :)

[Ted S]

For those of you trying to show recent susbcribers on the homepage, take a look at this addon https://vborg.vbsupport.ru/showthread.php?t=99049 which should work for 3.7.

[kau]

If I disable the option to not show that their subscription has expired then it leaves;

"Your Subscription is about to expire in less than 1 day"

If I keep it enabled it tells them their subscription has expired.

Once they expire I don't want to show them anything.

Is there a way to not show anything after they actually expire?

[Ted S]

Exclude that message, it should be an option?

[winpro19]

Amazing plugin, keep up the good work!

[winpro19]

Update: Just installed and tested. It is an amazing plugin indeed, been in look for something like this from long time. Don't know why, but not a lot of plugins for Paid Subscriptions out there =S

Anyway, this is great stuff. Works like a charm, and very professional looking / easy to manage.

Great stuff Ted!

Nominated for NOTM

[kau]

Exclude that message, it should be an option?

There is an option to not show the expired message but if I select no to that then it shows the Your Subscription is going to expire in less than a day but they are already expired.

[Ted S]

Got it. I'm a bit slammed this week but will release an upgrade that resolves this Thursday or Friday Kau.

[jambo_1969]

Installed.

Awesome mod !

[winpro19]

One question, it does not seem to be picking up on the latest 5 subscribers? This could be a conflict with one of the other mods I have installed, but I doubt it.

It's showing fairly recent subscribers, but I got few more after that and it's not updating. It is still showing the same 5 subscribers that it was when I first installed it. Anything I have to do to update it?

Thanks!

[SVTCobraLTD]

Got it. I'm a bit slammed this week but will release an upgrade that resolves this Thursday or Friday Kau.

Cant wait for an update for this. I havent installed it yet due to the message showing up as indicated before. Hopefully this is resolved with the update. Thanks for all your work.

[Ted S]

Kau & SVTCobraLTD...

I've made an update to address this issue but won't have time to test it until tomorrow. If you would like to run the new version here it is... It's a minor tweak so I don't expect any bad reactions, just the possibility that it doesn't solve the issue. Let me know if you get a chance to run this and what the results are.

Thanks!

[Ted S]

One question, it does not seem to be picking up on the latest 5 subscribers? This could be a conflict with one of the other mods I have installed, but I doubt it.

It's showing fairly recent subscribers, but I got few more after that and it's not updating. It is still showing the same 5 subscribers that it was when I first installed it. Anything I have to do to update it?

Thanks!

Are you new subscribers people who renewed or brand new to the program?

[winpro19]

Are you new subscribers people who renewed or brand new to the program?

Have had both brand new and a few that renewed their subscription (not automatic renewal, manually). It seems to be showing the same 5 (or 10) people ..hasn't changed even once.

Could this be a date issue ? I have the "Latest Paid subscribers" hack installed, and that works fine.

Thanks

[BigSoccer Tech.]

Were getting a bug where folks who once were preemies but didn't renew are getting a message saying "you have one more day til expriation"

how to fix??

[Ted S]

Were getting a bug where folks who once were preemies but didn't renew are getting a message saying "you have one more day til expriation"

how to fix??

Download the beta update a few posts back...

[SVTCobraLTD]

Am I missing something? I added the new updated product and also added $submessage to FORUMHOME but nothing. Below shows the code and where I entered it.

$headinclude
<title><phrase 1="$vboptions[bbtitle]">$vbphrase[x_powered_by_vbulletin]</phrase></title>
</head>
<body>
$header
$submessage
<br />
<table border="0" width="100%" cellspacing="0" cellpadding="0" align="center">
<tr>
<td valign="top" width="180px">
<table border="0" cellspacing="0" cellpadding="0" width="100%" align="center">
<tr>

[Ted S]

Have you turned on any notices to show up?

[SVTCobraLTD]

Yes, 24hr, 48hr, 7 day, no subcription, forumhome, usercp

But it does not show up anywhere. I am using 3.6.10pl3

[Ted S]

Do you have a test account I can login with that has a subscription setup?

[BigSoccer Tech.]

Download the beta update a few posts back...


thanks. in teh future will it be put in the main posting?

[SVTCobraLTD]

Do you have a test account I can login with that has a subscription setup?

I sent you a PM so we can discuss everything further. Thanks.

[BigSoccer Tech.]

Worked like a charm. You rock.

[Ted S]

thanks. in teh future will it be put in the main posting?

Yup. Just wanted confirmation from someone that it's working...

[Ted S]

Version 1.2.2 has been released with a minor bug fix which addresses an issue where the user's subscription has expired and the expired message was not enabled but other messages appear. To update install the new product file. No template changes are required.

This update is recommended.

[tarball]

Is it possible to show the message on the arcade header? I add $submessage on the arcade template, but nothing happens.

[Ted S]

At this point it won't work in external systems... You can however modify the plugin file to accomplish this.

[readjono]

Does the expiry notice disappear? I think it's a bit of a pain one member doesn't want to pay up now, but has had the message since May. Can we limit how long they see it?

[Ted S]

Does the expiry notice disappear? I think it's a bit of a pain one member doesn't want to pay up now, but has had the message since May. Can we limit how long they see it?

At this point you can't... how would you ideally like to see this message run (expires after time, lets them close it, etc...)?

[readjono]

Yeah I don't know. I mean I don't want the message to remain there forever as I guess some people won't want to renew subscriptions. If it just disappeared after 30 days or something would be good.

[Ted S]

Any other thoughts/ suggestions on how this would work?

[vitrag24]

what's more in 1.2.2 version than 1.2.1?

[Regs]

I would assume:

Updates:
- 08/26/2008 - Minor bug fix to change expired subscription message.

[vitrag24]

I would assume:

Updates:
- 08/26/2008 - Minor bug fix to change expired subscription message.

how to update from 1.2.1 to 1.2.2? just product overwrite or template modification also?

[Regs]

That I don't know for sure and the author is away until the 12th/13th.

[vitrag24]

That I don't know for sure and the author is away until the 12th/13th.

k.
i'll wait for 2-3days. thx. :)

[Ted S]

As explained in the instructions, updates are always applied by uploading the new product file overriding the old version.

[stamos2003]

I have a problem with the date and some languages,
with english & german language works fine when I set to Greek Language alla notifications come up like this:
Your paid subscription expired on B, D hd! Click here to renew it.

did I miss something? :confused:

[Ted S]

Sorry but I haven't tested this with other languages... you'll have to try and translate the phrase to see if it works.

[wacodep]

Nice, but I had to edit the SQL to show the most recent subscribers correctly.

[Puntoboy]

I enabled this mod and suddenly database errors occured.

[Ted S]

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]

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


What do you mean?

[Puntoboy]

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]

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 :)

[Goomzee]

i installed this but i don't know it's works or not

[Ted S]

i installed this but i don't know it's works or not

Well if it shows up to the groups you've set it for it works, if it doesn't show up then the install isn't working right. Not sure why you wouldn't know... If it's there it's there...

[dxlwebs]

OMG you will not believe how much of a div i am!

LOL i used this on my 3.6 version but then i updated to 3.7 and then a few later up to 3.8 for the fact of it being out! so i looked for this mod and found it here installed it and made the edits and everything was correct BUT nothing was showing and it drove me nuts for 1 whole hour!
:erm: then i realised i disabled it for the updates so i enabled it now and its working great like before thanks a lot great mod!

[Ted S]

Better that then a problem with the mod but still no fun!

[WavMixer]

This looks to be a great mod. It appears as though this only posts a notice to the subscriber on the message board. Can this also send email to the subscriber?

[Ted S]

This looks to be a great mod. It appears as though this only posts a notice to the subscriber on the message board. Can this also send email to the subscriber?

Nope . Although that's a good idea

[WavMixer]

Nope . Although that's a good idea
Perhaps a good enough idea to incorporate in a future release? :D

[Ted S]

Perhaps. I know vBulletin does some email notifications already so I'll need to see what can be done without this mod and be sure I'm not stepping on existing systems or mods.

[WavMixer]

Perhaps. I know vBulletin does some email notifications already so I'll need to see what can be done without this mod and be sure I'm not stepping on existing systems or mods.
Actually, I have been looking thru all of the mods for something to make multiple emails and specifed times and your mod is the closest thing so far. I wish there was already something that could do this.

[Budweiser]

Step 3) Template Modification

From your Admin Control Panel go to Styles & Templates --> Style Manager and select Edit Templates from the drop down list. Double click the USER CP and/ or FORUMHOME templates option and then double click the template name again to edit it.

Forum Homepage: Find $header in the template FORUM HOME...

User CP Page: Go to the top of the template USER CP...

Add the code: $submessage. Save the template and repeat the process for each top level style you have.

I'm not following your template modification instructions...
You say to Find $header in the template FORUM HOME... but then what??

Then go to the top of the template USER CP... Add the code: $submessage... I got that but why find $header in the template FORUM HOME if there is nothing to edit??
.
.

[Ted S]

I'm not following your template modification instructions...
You say to Find $header in the template FORUM HOME... but then what??

Then go to the top of the template USER CP... Add the code: $submessage... I got that but why find $header in the template FORUM HOME if there is nothing to edit??
.
.

[qoute]Add the code: $submessage. Save the template and repeat the process for each top level style you have.[/quote]

:confused:

[Budweiser]

Step 3) Template Modification

From your Admin Control Panel go to Styles & Templates --> Style Manager and select Edit Templates from the drop down list. Double click the USER CP and/ or FORUMHOME templates option and then double click the template name again to edit it.

Forum Homepage: Find $header in the template FORUM HOME...

User CP Page: Go to the top of the template USER CP...

Add the code: $submessage. Save the template and repeat the process for each top level style you have.


Add the code: $submessage. Save the template and repeat the process for each top level style you have. :confused:

I understand what you are saying about repeating the process for each top level style.
When I read the instructions this is what read...

There are two templates that need to be edited for each style.
1: Forum Home Templates>> FORUMHOME
2: User Control Panel Templates>> USERCP

The way I am reading the instructions, it says to go to the FORUMHOME template and find "$header". Am I supposed to add "$submessage" above the "$header" line?

Then the istructions say to go to the USERCP template and add "$submessage" at the top.

Am I reading the instructions incorrectly??
.
.
.

[Ted S]

Yes you are.

[Budweiser]

Yes you are.
LOL. Yes. I dont know why I read that thing over and over and it wouldn't sink in. I took a couple of days off and came back to it. I should of had a V8!

Anyway. another question which I hope is not too dumb.

I am using this on the USER CP page only and wanted to change the background color for all of the messages that appear there. I added ".alt3 {background:#F8F5A4;color:#222222;}" to my Additional CSS Definitions to change the background color of my notices and forum description area.
I went to $vbphrase[sub_phrase_none] and tried to add <body bgcolor="#F8F5A4"> but it didnt do anything. I also tried <td class="alt3"> It changed some of the background color but messed up the formatting.

I looked but dont know what other template to edit. Is there somewhere I can add <td class="alt3"> to change the background for all of the enabled notifications?

[Ted S]

<body> is the tag used for your entire page.

<td> creates a new table cell.

You're question can be best addressed understanding just a bit of HTML.... www.w3schools.com (http://www.w3schools.com) can help

[PVO_Dave]

Dont suppose you are planning to release this for v4 at all? Would be brilliant if you could use it in one of the forum blocks :)

[Ted S]

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

[vitrag24]

need this for vb 4.0
plZ

[Ted S]

need this for vb 4.0
plZ

This modification will be updated down the road... 4.0 is newly released and each mod takes time to update.

[wacnstac]

Yeap, I'm going to need it too.

[Ted S]

...

[Stubbed]

Haha.

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

[andreamarucci]

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

[vitrag24]

waiting for vb4 version

[vitrag24]

plz update to 4.0 soon.

[BadgerDog]

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

Thanks Ted ... :)

This particular mod has really helped our site ..

Regards,
Badger

[Falcon Capt]

Would love vB 4.x support as well!

This mod has been very helpful!

[Ted S]

Sorry for those waiting for a vb4 version.

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

[David Bott]

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,

[vitrag24]

update for vbulletin 4 plz?

[Ted S]

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]

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.

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_reminde r', $subscriptions_reminder['languageid']));
vbmail($subscriptions_reminder['email'], $subject, $message);
}
vbmail_end();

Something else, below in subscriptions.php is this line:
// 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]

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.

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_reminde r', $subscriptions_reminder['languageid']));
vbmail($subscriptions_reminder['email'], $subject, $message);
}
vbmail_end();Something else, below in subscriptions.php is this line:
// 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]

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