vb.org Archive - PayPal Donations For vBulletin 3.5.0

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - PayPal Donations For vBulletin 3.5.0 (https://vborg.vbsupport.ru/showthread.php?t=91567)

Quote:

Originally Posted by smoknz28 (Post 1133409)

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.

Quote:

Originally Posted by sinisterpain (Post 1133485)

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 (Post 1133485)

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 (Post 1133485)

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 (Post 1133485)

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.

Quote:

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.

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

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.
http://www.gunnersofwar.com/images/donators.jpg
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:
http://www.gunnersofwar.com/images/donators2.jpg

Quote:

Originally Posted by Dead-Meat (Post 1133841)

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.

Quote:

Originally Posted by Trana (Post 1133863)

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

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.....?

Quote:

Originally Posted by smoknz28 (Post 1134242)

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.

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
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02590 seconds Memory Usage 1,801KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (9)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: