Log in

View Full Version : Paypal Donations (With Instant Payment Notification) -- RC1 (Public Testing)


Cloudrunner
06-16-2003, 10:00 PM
This hack is obsolete, and is currently being ported to 3.0.7, and will be ported to 3.5 when it is allowed.

Thank you for your understanding.

Version 0.9.5 is a major fix to a bug that was found by shortywz. Please download the new archive and overwrite your old files to upgrade to 0.9.5 if you are running 0.9.4, if you are running any version lower than 0.9.4 then after overwriting the old files run the installer

[b]Paypal Donations for vBulletin

What it does:
Quite simply this hack provides you a way to receive donations from your website's users and provide them with the recognition deserving of a donating member of you community. It uses Paypal exclusively for the time being because of Paypal's "Instant Payment Notification" system. For more information on Paypal's IPN, please see the supplied manual for IPN located here in the docs directory. The file name is: "IPN.PDF".

The basics are this, your users goto your donations page where you have certain levels of donations available via hyperlinked "buttons". These buttons take your user to paypal's secure payment processing system where they pay you your donation. Once payment has been received, paypal sends your server a notification containing certain information pertaining to that specific transaction. Your server then repeats this information to the verification server (which is hardcoded into the system so that *spoofing* is rendered virtually impossible) which first checks to see if the information was sent by it, then checks the validity of the information. If everything checks out, it then sends your server a response of "VERIFIED". When this hack see that word after running the script it inserts all the information into your database so that you can see what was donated, who donated it, and where.

If the server returns a response of "INVALID" then this script drops the information into a separate table so that you can investigate the transaction further to detect fraud attempts. It also does this on any suspicious entries after a few checks. Once payment is verified and information has been inserted into the tables, the system then adds a few toys and items for the user to be recognized as a donating user. What you do with that recognition is up to you.

Features:


You as the admin have the ability to show as little or as much as you want about what happens with your donations.
Your users will only see what you want them to see.
Can block other admins from seeing the actual payment information (you have to explicitly allow them access to that).
Your members who have donated are recognized for doing so in the memberlist and their postbit.
You can show your donation goals to the public and on your forumhome.
Automatic updates EVERY time a user donates or retracts a donation.
Postbit Awards for certain levels of donations that you decide on
User has the ability to choose whether they receive the awards recognition
Admin can customize the PM sent to donators thanking them for donating.
Guest donations are now listed individually, sorted by IP(not displayed) on the Top Ten list, and within the database
**Coming Soon**

Add a time-limited feature for the donation buttons
Fix guest donations to show each indiviual guest's donations sorted uniquely
Integration with Lesane's Store Hack
The ability to verify Paypal's Secure Server ID and transfer the payment information via SSL if you have that enabled

Stuff you have to do:
Files to upload: 9
Files to modify: 7
Templates to modify: 4
Queries to run: (The install script does this for you, uninstallation is also provided as well)
Ease of install: Simple, but abit intensive with some file edits
Time of install: ~10 minutes

***REMEMBER! Add your email address that Paypal has on file in the ppfunc.php file. This step is not an option, your payments, although they may be valid, will all be considered invalid if you do not do this! Sign up for Paypal's Premiere Account (Business), and setup IPN.

Paypal Registration:
You will need to register with Paypal for a premiere account if you have not already, if you have, but your account is probably a personal account, you will need to upgrade the account to a premiere account. Assuming that you have a premiere account and have been verified, you then go into your profile at https://www.paypal.com and the select Instant Payment Notification. There will be a checkbox that you must check, and an inputbox where you will need to place your script file. Simply place your entire URL to the paypal.php file there.

On most systems it will be either:

http://www.yourdomain.com/paypal.php

or

http://www.yourdomain.com/forum/paypal.php

That's all there is to setting up Paypal to work with your site!

Install:
Upload the following files to your $ROOT/forum directory:

paypal.php
ppverify.php
ppfunc.php

Upload the following files to your $ROOT/forum/admin directory:

paypal_admin.php
paypal_donations_install.php

Upload the following files to your $ROOT/forum/images directory:

donate.gif
donate2.gif
donate3.gif
donate4.gif

Run the provided install file, after installation, DELETE THE FILE!

This will usually be:

http://www.yourdomain.com/forum/admin/paypal_donations_install.php

or

http://www.yourdomain.com/admin/paypal_donations_install.php

Upgrading:
Upload the following files to your $ROOT/forum directory overwriting the old files:

paypal.php
ppverify.php
ppfunc.php

Upload the following files to your $ROOT/forum/admin directory:

paypal_admin.php
paypal_donations_install.php

Upload the following files to your $ROOT/forum/images directory:

donate.gif
donate2.gif
donate3.gif
donate4.gif

Run the provided install file and follow the upgrade instructions, after upgrading, DELETE THE FILE!

This will usually be:

http://www.yourdomain.com/forum/admin/paypal_donations_install.php

or

http://www.yourdomain.com/admin/paypal_donations_install.php

After Install:
You will need to add a link somewhere in your navigation system for vBulletin pointing your users to the donations page.

------------------------------------------------------------------------
I sincerely hope that you enjoy this hack.

This thread is specifically for the use of bugs reporting and feature suggestions.

You are allowed to hack the crap outta this here script for your own personal use, BUT, if you do, I will not be able to provide you with support for the system if the base code has been changed! Also, if we find another hack that interferes with this one, I will do my best to provide a work around for it, but I will not garuantee that to occur!

For those of you who have been alpha testing this for me, THANK YOU! To upgrade from Alpha to Beta, you will have to do a complete uninstall (including file modifications) and reinstall. This is due to the extensive redo of code in vb resident pages. I hope you can understand.

Thank you!

)O( Cloudrunner )O(

P.s. --> I you want to be notified whenever I updated the Paypal Donations System, I suggest that you push that little button up top and down below that says install, It's especially useful to you to do so, cus when a New Version comes out, I can simply update and anyone who has it installed will be notified.....Just a suggestion...

A special thank goes out to ap0c for keeping me on my toes during Alpha testing...dude can find some bugs, lemme tell ya! And thanks for the suggestions as well bro! I added all of em.

Attached is the full release which includes screenshots and the manuals from Paypal for IPN and Donations for those of you who really want to play with the code for reference. Warning, the file is large!

If you want a smaller file, then look here (https://vborg.vbsupport.ru/showthread.php?postid=410209#post410209). The archive in that post is the smaller of the two at ~30K compared to ~1M. It does NOT contain the manuals OR the screens (as requested by gmarik).

Enjoy

(with the addition of the manuals and screens, the archive is too big to attach. If you want these, pm me and I'll send it them too you, or simply download the screens archive a few posts down, and then download the manuals from Paypal.)

Smoothie
06-17-2003, 06:54 AM
Have a question about paypals IPN. I have IPN on, and the Instant Payment Notification (IPN) URL filled in. It is used for another subscription hack. Is it possible to have 2 IPN's? If not, how would I go about using your paypal donations hack with the other subscriptions hack I am using now?

Hope that makes sense....

Cloudrunner
06-17-2003, 06:56 AM
Unfortunately Paypal only allows one IPN per email address on file. The only thing you could do is to setup and verify another account with them, and then setup the IPN for that account deal with this hack.

The catch with this...is not only will you need to have another email with which to register, but to verify that account, you'll need another checking account with them to verify yourself as a legit user.

Cloudrunner
06-17-2003, 08:28 AM
Here's the updated screens for the beta release.

Enjoy!

Dean C
06-17-2003, 09:50 AM
No point in installing my system on my board now. I love this one :)!

kaotic
06-17-2003, 03:53 PM
I'm glad we're finally out of Alpha. :D Great hack you've got here.

dreamhost
06-17-2003, 08:57 PM
will this hack work with the new 3.0?

Cloudrunner
06-17-2003, 09:03 PM
No it won't, cus 3.0 hacks have not been released, nor will they be until VB3 goes at least RC.

ap0c found a misscode on my part in the installer. If you try to install the code will break when inserting the default settings into the awards table. I've updated the archive to reflect the change that I did with the installer. To fix it, simply go into the installer and uninstall. This will remove the corrupted table, then reinstall, and all should be good.

Thanks, keep the bugs coming, and please post any bugs or feedback directly here as I don't often check my PMs.

)O( Cloudrunner )O(

Cloudrunner
06-17-2003, 10:08 PM
Another misscode found, Thank you ap0c:

During the last template edit for the template postbit you are told to input the variable $post[avatar]This should be:$donated

This will be fixed in the next update, but for now simply edit your postbit and make the change or you will end up with two(2) avatars in each user's postbit ;).

edit: This has been fixed, update is in the archive.

ap0c
06-17-2003, 11:39 PM
installed and running fine...

note to self,no more pms';)

Cloudrunner
06-18-2003, 12:08 AM
ADDED FEATURE:

A user on my forums actually asked for this feature, so I did it. Anyways, It allows your users to choose whether or not their donations award is displayed on the postbit and memberlist. Also I fixed that other misscode ap0c found.

To upgrade, upload all files, overwriting the old files on the server, then run the installer again, this time choosing the upgrade option.

The archive has been updated with the new release...

Enjoy, Let me know if any problems arise!

)O( Cloudrunner )O(

gmarik
06-18-2003, 05:53 AM
Why is the zip so big?
Can you make an archive without screenshots?!

Cloudrunner
06-18-2003, 06:57 AM
done...

but it's not the screens that take up most of the room, it's the IPN and Donations manuals that paypal provides. I've provided them for reference for those who want to play with the code.

This one doesn't contain the screens or the manuals, so it's about 30 Kb in size....enjoy

)O( Cloudrunner )O(

edit: check the bottom of the first post

Dean C
06-18-2003, 10:03 AM
Any chance you could change this so you can add a time frame for which the donation expires in. This is one of the features i had on my system. Also i had it so it sent users a PM on their donation being excepted and when it expired. The user the PM came from, the title and content was all customizable through options.

But definately i think you should have timed donation periods so they automatically expire :)

Sound good?

- miSt

gmarik
06-18-2003, 12:20 PM
Cloudrunner,

Thanks. And yes, as Mist noticed, if if would PM them
you're code would be out of comments, get what I mean?!

Cloudrunner
06-18-2003, 12:39 PM
I can see what I can come up with, shouldn't be too hard ;)

Mist, can you PM me with more details on that so we don't bog the thread down? Thanks.

I'll get right on the auto PM, prolly be added before I go to bed tonight.

Dean C
06-18-2003, 02:25 PM
Come in the IRC chat sometime. I'm in their most of the time now that i have finished my exams :).

We'll talk in private there ?

- miSt

Crazy Pete
06-18-2003, 05:42 PM
Will this work with non-forum members as well? For example if someone were to donate that wasn't a member of the forums, what would be processed then?

Cloudrunner
06-18-2003, 06:13 PM
Absolutely! Even guests can donate, I've not made that a feature to turn off guest donations yet in the adminCP. But yes, guest users can donate, and it will be processed, it just won't show up on the memberlist or postbits.

Crazy Pete
06-18-2003, 06:19 PM
Ah ok, great. It will still show up in the "Contributors" list though, correct? That's excellent, I can replace my current (static) donations page with this much better one. Thanks very much for writing this!

Cloudrunner
06-18-2003, 07:38 PM
no problem, I'm still trying to figure out the best way to sort the guest contributors uniquely. I'll probably have that figured out by the end of the week and I'll do another update. More than likely I'll be sorting them by IP address. But for now, it just updates the guest donations (1 guest for them all). I'll have this fixed soon though.

Cloudrunner
06-19-2003, 04:55 AM
ADDED FEATURES:

PM automatically sent to registered users after donation has been accepted and verified by the script. This feature is customizable within the AdminCP. Thank you mist for this suggestion. This portion of the hack is using a modified version of Sparkz's Pm on registration hack

Changed the database and some code to allow guest donators to be listed individually within the database and the Top Ten Listing.Thank you Crazy Pete for this suggestion

To update, simply upload all files again, overwriting the old ones, and run the provided installer, upgrading in sequence from your version of the hack.

The new version is in the first post.

Enjoy!

)O( Cloudrunner )O(

Crazy Pete
06-20-2003, 07:36 PM
Hey that rocks Cloudrunner, there aren't any file changes from 0.9.2 to 0.9.3? (According to the upgrade script there aren't.) Sweet! Thanks for using one of my suggestions, too. I feel the love.

Cloudrunner
06-20-2003, 07:57 PM
Well, the files have been recoded that are included with the archive (which is why I always have you reupload at upgrade, but as far as file edits, on resident VB files, there are none this time round ;)

Ps. You gonna install or what? :lick:

Crazy Pete
06-20-2003, 10:10 PM
Today at 04:57 PM Cloudrunner said this in Post #24 (https://vborg.vbsupport.ru/showthread.php?postid=411156#post411156)
Ps. You gonna install or what? :lick:

Ahh whoops, forgot to hit that button. ;)

Cloudrunner
06-20-2003, 10:27 PM
LOL

fair nuff, just don't wantcha to miss an update if you've truly installed it.

Cloudrunner
06-21-2003, 08:13 AM
06-18-03 at 08:25 AM Mist said this in Post #17 (https://vborg.vbsupport.ru/showthread.php?postid=410344#post410344)
Come in the IRC chat sometime. I'm in their most of the time now that i have finished my exams :).

We'll talk in private there ?

- miSt

Well seeing as I'm never around when you are my friend, let's just go into details here...

What exactly are you looking for in a time-delimited donation?

Dean C
06-21-2003, 01:08 PM
I.e. you have a row on the add a donation type page where it has an input where you enter some numerical data. And next to it is a dropdown with day(s), week(s), month(s), year(s)..

Just so that the donations last that amount of time and then they automatically expire and the features people make themselves and limit to donators are then revoked...

- miSt

Cloudrunner
06-21-2003, 01:31 PM
Today at 07:08 AM Mist said this in Post #28 (https://vborg.vbsupport.ru/showthread.php?postid=411332#post411332)
...so that the donations last that amount of time...

I understand the other stuff, but with this, you are meaning that the buttons only display for x number of days, weeks, whatever?

Dean C
06-21-2003, 02:37 PM
No the user is only classed as a donator for this period of time.... I.e. all their privilges go :)

- miSt

Cloudrunner
06-21-2003, 06:13 PM
ahh!!!

Another award mod! I can do that LOL

Take me abit it might, but I'll get that in then!

edit---I made mist mad....sorry, I thought it was funny :P!

rockergrrl
06-21-2003, 06:29 PM
06-17-03 at 03:56 AM Cloudrunner said this in Post #3 (https://vborg.vbsupport.ru/showthread.php?postid=409794#post409794)
Unfortunately Paypal only allows one IPN per email address on file. The only thing you could do is to setup and verify another account with them, and then setup the IPN for that account deal with this hack.

The catch with this...is not only will you need to have another email with which to register, but to verify that account, you'll need another checking account with them to verify yourself as a legit user.

Just commenting...

You can only have 1 personal and 1 business account at PayPal. In order to have IPN you have to have a business account.

If you try and register another account, with a different checking account, they'll probably catch it and flag it and restrict your account.

Trust me, to get it unrestricted, its a royal pain in the arse to do it.

Just a thought... ;)

Cloudrunner
06-21-2003, 06:47 PM
that I did not know ;)
thank you for the information. I'll contact em and see what they say, cus that has me bugged, because I've three legit businesses that use them, and they all run different accounts, but same name for me, and the business name is different....

rockergrrl
06-21-2003, 07:50 PM
Don't tell them that you have 3 different business accounts... they might just pull the plug on spot. (Never know with them).

I wish they had the ability to run more than one IPN for one account. I have 4 different sites that need IPN, and I have to figure out what to do because of it. Drives me crazy.

rockergrrl
06-21-2003, 07:56 PM
As their User Agreement states:
https://www.paypal.com/cgi-bin/webscr?cmd=p/gen/ua/ua


This Agreement was last modified on June 4, 2003.


Eligibility. In order to use the Service, you must register for a Personal, Premier, or Business account. Users may only hold one Personal account and either one Premier or one Business account. Our Services are only available to individuals or businesses that can form legally binding contracts under applicable law. Without limiting the foregoing, our Service is not available to minors (under 18), persons who are suspended from our Service, or to persons who present an unacceptable level of credit risk. In order to receive credit card funded payments or use the Service to conduct business or in conjunction with a business, you must upgrade to or register for a Premier or Business account.

insanctus
06-21-2003, 07:59 PM
Very nice hack ~ clicks install

Cloudrunner
06-21-2003, 09:07 PM
Thank you Insanctus :)

Well we have a conundrum then, how to get multiple accounts legally with Paypal....will have to think on this.

rockergrrl
06-21-2003, 09:20 PM
hmmm...

Maybe through a girlfriend/spouse, parent, friend ??

Just suggestions... dunno

Cloudrunner
06-22-2003, 07:45 AM
ADDED FEATURE:

Well folks, ask and ye shall receive...

I've added an option to show the awards only for a limited amount of time. After you update you MUST redo your options for the donations hack or it will default to show the award for only 30 days. thank you Mist for the suggestion


Anyway, same old same...Upload, overwrite all file, then run the installer to upgrade sequentially.

Let me know of ANY problems! The update is in the first post.

)O( Cloudrunner )O(

Dean C
06-22-2003, 10:13 AM
Well done :) - however i wanted it so the admin could set the amount of time... in either days, months or years that the donation lasts... and it's not a fixed amount :)

Also your attachment was a little inappropriate with the obscene words. Please don't post such material again :)

Thanks

- miSt

Rebel38
06-22-2003, 11:44 AM
Hi I'm getting this error when I try create a new button any idea what could be causing it?
Thaks
Rebel

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: INSERT INTO paypal_donatebuttons (id,
business,
item_name,
item_number,
image_url,
no_shipping,
return,
rm,
cancel_return,
no_note,
cn,
cs,
custom,
invoice,
tax,
currency_code,
amount,
submit_button) VALUES (NULL, '', 'Site Donations', '', '', '', 'http://www.mysite.com/forum1/paypal.php?action=success', '1', 'http://www.mysite.com/forum1/paypal.php?action=cancel', '', 'Comments', '1', 'mysite', 'Aus1', 'N/A', 'USD', '$200', 'http://www.mysite.com/donate.gif')
mysql error: Unknown column 'item_number' in 'field list'

mysql error number: 1054

Date: Sunday 22nd of June 2003 07:34:50 AM
Script: http://www.mysite.com/forum1/forum1/admin/paypal_admin.php
Referer: http://www.mysite.com/forum1/admin/paypal_admin.php?action=make_button&

Dean C
06-22-2003, 03:36 PM
You haven't installed the queries correctly as the item_number column does not exist :) ^^

Try

- miSt

ap0c
06-22-2003, 05:56 PM
nice update on this Cloudrunner

Cloudrunner
06-22-2003, 05:58 PM
Actually, the item_number column was removed for the guest posters portion of the hack...unfortunately, this is my fault, I forgot to remove that in the paypal_admin.php.

I will fix it and get the fixed archive up again.

bug found ;)

mist, okay, I'm not quite understanding again...you want the donation button to be displayed for xxx amount of (days, weeks, months, years, etc). and then upon expiration anyone who donated using that button get their awards and such removed right? What about the topten listing? do we want them removed from there as well?

I fix my post upstairs too...sorry, I thought it was funny :P

Okay to fix the donate_buttons query before I get the new archive up here:

edit: This bug has been fixed and is in the archive for 0.9.5 and later.

Cloudrunner
06-22-2003, 06:52 PM
Found another bug, sorry!

edit: This bug has been fixed and is in the archive for 0.9.5 and later.

sHORTYWZ
06-24-2003, 12:23 AM
definatly clicked on install on this one man.. looks GREAT..

question though, i had a friend of mine who wasn't registered on my board post a $1 donation at a test - everything is in the db correctly, however he isn't showing up on the contributor list.. nothing listed on there, not even guest. design or flaw?

Cloudrunner
06-24-2003, 01:23 AM
until the donation is marked as "Complete" from paypal's IPN then nothing will show up on the contributors list. If after the payment_status column shows up as "Complete" for that transaction, the information still does not show on the contributors list then let me know cus then it would be a bug...Thanks

Crazy Pete
06-24-2003, 01:27 AM
There appears to be a big discrepancy in the code for this when editing/adding buttons now. 0.9.2 worked fine, but it seems to be trying to find several columns which no longer exist...

Database error in vBulletin Control Panel 2.3.0:


Invalid SQL: INSERT INTO paypal_donatebuttons (id,
business,
item_name,
image_url,
no_shipping,
return,
rm,
cancel_return,
no_note,
cn,
cs,
custom,
invoice,
tax,
currency_code,
amount,
submit_button) VALUES (NULL, 'donations@expectedmiracles.com', 'emdonation', 'http://www.expectedmiracles.com/images/expect.1.jpg', '', 'http://www.expectedmiracles.com/forums/paypal.php?action=success', '1', 'http://www.expectedmiracles.com/forums/paypal.php?action=cancel', '', 'Comments:', '0', '', '', '', '', '', 'http://www.expectedmiracles.com/forums/images/donate.gif')
mysql error: Unknown column 'custom' in 'field list'


mysql error number: 1054


Date: Monday 23rd of June 2003 10:24:12 PM
Script: http://www.expectedmiracles.com/forums/forums/admin/paypal_admin.php
Referer: http://www.expectedmiracles.com/forums/admin/paypal_admin.php?action=make_button&s=

-and-

Database error in vBulletin Control Panel 2.3.0:


Invalid SQL: INSERT INTO paypal_donatebuttons (id,
business,
item_name,
item_number,
image_url,
no_shipping,
return,
rm,
cancel_return,
no_note,
cn,
cs,
custom,
invoice,
tax,
currency_code,
amount,
submit_button) VALUES (NULL, 'donations@expectedmiracles.com', 'emdonation', '', 'http://www.expectedmiracles.com/images/expect.1.jpg', '', 'http://www.expectedmiracles.com/forums/paypal.php?action=success', '1', 'http://www.expectedmiracles.com/forums/paypal.php?action=cancel', '', 'Comments:', '0', '', '', '', '', '', 'http://www.expectedmiracles.com/forums/images/donate.gif')
mysql error: Unknown column 'item_number' in 'field list'


mysql error number: 1054


Date: Monday 23rd of June 2003 10:20:54 PM
Script: http://www.expectedmiracles.com/forums/forums/admin/paypal_admin.php
Referer: http://www.expectedmiracles.com/forums/admin/paypal

I got it working but I had to remove those two lines of code from the paypal_admin file. Not sure what happened there or if you were aware of it just yet.

sHORTYWZ
06-24-2003, 01:30 AM
It's showing up as completed in the DB.

Cloudrunner
06-24-2003, 04:12 AM
Crazy Pete--

Both database errors were addressed already ;)

https://vborg.vbsupport.ru/showthread.php?postid=411663#post411663

And a bug found as well after that one was addressed:

https://vborg.vbsupport.ru/showthread.php?postid=411680#post411680

Shorty--Please contact me via on of the IM's listed in my profile. I need to take a look at your setup, I may have missed something, but my end is working fine.

Rebel38
06-24-2003, 11:47 AM
Yesterday at 05:58 AM Cloudrunner said this in Post #44 (https://vborg.vbsupport.ru/showthread.php?postid=411663#post411663)
Actually, the item_number column was removed for the guest posters portion of the hack...unfortunately, this is my fault, I forgot to remove that in the paypal_admin.php.

I will fix it and get the fixed archive up again.

bug found ;)

mist, okay, I'm not quite understanding again...you want the donation button to be displayed for xxx amount of (days, weeks, months, years, etc). and then upon expiration anyone who donated using that button get their awards and such removed right? What about the topten listing? do we want them removed from there as well?

I fix my post upstairs too...sorry, I thought it was funny :P

Okay to fix the donate_buttons query before I get the new archive up here:

in paypal_admin.php find: $DB_site->query("INSERT INTO paypal_donatebuttons (id,
business,
item_name,Replace that entire query with this: $DB_site->query("INSERT INTO paypal_donatebuttons (id,
business,
item_name,
image_url,
no_shipping,
return,
rm,
cancel_return,
no_note,
cn,
cs,
invoice,
tax,
currency_code,
amount,
submit_button) VALUES (NULL, '"
.addslashes($options['business_email'])
."', '"
.addslashes($_POST['item_name'])
."', '"
.addslashes($_POST['image_url'])
."', '', '"
.addslashes($return)
."', '"
.addslashes($_POST['rm'])
."', '"
.addslashes($cancel_return)
."', '', '"
.addslashes($_POST['cn'])
."', '"
.addslashes($_POST['cs'])
."', '"
.addslashes($_POST['invoice'])
."', '"
.addslashes($_POST['tax'])
."', '"
.addslashes($_POST['currency_code'])
."', '"
.addslashes($_POST['amount'])
."', '"
.addslashes($_POST['submit_button'])
."')");then find this:$DB_site->query("UPDATE paypal_donatebuttons SET business = '"and replace that entire query with this: $DB_site->query("UPDATE paypal_donatebuttons SET business = '"
.addslashes($options['business_email'])
."', item_name = '"
.addslashes($_POST['item_name'])
."', image_url = '"
.addslashes($_POST['image_url'])
."', return = '"
.addslashes($return)
."', rm = '"
.addslashes($_POST['rm'])
."', cancel_return = '"
.addslashes($cancel_return)
."', cn = '"
.addslashes($_POST['cn'])
."', cs = '"
.addslashes($_POST['cs'])
."', invoice = '"
.addslashes($_POST['invoice'])
."', tax = '"
.addslashes($_POST['tax'])
."', currency_code = '"
.addslashes($_POST['currency_code'])
."', amount = '"
.addslashes($_POST['amount'])
."', submit_button = '"
.addslashes($_POST['submit_button'])
."' WHERE id = '"
.$_POST['id']
."'");
The queries both end the line beforeecho "All good!";

The file is fixed, but won't be up until next update, so in the interrim use this to fix the problem.

Thanks Cloudrunner, it's working fine now, great hack to mate alot of people have been waiting for this,

Clicks install

Thanks again
Rebel

Crazy Pete
06-24-2003, 01:39 PM
Today at 01:12 AM Cloudrunner said this in Post #50 (https://vborg.vbsupport.ru/showthread.php?postid=412112#post412112)
Crazy Pete--

Both database errors were addressed already ;)

https://vborg.vbsupport.ru/showthread.php?postid=411663#post411663

And a bug found as well after that one was addressed:

https://vborg.vbsupport.ru/showthread.php?postid=411680#post411680


Ahh, thanks for that. I s'pose it's always best to actually look and search in the thread first eh? :)

Cloudrunner
06-24-2003, 06:38 PM
Crazy Pete--

usually ;)

smile! Life is grand!

Rebel38--

Thank you for the kind words! But don't forget the second fix just below the database repair, or you won't be notified of any of your payments ;)

Cloudrunner
06-25-2003, 01:31 AM
ALERT!!!

Right now as the code sits, There is a major bug in the code where nothing updates properly, you'll still recieve the donations and everything, but it's not displaying!

Please disable the link to your hack until I can get this fixed. I'm working on the problem with Shorty, and should get an updated release up soon!

Thank you for your patience and understanding on this!

)O( Cloudrunner )O(

Cloudrunner
06-25-2003, 03:31 AM
All fixed!

Please download the new version. If you are running version 0.9.4 then all you have to do is upload the new files overwriting the old ones.

If you are running a version prior to 0.9.4 then you'll need to run the installer and upgrade from your version.

This update fixes a bug found by shortywz where a new donator does not show up on the main donators page. This has been fixed. I also cleaned up some more code, and a slight adjustment to the adminCP.

Cloudrunner
06-25-2003, 03:44 AM
yak!

Sorry, missed a line...archive is updated again for 0.9.5...

if you downloaded paypal_donations(0.9.5).zip, then please download the new one: paypal_donations(0.9.5.beta--noscreens).zip

Thanks! (sorry about that ;))

)O( Cloudrunner )O(

Cloudrunner
06-25-2003, 03:53 AM
Before I forget--

Shorty! Bro, yer the man! Thank you for giving me a hand on this one, I appreciated it greatly!

You all should thank shorty for finding the bug and helping me to fix it up, cus without him it woulda slipped through the cracks!

Thanks!

)O( Cloudrunner )O(

Crazy Pete
06-25-2003, 01:26 PM
Thanks very much you guys! It's nice to see a really well thought-out hack with such great support for it.

Cloudrunner
06-28-2003, 01:31 AM
Well, it looks as though most of the major bugs have been worked out so far, Please let me know how it is running for you all who have installed this hack.

If there is still no bugs found in the next week or so, I'll be moving this to a full release (this is due to the fact that most of the coding adjustments are mostly features and addons to this hack that I will be doing when I am able to, there are a few updates that I will be doing to this, but all in due time of course).

Please let me know of any problems, and of course any more suggestions to the hack so that I may add them to the ToDo List.

Thanks for the help and support guys!

)O( Cloudrunner )O(

Shepski
07-02-2003, 12:57 PM
hiya, this is a great hack but i think i may have done something wrong. I have run thru the install and now sent some money to my account using visa but when I click continue on paypal to send me back to my site I get the following:

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT INTO paypal_funds (id, date, donated) VALUES ('0E567297NG154303X', NOW(), '4.63')
mysql error:

mysql error number:

Date: Wednesday 02nd of July 2003 03:00:26 PM
Script: http://forums.dvd-swaps.co.uk/paypal.php?action=success
Referer:


it does seem to be updating my user profile to say how much i have donated so not sure what this mysql error is relating to.

Any ideas?

sHORTYWZ
07-02-2003, 01:37 PM
noticed another problem, found another suggestions:

the width/height for the award banners is hardcoded into functions.php - probably shouldn't do that..

how about an option to completely disable award images? I tried setting the display to 0 days but that didn't work.

Cloudrunner
07-03-2003, 03:27 PM
The awards display is disabled by the individual users....for now

I can fix the hardcode before Final release.....

As far as the database error, I'm not sure, it seems to be correct for the query, but will have to play with it some more....Gimme abit this weekend...

)O( Cloudrunner )O(

Shepski
07-04-2003, 09:39 PM
right, may have found the problem with the mysql error.

if I try and add the query i posted before into the blank paypal_funds table it goes in fine. But, if I change the id to something else but it still starts with a 0 then I get the following error:

Error

SQL-query :

INSERT INTO paypal_funds( id, date, donated )
VALUES (

'0E567297NG154303X', NOW( ) , '4.63'
)

MySQL said:

Duplicate entry '0' for key 1


Now when i go back and look at the data in the table I see:

id date donated
0 2003-07-04 4.63

id is only a single figure, not that long one its trying to put in. Does this give you any pointers as to where the problem may lie?

Cloudrunner
07-09-2003, 10:56 PM
Sorry about being gone for abit there guys!

Been busy with the new kid and all.

Anyways, I've an idea of where to go with the DB problem, but am gonna have to test the theory this weekend (12 July) I'll get ya'll an ans2wer by Sunday evening.

Cloudrunner
07-09-2003, 11:00 PM
Nevermind. Shepski, Thank you for the info. Found the problem right off!

Bug Fixed!

Run the following query in your DB manager:

ALTER TABLE `paypal_funds` CHANGE `id` `id` VARCHAR(255) DEFAULT '0' NOT NULL;

bouncer18
07-10-2003, 02:07 AM
stoopid question

obviously i donate to my website (i own it)
how can i trick the Db into thinking i am a donating member so i can get my image to show next to my avatar?

i hope this post makes sense

Heffe2000
07-10-2003, 03:56 AM
I currently use my ebay paypal account (since you can only have one), and whenever I get payment for an auction, it shows up in my totals for donations to my forum. While this to some might not be a bad thing, I don't want it to see that I have loads of cash available to the forum that I really don't.

I had many people ask where they could donate money to the forums over the past year, but now that I have the donation buttons on the forum, they all seem to not be able to find it ;).

99SIVTEC
07-10-2003, 03:51 PM
I have a couple quick questions.

First Awesome hack, i've been looking for somehting like this for ages. Thank you for the aparent hard work.

I have several vbulletin sites all on the same server. They form a lose network as they all cover niches of the same industry. Problem being how can I use this hack on more than one site since paypal only allows you to point to one paypal.php file? Can I use this one file for all of my sites somehow? Would this make the totals and such global? If so cool, if not no big deal. I'm just wondering if it would work if I installed it on several sites, but paypal only pointed to the one paypal.php file.

Thank you in advance

bouncer18
07-11-2003, 12:20 AM
bug i found

i had a user donate a penny

where it says in the postbit user has donated
it shows up as

Has donated $ to date.

notice no value....

sHORTYWZ
07-11-2003, 12:59 AM
This is because paypal deducts a one cent fee for a one cent donation hence, zero donation.

Cloudrunner
07-11-2003, 03:35 AM
Bouncer --

Simply manually insert your information into the tables:

paypal_funds
paypal_contributors

and then change the donate field in your user table under your username to read '1'.

Heffe --

Currently, due to the way paypal has IPN setup with only one IPN per paypal account, there is no way to avoid this circumstance. I have asked paypal if they are planning on implementing a multiple site IPN, but thus far I have not received an answer.

99SIVTEC --

Yes, you can use this script globally across your sites, but it will require some slight modifications to the system, and requires that they all be on the same server. I don't think I'll be implementing this however due to time constraints on my part, but it would simply require that the other sites use the main site's paypal.php, ppfunc.php, and ppverify.php files, and also to read off the main site's database. It wouldn't be too hard to do I don't think, but I just don't have the time at the moment.

Shorty --

thank you for answering that one. You are correct. Paypal has a minimum fee of $0.01, so if you donate 0.01, and paypal deducts 0.01, and the mathematical law of 1-1=0 remains in effect, then it stands to reason that the total amount of the donation will be $0.00.

I am debating removing the fee paypal deducts from the user's donation to show what they intended to donate instead of the total minus the fee....still weighing the pros and cons of this scenario.

As for the rest of you ;)

I'll be gone this entire weekend, so further updates will not be occurring probably until next weekend. I have a highland games to go to. So while I'm out there drumming with the pipes in me kilt, I'll be thinking about...well...the competition ;)

Enjoy!

)O( Cloudrunner )O(

kaotic
07-12-2003, 06:14 PM
First of all, thanks for the great hack. But I'm curious, do you still plan to integrate this with Lesane's Store Hack?

Cloudrunner
07-13-2003, 08:08 AM
It is planned yes, but I've not had time to even sleep properly with the new baby....He's starting to sleep longer during the night, so hopefully I'll be able to sleep better myself shortly, when that happens, production will again be in ernest ;). Until then I'm working on it as I get the chance and can think straight...who'da thought that sleep was something you need to actually function properly...

sHORTYWZ
07-13-2003, 10:39 AM
Alright, I have a strange problem

INSERT INTO paypal_contributors( userid, username, avatarurl, datelast, amount, guest_ip )
VALUES (

'166', 'Jaago', 'images/avatars/0/160.gif', NOW( ) , '23.97', NULL
)

MySQL said:

Duplicate entry '127' for key 1

Why would key 1 be entering 127, when the query says 166.

Here is what has happened recently :

I received an echeck payment, which went into the DB as "pending" - ever since then, no donations have been able to enter the db because of strange problems like this.. i have more info cloud, if you can send me an AIM msg when you get around.

Cloudrunner
07-13-2003, 05:04 PM
Another update....Thanks for finding the prob Shorty.

run the following in your DB manager:

ALTER TABLE `paypal_contributors` CHANGE `userid` `userid` INT( 255 ) DEFAULT '0' NOT NULL;

Enjoy!

)O( Cloudrunner )O(

sHORTYWZ
07-13-2003, 07:53 PM
Alright, just thought of something.. do funds/goals ever expire?

I don't know how to go about it.. but otherwise in about six months I'm going to have 2 pages of goals and my frontpage is going to say that we need to raise $1000 worth of donations..

bouncer18
07-13-2003, 08:08 PM
yea i manually entered it into my DB

but what i was saying was maybe add an IF THEN statement to it so it atleast shows up as $0.00 rather then just $

Heffe2000
07-13-2003, 10:28 PM
What would be the chance of this running on 2 seperate VB setups, on 2 different domains, via one paypal account? (I'm guessing that it won't, or would be too difficult...).

Could you use the donation name to route to a different paypal.php or something?

I'm setting up a new domain with a seperate VB running on it, and would like donations to show up on there & the older forums.

If paypal would allow you to have multiple accounts, this would be irrelevent, but since they restrict you to one (even if you have 2 people living in the same house with seperate accounts, you can have them blocked...).

0zone
07-14-2003, 05:27 AM
great hack, thanks a lot!

0zone
07-14-2003, 06:20 AM
Umm, one problem, the buttons aren't showing up.

http://www.avriltalk.com/forums/paypal.php

Marulatree
07-15-2003, 10:57 AM
I have noticed with all paypal donations - the member donating seems to be tricked into registering with paypal. Is there another page that the member can just fill the donatation amount with there visa/switch details? I see what the script does for the members (giving the oppotunity to earn benefits for donations.)But if I just want to add a donation button to my postbit for example that allows the member/guest to just fill in there card details and the donation will be paid into my paypal account.

If this is not possible, are there any websites that allow this type of donation service that you guys know of?

Please PM me with any suggestions. Thanks in advance.

Cloudrunner, great hack by the way. You deserve a frickin' medal my man!

MT

Cloudrunner
07-17-2003, 04:06 AM
Shorty--

The only way to expire the goals at the moment is to remove them. I fogot to add the delete function into the admin manager. It's in me Todo list

Bouncer, I'll look into that, but really do not see the relevence of it since if the user donates a penny, it's pretty much not a donation now is it since Paypal takes that penny away ;)

Heffe--

At the moment it cannot be done due to the way Paypl implements their IPN system.

0zone--

Have you enabled them in the admin options for the donations? You have to tell the system that you want them to show up, this is in the donations options section of the adminCP. And thank you ;)

Marulatree--

Thanks for the praise, I needed that today. Unfortunately Paypal requires the folks to activate an account with them for you to accept their payment. There are a couple of other payment gateways available to do the visa straight through, but they require you to pay up front and hold a merchant account with them (which requires a credit background check etc.), and the ones that do not require this are not written into this hack ;)

sHORTYWZ
07-17-2003, 10:21 PM
Cloud -

Having problems with that transaction where I had to manually to enter the user into the contributions table - the "has contributed xxxx to the board so far" isn't showing up under his name.. I've checked the entry and everything and the userid is correct so I can't think any reason it wouldn't be working.. ideas?

Skyline_GT
07-17-2003, 11:09 PM
Hm.. how come my thing don't show up in the forumhome and postbit? I added the $donations_needed already..
Please help

Falkware
07-18-2003, 01:37 PM
First of all...thanks for a superb hack!

This makes things so easy for me compared to the manual labor I had to do for each contributing member.

I was looking for a system like this for a long time and I can't believe I found this! heh...

I have some minor requests, if that's ok. I figured since this is beta still that you won't mind...

1) Usergroup
Having the option to automatically move a contributing user to a specified usergroup upon successful/completed donation. I have a separate usergroup for contributors, giving them access to special forums etc on my site, and it would be great if the system could automatically transfer them to a usergroup admin specifies when their donation clears.

2) Delete function/Expire function on goals
Being able to expire goals would be great. Especially if there was some sort of automation, where if you flag a goal as "purchased" or "reached" it would then go away.

For instance, if you're setting up a goal to reach $xxx for a software/hardware addidtion to the site, and you reach that, then you're able to flag that goal as reached and that particular goal is removed and/or archived :)

I say Archived because it would be cool to have a list of "Goals Reached". This would show the contributing users that their donations are in fact helping the site. I realize this might be a little redundant, so it's just an open suggestion. :)

3) Donation Amount Explanations
One of the plans on our site is to set up the different donation amounts for users to quickly choose an amount they want to donate and thankfully that's already in there. One thing we do on the site is to offer some different perks depending on amount donated and it would be really great if we had a text field to write these in on each donation amount. For us it would just be a bulleted list of perks per amount...

4) Donating to a specific goal
This is more of a user-side suggestion. Some users are likely to want to donate their money to one goal in particular. Let's say you have 5 goals set up on your site. These are goals adding different features to your site. User X wants to donate $xx to goal #1. Is there any way to have donation buttons per goal so the user can click desired amount for a goal and have it reflect his goal donation in the Item Title of the donation as his contribution done towards that particular goal?

I don't know if that makes sense, so let's clearify.

Let's say we have goal 1 and goal 2. A user wants to donate to goal 2 as this seems to interest him. He clicks on a button for $20 under goal 2 and goes through the donation steps.

An E-mail arrives to system admin as always. In the Email it says...

------------------------------
Payment Details:
------------------------------

Total Amount: $20.00
Currency: U.S. Dollars
Transaction ID: xxxxxxxxxxxxxxxxxxx
Quantity: 1
Item Title: Site Name - Donation towards goal2name
Item Number: 1
Invoice ID: xxxxxxxx
Buyer: Name Surname

Just an idea of course :) It would open up possibilities for separating goals on the frontpage of forums too and show how much is needed for the different goals etc...

Well, here I am suggesting a ton of stuff. I honestly am VERY happy about this system. It makes my life easier!

Of the suggested features I would have to say I personally would really enjoy the usergroup feature the most, seeing how that's something we rely on.

I bet other sites using this system takes advantage of the usergroup powers as well...but I might be wrong of course :)

Thanks again and keep up the stellar work!

*Clicks Install*

Skyline_GT
07-21-2003, 06:45 AM
anyone help me?
please?

jc2002
07-21-2003, 03:47 PM
I installed the hack, but in my admin, I cannot see the other options except the first one. I remember that there should be an option for managing goals, awards, buttons, but cannot see them, why?

Falkware
07-22-2003, 05:13 AM
I ran into a problem and I wanted to see if anyone else could replicate this.

Someone made a donation through the paypal system, testing it's functionality for me. An error occured and I made some changes to the system as they received an error too.

Error that arrived in my Inbox included:

mysql error: Duplicate entry '311656859T426214A' for key 1

mysql error number: 1062

I refunded the donation to the person in question through the paypal system since I couldn't find any option to do this through this system's admin.

When I did that I received an email containing:

You have received a new payment transaction. To view the deatils of this new transaction place the following line into your database manager:

SELECT * FROM `paypal` WHERE `txn_id` = '61C12242C1842292T'

Enjoy!

When the person went to make another donation she received the following:

Error Detected

This invoice has already been paid. For more information, please contact the merchant.

So does this mean a person cannot make more than one donation through this system? What happens if a person wants to make monthly donations to the site?

How come when the donation was refunded to the person I got a 'new payment transaction' notice?

So far the system looks real nice and with some html edits I got it looking real nice. Now if I can figure out these little 'errors' I'll be a happy user! :)

0zone
07-23-2003, 01:51 AM
0zone--

Have you enabled them in the admin options for the donations? You have to tell the system that you want them to show up, this is in the donations options section of the adminCP. And thank you ;)



Cloudrunner, I enabled everything in my admin options under donations, but alas, still no buttons. I have made sure I have uploaded it into the right directory, so there is no problem there. I had absolutely NO errors whilst installing this hack.

I am stumped. I really want to use this hack :(

jc2002
07-23-2003, 01:04 PM
ozone, do u see an option under Donations that says Add button? If you don't, your installatin is not complete.

vB-Host.com
07-24-2003, 06:56 AM
when someone makes a donation and paypal sends them back with ?=sucess you get this...
Fatal error: Call to undefined function: vbmail() in /home/sports/public_html/ppfunc.php on line 127

put then if you go to paypal.php the donation shows....

Cloudrunner
07-25-2003, 06:37 AM
Sorry I've been away for awhile again guys ;)

Alas, with the personal side of me life I've not had much time still to work on the hack I am still working on it as time allows though. I will see what I can do for all problems encountered since my last post tomorrow. Please be patient with me...

Dean C
07-25-2003, 02:07 PM
vbhost - you are not running the latest release of vbulletin as the vbmail function was added in 2.3.0 :)

- miSt

Skyline_GT
07-26-2003, 02:17 AM
07-18-03 at 01:09 AM Skyline_GT said this in Post #84 (https://vborg.vbsupport.ru/showthread.php?postid=418592#post418592)
Hm.. how come my thing don't show up in the forumhome and postbit? I added the $donations_needed already..
Please help

any help please?

Cloudrunner
07-26-2003, 02:24 PM
07-17-03 at 04:21 PM sHORTYWZ said this in Post #83 (https://vborg.vbsupport.ru/showthread.php?postid=418580#post418580)
Cloud -

Having problems with that transaction where I had to manually to enter the user into the contributions table - the "has contributed xxxx to the board so far" isn't showing up under his name.. I've checked the entry and everything and the userid is correct so I can't think any reason it wouldn't be working.. ideas?


goto that user's information in the user table and change the donation field to '1' (this is the check to see if that specific user has donated or not).

Cloudrunner
07-26-2003, 02:25 PM
07-17-03 at 05:09 PM Skyline_GT said this in Post #84 (https://vborg.vbsupport.ru/showthread.php?postid=418592#post418592)
Hm.. how come my thing don't show up in the forumhome and postbit? I added the $donations_needed already..
Please help


Got into your adminCP and in the options for the donations make sure you have turned the options to show these items on ;)

Cloudrunner
07-26-2003, 02:27 PM
07-21-03 at 11:13 PM Falkware said this in Post #88 (https://vborg.vbsupport.ru/showthread.php?postid=419638#post419638)
I ran into a problem and I wanted to see if anyone else could replicate this.

Someone made a donation through the paypal system, testing it's functionality for me. An error occured and I made some changes to the system as they received an error too.

Error that arrived in my Inbox included:



I refunded the donation to the person in question through the paypal system since I couldn't find any option to do this through this system's admin.

When I did that I received an email containing:



When the person went to make another donation she received the following:



So does this mean a person cannot make more than one donation through this system? What happens if a person wants to make monthly donations to the site?

How come when the donation was refunded to the person I got a 'new payment transaction' notice?

So far the system looks real nice and with some html edits I got it looking real nice. Now if I can figure out these little 'errors' I'll be a happy user! :)


Run through the thread here and you'll find the fixes required to repair this bug. I have not yet updated the release to reflect the small alterations to the database, but this has been addressed.

You will probably have to delete this donation from the database to fully repair the problem as well, but do the fixes first them try it before you remove the donation from the DB.

Cloudrunner
07-26-2003, 02:33 PM
07-22-03 at 07:51 PM 0zone said this in Post #89 (https://vborg.vbsupport.ru/showthread.php?postid=419876#post419876)
Cloudrunner, I enabled everything in my admin options under donations, but alas, still no buttons. I have made sure I have uploaded it into the right directory, so there is no problem there. I had absolutely NO errors whilst installing this hack.

I am stumped. I really want to use this hack :(


I'll need to look at how your setup is bro. I'm kinda stumped on this one as well...butI canna help with that level of support at the moment as I've real life to attend to at the moment...I'll be able to hit the pavement again hard soon, but not until after I clear up some ++++ in me personal side of life first ;)

Hope you understand.

Skyline_GT
07-26-2003, 06:38 PM
Today at 04:25 PM Cloudrunner said this in Post #96 (https://vborg.vbsupport.ru/showthread.php?postid=420791#post420791)
Got into your adminCP and in the options for the donations make sure you have turned the options to show these items on ;)


Yes, I double check, and it is there and I have check all to yes

sHORTYWZ
07-29-2003, 05:40 PM
07-26-03 at 04:24 PM Cloudrunner said this in Post #95 (https://vborg.vbsupport.ru/showthread.php?postid=420790#post420790)
goto that user's information in the user table and change the donation field to '1' (this is the check to see if that specific user has donated or not).


awesome.. worked great. Thanks again!

PurpleCow
07-31-2003, 06:23 AM
Great hack Cloud. i will sure install it soon.

folkware seems have some very very interesting suggestions. Do you plan to consider them ??

Thanks for such a nice and iseful hack !

Thanks

sHORTYWZ
07-31-2003, 02:21 PM
Cloud.. few more troubles =)

gotten two donations today, and both of them came back with an error:

Invalid SQL: INSERT INTO paypal_funds (id, date, donated) VALUES ('2P391627PJ628391M', NOW(), '95.8')
mysql error: Duplicate entry '2P391627PJ628391M' for key 1

Invalid SQL: INSERT INTO paypal_funds (id, date, donated) VALUES ('10S829370N231235D', NOW(), '4.55')
mysql error: Duplicate entry '10S829370N231235D' for key 1

jc2002
08-01-2003, 06:50 PM
I got an error message saying:

"Error Detected

This invoice has already been paid. For more information, please contact the merchant. "

I don't understand, I am trying to test the paypal using a visitor account. I don't even get to enter my credit card information yet. Just click on the donate button and I got the above error message? Why?

It was working twice last week before I installed the Archive hack. I wonder if the archive hack screwed something up???

jc2002
08-03-2003, 03:14 AM
07-25-03 at 11:07 AM Mist said this in Post #93 (https://vborg.vbsupport.ru/showthread.php?postid=420522#post420522)
vbhost - you are not running the latest release of vbulletin as the vbmail function was added in 2.3.0 :)

- miSt

so how can I use the vbmail function with this hack if I am on 2.2.9??? This hack, according to cloud, does not work with 2.3.0.

I am getting the same error for vbmail.

Help please.

thanks.

Cloudrunner
08-03-2003, 07:20 PM
actually jc it was designed and written using 2.3.0 ;) So it is 2.3.0 compliant, but the others I'm not sure of.

Shorty, Find the records in your database that have only a few characters in the id field and remove them (or edit them to something random to match the length of the txnid from paypal: i.e. 17 characters). What is happening is that your old donations are in there as one or two characters and as they are being put in your are getting duplicat ids cus mysql ignores the rest of the code. This is a side effect of the last fix that I made to the db.

I'm am still working on this folks, so please be patient, I still have a new baby that requires about 95% of my attention anymore ;). The next update will be within the month.

Skyline -- did you make sure that you did all the changes verbatim?

Skyline_GT
08-03-2003, 10:09 PM
verbatim?
What is verbatim?
i know i did all things in the instruction

Cloudrunner
08-03-2003, 11:44 PM
verbatim means word for word.

post a screen capture of you admin CP for the donations hack here and I'll see what I can come up with.

jc2002
08-04-2003, 01:37 AM
so if I don't use vb2.3.0, I cannot use this hack because of the vbmail problem that I had??? is there any substitute for vbmail?
is there a way to turn off the vbmail functionality?

Thanks.

Crazy Pete
08-05-2003, 01:00 PM
jc2002, you can try changing the vbmail() functions to mail() instead. That was the old code for sending e-mails which was changed in 2.3.0. Not sure if it'll work correctly, but it's worth a shot.

jc2002
08-06-2003, 03:23 PM
thanks i'll try

Dras
08-06-2003, 10:28 PM
How do you add a goal? I can't seem to find it in my AdminCP

jc2002
08-11-2003, 06:43 PM
it did not work using mail().

anyway, now I have another problem. After I installed paypal hack, I cannot do a full database dump any more. It always stops at one of the paypal tables. I think one of the tables has a problem with empty column.

sHORTYWZ
08-18-2003, 04:03 PM
Cloud -

I already did that, I'm wondering if it didn't update the keys for these records?

The weird thing is that they are getting inserted into the db, just giving me and the donating user an error before it does it.

Briskoda
08-20-2003, 09:45 PM
Firstly, great hack, reading notes from proposal to install, very good material.

Apologies if this is already known, but in summary:
Auto complete IPN causes duplicate txn_id insert attempt.
Default post back of txn_id causes VERIFIED display only.
Refund sets all funds to 0.
Refund does not reduce contributors sum.

Assumption: guest processing. Not permitting guests to this page, at present...

Okay onto my experince, not sure if a few bugs are known or if it's a recent change at PayPals end.

Basically the first few payments where a manual deny was issued worked a treat, the user was returned to the success page. Although the payment was still pending in my account (to be denied or accepted) So I accepted it, thus enabling the autocomplete processing in paypal, so now each payment that comes in is appearing as completed.

So initially this hack worked, then the continue button induced the duplicate keys bug as eluded to previously, so I checked the id's all was fine, ran a few more through, same issue.

After going throught the code it seems that the IPN is beating the continue button process, but still by default it seems posting back txn_id. As such ppverify is picked up and processed where by the insert is run at 104 regardless at this point. For a completed status where the entry is already in the db I cannot see why this is needed. So I commented it out and the process began to work, except now I was rewarded with just the word VERIFIED, so I modified the paypal to do ppverify.php processing and sucess/cancel, it all seems to work again, apart from duplicated payments amounts, the update circa 139 was commented out.

I created a multitude of credits and refunds, it seems to be working now...

I then began to check what was happening for refunds, it set's all funds to 0.00 not the txn_id record passed in for the refund. Also noted the contributors table was not downdated for the refund. So I added an SQL in for that.

Has anybody else noted this behaviour, are the fixes in, if needed atall?

Does the fact I'm a UK user of paypal, the transactions appearing as complete immediatly have any bearing?

Apologies if this is a wild goose chase and I really do appreciate the hack, newborn pressures on time, so one for everybody else to ponder over :D

Colin.

vB2.3.0

Voltron420
08-23-2003, 08:18 PM
I'm having problems with the success page, all that is displayed is the word "VERIFIED"

There is no HTML whatsoever on the page, viewing the source code just shows the word "VERIFIED"

The transaction is logged correctly, and all of the information is stored, but the user is left with blank page seeing the word "VERIFIED" when they should be seeing the thank you/successful text page.

Any ideas?

Briskoda
08-27-2003, 06:50 AM
Voltron,

As per the post above, I modified paypal.php to do the ppverify processing and the paypal.php processing. There is an obvious (sorry not at dev machine to qoute source) if else statement that tests for Post vars, I changed this to a If/End around the inluced for ppverify, this still processes and displays VERIFIED, but also the sucess page texts.

Intresting you have the same symptom as I had. I'm not saying what I have done is correct, just it now appears to work, original mod worked fine till I added the CC and payments were automatically confirmed.

b00tsauce
09-05-2003, 02:59 AM
Cool hack indeed. However I have a couple of important questions.

I've been loving the VB3 integration of PayPal. However, there are some bugs with it and stuff. Is this one any stable?

I'll be looking to use a hack for PayPal with vBulletin but can it be labeled as a "subscription" rather than a "donation". Maybe there are examples somewhere?

The reason that I wanna really go back to 2.29 or 2.30 is because of all the hacks that are available for them. vbindex, vbhome, etc are stuff that I would really need. VB3 has no support for that.

Anyway, you can see my dilemma:

VB3 = Has PayPal, but its a little buggy, but has no widespread hacks like 2.x

VB2.x = Stable, with a lot of hacks, but doesnt have PayPal integrated.

If someone could shine some light on this for, it would be great! :)

Thanks!

steve@dvdlard
10-23-2003, 03:39 PM
This is a great hack, very useful.

I do have one question, is there any quick way to change the currency symbols etc to GBP instead of USD on all the screens?

gmarik
10-23-2003, 04:19 PM
Oh, if only it would be more easy to integrate into other vB hacks ...

Itworx4me
11-05-2003, 09:13 PM
Anyway to make it so that members are the only ones that can donate?

Neo
11-16-2003, 09:33 PM
can you tell me what RC means? O_O

tpearl5
11-18-2003, 03:51 AM
All fixed!

Please download the new version. If you are running version 0.9.4 then all you have to do is upload the new files overwriting the old ones.

If you are running a version prior to 0.9.4 then you'll need to run the installer and upgrade from your version.

This update fixes a bug found by shortywz where a new donator does not show up on the main donators page. This has been fixed. I also cleaned up some more code, and a slight adjustment to the adminCP.

For some reason I am having this problem. I did a fresh install updating from an alpha release.

MaDCaT75
11-19-2003, 08:32 PM
can you tell me what RC means? O_O
Release Candidate

C.Birch
11-23-2003, 07:30 AM
dont work for me

i get the paypal e-mail telling me i have new money but not a think gets updated on the forums i have been having to do it by hand editing the database.

im a paypal.co.uk user and my forums is 2.3.2

http://forums.ultimatepop-network.com

kastle
12-07-2003, 07:59 PM
I couldn't find the fix to this, so please bear with me if it's already been posted... I spent quite a bit of time searching and reading....

Once a transaction with PayPal has been completed, the person who donates selects to return to my site (www.mysite.com/forums/paypal.com) and all they see is a white page with VERIFIED printed on it...

Now, I did see a few posts that spoke about adding stuff from ppverify.php to paypal.php, but I couldn't find the specifics.

Can anyone help me out on this... would be greatly appreciated...

-K

tpearl5
12-08-2003, 01:52 AM
I'm still having the same problem.. any ideas?

por4x4
12-09-2003, 01:11 AM
I installed this hack, and when I click on the "Click here to begin the installation process -->" link nothing happens?

por4x4
12-10-2003, 01:36 AM
I installed this hack, and when I click on the "Click here to begin the installation process -->" link nothing happens?

Top. :(

PixelFx
12-10-2003, 12:07 PM
I installed it on orbsydia.com with vb2.3.3 as far as I know everything installed clean, I just have to wait for donation to see if it works :P

por4x4
12-12-2003, 03:31 AM
ok, can someone PLEEEASE help me here? I realllllly need this hack.

kastle
12-12-2003, 05:00 AM
Makes 2 of us who need resolution to this... :)

Cloudrunner
12-13-2003, 03:34 PM
Wow...I didn't think anyone really gave a damn about this hack anymore...

After the thread died out and VB3 came with it's integration of paypal IPN, I stopped work on this hack. Then reality set in, and I had a new boy, plus got involved in alot of other projects including moving the family (again) and a few other issues that I needed to resolve.

All excuses aside, I personally am now using the integrated paypal subscriptions for VB3 as a donations setup (It's not hard to do actually), and since the integration of the vb3 system is already done, and paypal has changed the way IPN is working, I just kinda let this hack fall to the wayside.

All things said and done, I am no longer developing this hack. I apologize for anyone who may wish to stone me for this, but VB3 has made this hack basically obsolete.

Anyone who wishes to, may take over development, I don't mind. I simply do not have the time to spend on developing a hack that will be obsolete with the full release of VB3.

*stands with arms spread*

So here I be if you wish to throw things at me because of my decision. I apologize for doing it, but I do not regret it simply because making the subscriptions feature within VB3 a donations portal took me all of 10 minutes ;)

Enjoy

)O( Cloudrunner )O(

PixelFx
12-13-2003, 09:55 PM
This hack really kicks ass, I just added it to my vb2.3.3 forum, It hink all of it worked find :)

PixelFx
12-14-2003, 03:47 PM
Question in award change section of this hack how do I change the image size of the award?

Thanks :)

Cloudrunner
12-14-2003, 03:52 PM
If I remember correctly, I think I hard-coded the image sizes in the code, but I do not remember if that's the case.

do a search within the files for width= or height= and that should give you a jumping off point, but I truly don't remember cus I no longer have the code, and am not doing the hack any longer.

b6gm6n
12-21-2003, 11:12 AM
Just like to say, .... anyone have an idea about the gamma subs not working i see 'C-Birch' has exactly the same trouble, i can use IPN, i'm a UK premier membert, but nothing happens...SO

do "i" have to be verifed for this to work (i'm not)

-b6

Etcher
01-04-2004, 02:08 AM
Don't give up on this hack just yet... NOT all of us are moving into the VB3 world...
Portal is not ready, and my site is working perfect as it is, I am in no hurry to upgrade...

ghost323f
01-07-2004, 02:30 AM
Two problems, user id not being displayed in the top ten field, only amt.

And, I cant fing the file,scrip,table ect.. to manualy change this.

cnczone
01-07-2004, 02:44 AM
I would like to have this hack for VB3!

kneesparx
01-09-2004, 09:27 PM
I would like to have this hack for VB3!

ditto :)

Funkie
01-25-2004, 09:12 AM
me too

Kaelon
01-27-2004, 04:18 PM
vB3 already comes with integrated PayPal.

Funkie
01-27-2004, 04:35 PM
With Instant Payment Notification?????

twoseven
01-28-2004, 02:38 AM
i havent downloaded and looked at the code yet but is this hack easy to modify for those of us who cant use paypal to another host that uses IPN?
Great hack Btw was goin to pay someone to write this exact hack.

tpearl5
02-03-2004, 05:35 AM
I'm still having problems with my install on 2.3.3. I would really love to see someone integrate this into the store hack..

PLEASE!? :)

vreynaud
02-15-2004, 02:36 PM
vB3 already comes with integrated PayPal.

can you tell me where? I am running VB3 RC3, I looked but cant find it
thx

Funkie
02-15-2004, 02:39 PM
user cp paid subscriptions under Miscellaneous

vreynaud
02-15-2004, 02:52 PM
user cp paid subscriptions under Miscellaneous
on the user end the options they have:
Miscellaneous
-Event Reminders
-Buddy / Ignore Lists
-Attachments
i dont see donations/paypal
dont i need to set it up on the back end somewhere?
thx

vreynaud
02-15-2004, 02:59 PM
found it duhhh!
thx anyway
for other blind one like me, its here:
admin CP>subscriptions>subscription manager> add new subscription

cnczone
03-13-2004, 03:43 AM
How can I manually add a person who has contributed???

cnczone
03-21-2004, 02:42 AM
Is their a ANSWER out there???

bigtime
05-09-2004, 03:44 PM
Does this work with 3.01?

bigtime
05-15-2004, 07:41 PM
Have a question about paypals IPN. I have IPN on, and the Instant Payment Notification (IPN) URL filled in. It is used for another subscription hack. Is it possible to have 2 IPN's? If not, how would I go about using your paypal donations hack with the other subscriptions hack I am using now?

Hope that makes sense....


Specifying Your Notification URL
If you only need to receive your IPNs at a single URL, you can enter that URL in the
Preferences section of your Profile.
If you would like to receive payment notifications for different payments at different
URLS (i.e. if you need to separate payments made to different websites you run), you
can manually pass the IPN URL with each payment by including it in that payment?s
HTML code. Use the notify_url field to pass this information.
The notify_url for a specific payment will be saved, and any subsequent updates to
that payment (e.g. cleared eCheck) will be sent to that notify_url. When you pass a
notify_url in your HTML code, it will override any preferences you set in your Profile.

Playboy69
06-05-2004, 02:53 PM
I downloaded this hack and uploaded the files as told in the install. I have a few problems though. When i try to run the install i get this

Warning: main(./config.php): failed to open stream: No such file or directory in /home/ultimate/public_html/forums/admincp/paypal_donations_install.php on line 5

Warning: main(): Failed opening './config.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/ultimate/public_html/forums/admincp/paypal_donations_install.php on line 5

Fatal error: Call to undefined function: cpheader() in /home/ultimate/public_html/forums/admincp/paypal_donations_install.php on line 6

Now my forums is in a "forums" directory


only edited to subscribe tothe post
My site is a standard non hacked site that was only put in a directory "forums" instead of root, also I have noticed were it says to upload 2 files to admin directory well I dont have that I have a admincp directory not sure if this matters but I thought I would post that. please let me know thank you .

My Site (http://www.ultimate-gamers.com)

Sirius Black
07-25-2004, 12:32 AM
Any plans on porting this or something like it to vb3 ?

tpearl5
08-15-2004, 08:20 PM
Specifying Your Notification URL
If you only need to receive your IPNs at a single URL, you can enter that URL in the
Preferences section of your Profile.
If you would like to receive payment notifications for different payments at different
URLS (i.e. if you need to separate payments made to different websites you run), you
can manually pass the IPN URL with each payment by including it in that payment?s
HTML code. Use the notify_url field to pass this information.
The notify_url for a specific payment will be saved, and any subsequent updates to
that payment (e.g. cleared eCheck) will be sent to that notify_url. When you pass a
notify_url in your HTML code, it will override any preferences you set in your Profile.

If anyone needs the edits to do this, let me know. I came across this problem and added a field to the buttons for the notify_url.

adieball
08-24-2004, 05:16 PM
Hi

any news on whether this will ported to VB3?

Rgds.
Andre

Kaelon
08-26-2004, 07:48 PM
Doesn't vB3 already come with integrated subscriptions?

FWF
08-27-2004, 03:27 AM
man a hack like this for 3.x.x would rule!

CVMagic
08-30-2004, 12:47 PM
Doesn't vB3 already come with integrated subscriptions?
Actually it does but it does not allow you to just take donations, so in the case of donations a user could donate as many times as he or she wants but in the case of the subscription script for vB3 it is limited to once every time period and it is also limited to a set ammount you wanted it at, not how much the user wants to give which is somewhat a set off.

stevnmd
09-05-2004, 03:18 PM
I agree that this hack, ported to vB3, would be REALLY appreciated!

chet
09-06-2004, 11:58 AM
Ditto, this would be an ideal hack for VB3

I agree that this hack, ported to vB3, would be REALLY appreciated!

nhatrang
09-17-2004, 09:53 PM
I think it's more a implenting hack to get the ipn work with the paypal transcastion..

chet
09-19-2004, 05:58 PM
Could somebody make this available for vb3.x, I want to be able to use this hack to show users how much money they have donated which will go to charity

Chet

Takamine334
11-25-2004, 03:31 PM
topping this for the coder...we really need this in ver 3.0.3 :)

Please! :)

chet
11-25-2004, 03:43 PM
Our site too :)

DS MrSinister
12-02-2004, 05:31 PM
this would be great for VB 3.0.3

lasto
12-14-2004, 11:05 PM
would this work on vb3 ?? or is it a no go ?

SupraT
03-15-2005, 04:20 AM
would this work on vb3 ?? or is it a no go ?
Think this can make it to VB3? There is much interest, would be great.

Marco van Herwaarden
04-07-2005, 11:58 AM
vB2 and vB3 are internal complete different. Chances are 99% that any vB2 hack would have to be rewritten from scratch to work on vB3.

tankknat
04-13-2005, 05:28 AM
Hi there, Just a n00b Question, (first time with vBa), When I try to load the install page I got this error...

Warning: main(./config.php): failed to open stream: No such file or directory in /admincp/paypal_donations_install.php on line 5

Warning: main(./config.php): failed to open stream: No such file or directory in /admincp/paypal_donations_install.php on line 5

Warning: main(): Failed opening './config.php' for inclusion (include_path='.:/usr/local/lib/php') in /admincp/paypal_donations_install.php on line 5

Fatal error: Call to undefined function: cpheader() in /forums.clan-da.com/admincp/paypal_donations_install.php on line 6

So I changed the path to the right path for the config file which is ./includes/config.php
and now I only get this error..

Fatal error: Call to undefined function: cpheader() in /home/hsphere/local/home/tankknat/forums.clan-da.com/admincp/paypal_donations_install.php on line 6

can anyone put me in the right direction... Thanks in advance for any help.

Marco van Herwaarden
04-13-2005, 06:26 AM
vBa? I suppose you mean vB?

What version of vB you are running? This hack is for vB2, and will not run on a vB3.

tankknat
04-13-2005, 06:14 PM
OK I guess you have answered my question as im using vb.3.0.7... Is anyone going to release this for vb3, cos this mod is fantastic, i used to have a mod like this on my old phpnuke site...

Monica05
04-19-2005, 04:55 AM
I would love this for my vb 3.0.7 as well.

Marco van Herwaarden
04-19-2005, 06:05 AM
Please stop bumping years old threads.

If you are looking for a hack for your vB3 board, look in the apropriate forum. If you don't find what you are looking for make a post in the vB3 Modification requests.

Thank you.

Polo
04-20-2005, 01:27 PM
wow, this looks really nice cloudrunner... good job!

|Jordan|
04-29-2005, 09:36 PM
OMG this is sooooo cool. I've been looking for something that does this.

YOU ROCK!

EDIT: Oops, didn't realize this was for vb2.x i run 3.x :( any chance this will be ported?

Cloudrunner
05-21-2005, 09:17 PM
OMG this is sooooo cool. I've been looking for something that does this.

YOU ROCK!

EDIT: Oops, didn't realize this was for vb2.x i run 3.x :( any chance this will be ported?
Good lord, who ressurected this thing?

I haven't even touched this things since I scrapped it when VB3 was released, sheesh, that's almost 2 years now gone by...

I guess if peeps still want a donations system I can look into redoing this thing, but jeez, why would you have resurrected a two year old thread?

|Jordan|
05-21-2005, 09:31 PM
I didn't notice the date on thread, i was too excited that i found a donation system for vBulletin. After i noticed it was for 2.x my excitement died.

Sorry :o :surprised:

Cloudrunner
05-28-2005, 05:51 PM
I didn't notice the date on thread, i was too excited that i found a donation system for vBulletin. After i noticed it was for 2.x my excitement died.

Sorry :o :surprised:
Alright, after thinking on this abit, I've decided to resurrect this thing again and port it over to vB 3.0.7 and the new PayPal IPN / Data Transfer system.

This is going to take me awhile to do this, so please be patient. If you wish to assist in the testing of it once I've blocked the coding up then PM me and I'll get you on the list for testing. The Alpha phase will cover only 5 testers, so it's first come first served.

|Jordan|
05-29-2005, 12:52 PM
OMG, YOU ARE AWESOME!

Thanks a million!

Are there any places i can donate money to you to encourage this vast undertaking?

Cloudrunner
05-29-2005, 02:12 PM
OMG, YOU ARE AWESOME!

Thanks a million!

Are there any places i can donate money to you to encourage this vast undertaking?
Not to me personally, but if you truly wish to help financially, feel free to donate to The Noble Pagan, non-profit Organization for Promoting Tolerance Through Education. Simply use Paypal and the email address tnp@noblepagan.com. Details on where donations there go are on http://www.noblepagan.com.

dsboyce8624
06-05-2005, 09:34 PM
He can donate whatever he wants to me!!!!!

karanlikdunya
10-20-2005, 07:05 PM
3.05 working?