Mini Mods - MNG - Send Custom PM or Email to User on Paid Subscription

Send Custom PM or Email on Paid Subscription v1.0

About this mod:

I have seen a number of requests for the ability to send a custom PM and/or a custom email when a user buys a Paid Subscription from your board. This would be used if you want to tell them their payment has been received, rather than relying on, say, paypal to do it for you. You can write a custom message in the PM or email to explain what they've bought and are entitled to now.

This is also good for when you receive a donation from users, as you want them to feel like they've been acknowledged in some way, by PM or email.

I had to code this for my own board anyway, so I thought I'd release it here.
I'm just that nice.

This hack allows you to configure text for a PM and/or an email on a per-subscription basis.
You can set either the PM or email or both to send when someone purchases a subscription.

Configurable:
* The PM sender
* The PM subject
* The body of the PM
* PM active/inactive for a particular subscription.
* The email sender address
* The email subject
* The body of the email
* Email active/inactive for a particular subscription.
* The Paid Subscription ID that the PM and/or Email are to be sent for when one of the subscriptions is bought.
* Email text always includes the expiry date of the subscription (hardcoded).
* Email text always includes a link to the members' profile.


Input on features you would like to see for this hack is very welcome, but may not be possible to implement. The Paid Subscriptions are very tightly coded by default in vbulletin.

What this mod does to your board: (nice to know beforehand)

* 1 plugin added.
* 1 table added (called 'subscriptionpmemail').
* 1 Admincp menu xml file.
* 1 function file for use by the admincp.
* Time to install: 1 min

Updates:

Version 1.0 (28th March 2008):

* Release of this hack for vBulletin version 3.6.8

MAKE SURE YOU CLICK INSTALL!
If you like this hack and use it then DONATE!

Pictures (attached):

1. Admincp: Configure PM or Email text to send.
2. PM that is sent to user upon purchase of a particular subscription.
3. Email that is sent to a user upon purchase of a particular subscription.

[stamos2003]

awesome, I will give it a try!

[Konstantinos]

* Email text always includes the expiry date of the subscription (hardcoded).
* Email text always includes a link to the members' profile.

how do we include this in pm too

[Konstantinos]

Originally Posted by fariborz

I installed in 3.7.1 PL2
I have not any problem with this product, just can't send any email to users.

well if this is not a problem than what whould be ?

[MrEyes]

I have installed this on my 3.7.2 test forum and everything seems to work as intended which is great.

However, I have noticed a quirk....

If an admin goes to ACP Paid Sub Manager and edits an existing user subscription then a PM is also sent to the user. Is there anyway to stop this from happening?

And, I have a couple of suggestions....

It would be great to have replacement variables in the PM text, for example:

Hello {UserName}

Thanks for subscribing to {PaidSubName}, I can confirm that we have received your payment of {PaidSubAmount} and your account has now been upgraded

So this would be received as

Hello JohnDoe

Thanks for subscribing to The Greatest Subscription on Earth, I can confirm that we have received your payment of ?1,000,000 and your account has now been upgraded

Another suggestion, which I am sure many people will really appreciate is the ability to run custom SQL calls on subscription. As a silly example, buying a paid sub increases your post count by 100 and gives you 1000 in casino money (see Casino mod here on vb.org) So you would define additional SQL as:

update user set posts = posts + 100 where userid = {userid}
update user set casino_cash = casino_cash + 1000 where userid = {userid}

And finally, another suggestion - have the ability to exclude usergroups/userid from receiving the PM

EDIT: Note to self, read the entire mod description before wading in with a "quirk report" However having the ability to exclude userid from the PM could prevent this. So if an admin is making a sub edit they temporarily add the userid into exclusions, make the edit and then remove it.

EDIT 2: If for whatever reason you do not want to make these changes do you mind if I take the current mod code base and extend it to perform these functions?

[ringleader]

Hey guys, I've been reading the posts and keeping up with the suggestions and such on this thread, but I've been snowed under with work for the past while (new job and all that jazz).

I will be free in about 2 weeks to begin working on this again immediately. Thanks for supporting the mod! Apologies for not getting the time to respond earlier.

[fariborz]

I'm using vBulletin 3.7.2 PL2, and i'm moving my second DataBase to other server.
After that your problem is not worked for me!!
and after add paid i received this error:

FATAL ERROR

Unable to proceed with save while $errors array is not empty in class vB_DataManager_PM in [path]/includes/class_dm.php on line 810
#0 vb_error_handler(256,

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

What can i do now?

[kafi]

Some of my users got PM and Email although I havent updated or changed their subscriptions.
The time when messages was sent gives me hint that this happen somehow along with subscription script reminder.

Is that possible? What really trigger these mesages in this add-on?

[fariborz]

please update this plugin, i so need to using this

[nocturnix]

I would love to see an update too!

[stamos2003]

what about an option for sending PMs on subscription end?