Reoccurring Paypal Subscriptions

What this does (added in first post)

With the current vbulletin subscription set up, it only charges your members one time. So if you have a pay based site, or forum area they have to keep subscribing, and causing them to waste time and effort (and maybe you lose money)

What this does, is give you the option if you want one time payment (standard vb) or reoccurring payment.

When you choose reoccurring the script has them sign up for a reoccurring payment, as paypal sends you confirmation each time you get a subscription payment, your system will now update their access time.

This will save your members from having to resign up all the time and hopefully save you some money


For instance, say you have a paying member?s only area, and you want them to have to pay $10 a month.

With this you can charge per month and it handles all the charges, and every month they send another payment automatically your script gets updated and sets their new expiration.


This has been asked for many times and IMO should have been in to begin with.

Enjoy and I will help as I can.

Note from the new supporter: This hack is now being actively supported again. I have updated the install instructions to work for version 3.0.7, and we can now begin to work out any existing bugs. This code is still raw and has not been tested extensively due to the difficult nature of testing paypal transactions.

[Doug Quance]

I just discovered the problem only occurs when I select "reoccuring" in the ACP. If I uncheck it, it works fine...

Any ideas?

[Yahhoon23]

Just a quick question, maybe I could get an answer here.

I have it set for recurring subscriptions etc etc but one problem.

Whenever someone subscribes to my website, it gives them the option to provide a shipping address or not provide one. Well I want to make it where they have no option and it automatically provides the shipping address for me.

I have a Paypal donation button added on my website that auto-provides the shipping address but when you actually subscribe through the website and not the donation button you have the option to pick shipping address or no shipping address.

Any feedback would be great.

[AidanII]

I've been taking a quick look at the code for one or two purposes of my own...

Would it not make more sense to change

PHP Code:

if ($_POST['txn_type'] == 'web_accept' AND $_POST['payment_status'] == 'Completed' OR $_POST['txn_type'] == 'subscr_payment' AND $_POST['payment_status'] == 'Completed') 


to be:

PHP Code:

if (($_POST['txn_type'] == 'web_accept' OR $_POST['txn_type'] == 'subscr_payment') AND $_POST['payment_status'] == 'Completed') 


I beleive this is functionally the same, but does one less comparison. Yes, I'm being picky here, sometimes things like this just irk me a bit.

A possible addition might be setting up the POST request to Paypal to automatically submit the correct URL for the notification. I beleive the parameter is called "notify_url". This should automatically enable IPN for the transaction posted, regardless of the settings in the account - As long as it's capable of IPN of course!

[AidanII]

Originally Posted by Doug Quance

Any clues as to how to fix this?

Doug, check the code you added to the includes/functions_subscriptions.php, in particular the bit under case 'paypal' after the case statement. Also check to see if it still works correctly for a one-off payment. If you're getting an error from that part, then ensure things like your paypal email address are set correctly in the configuration.

That would be my guess!

[Doug Quance]

Yes, it works fine until I select the recurring option... then I get the error message.

I don't really understand PHP, so I can't tell where the problem might exist...

[idslamyou]

I have had this installed for a month or so. I am just starting to get some members. They are able to subscribe and I get the notice from paypal about their payment, but their usergroup is not changing. I have doublechecked to make sure I have checked the additional usergroup to add them too. Can anyone help?

[idslamyou]

Can anyone help me with the problem I am having in the post above this? I have doublechecked all of the edits and still have the same problem or vbulletin not adding the user to the additional usergroup.

TIA

[Illuvatar]

Okay.....what in the world did I do wrong! lol

I copied the query in and ran it against the 'subscriptions' table, and after applying all the php edits, I get this when I attempt to update the subscriptions area in the admin cp.

Invalid SQL: UPDATE subscription SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Silver Subscriber Monthly',
description = 'Thank you for your interest in subscribing to WotR. Forum Benefits for the Silver Subscriber are:
A custom Avatar of your choice
A custom title of your choice
An additional avatar showing their status as subscribers and supporters of the site.',
length = '30',
units = 'D',
cost = 'a:3:{s:3:\"usd\";s:4:\"5.00\";s:3:\"gbp\";s:4:\"0 .00\";s:3:\"eur\";s:4:\"0.00\";}',
nusergroupid = '9',
active = '0',
reoccur = '0',
membergroupids = '',
forums = 'N;'
WHERE subscriptionid=1
mysql error: Unknown column 'reoccur' in 'field list'

mysql error number: 1054

Date: Friday 01st of October 2004 07:01:28 PM

[jbroder]

Hi,
I've never used a hack before, I usually just do my own thing. But, this one made things so much easier, I am really glad I downloaded.

I made some modifications to my install, so that the user could tell whether their subscription is going to be billed again or not. I added a cancel button right on the user cp for paid subscriptions, and when the user cancels through paypal, the subscriptionslog table is updated to show that the subscription has been cancelled.

I don't know if anyone else needs this, but here it is attached. I just wrote it today, so maybe there are errors I haven't found yet. For instance, my board only has rebilling transactions, so that might cause an issue on your board.

cheers!

[version2]

Originally Posted by sketch42

I thought i would update anyone else experiencing the issue with the refunded payments.. i hope noone minds....



Here's the FIX clickity click click click

Hey, uh, everyone...I think I might see a problem here.

When I installed this last month my subscribers started subscribing. In my paypal register I can see the 'Subscription Creation' line as well as the 'Payment' line for each new subscriber. Well, a month later it is *almost* time for renewal and I am getting 'Subscription Creations' as well as payments again. And the first subscription creation still look like they are active and are not set to renew for a couple of days now.

What do I need to do?! Is this a problem? I dont really want to wait a couple to find out I am doublebilling all my subscribers.