Add-On Releases - EPC PM Notifications "SUITE" with AJAX

EPC PM Notifications "SUITE" with AJAX

Ok, you may have to ask, what would we want this for? Because we just fulfilled a member's request here in our other MOD: EPC vbMailer

Where this member asked in posts, 8, 18, and 34... So that being said we put the whole idea wrapped around his thoughts into a FREE mod here...

Description

Basically the paid subscriptions in vbulletin when someone signs up and buys something from the forums/payments.php page there is no email/pm notification sent to them.

For people who use the paid subscriptions in vbulletin for one thing or another, it is quite often very useful to set up a email/pm notification to say thanks, or to let them know what they have to do next, or to let them know what features that now have access to etc.

So what he wanted we built , that's what you get when you support our by leaving us feedback!

Installation Guide

If you had our previous hack installed, from version 1.1 and prior, remove it totally!

Step 1) Upload the files in the 'upload' folder to your forums' root folder

Step 2) Import the 'product-sub_receipt.xml' file into your Product Manager (Add/Import Product)

Step 3) Enjoy and remember us in the future! Click INSTALL for updates!

Settings Documentation

General Settings --

• Send PM Global - this is a switch to turn global PM sending on and off, allowing you to control every notification sender in EPC PM Notifications.
• Send Email Global - same as above except pertaining to emails.
• Admin Username - set this to the admin username of your forum. This is where admin PM notifications are sent and where user notifications are sent from.

Paid Subscription Settings --

• Send PM - allows you to turn PM sending for Paid Subscription Notifications on or off.
  PM CC Usernames - a comma-separated entry of usernames to send CC of the Paid Subscription Notification to.
• PM Title - the title of every outgoing notification.
• PM Message - the message of every outgoing notification. To display a user's username, enter '%1$s'. To display the subscription's name, enter '%2$s'. To display the subscription's cost, enter '%3$s'.
• Send Email - allows you to turn Email sending for Paid Subscription Notifications on or off.
• Email Subject - the subject of every outgoing notification email.
• Email Body - the body of every outgoing notification email. To display a user's username, enter '%1$s'. To display the subscription's name, enter '%2$s'. To display the subscription's cost, enter '%3$s'.

Change Log

v1.1:

• Ajaxified the whole backend for the admin
• Added support for sending as e-mail also

v1.2:

• Converted to a Suite with many more options and cool features
• More secure than v1.1 due to a flag we just received last night about a possible SQL Injection possibility. So we corrected it all overnight

v1.5:

• Renamed the whole project to EPC PM Notifications "Suite" you will see why when you install!
• Security fixes
• Optimized code

[Andreas]

serialize() works fine with apostrophes - you just have to run the serialized string through mysql_real_escape_string (eg. $db->escape_string()), just as any other non-sql safe string too.

Not using phrases is bad if you run a board with multiple languages.

[blogtorank]

Originally Posted by Andreas

serialize() works fine with apostrophes - you just have to run the serialized string through mysql_real_escape_string (eg. $db->escape_string()), just as any other non-sql safe string too.

Not using phrases is bad if you run a board with multiple languages.

Thanks Andreas, you are great help to us and if anything we owe you a link back to you on this next release Great help like you is hard to come by, especially with your expertise within vB code!

Thanks again.

[blogtorank]

Side note to Andreas bug:

However to reproduce your "Bug" that's not happening here neither, I've run this many times on 3.6.8 and can't reproduce no bug as you state that is to the naked eye or to error_logs. As mentioned we are looking at your standards are implement them into our next revision because of my previous post.

[Andreas]

It most likely does not happen with default vB code, however it would occur on my board (which uses a cronjob to extend subscriptions if the user had chosen a recurring subscription)

[blogtorank]

But you downloaded so you did check install so I can make a special fix for andreas?

[Andreas]

[ot]
Yes, I downloaded it but I did not install it - I came across the first bug I posted (exec_shut_down() being called) on a customers board
[/ot].

[blogtorank]

Originally Posted by Andreas

[ot]
Yes, I downloaded it but I did not install it - I came across the first bug I posted (exec_shut_down() being called) on a customers board
[/ot].

Ah I C now.. :P Anyhow I'll send a test your way for that board if you like unless you have made this revision and like to share?

[Hornstar]

Hey I finally got to install this just now after being so hectic at uni.

Just wanted to say, it does not have the 1 extra feature I need.

The ability to write up different emails/pms per subscription. I dont want to send the same email/pm for the different subscriptions I have, some I may like to give them info of where they have to download the content from, another subscription may be just as simple as saying thanks etc.

Can you add the ability to write up a predefined template per subscription that I have.

Thanks.

[Inkybro]

Originally Posted by hornstar1337

Hey I finally got to install this just now after being so hectic at uni.

Just wanted to say, it does not have the 1 extra feature I need.

The ability to write up different emails/pms per subscription. I dont want to send the same email/pm for the different subscriptions I have, some I may like to give them info of where they have to download the content from, another subscription may be just as simple as saying thanks etc.

Can you add the ability to write up a predefined template per subscription that I have.

Thanks.

Hm...

We will certainly look into this for you.

[Hornstar]

I woke up this morning with database errors as follows:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM vb3_subscription WHERE id='10';

MySQL Error  : Unknown column 'id' in 'where clause'
Error Number : 1054
Date         : Friday, August 31st 2007 @ 03:25:41 PM
Script       : http://www.gamerzneeds.net/forums/payment_gateway.php?method=paypal

Uninstalling until the above can be fixed as well, as I lost several subscriptions last night.