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.

[Skyline_GT]

Nice..
very useful

[insanctus]

Most welcome , don't forget to click install if you use this

I have been using something simular on my site for some time, makes life so much easier.

[FWF]

awesome!

i agree this should have been included in vB 3, anywho...ive got this installed thanks for releasing it

*installs*

[dkny]

I get error:
Fatal error: Call to a member function on a non-object in /home/jb/public_html/forum/includes/functions_subscriptions.php on line 332

doesn't agree with this command:
$paypalextra = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "subscription AS subscription WHERE subscriptionid=$subscriptionid");

btw I ran ALTER TABLE `subscription` ADD `reoccur` VARCHAR( 10 ) DEFAULT '0' NOT NULL ;

Any suggestions?

[insanctus]

Originally Posted by dkny

I get error:
Fatal error: Call to a member function on a non-object in /home/jb/public_html/forum/includes/functions_subscriptions.php on line 332

doesn't agree with this command:
$paypalextra = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "subscription AS subscription WHERE subscriptionid=$subscriptionid");

btw I ran ALTER TABLE `subscription` ADD `reoccur` VARCHAR( 10 ) DEFAULT '0' NOT NULL ;

Any suggestions?

Yes I am sorry about that (will update the txt, had it in there but right before saved power went out)

To fix find in includes/functions_subscriptions.php

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

Replace With

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

[dkny]

Wow that was the fastest reply EVER! Will try it now, thanks!

[insanctus]

lmao no trouble at all, I had it in then I had to redo the todo , power went out right before I hit save, this area is bad for power.

[dkny]

Yep that worked, you the man!

[insanctus]

Originally Posted by dkny

Yep that worked, you the man!

Very cool I know alot had been after this. I had time since one my clients is MIA and I am waiting on a responce.