******************************** Array ( [transaction_subject] => [payment_date] => 23:54:37 Mar 26, 2017 PDT [txn_type] => web_accept [last_name] => Katalin [residence_country] => CY [item_name] => Testing D [payment_gross] => [mc_currency] => GBP [business] => basharatb@hotmail.com [payment_type] => instant [protection_eligibility] => Ineligible [verify_sign] => A0.bfoEkDwQi-mOWflXZGoy5EOyyAifuL2VztzMBo1DKM79RRumgXkgN [payer_status] => unverified [payer_email] => sarikatalin31@gmail.com [txn_id] => 0KR61350EK680240S [quantity] => 1 [receiver_email] => basharatb@hotmail.com [first_name] => Sari [invoice] => 6 [payer_id] => QJQ77DTXRS9A6 [receiver_id] => 5MFGNNYYTYAXY [item_number] => [payment_status] => Completed [payment_fee] => [mc_fee] => 0.24 [mc_gross] => 0.99 [custom] => [charset] => windows-1252 [notify_version] => 3.8 [ipn_track_id] => 75937116dc1 ) Verified select * from orders where id='6' and ipn_id='0KR61350EK680240S,75937116dc1' and pay_status='1' limit 1 update orders set ipn_id='0KR61350EK680240S,75937116dc1', pay_status='1' where id='6' limit 1 Updated ******************************** Array ( [mc_gross] => 3.20 [invoice] => 13 [protection_eligibility] => Ineligible [payer_id] => TYPJKHJ2JLZTJ [payment_date] => 09:32:08 Jul 22, 2018 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Farah [mc_fee] => 0.31 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AY3oEML8OZxDGLB9TEOsnsrU.-BpA5VpDoJFURq4JjDH0FNtUtNxFDUJ [payer_email] => everontradingltd@hotmail.com [txn_id] => 45K832377K718283X [payment_type] => instant [payer_business_name] => Everon Trading Ltd [last_name] => Latif [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 954c259774e3c ) Verified select * from orders where id='13' and ipn_id='45K832377K718283X,954c259774e3c' and pay_status='1' limit 1 update orders set ipn_id='45K832377K718283X,954c259774e3c', pay_status='1' where id='13' limit 1 Updated ******************************** Array ( [mc_gross] => 341.25 [invoice] => 14 [protection_eligibility] => Ineligible [payer_id] => 2B27W745XX34A [payment_date] => 09:22:38 Aug 22, 2018 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Sam [mc_fee] => 11.80 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => A4oXaJGYI0RmM8PSoZ4Bgr5wsoMlA8ZbayYp2H9VKX0i6gci24bgjsJI [payer_email] => nicholascornelious@hotmail.com [txn_id] => 9X887886HY960233K [payment_type] => instant [last_name] => Whitlock [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 7bf495715787b ) Verified select * from orders where id='14' and ipn_id='9X887886HY960233K,7bf495715787b' and pay_status='1' limit 1 update orders set ipn_id='9X887886HY960233K,7bf495715787b', pay_status='1' where id='14' limit 1 Updated ******************************** Array ( [mc_gross] => 262.50 [invoice] => 15 [protection_eligibility] => Ineligible [payer_id] => 77S3AWWJD749A [payment_date] => 03:54:44 Sep 19, 2018 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Sam [mc_fee] => 9.13 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => ALaXlqFSSQOFH1oNAq9k3AEqrvucAnNvtXo3HJ5PatzAFpbo9p4iVfOk [payer_email] => sales@stylecreep.com [txn_id] => 1S735472R5290624L [payment_type] => instant [payer_business_name] => Stylecreep Limited [last_name] => Whitlock [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => fad726f893574 ) Verified select * from orders where id='15' and ipn_id='1S735472R5290624L,fad726f893574' and pay_status='1' limit 1 update orders set ipn_id='1S735472R5290624L,fad726f893574', pay_status='1' where id='15' limit 1 Updated ******************************** Array ( [mc_gross] => 10.32 [invoice] => 19 [protection_eligibility] => Ineligible [payer_id] => VSCAM3Z759CN2 [payment_date] => 06:04:47 Jun 04, 2019 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Paula [mc_fee] => 0.55 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => Aro-EnMEw3wy9N3xh8fDDwfCni04APWPy06bUnsxvBTW3BbX710W..pg [payer_email] => paulatromans@btinternet.com [txn_id] => 3N30689089445651A [payment_type] => instant [last_name] => Tromans [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => d074d672a115a ) Verified select * from orders where id='19' and ipn_id='3N30689089445651A,d074d672a115a' and pay_status='1' limit 1 update orders set ipn_id='3N30689089445651A,d074d672a115a', pay_status='1' where id='19' limit 1 Updated ******************************** Array ( [mc_gross] => 15.99 [invoice] => 22 [protection_eligibility] => Ineligible [payer_id] => K29D5MTLGHPRY [payment_date] => 07:47:25 Oct 19, 2019 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => T [mc_fee] => 0.76 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AUkB1L6goQRF46t52j8OfdVmfMssAIrjpKXrn.IjcG3zf3NEYODWnAoH [payer_email] => trattigan79@gmail.com [txn_id] => 6D903499S7419424G [payment_type] => instant [last_name] => RATTIGAN [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0575-5258-3596-9008 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 5bda496e98505 ) Verified select * from orders where id='22' and ipn_id='6D903499S7419424G,5bda496e98505' and pay_status='1' limit 1 update orders set ipn_id='6D903499S7419424G,5bda496e98505', pay_status='1' where id='22' limit 1 Updated ******************************** Array ( [mc_gross] => 19.99 [invoice] => 23 [protection_eligibility] => Ineligible [payer_id] => NUM9UH5ANJPD2 [payment_date] => 04:43:00 Oct 24, 2019 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Jayne [mc_fee] => 0.88 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AJwCsbUzqHOJEvmMk1tFh-CwgusUANFXtwagm1aEl-g5DaCTlgIqfFrX [payer_email] => rhodesjayne@hotmail.com [txn_id] => 1XX256811L1108732 [payment_type] => instant [last_name] => Rhodes [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => d83387311f153 ) Verified select * from orders where id='23' and ipn_id='1XX256811L1108732,d83387311f153' and pay_status='1' limit 1 update orders set ipn_id='1XX256811L1108732,d83387311f153', pay_status='1' where id='23' limit 1 Updated ******************************** Array ( [txn_type] => new_case [payment_date] => 04:43:00 Oct 24, 2019 PDT [case_id] => PP-D-45440328 [case_type] => dispute [business] => basharatb@hotmail.com [verify_sign] => A5aMk4NIQRh7jsdJvAVVCVqfUsLuA09gYBvbhxEeby34uxEnw1iFZ-Lp [payer_email] => rhodesjayne@hotmail.com [txn_id] => 1XX256811L1108732 [case_creation_date] => 04:58:59 Nov 08, 2019 PST [receiver_email] => basharatb@hotmail.com [payer_id] => NUM9UH5ANJPD2 [invoice] => 23 [receiver_id] => 5MFGNNYYTYAXY [reason_code] => non_receipt [custom] => [charset] => windows-1252 [notify_version] => 3.9 [ipn_track_id] => cc50b7d91e77d ) Verified ******************************** Array ( [mc_gross] => 13.45 [invoice] => 25 [protection_eligibility] => Ineligible [payer_id] => QGTW369KK4KQ6 [payment_date] => 00:14:31 Dec 24, 2019 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Helen [mc_fee] => 0.69 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => A0vzuRF9aPflnHq-U5s13XYUHvixAjtWMD7Kf97pIVTYR2sBBqYbu7j3 [payer_email] => helenlhowell@btinternet.com [txn_id] => 5V07756008324170Y [payment_type] => instant [last_name] => Howell [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => multi aperture frame of 9 x 6x4" photo windows in oak [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => ab4eb44402691 ) Verified select * from orders where id='25' and ipn_id='5V07756008324170Y,ab4eb44402691' and pay_status='1' limit 1 update orders set ipn_id='5V07756008324170Y,ab4eb44402691', pay_status='1' where id='25' limit 1 Updated ******************************** Array ( [txn_type] => new_case [payment_date] => 00:14:31 Dec 24, 2019 PST [case_id] => PP-D-51297909 [case_type] => dispute [business] => basharatb@hotmail.com [verify_sign] => AMI6sK1Qf.Tu20KfZRDEuHqXKHqeAoTDVf58FJvvelwUQl93s8uktdef [payer_email] => helenlhowell@btinternet.com [txn_id] => 5V07756008324170Y [case_creation_date] => 03:23:57 Jan 04, 2020 PST [receiver_email] => basharatb@hotmail.com [payer_id] => QGTW369KK4KQ6 [invoice] => 25 [receiver_id] => 5MFGNNYYTYAXY [reason_code] => non_receipt [custom] => [charset] => windows-1252 [notify_version] => 3.9 [ipn_track_id] => 9b07948ef870d ) Verified ******************************** Array ( [mc_gross] => -13.45 [invoice] => 25 [protection_eligibility] => Ineligible [payer_id] => QGTW369KK4KQ6 [payment_date] => 04:39:05 Jan 16, 2020 PST [payment_status] => Reversed [charset] => windows-1252 [first_name] => Helen [mc_fee] => 0.00 [notify_version] => 3.9 [reason_code] => buyer_complaint [custom] => [business] => basharatb@hotmail.com [verify_sign] => A614me5WYVfxoYVlbKwnuOCoyzW-AUTJ-qkwHEp4EjiH-22HX6OYnDFy [payer_email] => helenlhowell@btinternet.com [parent_txn_id] => 5V07756008324170Y [txn_id] => 1VN09033RU077005J [payment_type] => instant [last_name] => Howell [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [item_name] => multi aperture frame of 9 x 6x4" photo windows in oak [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [handling_amount] => 0.00 [shipping_method] => Default [transaction_subject] => [payment_gross] => [shipping] => 0.00 [ipn_track_id] => 4a07844748151 ) Verified ******************************** Array ( [mc_gross] => 40.99 [invoice] => 27 [protection_eligibility] => Ineligible [payer_id] => ZQCQRTCACNZME [payment_date] => 01:41:48 Jan 27, 2020 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Georgina [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AjY0YZZ6HXCnJOjAQTwGWP6Y0ZhYA6f4edVqrv7-4bEh3SK991QXnTAg [payer_email] => gelliottdew@mulberrybush.org.uk [txn_id] => 5136463944214560M [payment_type] => instant [last_name] => Elliott-Dew [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frame [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 5f0f78749a7a9 ) Verified select * from orders where id='27' and ipn_id='5136463944214560M,5f0f78749a7a9' and pay_status='1' limit 1 update orders set ipn_id='5136463944214560M,5f0f78749a7a9', pay_status='1' where id='27' limit 1 Updated ******************************** Array ( [mc_gross] => 10.32 [invoice] => 32 [protection_eligibility] => Ineligible [payer_id] => LRRHLTG8E5GFC [payment_date] => 05:30:48 Feb 17, 2020 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Sadie [mc_fee] => 0.60 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AOeJqGRMALOM2h4zqenEorGhsFOVA4JmDH.epMfULI1pZrsZqMBBfkIq [payer_email] => wintosadie@hotmail.co.uk [txn_id] => 16T76334JV5833734 [payment_type] => instant [last_name] => Winterbottom [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 2612-4748-0289-7085 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 7d97516ce1aa4 ) Verified select * from orders where id='32' and ipn_id='16T76334JV5833734,7d97516ce1aa4' and pay_status='1' limit 1 update orders set ipn_id='16T76334JV5833734,7d97516ce1aa4', pay_status='1' where id='32' limit 1 Updated ******************************** Array ( [mc_gross] => 18.99 [invoice] => 39 [protection_eligibility] => Ineligible [payer_id] => PB4HD2WQ43CRJ [payment_date] => 13:56:39 Mar 04, 2020 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Lucy [mc_fee] => 0.85 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => Ae3F2Jd1MXMweRq2ykW9X5Hi8Nj7A6BpwVhesH8o-F6wKwJTZWkZ2W9y [payer_email] => loopy_lou760@hotmail.com [txn_id] => 4L764570D2717294S [payment_type] => instant [last_name] => Evans [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 0041a9a912460 ) Verified select * from orders where id='39' and ipn_id='4L764570D2717294S,0041a9a912460' and pay_status='1' limit 1 update orders set ipn_id='4L764570D2717294S,0041a9a912460', pay_status='1' where id='39' limit 1 Updated ******************************** Array ( [mc_gross] => 12.99 [invoice] => 41 [protection_eligibility] => Ineligible [payer_id] => NUP3DB4M647CA [payment_date] => 09:07:59 Mar 13, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Tony [mc_fee] => 0.68 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AJm0f3fc2VTb.LWyMH3Fm0DrSa37Afy4ACJRetHNAvD2.QFPEBMrj3sQ [payer_email] => ajman@waitrose.com [txn_id] => 2BY08547XH6062233 [payment_type] => instant [last_name] => Manser [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a8621d9d64db0 ) Verified select * from orders where id='41' and ipn_id='2BY08547XH6062233,a8621d9d64db0' and pay_status='1' limit 1 update orders set ipn_id='2BY08547XH6062233,a8621d9d64db0', pay_status='1' where id='41' limit 1 Updated ******************************** Array ( [txn_type] => new_case [payment_date] => 13:56:39 Mar 04, 2020 PST [case_id] => PP-D-58869614 [case_type] => dispute [business] => basharatb@hotmail.com [verify_sign] => A47YG2lhjcjjXBogf1emesliUQn5A-gkBwUwwVHItsCVJIDMId17x2ag [payer_email] => loopy_lou760@hotmail.com [txn_id] => 4L764570D2717294S [case_creation_date] => 06:50:40 Mar 18, 2020 PDT [receiver_email] => basharatb@hotmail.com [payer_id] => PB4HD2WQ43CRJ [invoice] => 39 [receiver_id] => 5MFGNNYYTYAXY [reason_code] => non_receipt [custom] => [charset] => windows-1252 [notify_version] => 3.9 [ipn_track_id] => 00a537bb6758d ) Verified ******************************** Array ( [mc_gross] => -18.99 [invoice] => 39 [protection_eligibility] => Ineligible [payer_id] => PB4HD2WQ43CRJ [payment_date] => 08:01:06 Apr 23, 2020 PDT [payment_status] => Reversed [charset] => windows-1252 [first_name] => Lucy [mc_fee] => 0.00 [notify_version] => 3.9 [reason_code] => buyer_complaint [custom] => [business] => basharatb@hotmail.com [verify_sign] => ASwtEnW3.Gk1S4djLRLBZtTlMKQmAm4Xrtad4QKKY5O7wfBacDz6dsxF [payer_email] => loopy_lou760@hotmail.com [parent_txn_id] => 4L764570D2717294S [txn_id] => 7FE0183803558363Y [payment_type] => instant [last_name] => Evans [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [handling_amount] => 0.00 [shipping_method] => Default [transaction_subject] => [payment_gross] => [shipping] => 0.00 [ipn_track_id] => 678211f2abc2c ) Verified ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 update orders set ipn_id='28452544AE6159232,a341c1dcbdadc', pay_status='1' where id='46' limit 1 Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 63.96 [invoice] => 46 [protection_eligibility] => Eligible [payer_id] => 54XYMZJFC9LMA [payment_date] => 05:27:16 Apr 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louise [mc_fee] => 2.15 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhsfYetqmWXbvm8u5UC00Hk5QczQATBy1K73Ct8qlRFxs3riQ0Yj0g9v [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [payment_type] => instant [last_name] => Bailey [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frames [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a341c1dcbdadc ) Verified select * from orders where id='46' and ipn_id='28452544AE6159232,a341c1dcbdadc' and pay_status='1' limit 1 Already Updated ******************************** Array ( [txn_type] => new_case [payment_date] => 05:27:16 Apr 28, 2020 PDT [case_id] => PP-D-66933666 [case_type] => dispute [business] => basharatb@hotmail.com [verify_sign] => ATIlQ7tEOW5YtD8.I9vCEytFm..SA271prFJ0opsjvyoX48YDlSiz0gJ [payer_email] => baileylouise527@gmail.com [txn_id] => 28452544AE6159232 [case_creation_date] => 01:56:16 May 19, 2020 PDT [receiver_email] => basharatb@hotmail.com [payer_id] => 54XYMZJFC9LMA [invoice] => 46 [receiver_id] => 5MFGNNYYTYAXY [reason_code] => non_receipt [custom] => [charset] => windows-1252 [notify_version] => 3.9 [ipn_track_id] => 34c41b8e65baf ) Verified ******************************** Array ( [mc_gross] => 16.40 [invoice] => 52 [protection_eligibility] => Eligible [payer_id] => T7LR2U8SY6H2Y [payment_date] => 01:40:21 May 28, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => terence [mc_fee] => 0.78 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AhKL7aX5OWXTsvRJ6EeZ39vLlCv2AfA2ef6FOEFq2beHckAaw-yMfsKc [payer_email] => telboy776@gmail.com [txn_id] => 3L711400316752334 [payment_type] => instant [last_name] => mclaren [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => e1c3bc01ca652 ) Verified select * from orders where id='52' and ipn_id='3L711400316752334,e1c3bc01ca652' and pay_status='1' limit 1 update orders set ipn_id='3L711400316752334,e1c3bc01ca652', pay_status='1' where id='52' limit 1 Updated ******************************** Array ( [mc_gross] => 40.99 [invoice] => 58 [protection_eligibility] => Eligible [payer_id] => G866J7VLTNH8Y [payment_date] => 07:59:02 Jun 17, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Richard [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => A4u3fYmtnCkNw2A1QMBR8xbl1c9eAy2wANE-zW3Fq.ywiQB1AsT.oq1B [payer_email] => rapg1000@hotmail.com [txn_id] => 1GL65819KJ243051N [payment_type] => instant [last_name] => Green [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 4ffadec8e62ea ) Verified select * from orders where id='58' and ipn_id='1GL65819KJ243051N,4ffadec8e62ea' and pay_status='1' limit 1 update orders set ipn_id='1GL65819KJ243051N,4ffadec8e62ea', pay_status='1' where id='58' limit 1 Updated ******************************** Array ( [mc_gross] => 9.82 [invoice] => 66 [protection_eligibility] => Eligible [payer_id] => TAV84UYB7SKTN [payment_date] => 06:44:40 Jul 21, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Claire [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AzpQSvNytccTunMfYwA2c7PT9l80AN1pJ5fLWxdBB0yn1PVhoi3Kfqqi [payer_email] => clairemcallister@msn.com [txn_id] => 6DG42565TJ2812209 [payment_type] => instant [last_name] => McAllister [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frame [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 12f9bd2c8434d ) Verified select * from orders where id='66' and ipn_id='6DG42565TJ2812209,12f9bd2c8434d' and pay_status='1' limit 1 update orders set ipn_id='6DG42565TJ2812209,12f9bd2c8434d', pay_status='1' where id='66' limit 1 Updated ******************************** Array ( [mc_gross] => 13.45 [invoice] => 67 [protection_eligibility] => Eligible [payer_id] => C58ZQDVK4BBLU [payment_date] => 08:57:56 Aug 03, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Sarah [mc_fee] => 0.69 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => Aj7PqGjr2jucZNqGJiUUoEYgrw..A0vsWc0s82TuEV9I917Rcx.13QGl [payer_email] => sarahjcaine@sky.com [txn_id] => 2VL47711C7559831E [payment_type] => instant [last_name] => Caine [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 44cccb353c3e ) Verified select * from orders where id='67' and ipn_id='2VL47711C7559831E,44cccb353c3e' and pay_status='1' limit 1 update orders set ipn_id='2VL47711C7559831E,44cccb353c3e', pay_status='1' where id='67' limit 1 Updated ******************************** Array ( [mc_gross] => 18.99 [invoice] => 70 [protection_eligibility] => Eligible [payer_id] => GW6GT9DHZXP7W [payment_date] => 09:19:34 Aug 30, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Ryan [mc_fee] => 0.85 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => Aie4CM43uPj-PyX3MYQGxCsvcAbYAeTmwfLNuowYUFjxZfadsO0oJ1QG [payer_email] => ryangray15@hotmail.co.uk [txn_id] => 6A3517659G921303C [payment_type] => instant [last_name] => Gray [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => fae100570d46e ) Verified select * from orders where id='70' and ipn_id='6A3517659G921303C,fae100570d46e' and pay_status='1' limit 1 update orders set ipn_id='6A3517659G921303C,fae100570d46e', pay_status='1' where id='70' limit 1 Updated ******************************** Array ( [mc_gross] => 13.45 [invoice] => 71 [protection_eligibility] => Eligible [payer_id] => KZ7ZSWCHBCUHG [payment_date] => 03:10:34 Sep 12, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Jacalyn [mc_fee] => 0.69 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => Ah-ySHtOuCYqoO.0ICmhoFVnyJ8YA2AhpiciDoLNaCkn03EYQ9IsHA3H [payer_email] => jackie@finetimber.com [txn_id] => 3T0468708G037153M [payment_type] => instant [last_name] => Hopkins [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 1b3b89a38c434 ) Verified select * from orders where id='71' and ipn_id='3T0468708G037153M,1b3b89a38c434' and pay_status='1' limit 1 update orders set ipn_id='3T0468708G037153M,1b3b89a38c434', pay_status='1' where id='71' limit 1 Updated ******************************** Array ( [mc_gross] => 40.99 [invoice] => 72 [protection_eligibility] => Eligible [payer_id] => V9CFKFEV8B27Y [payment_date] => 13:36:04 Sep 13, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Vera [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => A38twiByEFj-dfUJEaiQ.KBopw.WAGss2X4xyePSGec9B3PmaVxaSNkX [payer_email] => shhawtyy28@hotmail.com [txn_id] => 06P692095R957570E [payment_type] => instant [last_name] => Segu [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Picture frame [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 230153fe4fbb9 ) Verified select * from orders where id='72' and ipn_id='06P692095R957570E,230153fe4fbb9' and pay_status='1' limit 1 update orders set ipn_id='06P692095R957570E,230153fe4fbb9', pay_status='1' where id='72' limit 1 Updated ******************************** Array ( [mc_gross] => 40.99 [invoice] => 73 [protection_eligibility] => Eligible [payer_id] => 9256D5UYQLGZW [payment_date] => 08:06:57 Sep 16, 2020 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Louis [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => A2dz2w0hGS2TibNPSRBSviJXON.KArOW7P5p9O73zAySQmWTW5QCuGaW [payer_email] => lcutner@me.com [txn_id] => 5XU08356S7286824T [payment_type] => instant [last_name] => Cutner [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frame [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 49bf3c3ef6d3f ) Verified select * from orders where id='73' and ipn_id='5XU08356S7286824T,49bf3c3ef6d3f' and pay_status='1' limit 1 update orders set ipn_id='5XU08356S7286824T,49bf3c3ef6d3f', pay_status='1' where id='73' limit 1 Updated ******************************** Array ( [txn_type] => new_case [payment_date] => 03:10:34 Sep 12, 2020 PDT [case_id] => PP-D-84528293 [case_type] => dispute [business] => basharatb@hotmail.com [verify_sign] => Aclg2ZaXTHj3H2BdktEcoay6gl21AIzD8ibqH.bXw9jWOuoJHv8fZPoU [payer_email] => jackie@finetimber.com [txn_id] => 3T0468708G037153M [case_creation_date] => 03:35:15 Sep 17, 2020 PDT [receiver_email] => basharatb@hotmail.com [payer_id] => KZ7ZSWCHBCUHG [invoice] => 71 [receiver_id] => 5MFGNNYYTYAXY [reason_code] => non_receipt [custom] => [charset] => windows-1252 [notify_version] => 3.9 [ipn_track_id] => 82a94336009ab ) Verified ******************************** Array ( [txn_type] => new_case [payment_date] => 09:19:34 Aug 30, 2020 PDT [case_id] => PP-D-84850248 [case_type] => dispute [business] => basharatb@hotmail.com [verify_sign] => AW2G-dg7F3MCA3PBtCb1vpcrBXZcAcPGFbFtUwqjeixyyFqHniWOmw9k [payer_email] => ryangray15@hotmail.co.uk [txn_id] => 6A3517659G921303C [case_creation_date] => 05:56:23 Sep 20, 2020 PDT [receiver_email] => basharatb@hotmail.com [payer_id] => GW6GT9DHZXP7W [invoice] => 70 [receiver_id] => 5MFGNNYYTYAXY [reason_code] => non_receipt [custom] => [charset] => windows-1252 [notify_version] => 3.9 [ipn_track_id] => 09f7e3c41a63b ) Verified ******************************** Array ( [txn_type] => new_case [payment_date] => 13:36:04 Sep 13, 2020 PDT [case_id] => PP-D-85048361 [case_type] => dispute [business] => basharatb@hotmail.com [verify_sign] => AcUFN4LHFAM7xtradAcMkDDAVmBBAiDtIa15RciMi-qzdT1n6mX4jjTy [payer_email] => shhawtyy28@hotmail.com [txn_id] => 06P692095R957570E [case_creation_date] => 04:31:53 Sep 22, 2020 PDT [receiver_email] => basharatb@hotmail.com [payer_id] => V9CFKFEV8B27Y [invoice] => 72 [receiver_id] => 5MFGNNYYTYAXY [reason_code] => non_receipt [custom] => [charset] => windows-1252 [notify_version] => 3.9 [ipn_track_id] => d69b4b9c814f3 ) Verified ******************************** Array ( [mc_gross] => -40.99 [invoice] => 72 [protection_eligibility] => Eligible [payer_id] => V9CFKFEV8B27Y [payment_date] => 23:11:31 Oct 04, 2020 PDT [payment_status] => Reversed [charset] => windows-1252 [first_name] => Vera [mc_fee] => 0.00 [notify_version] => 3.9 [reason_code] => buyer_complaint [custom] => [business] => basharatb@hotmail.com [verify_sign] => AgO6czovQgTIOFq62CAzXRu6BlKRA3RduCo.rM3gvTfEKzU8HL-m.XUI [payer_email] => shhawtyy28@hotmail.com [parent_txn_id] => 06P692095R957570E [txn_id] => 72E605766S916343W [payment_type] => instant [last_name] => Segu [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [item_name] => Picture frame [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [handling_amount] => 0.00 [shipping_method] => Default [transaction_subject] => [payment_gross] => [shipping] => 0.00 [ipn_track_id] => 55d1563c79208 ) Verified ******************************** Array ( [mc_gross] => 40.99 [invoice] => 81 [protection_eligibility] => Eligible [payer_id] => VL2U4K5FMRTCC [payment_date] => 18:15:24 Dec 22, 2020 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => RUVIMBO NATALIE [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => As7YjUf-EtwWTklniO1RIaVMU-GLAp0t5fg6rgZ2MahskUtgeNXY.khH [payer_email] => natalie.mavhiki@cityhearts.co.uk [txn_id] => 06M195235Y505341S [payment_type] => instant [last_name] => MAVHIKI [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a75f33f34e9d6 ) Verified select * from orders where id='81' and ipn_id='06M195235Y505341S,a75f33f34e9d6' and pay_status='1' limit 1 update orders set ipn_id='06M195235Y505341S,a75f33f34e9d6', pay_status='1' where id='81' limit 1 Updated ******************************** Array ( [mc_gross] => 45.42 [invoice] => 84 [protection_eligibility] => Eligible [payer_id] => 9V37DDHUKU692 [payment_date] => 08:10:30 Jan 12, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => emily [mc_fee] => 1.62 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => A0TlpJE4a13MjEm.BcO4AOtAypYZA9c8a2dluI3t1fR-gy3Do9UJ98EN [payer_email] => epollard1@hotmail.co.uk [txn_id] => 91660704PD653654U [payment_type] => instant [last_name] => pollard [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 3142596718b4b ) Verified select * from orders where id='84' and ipn_id='91660704PD653654U,3142596718b4b' and pay_status='1' limit 1 update orders set ipn_id='91660704PD653654U,3142596718b4b', pay_status='1' where id='84' limit 1 Updated ******************************** Array ( [mc_gross] => 40.99 [invoice] => 90 [protection_eligibility] => Eligible [payer_id] => KFRDEQ8C5UGRJ [payment_date] => 08:53:35 Feb 08, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Sandra [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => Aj3n1uG0TJrz-xAOG62laSKUAF-hAbOd7AXKATDCh.hd88uwgpkwRRHS [payer_email] => sandracummings1@hotmail.co.uk [txn_id] => 3H337437E6622510A [payment_type] => instant [last_name] => Cummings [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => a5bf7483849b1 ) Verified select * from orders where id='90' and ipn_id='3H337437E6622510A,a5bf7483849b1' and pay_status='1' limit 1 update orders set ipn_id='3H337437E6622510A,a5bf7483849b1', pay_status='1' where id='90' limit 1 Updated ******************************** Array ( [txn_type] => new_case [payment_date] => 08:53:35 Feb 08, 2021 PST [case_id] => PP-D-102897716 [case_type] => dispute [business] => basharatb@hotmail.com [verify_sign] => AyH4oWDLm375CcYgZ2tQ9eKSuMLGAeJ5jh77FIap4e9kayz3HxBVLM78 [payer_email] => sandracummings1@hotmail.co.uk [txn_id] => 3H337437E6622510A [case_creation_date] => 08:43:09 Feb 16, 2021 PST [receiver_email] => basharatb@hotmail.com [payer_id] => KFRDEQ8C5UGRJ [invoice] => 90 [receiver_id] => 5MFGNNYYTYAXY [reason_code] => non_receipt [custom] => [charset] => windows-1252 [notify_version] => 3.9 [ipn_track_id] => 923c18a08c109 ) Verified ******************************** Array ( [mc_gross] => 40.99 [invoice] => 92 [protection_eligibility] => Eligible [payer_id] => 3E8S4BQYRXGQ4 [payment_date] => 23:33:40 Feb 17, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Lisenka [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => Af8UHmapGoWAr0IEwEeeKS1h5RbbAZzPuH01nwRe3cHPhbhd1UAntNs8 [payer_email] => lisenkaj@gmail.com [txn_id] => 4U413157XE969314K [payment_type] => instant [last_name] => Exell [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frame [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => e134f459a811c ) Verified select * from orders where id='92' and ipn_id='4U413157XE969314K,e134f459a811c' and pay_status='1' limit 1 update orders set ipn_id='4U413157XE969314K,e134f459a811c', pay_status='1' where id='92' limit 1 Updated ******************************** Array ( [mc_gross] => -40.99 [invoice] => 90 [protection_eligibility] => Eligible [payer_id] => KFRDEQ8C5UGRJ [payment_date] => 01:45:46 Mar 02, 2021 PST [payment_status] => Reversed [charset] => windows-1252 [first_name] => Sandra [mc_fee] => 0.00 [notify_version] => 3.9 [reason_code] => buyer_complaint [custom] => [business] => basharatb@hotmail.com [verify_sign] => AgEyY4IfuSAB9WYotLD68Pq9mEwRAnEEoBRiFXQDinRddExEX0z-81wC [payer_email] => sandracummings1@hotmail.co.uk [parent_txn_id] => 3H337437E6622510A [txn_id] => 6DG732870E1740403 [payment_type] => instant [last_name] => Cummings [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [handling_amount] => 0.00 [shipping_method] => Default [transaction_subject] => [payment_gross] => [shipping] => 0.00 [ipn_track_id] => c232a60292c96 ) Verified ******************************** Array ( [mc_gross] => 40.99 [invoice] => 96 [protection_eligibility] => Eligible [payer_id] => WLGPRKWDR7B2Q [payment_date] => 11:16:36 Mar 11, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Harry [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => A07nkSy-SCFdth2oGRHmhflaKuT2A9L1ImuYzOGB5GCn.iMyJ9-k7km7 [payer_email] => pondenterprise@hotmail.com [txn_id] => 6NB47951CH2396812 [payment_type] => instant [last_name] => Pond [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frame, 80x120 [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => c71f9c6214cc3 ) Verified select * from orders where id='96' and ipn_id='6NB47951CH2396812,c71f9c6214cc3' and pay_status='1' limit 1 update orders set ipn_id='6NB47951CH2396812,c71f9c6214cc3', pay_status='1' where id='96' limit 1 Updated ******************************** Array ( [mc_gross] => 40.99 [invoice] => 101 [protection_eligibility] => Eligible [payer_id] => AALEDLUNXJQSC [payment_date] => 05:26:49 Mar 20, 2021 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Michael [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AqhvMQzGEp65TMmachXwkYPO8YnOAbLqAZy.-2fnFgb7UcT7Lz7g1jQM [payer_email] => djangology26@hotmail.com [txn_id] => 9YB11625JX258744R [payment_type] => instant [last_name] => Ostromooukhov [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => c83acb7770b6f ) Verified select * from orders where id='101' and ipn_id='9YB11625JX258744R,c83acb7770b6f' and pay_status='1' limit 1 update orders set ipn_id='9YB11625JX258744R,c83acb7770b6f', pay_status='1' where id='101' limit 1 Updated ******************************** Array ( [mc_gross] => 40.99 [invoice] => 103 [protection_eligibility] => Eligible [payer_id] => QA6CNAA5LLATW [payment_date] => 12:02:03 Apr 05, 2021 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Aldebaran [mc_fee] => 1.69 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => ArOwH2-2U6ujY.v16rG9LUwNZrm7Ab4LSR8g3MFqtshJxuWDW8O6b.R5 [payer_email] => aldebaran.ossola@outlook.it [txn_id] => 9HL22863GF0877431 [payment_type] => instant [last_name] => Ossola [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => Frame [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => IT [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 5bb30fd70cea8 ) Verified select * from orders where id='103' and ipn_id='9HL22863GF0877431,5bb30fd70cea8' and pay_status='1' limit 1 update orders set ipn_id='9HL22863GF0877431,5bb30fd70cea8', pay_status='1' where id='103' limit 1 Updated ******************************** Array ( [txn_type] => new_case [payment_date] => 23:33:40 Feb 17, 2021 PST [case_id] => PP-D-112346297 [case_type] => dispute [business] => basharatb@hotmail.com [verify_sign] => Arpfsg0L7zfrDVZ8VPlDkVB9kZ8qAP6ND4p1eTCXc7YInP5Op02ykb-a [payer_email] => lisenkaj@gmail.com [txn_id] => 4U413157XE969314K [case_creation_date] => 23:12:21 May 09, 2021 PDT [receiver_email] => basharatb@hotmail.com [payer_id] => 3E8S4BQYRXGQ4 [invoice] => 92 [receiver_id] => 5MFGNNYYTYAXY [reason_code] => non_receipt [custom] => [charset] => windows-1252 [notify_version] => 3.9 [ipn_track_id] => ce05148261549 ) Verified ******************************** Array ( [mc_gross] => -40.99 [invoice] => 92 [protection_eligibility] => Eligible [payer_id] => 3E8S4BQYRXGQ4 [payment_date] => 05:03:48 May 24, 2021 PDT [payment_status] => Refunded [charset] => windows-1252 [first_name] => Lisenka [mc_fee] => 0.00 [notify_version] => 3.9 [reason_code] => buyer_complaint [custom] => [business] => basharatb@hotmail.com [verify_sign] => A5VN1xpDxsWM38K.abHASFmzHRrXALQqvrvPerN5RUbLGQEOW3LMc7R7 [payer_email] => lisenkaj@gmail.com [parent_txn_id] => 4U413157XE969314K [txn_id] => 4CW14092LA431404A [payment_type] => instant [last_name] => Exell [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [item_name] => Frame [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [handling_amount] => 0.00 [shipping_method] => Default [transaction_subject] => [payment_gross] => [shipping] => 0.00 [ipn_track_id] => 65ccd53b89ac8 ) Verified ******************************** Array ( [mc_gross] => 40.99 [invoice] => 107 [protection_eligibility] => Eligible [payer_id] => TJRRR66L6M7S6 [payment_date] => 02:39:08 Jun 08, 2021 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => terrina [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AftnQQPG1GN3UCZl.xBjmHT28mcBAoGtahOVuTIOAgo3po4VGR69ThCs [payer_email] => terrinalaughton46@gmail.com [txn_id] => 9WD36038X83799001 [payment_type] => instant [last_name] => laughton [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => picture frame [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => 3667dc4b32df6 ) Verified select * from orders where id='107' and ipn_id='9WD36038X83799001,3667dc4b32df6' and pay_status='1' limit 1 update orders set ipn_id='9WD36038X83799001,3667dc4b32df6', pay_status='1' where id='107' limit 1 Updated ******************************** Array ( [mc_gross] => 37.80 [invoice] => 110 [protection_eligibility] => Eligible [payer_id] => GU6TWJUBRS8J8 [payment_date] => 11:16:46 Jun 18, 2021 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicholas [mc_fee] => 1.40 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AFA-0FULwwEaf8iWc149dR4hjX5oA6FEW42uVPyCbDFweIHOdqpJTytw [payer_email] => nmholmes@btinternet.com [txn_id] => 780444095S306482F [payment_type] => instant [last_name] => Holmes [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => d31baee0475d2 ) Verified select * from orders where id='110' and ipn_id='780444095S306482F,d31baee0475d2' and pay_status='1' limit 1 update orders set ipn_id='780444095S306482F,d31baee0475d2', pay_status='1' where id='110' limit 1 Updated ******************************** Array ( [mc_gross] => 40.99 [invoice] => 113 [protection_eligibility] => Eligible [payer_id] => W4LT8HREVY9GJ [payment_date] => 01:51:16 Jul 03, 2021 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => Anna [mc_fee] => 1.49 [notify_version] => 3.9 [custom] => [payer_status] => verified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => ATDc66oLqGYKlnyDpI-hw-0gsez3AdqnkgU4BkqmQs--J4pI-HkqizbG [payer_email] => notplastic@mail.ru [txn_id] => 0U121377TT2619946 [payment_type] => instant [last_name] => Solovjova [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => ce30522c018f1 ) Verified select * from orders where id='113' and ipn_id='0U121377TT2619946,ce30522c018f1' and pay_status='1' limit 1 update orders set ipn_id='0U121377TT2619946,ce30522c018f1', pay_status='1' where id='113' limit 1 Updated ******************************** Array ( [mc_gross] => 10.39 [invoice] => 123 [protection_eligibility] => Eligible [payer_id] => CWFGFGUNS87A2 [payment_date] => 11:07:48 Aug 09, 2021 PDT [payment_status] => Completed [charset] => windows-1252 [first_name] => basharat [mc_fee] => 0.60 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => A0D6kKri0YYBCL6vVXkGaKfk0NIvAJqBm-QlXLUzHj417XrkUcylPQEY [payer_email] => onlinesuppliesukltd@gmail.com [txn_id] => 4V5231984R6488315 [payment_type] => instant [last_name] => bashir [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 2851-5645-8557-7126 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f406617088c69 ) Verified select * from orders where id='123' and ipn_id='4V5231984R6488315,f406617088c69' and pay_status='1' limit 1 update orders set ipn_id='4V5231984R6488315,f406617088c69', pay_status='1' where id='123' limit 1 Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 update orders set ipn_id='5AY83382UL480601D,f8608230c17c2', pay_status='1' where id='136' limit 1 Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated ******************************** Array ( [mc_gross] => 9.49 [invoice] => 136 [protection_eligibility] => Eligible [payer_id] => 8TTEKYF2BDPSA [payment_date] => 02:17:53 Dec 31, 2021 PST [payment_status] => Completed [charset] => windows-1252 [first_name] => Nicola [mc_fee] => 0.58 [notify_version] => 3.9 [custom] => [payer_status] => unverified [business] => basharatb@hotmail.com [quantity] => 1 [verify_sign] => AXm4GX-dg4fCYd-yxyhgXRHdv4QVA7gwxSP23FCawCiZn-oHR27Dln1F [payer_email] => nicola.meade@yahoo.co.uk [txn_id] => 5AY83382UL480601D [payment_type] => instant [last_name] => Meade [receiver_email] => basharatb@hotmail.com [payment_fee] => [shipping_discount] => 0.00 [receiver_id] => 5MFGNNYYTYAXY [insurance_amount] => 0.00 [txn_type] => web_accept [item_name] => [discount] => 0.00 [mc_currency] => GBP [item_number] => [residence_country] => GB [receipt_id] => 0587-9472-5309-2418 [shipping_method] => Default [transaction_subject] => [payment_gross] => [ipn_track_id] => f8608230c17c2 ) Verified select * from orders where id='136' and ipn_id='5AY83382UL480601D,f8608230c17c2' and pay_status='1' limit 1 Already Updated