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.

Nice..
very useful:D

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.

awesome!

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

*installs*

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

Replace With

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

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.

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.

Updated File If You Already Installed Do The Following.

Open /subscriptions/paypal.php And Find
Replace With
Sorry about that, darn power.....

I don't mean to sound simple here, but what does this actually do?

Ok vbulletin paypal subscriptions only charges one time, so if you set up a monthly fee your users have to redo it every month or loss there forum access or what ever else you give them.

This takes it and turns it into reoccuring payments (if you choose that option)

This way they pay you every set ammount of time you picked for that subscription and it checks to see if it gets paid every month :)

For instance, say you have a paying members 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 automaticly your script gets updated and sets their new expiration.

The vbulletin subscriptions before only worked one time per click now you can do reoccuring :)

Hope that makes sence, if not I will drink some coffee and try again :)

No, you explained it very well, thank you. I don't have any paypal subscriptions set up on my board but I will click install and install it anyway as this should be default in vb3. Good job! ;)

Many thanks :) , I prolly should write a better explination in first post.

Never know they may toss my code in the next update

[high]* insanctus laughs and dreams on.[/high]

If this working in this version then?

This quote is from the other thread.

Yes it is working in this version :) hence why the release.

I had to get some data built up on it.

I thought so but I wanted to be sure. Again, excellent job! ;)

Never hurts to ask :) and most welcome.

I learned 'alot' about paypal in last 4 days or so, and I wanted to make sure I had the payments tight :)

Excellent job. Clicking Install, and installing it right now, much to the delight of my monthly subscribers.

Thanks!

The only thing keeping me from installing this is that I am sure the next vB3 update will have this, and I don't want to muck up the database with extra fields. :) On the other hand, great job. I will press install in the meantime.

Ah, what the heck, I installed it. :)

By the way, if the member wants to cease the reoccuring subscriptions, how does he or she do that? I need to provide instructions.

One little typo in Step 3:

Only one M in there...

what about something like.....another drop down right under the price on the subscription page...that says one time or reoccuring? that way they can choose if they want to pay once or for life? I would install that :-D

Thanks...looks like a useful hack (wish i could use that)

They log into their paypal, and hit cancle on that subscription. It will stop their payments , hence stoping the update of their time expire date.

I may in the future, sounds like an interesting idea.

Actually that <input type=\"hidden\" name=\"ammount\" value=\"$cost\" /> is useless any how :)

Subscriptions uses a3

Excellent addition.. :up: I'll never know why some things weren't inluded originally.

I agree... if you make the checkbox on the subscription page itself, it would make it easier to implement. Great hack nonetheless.

I think that would be a sepperate hack, and the two would conflict.

Reason is, say you as admin want it to be reoccuring, then their check box is in effect useless.

Plus lets face it most members are not bright enough to read all of what they are doing in the first place.

Okay, before I install this I have a couple questions.

When the month comes, where do they pay? From their usercp? Like if they bought a month. It expires how would they go about renewing it. If it's from paypal, then what would be the difference of a manual one. Or does it automatically just take it out. *what I'm thinking*. And what if they hit the bunkers...aka below zero in their account. I know that paypal accounts can go negative, but would this stop it upon hitting 0? Doesn't matter to me jw.

But now that I rethought and figures it pays every month itself. It's all good and I'll install. :)

It auto bills them if you select reoccur, if they hit 0 and it shows as pending, they do not get updated time limit until their payment goes thru (so they would lose access while not paid)

Thank you. Was wondering how that little part worked :).

Thanks insanctus! Erwin... just keep the install button clicked :P

I've set it up. :) Let's see how it goes.

It is working good on mine :) ..

I installed this excellent hack. I have a test account set up. The problem I have, even before installing this hack is that the members dont show up in the subscription section in admin, plus there group doesn't chang (from Regular member to Paid Member). I went to MYPHPadmin and the Subscriptionlog tables are blank. I tried it with a few test accounts. Anyone have the same problem? I need this fixed, I'm willing to pay.

Sounds like you did not edit paypal.php :) Step 4

After some thought, I may add in some more on this.

For my uses I and I think others would like it, is one time of so much , then so much each time after. :)

I will play with it when wake.

Here is an example of what it would look like.

So say you wanted to charge them $50 at first then $10 a month each month after this would allow that.

I will release this update once I get a chance to test it.