vb.org Archive - Paypal Donations (With Instant Payment Notification) -- RC1 (Public Testing)

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

- vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)

- - Paypal Donations (With Instant Payment Notification) -- RC1 (Public Testing) (https://vborg.vbsupport.ru/showthread.php?t=54436)

Quote:

Yesterday at 05:58 AM Cloudrunner said this in Post #44
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:

PHP Code:

  $DB_site->query("INSERT INTO paypal_donatebuttons (id,                                                      business,                                                      item_name,

Replace that entire query with this:

PHP Code:

  $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:

PHP Code:

$DB_site->query("UPDATE paypal_donatebuttons SET business = '"

and replace that entire query with this:

PHP Code:

  $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 before

PHP Code:

echo "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

Quote:

Today at 01:12 AM Cloudrunner said this in Post #50
Crazy Pete--

Both database errors were addressed already ;)

https://vborg.vbsupport.ru/showthrea...663#post411663

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

https://vborg.vbsupport.ru/showthrea...680#post411680

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

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 ;)

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(

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.

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(

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(

Thanks very much you guys! It's nice to see a really well thought-out hack with such great support for it.

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(

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:

Code:

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?

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_code_printable (5)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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.01422 seconds Memory Usage 1,806KB 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_code_printable (5)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)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: