DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
PayPal IPN  
DwZone Forum Index -> PayPal IPN

Moderators: AdministratorsModerators 
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 11 to 20 of 76 (Total: 29) First |  Prev |  Next |  Last  
 Subject Author Date  
   Re: IPN send email  
View this persons public profile  Gary   9:29 9 Sep 2011  
   Re: IPN send email  
View this persons public profile  Gianluigi   9:41 9 Sep 2011  
   XMLHTTP error on new server  
View this persons public profile  [email protected]   3:43 9 Nov 2008  
   Re:XMLHTTP error on new server  
View this persons public profile  gianluigi   7:39 9 Nov 2008  
    multiple row insert?  
View this persons public profile  [email protected]   13:33 25 Oct 2008  
 
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
 
Reply to this current thread  View this persons public profile  Send Private Message
   Re:multiple row insert?  
View this persons public profile  gianluigi   15:53 25 Oct 2008  
   Re:multiple row insert?  
View this persons public profile  [email protected]   5:01 29 Oct 2008  
   Brilliant extension  
View this persons public profile  [email protected]   10:27 22 Oct 2008  
   Help with Database Update  
View this persons public profile  [email protected]   4:13 28 Jan 2008  
   Re:Help with Database Update  
View this persons public profile  gianluigi   11:47 28 Jan 2008  
Last Visit: Thursday 28 Mar, 2024 8:48 pm First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-1

Jump to: