phpBB • Free and Open Source Forum Software

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 (
    'receiver-mail@address.com', /* email of your own PayPal account */
    'donor-mail@address.com',    /* 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',
    ''
);