Hi your extension is amazing really helpful. I have it working great but would like to do one more thing On payment verified I have 3 transactions. On the third transaction which is an insert I would like to insert multiple rows in the table based on the quantity field passed from paypal.
For example if the quanity field passed from paypal is 5 then the transaction would insert 5 times into the tbl_entry (I only want to insert multiple rows on transaction3 this does not work below)
'***************************** ' http://www.dwzone-it.com ' PayPal IPN setup ' Version 1.1.2 '***************************** PayPal_IPN.SetConnection MM_connection_STRING PayPal_IPN.SetPayPalPage "https://www.sandbox.paypal.com/uk/cgi-bin/webscr" PayPal_IPN.SetFieldList "Item_Name;Item_Number;Payment_Status;Mc_Gross;Mc_Currency;Txn_id;Receiver_Email;Payer_Email;first_name;last_name;payer_id;contact_phone;residence_country;quantity;auth_id;auth_exp;auth_status;parent_txn_id;payment_date;exchange_rate;mc_fee" PayPal_IPN.SetLog "true", "paypal-logs" PayPal_IPN.SetMailOnError "[email protected]" PayPal_IPN.SetVerify "false;false;false;false;false", "None;None;None;None;None", "None;None;None;None;None" PayPal_IPN.AddTransaction "Update", "tbl_Cst", "None", "Verified", "None", "Cst_Verified_@@_None_@@_Integer,0_@@_1;_;Cst_Verified_Date_@@_None_@@_MM/DD/YYYY,Null_@@_date()", "cst_ID_@@_PayPal: Item_Number_@@_Numeric,Null_@@__@@_=" PayPal_IPN.AddTransaction "Insert", "tbl_Paypal_Orders", "Paypal_Order_ID", "Verified", "None", "item_number_CstFK_@@_PayPal: Item_Number_@@_Integer,Null_@@_;_;first_name_@@_PayPal: first_name_@@_Text,Null_@@_;_;last_name_@@_PayPal: last_name_@@_Text,Null_@@_;_;payer_id_@@_PayPal: payer_id_@@_Text,Null_@@_;_;payer_email_@@_PayPal: Payer_Email_@@_Text,Null_@@_;_;contact_phone_@@_PayPal: contact_phone_@@_Text,Null_@@_;_;residence_country_@@_PayPal: residence_country_@@_Text,Null_@@_;_;quantity_@@_PayPal: quantity_@@_Integer,Null_@@_;_;auth_id_@@_PayPal: auth_id_@@_Text,Null_@@_;_;auth_exp_@@_PayPal: auth_exp_@@_Text,Null_@@_;_;auth_status_@@_PayPal: auth_status_@@_Text,Null_@@_;_;parent_txn_id_@@_PayPal: parent_txn_id_@@_Text,Null_@@_;_;txn_id_@@_PayPal: Txn_id_@@_Text,Null_@@_;_;payment_date_@@_PayPal: payment_date_@@_Text,Null_@@_;_;exchange_rate_@@_PayPal: exchange_rate_@@_Text,Null_@@_;_;mc_fee_@@_PayPal: mc_fee_@@_Text,Null_@@_;_;mc_gross_@@_PayPal: Mc_Gross_@@_Text,Null_@@_;_;ipn_verified_@@_None_@@_Integer,0_@@_1", ""
VarEntryQuantity = Request.QueryString("quantity") FOR i = 1 to VarEntryQuantity
PayPal_IPN.AddTransaction "Insert", "tbl_Entries", "Entry_ID", "Verified", "None", "Paypal_OrderFK_@@_Transaction(2): Paypal_Order_ID_@@_Integer,Null_@@_", ""
PayPal_IPN ()
next '*****************************
Ignore the paypal_ipn line befire next this forum would not let me post the correct code |
|
|