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.

[trainer]

Originally Posted by insanctus

It is not as much a bug as just not an option?

can you get back to me on the contest hack?

[Amzadi]

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

Thanks for the link Sketch42

[Cold Steel]

Installed. Thanks!

[heynurse]

Does anyone have this installed on 3.0.3? I'm having difficulties getting it to work correctly?

I'm installing this on 3.0.3 and I'm having a problem with this step:

Step 3. Open includes/functions_subscriptions.php

It says to find:

 case 'paypal':
$form['action'] = 'https://www.paypal.com/cgi-bin/webscr';
$form['method'] = 'post';
$form['hiddenfields'] = "
<input type=\"hidden\" name=\"cmd\" value=\"_xclick\" />
<input type=\"hidden\" name=\"business\" value=\"$vboptions[ppemail]\" />
<input type=\"hidden\" name=\"item_name\" value=\"$title Subscription\" />
<input type=\"hidden\" name=\"item_number\" value=\"$item\" />
<input type=\"hidden\" name=\"amount\" value=\"$cost\" />
<input type=\"hidden\" name=\"currency_code\" value=\"$currency\" />
<input type=\"hidden\" name=\"no_shipping\" value=\"1\" />
<input type=\"hidden\" name=\"return\" value=\"$vboptions[bburl]\" />
<input type=\"hidden\" name=\"no_note\" value=\"1\" />";
break;

But I can't find that exactly, I'm sure the code was modified since this hack was writtne, the closest thing to it is this:

 case 'paypal':
$form['action'] = 'https://www.paypal.com/cgi-bin/webscr';
$form['method'] = 'post';
$form['hiddenfields'] = "
<input type=\"hidden\" name=\"cmd\" value=\"_xclick\" />
<input type=\"hidden\" name=\"business\" value=\"$vboptions[ppemail]\" />
<input type=\"hidden\" name=\"item_name\" value=\"$title Subscription\" />
<input type=\"hidden\" name=\"item_number\" value=\"$item\" />
<input type=\"hidden\" name=\"amount\" value=\"$cost\" />
<input type=\"hidden\" name=\"currency_code\" value=\"$currency\" />
<input type=\"hidden\" name=\"no_shipping\" value=\"1\" />
<input type=\"hidden\" name=\"shipping\" value=\"0.00\" />
<input type=\"hidden\" name=\"return\" value=\"$vboptions[bburl]/$vboptions[forumhome].php\" />
<input type=\"hidden\" name=\"notify_url\" value=\"$vboptions[bburl]/subscriptions/paypal.php\" />
<input type=\"hidden\" name=\"custom\" value=\"$userinfo[username]\" />
<input type=\"hidden\" name=\"no_note\" value=\"1\" />";
break;

This is what is supposed to be what is to replace the first set of code above:

 case 'paypal':
$form['action'] = 'https://www.paypal.com/cgi-bin/webscr';
$form['method'] = 'post';
/// Add In For Reacuring Payments
$paypalextra = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "subscription AS subscription WHERE subscriptionid=$subscriptionid");
if($paypalextra[reoccur]==0){// It is one time
$form['hiddenfields'] = "
<input type=\"hidden\" name=\"cmd\" value=\"_xclick\" />
<input type=\"hidden\" name=\"business\" value=\"$vboptions[ppemail]\" />
<input type=\"hidden\" name=\"item_name\" value=\"$title Subscription\" />
<input type=\"hidden\" name=\"item_number\" value=\"$item\" />
<input type=\"hidden\" name=\"amount\" value=\"$cost\" />
<input type=\"hidden\" name=\"currency_code\" value=\"$currency\" />
<input type=\"hidden\" name=\"no_shipping\" value=\"1\" />
<input type=\"hidden\" name=\"return\" value=\"$vboptions[bburl]\" />
<input type=\"hidden\" name=\"no_note\" value=\"1\" />";
}else{
$form['hiddenfields'] = "
<input type=\"hidden\" name=\"cmd\" value=\"_xclick-subscriptions\" />
<input type=\"hidden\" name=\"business\" value=\"$vboptions[ppemail]\" />
<input type=\"hidden\" name=\"item_name\" value=\"$title Subscription\" />
<input type=\"hidden\" name=\"item_number\" value=\"$item\" />
<input type=\"hidden\" name=\"currency_code\" value=\"$currency\" />
<input type=\"hidden\" name=\"ammount\" value=\"$cost\" />
<input type=\"hidden\" name=\"a3\" value=\"$cost\" />
<input type=\"hidden\" name=\"p3\" value=\"$paypalextra[length]\">
<input type=\"hidden\" name=\"t3\" value=\"$paypalextra[units]\">
<input type=\"hidden\" name=\"src\" value=\"1\">
<input type=\"hidden\" name=\"sra\" value=\"1\">
<input type=\"hidden\" name=\"no_shipping\" value=\"1\" />
<input type=\"hidden\" name=\"return\" value=\"$vboptions[bburl]\" />
<input type=\"hidden\" name=\"no_note\" value=\"1\" />";
 
}
break;

Does anyone have any updated instructions for this step in 3.0.3? Any assistance would be greatly appreciated. Thanks

you just need to find the corresponding lines, and that's all... put the missing lines.

the new version of 3.0.3 is adding some lines in the paypal reoccuring process that may answer the bugs with the older versions, that's why...

[heynurse]

Cool, thanks for the advice, but I've tried messing with the code, I keep getting all kinds of errors, I am a complete novice and don't know what the heck I'm doing when it comes to programing.

$$$$ If someone wants to figure this out, I'd pay them for their time and share it with the forum for free I'll pay you by paypal.

[heynurse]

duplicate post removed... oops

[RapCheck]

heynurse, I just upgraded to 3.03 myself, and re-adding hacks I ran into the same problem. This is what I put in, and everything appears to be working fine. I don't receive any errors at all. Hopefully it's correct.

PHP Code:

 case 'paypal': 
$form['action'] = 'https://www.paypal.com/cgi-bin/webscr';
$form['method'] = 'post';
/// Add In For Reacuring Payments
$paypalextra = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "subscription AS subscription WHERE subscriptionid=$subscriptionid");
if($paypalextra[reoccur]==0){// It is one time
$form['hiddenfields'] = "
<input type=\"hidden\" name=\"cmd\" value=\"_xclick\" />
<input type=\"hidden\" name=\"business\" value=\"$vboptions[ppemail]\" />
<input type=\"hidden\" name=\"item_name\" value=\"$title Subscription\" />
<input type=\"hidden\" name=\"item_number\" value=\"$item\" />
<input type=\"hidden\" name=\"amount\" value=\"$cost\" />
<input type=\"hidden\" name=\"currency_code\" value=\"$currency\" />
<input type=\"hidden\" name=\"no_shipping\" value=\"1\" />
<input type=\"hidden\" name=\"shipping\" value=\"0.00\" />
<input type=\"hidden\" name=\"return\" value=\"$vboptions[bburl]/$vboptions[forumhome].php\" />
<input type=\"hidden\" name=\"notify_url\" value=\"$vboptions[bburl]/subscriptions/paypal.php\" />
<input type=\"hidden\" name=\"custom\" value=\"$userinfo[username]\" />
<input type=\"hidden\" name=\"no_note\" value=\"1\" />";
}else{
$form['hiddenfields'] = "
<input type=\"hidden\" name=\"cmd\" value=\"_xclick-subscriptions\" />
<input type=\"hidden\" name=\"business\" value=\"$vboptions[ppemail]\" />
<input type=\"hidden\" name=\"item_name\" value=\"$title Subscription\" />
<input type=\"hidden\" name=\"item_number\" value=\"$item\" />
<input type=\"hidden\" name=\"currency_code\" value=\"$currency\" />
<input type=\"hidden\" name=\"ammount\" value=\"$cost\" />
<input type=\"hidden\" name=\"a3\" value=\"$cost\" />
<input type=\"hidden\" name=\"p3\" value=\"$paypalextra[length]\">
<input type=\"hidden\" name=\"t3\" value=\"$paypalextra[units]\">
<input type=\"hidden\" name=\"src\" value=\"1\">
<input type=\"hidden\" name=\"sra\" value=\"1\">
<input type=\"hidden\" name=\"no_shipping\" value=\"1\" />
<input type=\"hidden\" name=\"return\" value=\"$vboptions[bburl]\" />
<input type=\"hidden\" name=\"no_note\" value=\"1\" />";
 
}
break; 


[por4x4]

Trying to install this on 3.0.3, and am having trouble finding some of the code....

Instructions call to find -

function construct_payment($method, $cost, $currency, $subscriptionid, $title, $userid)
{
	global $vboptions;

But all I can find is this -

function construct_payment($method, $cost, $currency, $subscriptionid, $title, $userinfo)
{
	global $vboptions;

What to do?

[sblum]

I had the same problem, por4x4. I tried changing userid to userinfo and it didn't work. I'd get the paypal subscription and money, but their subscription was not activated.