PayPal Donation Extension

Add donors manually - PayPal Donation Extension

Add donors manually

by nudels64 » Wed Oct 31, 2018 9:16 pm

Great ext. Thanks a lot! Can you still create a way to add donors manually?
phpbb 3.2.9 # PHP-Version: 7.0 # Themes: Prosilver and Basic
nudels64
Registered User
Posts: 53
Joined: Mon Oct 24, 2016 9:17 pm
Contact:

Re: Add donors manually

by wraith50 » Wed Nov 28, 2018 3:52 pm

I got this SQL query from my friend Kasimi and works, your donor has to be a member to use "ID"
this will add donor to list with amount, user name and date donated:

Code: Select all

INSERT INTO phpbb_ppde_txn_log (receiver_email, payer_email, residence_country, first_name, last_name, user_id, mc_currency, mc_fee, mc_gross, net_amount, settle_currency, exchange_rate, settle_amount, payment_date, payment_status, payment_type, payer_status, confirmed, txn_id, txn_type, txn_errors) VALUES (
    '[email protected]', /* email of your own PayPal account */
    '[email protected]',    /* PayPal email of donor */
    '',                          /* donor country code */
    '',                          /* donor first name */
    '',                          /* donor last name */
    2583,                           /* donor user id, use 1 for guest donation */
    'GBP',                       /* donor currency */
    '0.00',                      /* fee, probably unknown so leave it at 0 */
    '10.00',                      /* donation amount before fee in donor currency */
    '0.00',                      /* donation amount after fee in donor currency */
    '',                          /* your currency, leave empty if no conversion */
    '',                          /* exchange rate */
    '0.00',                      /* donation amount after exchange rate in your currency */
    UNIX_TIMESTAMP(STR_TO_DATE("2018-11-27 22:40:00", "%Y-%m-%d %H:%i:%s")), /* donation time */
    'Completed',
    'instant', 
    'unverified',
    1,
    'Unknown',
    'web_accept',
    ''
);
wraith50
Registered User
Posts: 9
Joined: Sun Dec 24, 2017 2:37 pm
Contact:

Re: Add donors manually

by nudels64 » Wed Nov 28, 2018 4:00 pm

That's a great idea. I still need an interface to do this, because the Moderators don't have Access to the SQL Database.
phpbb 3.2.9 # PHP-Version: 7.0 # Themes: Prosilver and Basic
nudels64
Registered User
Posts: 53
Joined: Mon Oct 24, 2016 9:17 pm
Contact:

Re: Add donors manually

by Skouat » Sat May 25, 2019 10:07 pm

Hi there,

This feature is available on PPDE 2.1.0. ;)
Skouat
Code Contributor
Posts: 1038
Joined: Mon Mar 10, 2008 5:30 pm
Location: France
Contact:

Re: Add donors manually

by Raul [ThE KuKa] » Sun May 26, 2019 8:21 am

Hello Skouat,

I can not see the option, I'm lost. :oops: :roll:
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies | Styles Queue Stats :warning:


If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate.
:flag_es: phpBB Spain - Online Since 2003 :heart:


User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 11073
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact:

Re: Add donors manually

by Skouat » Sun May 26, 2019 8:34 am

This is not a dedicated module.
Take a look in the Transaction log. You will find a button. ;)
Skouat
Code Contributor
Posts: 1038
Joined: Mon Mar 10, 2008 5:30 pm
Location: France
Contact:

Re: Add donors manually

by Raul [ThE KuKa] » Sun May 26, 2019 8:51 am

I don't see button:

Image

Permissions problems maybe?
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies | Styles Queue Stats :warning:


If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate.
:flag_es: phpBB Spain - Online Since 2003 :heart:


User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 11073
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact:

Re: Add donors manually

by Skouat » Sun May 26, 2019 9:27 am

Damn! It works only if you have at least one transaction in the log -_-
Skouat
Code Contributor
Posts: 1038
Joined: Mon Mar 10, 2008 5:30 pm
Location: France
Contact:

Re: Add donors manually

by Raul [ThE KuKa] » Sun May 26, 2019 9:33 am

New revision time... :P LOL

Sorry for LOL.

Really nice extension Skouat.

And sorry for this report. ;)
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies | Styles Queue Stats :warning:


If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate.
:flag_es: phpBB Spain - Online Since 2003 :heart:


User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 11073
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact:

Re: Add donors manually

by Skouat » Sun May 26, 2019 9:56 am

Is it a good idea if I say that it's Kasimi who implemented this feature. :roll: :mrgreen: :lol:

issue fixed... I'll send a new release.
Thanks for this bug report
Skouat
Code Contributor
Posts: 1038
Joined: Mon Mar 10, 2008 5:30 pm
Location: France
Contact:

Re: Add donors manually

by Raul [ThE KuKa] » Sun May 26, 2019 10:00 am

I testing this

Nice job, and again, nice extension. ;)
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies | Styles Queue Stats :warning:


If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate.
:flag_es: phpBB Spain - Online Since 2003 :heart:


User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 11073
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact:

Re: Add donors manually

by Skouat » Sun May 26, 2019 10:38 am

New release submitted in the DB 8-)
Skouat
Code Contributor
Posts: 1038
Joined: Mon Mar 10, 2008 5:30 pm
Location: France
Contact:

Re: Add donors manually

by Raul [ThE KuKa] » Sun May 26, 2019 10:52 am

Perfect :beer:
All unsolicited PMs will be ignored.
:warning: Knowledge Base | Documentation | Board rules | phpBB Styles Rules & Policies | Styles Queue Stats :warning:


If you like my styles, translations, etc. and want to show some appreciation, then feel free to Donate.
:flag_es: phpBB Spain - Online Since 2003 :heart:


User avatar
Raul [ThE KuKa]
Style Customisations
Style Customisations
Posts: 11073
Joined: Mon Dec 08, 2003 9:24 pm
Location: Spain
Name: Raul Arroyo
Contact: