Donations / Paypal IPN Integration
 

Well, after searching and searching for a donation system that works, I've come to the realization that although there are a few good contribution / donation hacks out there, none of them are compatible with Paypal's IPN feature. That being the case I went experimenting, and got the IPN to work properly with VB.

So now I'm dealing with options and features that you all want to see in this type of hack. I am willing to put forth the effort to get this hack to be the best one there is on the market for this. After I get all the coding and stuff done with paypal and the "look & feel" of the hack for the rest of your VB site, I'll work on integrating it with Authorize.net as well. But for now, since the IPN is working, I need your input on what you would like to see included with this hack.

So far, I'm looking at a notification on the memberlist, one in the postbit for members of the top ten donators club, possible rewards for certain levels of donations, the option to show total amount collected, and exactly where the $$$ is going to (this is needed for me personally since my site is not-for-profit, so may be helpful to you as well), with the main donations page showing all the above with an information page for explanations of where the $$$ goes, etc.

The IPN backend is running via Paypal's recommended procedures and should any suspicious activities be seen by either the script or Paypal's server, the script will not add the information into the main database, but into a separate table for further investigation by the admin.

One thing that I am missing that I need help on is verifying Paypal's Verisign Digital Signature, When it comes to that, I'm dumber than Jim Carrey on LSD. If I could get help on that one, we will all be appreciative as this will increase the security of the system.

Please, let me know your ideas for this hack, and I will get them on my "ToDo" list. Please be understanding and patient though, as I am about to have a second child born into the world within the next few weeks, so may drop off working on this one for abit, but I will continue to code for it during my free time.

Until then, Enjoy!

)O( Cloudrunner )O(

Update:

Okay, working on the main page for this little integration a bit at a time.

I've attached a small initial screen for the page to give a basic idea of where I'm going with this.

Today I finished the dynamic donation buttons, so you can make an unlimited number of different donation level buttons. Later I'll be adding "prizes" per donation level button chosen. There is also a button there to allow your users to choose the amount they wish to contribute to you.

I'll start working on the member's integration portion of this over the next week or so (provided that my wife does not give birth during this time, if that occurs, of course, then it'll be abit longer).

I'm still looking for assistance in the verisign digital check portion of this whole thing. If you have the time and know how this would work, please contact me.

Enjoy!

)O( Cloudrunner )O(

Button Clicked with a set amount:

Button clicked without a set amount:

I might just start drooling over my keyboard if I don't install this soon! :D Lookin' good! :cool:

Maybe this can help...
http://www.perl-studio.com/php/paypal/

That one looks a bit more complicated than what I would've hoped for. I'll wait for Cloudrunner's version before I try that one.

That was a suggestion for him to see example code on the digital signature, not a suggestion for an alternative. :)

Not only that, but the information there is misleading, as one doesn't really need to use an ssl socket to connect to paypal, as there is no financial information (i.e. credit cards, bank accounts, etc) being passed during the IPN exchange. Therefore, since vBulletin uses PHP, using a perl script to integrate would be alot more code involved to get perl to talk to the vb php backend properly.

That, and that script doesn't help me in the versign signature authentication, and that's the #1 thing I'm worried about right now, because I can "spoof" the script with a proxied form using the right variables (i.e. it will accept the variables and such, but when talking to paypal for verification of the data, paypal will always send an INVALID string since it did not initiate the call.) With the verification of paypal's verisign sig, I wouldn't be able to do that.

Thanks for the help though ;)

)O( Cloudrunner )O(

ah crap!

I just realized that to verify paypal's digital server ID, one MUST be using SSL transport. CRAP!

PHP will not transport via SSL, well let's find another way to verify proper server access....is there a better way than using $_SERVER['HTTP_REFERER']?

UPDATE:

I finished the Total Funds Contributed portion of the main page.

It takes all of your total funds contributed and separates them into funds contributed in the last 30 days, 6 months, Year To Date, and total amount since the start. This is dynamically updated whenever you receive an IPN with the payment_status of: "Completed", and a verification status of: "VERIFIED".

Attached is another screener.

UPDATE:

I've finished the code and layout for the "where did we spend the money" section of the site. (this is not yet an option as I haven't even started on the admin portion of this hack).

I've decided to use another of my installed styles to show how it loads into different styles on different boards. Basically the only replacement this hack uses is #13486D. You can adjust that as needed by you when you install it once it's released.

This section will need to be manually updated whenever you spend the money from this account. Just FYI.

Enjoy!

)O( Cloudrunner )O(

UPDATE:

Finished the Top Ten Listing of contributors.

If the contributor has an avatar on file with your board, then it will display in the listing. If not, then it simply contains their username, date of last donation, and the total amount they've donated.

Enjoy!

)O( Cloudrunner )O(

UPDATE:

Reused some code to get the listing for ALL of the contributors to show up. There is no avatar display for this part of the page.

I find myself wondering if this should even be a part of the script. I don't really wanna worry about having to split the page if the board gets alot of donations, ya know? Sides, it's kind of redundant as the top ten is already listed.

Oh well...lemme know what you think I should do.

Enjoy!

)O( Cloudrunner )O(

looks awesome so far!
Top 10 would seem good enough.

FYI.

fopen will work with https in 4.3.0 and above, IF compiled with OPENSSL.

Going to try it out in a few minutes.

Shri

Thanks for the info, unfortunately, my server / host is running 4.1.3 with very little chance of upgrade in the near future. They're kinda adamant about that point.

Thus, my ability to integrate SSL into this hack is nill. Once I release the hack into beta, I'll be open to any code adjustments necessary for it to talk via SSL to verify paypal's verisign sig.

)O( Cloudrunner )O(

Ok. I'm installing php 4.3.2 with SSL as we speak. Let me know if you need me to test / help you code anything.

:)

Wow Great!!
maybe make someone like that board.
Like in the index some where put currently we have an amount of money. and we need an amount money.

Anything else to add while I'm at it?

I'm willing to work on part 8 for ya. Just got everything installed.

Now going to install curl and see what would be the best mechanism to get this done.

Shri

8 is easy, lol .... it took me a week to work that out for the trader

Add points to the member according to how much they donated. :)

via Lesane's Store? I can work that in, but for other points systems, I don't use them, so it would have to be an addon from someone who has one of those installed.

You can do it for Lesane, and I will convert it for my custom poinst system. :)

no problem, will drop that in the "ToDo".

Gonna work on the memberlist and postbit now though...I've a few minnows avalable tonight surprisingly...The wife has crashed....thank the gods!

UPDATE:

Finished integration into the memberlist. Will update toys and graphics later. This requires a small addition to the user table. One TINYINT(1) field that is merely a 1 if donated or a 0 if not donated.

Okay, one question...

Where's the best place to add a bit of code for it to show up in the postbit?

I tried this code in the showthreads.php, but that didn't work.

($donated is the variable called by the postbit template)

edit: Nevermind...Found it!

UPDATE:

Finished the postbit. Again, I'll be working on toys and ++++ later.

On that note, anyone care to design me up three postbit graphics simply to show three levels of appreciation for donations? I'll let you have free artistic creativity on them, and you'll have full credit for them in the release. They will be used on the postbit and the memberlist.

Thanks, and for the screen:

here ya go

Updated "ToDo":

UPDATE:

Getting ever so closer to release guys (unless of course ya'll come up with some more stuff to add, LOL)!

Anyways, finished the requested feature for adding totals and stuff to the index page. This adds two queries to your index.

Anyways...To the BatScreen Robin!

So are we agreed that the top ten contributors is good enough on the main donations page? I REALLY don't wanna code for multiple pages for contributors....I REALLY REALLY REALLY don't wanna...

yack!!! Just realized my math is all screwed up....

oh well...that's what happens when you're losing your mind!

It's fixed in the code, just not the screener.

:) It's looking nice Cloudrunner, I think having this hack on my site will help out a lot, especially emphasizing donations and recognizing members who have donated

Great this hack will be good and useful
well at least for me:D

A top ten list will suffice. :)

I'm currently working on the AdminCP of this hack...It's taking abit longer for this portion of the hack than I had hoped for it too, cus I keep coming up with new things for the admins to be able to do with the hack ;)

Anyways, I'll keep you updated as usual.

)O( Cloudrunner )O(

Awe Man, this is going to be great! Can't wait! Thanks Cloudrunner. :)

UPDATE:

Almost done with the AdminCP, once I finish it the hack goes to version 0.7, and I'll go through some coding issues and tweaks to the system. When I finish that, the code goes to 0.8, where a select group of hackers gets a copy of the hack prior to release for "Alpha" testing. This will go on for approx. 1 week. Then I will release 0.9 "beta" to the public. I will be supporting this little gem for awhile, but remember please that my wife is due Friday, so I will be falling off the face of the planet soon, for a few days anyway.

Anyways, some more screeners for you.