The Arcive of Official vBulletin Modifications Site.

PayPal Donations For vBulletin 3.5.0 · **Released**: 07-02-2005

Sorry Guys...I have disappeared from vB coding completely for the time being...RL is paying me $35/hour to ignore it lol. Hope you understand why I haven't been around...

Paypal Donations For vBulletin 3.5
Version 2.02b

Hack Provided and coded by )O( Cloudrunner )O( of The Noble Pagan.
Release version: 2.02b
Release Date: 03 July 2005

Change Log

Paypal Donations 2.02

Fixed Bug introduced with the installer for the tables from 2.01
Added Who's Online Support Plugins For Donations Script

Paypal Donations 2.01

Fixed a small bug in the display of the top / last donors on the donate page.

Paypal Donations 2.00

Ported system over to vBulletin 3.50
Added ability for the installer to install template edits automatically
System installs plugins automatically
Fixed some minor bugs that were present in 1.07 of the 3.0.7 vBulletin donations system.

Special Thanks

Special Thanks goes to the following people, without their support, this would never have happened:

dsboyce8624
guvner
SLeeeper
And all of the Alpha Testers that helped out with this Hack!

I couldn't have done it without you all, Thank you!

)O( Cloudrunner )O(

What Paypal Donations Is:

Paypal Donations is a complete system that controls donations and how they are received via backend interfacing between your vBulletin server and Paypal's payment gateway server. The beauty of this marriage of servers is quite simply automation of the donation process as well as security of the transactions for both you, the administrator, and your users. With the Paypal donations system installed on your forums, you will be able to bring in that much needed income to not only keep your forums alive, but also to help defer costs of doing so to the users of your site without having to bug everyone and beg for money.

This seamless integration of Paypal as your backend payment processor not only provides your user with a well known and safe payment processor, but you are saved the hassle of opening a merchant account with your banking institution as well as saves you time in the process as it takes only a few short minutes to sign up with Paypal if you are not already an account holder there.

System Requirements

OS: vBulletin 3.5 (if you are running this already, then your server has the required installation, GD libraries are required, as well as CURL capabilities for this system to work)

Things To Do Before Installation

Direct File Edits To vB Resident Files: 1 (needed to group templates in AdminCP)
File Uploads: 34 (Of which 18 will be deleted after installation, leaving a total of 16 Files on your server)
Direct Database Queries: None, the installer does these for you
Direct Plugin Installation: None, the installer does these for you
Direct Template Modification: None, the installer installs all new templates, and modifies the resident templates as needed

The uninstaller will remove all modifications (to include the templates) should you decide to remove the system from your server.

How To Install / Upgrade Paypal Donations

Installation and Upgrading are as easy as a human like me could make it. Simply upload all the files from the archive to your server keeping the folder hierarchy intact and then point your browser to the installation file. On most servers it will be one of the following:

Just follow the prompts from there folks, the installer does all the database, template, plugin, phrasing, and settings automatically for you!

If you ever decide to remove the system, just upload the install files and folder again and run the installer and choose uninstall. The uninstaller will remove any and all modifications that it did to your files, database, and templates automatically as well. Its as easy as you can get!

Time to install: less than five minutes depending on your upload speed.

Steps To Perform After Installation

You must make sure that you have either a Business or Premiere account with Paypal.
1. If you do not, then you will need to upgrade your Paypal account to that level before this system will work.
You must have Paypal's IPN (Instant Payment Notification) turned on in your Paypal Profile.
1. You do not need to have it pointing at any particular file for this system to work as the system will tell Paypal where to send the IPN to credit your users and notify you of the transaction.
You will need to run through the donations settings at the end of the installer and make sure that you have all the required information in there.
Please note that this system can be placed into test mode (default setting is ON when system is first installed).
1. This setting tells the system whether to speak with the real Paypal Server for transactions or with Paypal's Sandbox (testing) server. If you wish to test the system before going live you will need to have access to Paypal's Sandbox server, you can sign up for access there at: http://developer.paypal.com.
You will need to input your Paypal Account Email into the settings
You will need to input the full URL to your donate.php file so that your users can make it back to your site after payment
You will need to input the full URL to your ppverify.php file so that Paypal can send your IPNs to you and your system can process the information and give your users credit for the donation

License

Quote:

Originally Posted by Brandon J. Briggs aka. Cloudrunner

As the original author of the Paypal Hacks for vBulletin 3.0.x and 3.5.x I give full authorization to modify, recode, compile and/or reverse engineer the paypal donation hacks to any and all fully licensed members of vBulletin.org. I also give permission to fully distribute any derivative works that are created due to this authorization without need of providing credit or other means of recompense.

I am releasing this authorization in the hopes that someone will be able to carry on the work that was begun.

Final words

You will need to add a link somewhere in your navigation system for vBulletin pointing your users to the donations page (if you installed the vBadvanced Module then you have a link on the home page, but you might want to add one in the nav bar as well), as well as setting up your paypal account to give IPN responses to you, you can do this in your Paypal Profile under Instant Payment Notification.

To play in PayPal's Sandbox you will need to be registered with their developer network and setup a few sandbox accounts to play with the sandbox properly. I have throughly tested the sandbox functionality, and it is working until they decide to change coding standards again.

I sincerely hope that you enjoy this hack, Please feel free to send feedback to tnp@noblepagan.com !

Thank you!

)O( Cloudrunner )O(

P.s. Should you feel the need to donate to me in thanks, I will not stop you

, in fact I will say thank you and that your support is greatly appreciated. If you do donate to me for this hack, I will give the recognition here as well as on The Noble Pagan. You can find my donations page here (also works as a demo site should you feel the need to check it out):

The Noble Pagan Donation Page

sinisterpain · #**1292** 12-06-2006, 09:18 PM

Quote:

Originally Posted by smoknz28

There have been some thoughts from my members on the issue of showing who has donated and the amounts... Their thoughts are that showing who and how much was donated by the members could cause issues. Where those members think they are above the moderators and can disregard rules, etc. Or, those who have given more than others may tend to think they can get away with more than others who have given less or none at all.

Is there any way we can show just those who have given without the amount donated? Then, is there a way we can show just the amount donated, but without the member's name?

Also, I still can't get mine to display who have paid through PayPal....when a member goes into PayPal and donates....I get an email from PayPal alerting me that someone has donated....but this hack is not grabbing that info.

I know the hack grabs that info because mine works just fine.

Please check in your admin cp=>Paypal Donationsfor the following:
1. View all Valid transactions. Is the name listed there.
2. If yes to the above, check your donation settings and make sure you have show donors selected yes.
3. If the answer is no to the above, make sure in your donation settings that you have the url to the ppverify file. You must also have a paypal business account, have turned on IPN in your Paypal account withe the url to your site.

4. Ensure that you have uploaded all the files for this hack to your webserver and to the correct directories. I believe the alldonors.php file on your webserver outputs to the donation_all_donors and donation_all_donors_bits templates.

Lastly, if you do not wish to show who has donated and how much do not activate the show donors but if you make the required template edits to your postbit and member info templates you can show a donor button in their post and user cp.

smoknz28 · #**1293** 12-06-2006, 11:51 PM

Quote:

Originally Posted by sinisterpain

Please check in your admin cp=>Paypal Donations for the following:
1. View all Valid transactions. Is the name listed there.

No.

Quote:

Originally Posted by sinisterpain

2. If yes to the above, check your donation settings and make sure you have show donors selected yes.

I turned it off today as I was testing some other features, but is back on.

Quote:

Originally Posted by sinisterpain

3. If the answer is no to the above, make sure in your donation settings that you have the url to the ppverify file. You must also have a paypal business account, have turned on IPN in your Paypal account withe the url to your site.

Yes, the url to ppverify.php is correct. I have a Premiere Account and have IPN turned on...however, you told me previously to not put a url in the setting with PayPal's IPN. So, it already was enabled, but not pointing to a notification URL. If I am to point PayPal's IPN Notification URL to my site...would I use my forums url: http://www.f-bodyhideout.com/forums or does this notification URL need to point elsewhere on my server?

Quote:

Originally Posted by sinisterpain

4. Ensure that you have uploaded all the files for this hack to your webserver and to the correct directories. I believe the alldonors.php file on your webserver outputs to the donation_all_donors and donation_all_donors_bits templates.

Yes, they are in the correct locations.

sinisterpain · #**1294** 12-07-2006, 12:21 AM

Quote:

Yes, the url to ppverify.php is correct. I have a Premiere Account and have IPN turned on...however, you told me previously to not put a url in the setting with PayPal's IPN. So, it already was enabled, but not pointing to a notification URL. If I am to point PayPal's IPN Notification URL to my site...would I use my forums url: http://www.f-bodyhideout.com/forums or does this notification URL need to point elsewhere on my server?

I believe you misunderstood, you do not have to point to the ppverify file but you need to put the URL of your site ie.. http://www.f-bodyhideout.com.
What I did on our site was point directly to the ppverify.PHP file its not required just what i did. So in that case you could put http://www.f-bodyhideout.com/forums/ppverify.php. Up to you.

smoknz28 · #**1295** 12-07-2006, 12:25 AM

Yea, I definitely misunderstood you.... I went in to PayPal and set it to ppverify.php just in case.

I'll report back to let you know if it worked this round.

Thanks

Dead-Meat · #**1296** 12-07-2006, 01:22 PM

I'm trying to get something to work in PayPal Donations 2.0.2, Paypal Donations For vBulletin 3.5.
I've been looking at the php codes from the alldonators.php and created a new php file which I am showing through an iframe.

I want to show all donators from the current month and not as it is doing now, from all months. I'm redoing the php file to get the data from the paypalipn table, because that one inserts a date of transaction which I can use.

What I need is a way to compair the current month with the month that is stored in the payment_date table. The type of the table is varchar instead of datetime and looks like this: 12:00:00 November 25 2006 PST. I managed to bring this date back to the three letters of the month, but I can't figure out how to only show those results that match the current month. Any help is greatly appreciated.

This is the php code that I created now. (There's probably a lot left from the alldonators.php code that isn't needed, but it currently gets half the job done).

PHP Code:


			
<?

/*======================================================================*\

|| #################################################################### ||

|| # Paypal Donations for vBulletin 3.5 - Version 2.00                # ||

|| # ---------------------------------------------------------------- # ||

|| # Copyright ?2005 The Noble Pagan, Inc. All Rights Reserved.       # ||

|| # This file may not be redistributed in whole or significant part. # ||

|| # ---------------------------------------------------------------- # ||

|| # This Addon Contributed by DSBoyce8624                            # ||

|| # ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # ||

|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html # ||

|| # ---------------------------------------------------------------- # ||

|| #################################################################### ||

\*======================================================================*/







// ######################### REQUIRE BACK-END ############################

require_once('./global.php');



$month = date("M");



echo "<link href="donors.css" rel="stylesheet" type="text/css">";

echo "<center><table>";

echo "<tr><td colspan=2 align=center><a href="forums/alldonors.php" target="_top">Our Donators</a></td></tr>";



// #######################################################################

// ######################## START MAIN SCRIPT ############################

// #######################################################################



// ###### Show All Donors ######

$query = $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."donation_paypalipn WHERE userid != '0' AND valid != '0' ORDER BY mc_gross DESC");

$num = $vbulletin->db->num_rows($query);

$pic='';

$i = 1;

$p = 1;

while ($row = $vbulletin->db->fetch_array($query)){

    $avatar_row = $vbulletin->db->query_first("SELECT user.showdonor, user.username, user.avatarid, user.avatarrevision, avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar, customavatar.dateline AS avatardateline

                                                                            FROM ".TABLE_PREFIX."user AS user

                                                                            LEFT JOIN ".TABLE_PREFIX."avatar AS avatar ON(avatar.avatarid = user.avatarid)

                                                                            LEFT JOIN ".TABLE_PREFIX."customavatar AS customavatar ON(customavatar.userid = user.userid)

                                                                            WHERE user.userid = '".$row['userid']."'");

                    

    if ($avatar_row['avatarid']){

        $avatarurl = $avatar_row['avatarpath'];

    } else {

        if ($avatar_row['hascustomavatar']){

            if ($vbulletin->options['usefileavatar']){

                $avatarurl = $vbulletin->options['avatarurl']."/avatar".$row['userid']."_".$avatar_row['avatarrevision'].".gif";

            } else {

                $avatarurl = "image.php?".$session['sessionurl']."u=".$row['userid']."&amp;dateline=".$avatar_row['avatardateline'];

            }

        } else {

            $avatarurl = '';

        }

    }

    $userid = $row['userid'];

    $avatar = '<img src="'.$avatarurl.'" border="0">';

    $username = stripslashes($avatar_row['username']);

    $show_as_donor = $avatar_row['showdonor'];

    $total = number_format($row['mc_gross'], 2, '.', ',');

    $currency = $row['mc_currency'];

    $date = date("M", strtotime($row['payment_date']));

    





echo "<tr><td><font size="1">$username</font></td><td><font size="1">$total $currency $month $date</font></td></tr>";

}

{

echo "</table></center>";

}

/*======================================================================*\

|| #################################################################### ||

|| # alldonors -- Fileversion 2.00                                    # ||

|| # Date Version Finalized -- 03 July 2005                           # ||

|| #################################################################### ||

\*======================================================================*/

?>

This is what it outputs now:

Trana · #**1297** 12-07-2006, 02:02 PM

Quote:

Originally Posted by Dead-Meat

php file which I am showing through an iframe.

Avoid iframes at all costs. They will cause you major problems when you try to do anything SEO related. You will find links to the frames themselves in search engines.

Dead-Meat · #**1298** 12-07-2006, 02:21 PM

Quote:

Originally Posted by Trana

Avoid iframes at all costs. They will cause you major problems when you try to do anything SEO related. You will find links to the frames themselves in search engines.

I'd like to do it through a template, but haven't got an idea how to do that yet. Untill then I use iframes

smoknz28 · #**1299** 12-08-2006, 01:28 AM

Mmmm.....no go still... I again reverified that the files were in their correct locations, ensured IPN is on and set to ppverify.php.

Instant Payment Notification (IPN): On
Instant Payment Notification (IPN) URL: http://www.f-bodyhideout.com/forums/ppverify.php

Maybe one of my other hacks are preventing this from working.....?

sinisterpain · #**1300** 12-08-2006, 02:20 AM

Quote:

Originally Posted by smoknz28

Mmmm.....no go still... I again reverified that the files were in their correct locations, ensured IPN is on and set to ppverify.php.

Instant Payment Notification (IPN): On
Instant Payment Notification (IPN) URL: http://www.f-bodyhideout.com/forums/ppverify.php

Maybe one of my other hacks are preventing this from working.....?

Could be wrong but that paypal reminder should not be comming up when you click the donations link. Also if I click on http://www.f-bodyhideout.com/forums/ppverify.php it also comes to that donation reminder. So some how this may be blocking paypal from reading your donations. I also noticed that you do have members and donations dollars showing on your donations page.

smoknz28 · #**1301** 12-08-2006, 02:25 AM

The reminder is another hack....but it's working corectly as no other users have complained. I'm not coming up with the donation reminder.... It's only to come up after every 1 month a user is on the site.

As for the members who are on my donation's page...I had to manually add them however, there are another 5-6 after them that the program again never picked up after they donated.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06087 seconds Memory Usage 2,372KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_php (10)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!