October 1, 2010, 8:46 am
Found
October 1, 2010, 8:46 am
cmd=_notify-validate&test_ipn=1&payment_type=instant&payment_date=08%3A37%3A29+Oct+01%2C+2010+PDT&payment_status=Completed&payer_status=verified&first_name=John&last_name=Smith&payer_email=buyer%40paypalsandbox.com&payer_id=TESTBUYERID01&business=seller%40paypalsandbox.com&receiver_email=seller%40paypalsandbox.com&receiver_id=TESTSELLERID1&residence_country=US&item_name1=something&item_number1=AK-1234&quantity1=1&tax=2.02&mc_currency=USD&mc_fee=0.44&mc_gross=15.34&mc_gross_1=12.34&mc_handling=2.06&mc_handling1=1.67&mc_shipping=3.02&mc_shipping1=1.02&txn_type=cart&txn_id=291011537&notify_version=2.4&custom=xyz123&invoice=abc1234&charset=windows-1252&verify_sign=Amys.63aGQ350VXGIlHlYpc6XPgwACpfA31p.lMQPImoxOk.dGKj.poD
October 1, 2010, 8:46 am
Recieved Inputs
October 1, 2010, 8:46 am
Doing Get:POST /cgi-bin/webscr HTTP/1.0
Content-Type: application/x-www-form-urlencoded
Content-Length: 725

cmd=_notify-validate&test_ipn=1&payment_type=instant&payment_date=08%3A37%3A29+Oct+01%2C+2010+PDT&payment_status=Completed&payer_status=verified&first_name=John&last_name=Smith&payer_email=buyer%40paypalsandbox.com&payer_id=TESTBUYERID01&business=seller%40paypalsandbox.com&receiver_email=seller%40paypalsandbox.com&receiver_id=TESTSELLERID1&residence_country=US&item_name1=something&item_number1=AK-1234&quantity1=1&tax=2.02&mc_currency=USD&mc_fee=0.44&mc_gross=15.34&mc_gross_1=12.34&mc_handling=2.06&mc_handling1=1.67&mc_shipping=3.02&mc_shipping1=1.02&txn_type=cart&txn_id=291011537&notify_version=2.4&custom=xyz123&invoice=abc1234&charset=windows-1252&verify_sign=Amys.63aGQ350VXGIlHlYpc6XPgwACpfA31p.lMQPImoxOk.dGKj.poD
October 1, 2010, 8:46 am
Res:INVALID
October 1, 2010, 8:46 am
INVALID IPN DETECTED
October 1, 2010, 8:48 am
Found
October 1, 2010, 8:48 am
cmd=_notify-validate&test_ipn=1&payment_type=instant&payment_date=08%3A37%3A29+Oct+01%2C+2010+PDT&payment_status=Completed&payer_status=verified&first_name=John&last_name=Smith&payer_email=buyer%40paypalsandbox.com&payer_id=TESTBUYERID01&business=seller%40paypalsandbox.com&receiver_email=seller%40paypalsandbox.com&receiver_id=TESTSELLERID1&residence_country=US&item_name1=test&item_number1=4&quantity1=1&tax=2.02&mc_currency=USD&mc_fee=0.44&mc_gross=15.34&mc_gross_1=12.34&mc_handling=2.06&mc_handling1=1.67&mc_shipping=3.02&mc_shipping1=1.02&txn_type=cart&txn_id=291011537&notify_version=2.4&custom=6&invoice=abc1234&charset=windows-1252&verify_sign=AFcWxV21C7fd0v3bYYYRCpSSRl31AqwQ0zeyMv.RaKVDh1AAv7YqQAvY
October 1, 2010, 8:48 am
Recieved Inputs
October 1, 2010, 8:48 am
Doing Get:POST /cgi-bin/webscr HTTP/1.0
Content-Type: application/x-www-form-urlencoded
Content-Length: 709

cmd=_notify-validate&test_ipn=1&payment_type=instant&payment_date=08%3A37%3A29+Oct+01%2C+2010+PDT&payment_status=Completed&payer_status=verified&first_name=John&last_name=Smith&payer_email=buyer%40paypalsandbox.com&payer_id=TESTBUYERID01&business=seller%40paypalsandbox.com&receiver_email=seller%40paypalsandbox.com&receiver_id=TESTSELLERID1&residence_country=US&item_name1=test&item_number1=4&quantity1=1&tax=2.02&mc_currency=USD&mc_fee=0.44&mc_gross=15.34&mc_gross_1=12.34&mc_handling=2.06&mc_handling1=1.67&mc_shipping=3.02&mc_shipping1=1.02&txn_type=cart&txn_id=291011537&notify_version=2.4&custom=6&invoice=abc1234&charset=windows-1252&verify_sign=AFcWxV21C7fd0v3bYYYRCpSSRl31AqwQ0zeyMv.RaKVDh1AAv7YqQAvY
October 1, 2010, 8:48 am
Res:INVALID
October 1, 2010, 8:48 am
INVALID IPN DETECTED
October 1, 2010, 8:51 am
Found
October 1, 2010, 8:51 am
cmd=_notify-validate&mc_gross=0.01&protection_eligibility=Eligible&address_status=confirmed&payer_id=HGQSL4P9DFKVE&tax=0.00&address_street=7905+4th+St&payment_date=08%3A51%3A34+Oct+01%2C+2010+PDT&payment_status=Completed&charset=windows-1252&address_zip=48130&first_name=JEREMY&mc_fee=0.01&address_country_code=US&address_name=JEREMY+LOE&notify_version=3.0&custom=6&payer_status=unverified&business=rich%40elegantlady.com&address_country=United+States&address_city=Dexter&quantity=1&verify_sign=A92aS7o7CRdL9PBo3V6jYt3EGvd-A6CB0i4vUVlCjmqPYm3LTaArWKI9&payer_email=jeremy.loe%40gmail.com&txn_id=1KD244619A195043R&payment_type=instant&last_name=LOE&address_state=MI&receiver_email=rich%40elegantlady.com&payment_fee=0.01&receiver_id=TWDJEV4ADH2AS&txn_type=web_accept&item_name=test&mc_currency=USD&item_number=4&residence_country=US&handling_amount=0.00&transaction_subject=6&payment_gross=0.01&shipping=0.00
October 1, 2010, 8:51 am
Recieved Inputs
October 1, 2010, 8:51 am
Doing Get:POST /cgi-bin/webscr HTTP/1.0
Content-Type: application/x-www-form-urlencoded
Content-Length: 906

cmd=_notify-validate&mc_gross=0.01&protection_eligibility=Eligible&address_status=confirmed&payer_id=HGQSL4P9DFKVE&tax=0.00&address_street=7905+4th+St&payment_date=08%3A51%3A34+Oct+01%2C+2010+PDT&payment_status=Completed&charset=windows-1252&address_zip=48130&first_name=JEREMY&mc_fee=0.01&address_country_code=US&address_name=JEREMY+LOE&notify_version=3.0&custom=6&payer_status=unverified&business=rich%40elegantlady.com&address_country=United+States&address_city=Dexter&quantity=1&verify_sign=A92aS7o7CRdL9PBo3V6jYt3EGvd-A6CB0i4vUVlCjmqPYm3LTaArWKI9&payer_email=jeremy.loe%40gmail.com&txn_id=1KD244619A195043R&payment_type=instant&last_name=LOE&address_state=MI&receiver_email=rich%40elegantlady.com&payment_fee=0.01&receiver_id=TWDJEV4ADH2AS&txn_type=web_accept&item_name=test&mc_currency=USD&item_number=4&residence_country=US&handling_amount=0.00&transaction_subject=6&payment_gross=0.01&shipping=0.00
October 1, 2010, 8:51 am
Res:VERIFIED
October 1, 2010, 8:51 am
Verified transcation
October 1, 2010, 8:51 am

			SELECT
				txn_id, ID_MEMBER
			from `pagantoo_smp1`.smf_seller_transactions 
			WHERE txn_id = '1KD244619A195043R'
October 1, 2010, 8:51 am

							SELECT
								title, price
							 FROM `pagantoo_smp1`.smf_seller_ad_packages
							 WHERE ID_PACKAGE = 4 LIMIT 1
October 1, 2010, 8:51 am
INSERT INTO `pagantoo_smp1`.smf_seller_transactions
						(ID_PACKAGE, ID_MEMBER, payment_status,payer_email,first_name,last_name,
						address_street,address_city,address_state,address_zip,address_country,
						memo,payment_type,payment_date,txn_id,pending_reason,reason_code,tax,
						mc_gross, mc_fee,mc_currency, quantity,ipndate,txn_type,shipping

						)
						VALUES
						(4, 6, 'Completed','jeremy.loe@gmail.com','JEREMY','LOE',
						'7905 4th St','Dexter','MI','48130','United States',
						'','instant','08:51:34 Oct 01, 2010 PDT','1KD244619A195043R','','','0.00',
						'0.01', '0.01', 'USD',1,'1285948297','web_accept','0.00'

						)
October 1, 2010, 8:51 am
Entering complete transaction
October 1, 2010, 8:51 am

	SELECT
		title, price, needsstock 
	FROM `pagantoo_smp1`.smf_seller_ad_packages 
	WHERE ID_PACKAGE = 4 LIMIT 1
October 1, 2010, 8:51 am
UPDATE `pagantoo_smp1`.smf_seller_transactions SET payment_status  = 'Completed'
		WHERE txn_id = '1KD244619A195043R' 
October 1, 2010, 8:51 am
Completed transaction
October 1, 2010, 8:52 am
Found
October 1, 2010, 8:52 am
cmd=_notify-validate
October 1, 2010, 8:52 am
Recieved Inputs
October 1, 2010, 8:52 am
Doing Get:POST /cgi-bin/webscr HTTP/1.0
Content-Type: application/x-www-form-urlencoded
Content-Length: 20

cmd=_notify-validate
October 1, 2010, 8:52 am
Res:INVALID
October 1, 2010, 8:52 am
INVALID IPN DETECTED
October 1, 2010, 8:54 am
Found
October 1, 2010, 8:54 am
cmd=_notify-validate&mc_gross=0.01&protection_eligibility=Eligible&address_status=confirmed&payer_id=HGQSL4P9DFKVE&tax=0.00&address_street=7905+4th+St&payment_date=08%3A11%3A55+Oct+01%2C+2010+PDT&payment_status=Completed&charset=windows-1252&address_zip=48130&first_name=JEREMY&mc_fee=0.01&address_country_code=US&address_name=JEREMY+LOE&notify_version=3.0&custom=6&payer_status=unverified&business=rich%40elegantlady.com&address_country=United+States&address_city=Dexter&quantity=1&verify_sign=AnNMT7nRteKS2auTkxdsRz9rRvvPAn.3IdTJPAIxsBlgRzYXlwn6o9cF&payer_email=jeremy.loe%40gmail.com&txn_id=2G4626889A822535W&payment_type=instant&last_name=LOE&address_state=MI&receiver_email=rich%40elegantlady.com&payment_fee=0.01&receiver_id=TWDJEV4ADH2AS&txn_type=web_accept&item_name=test&mc_currency=USD&item_number=4&residence_country=US&handling_amount=0.00&transaction_subject=6&payment_gross=0.01&shipping=0.00
October 1, 2010, 8:54 am
Recieved Inputs
October 1, 2010, 8:54 am
Doing Get:POST /cgi-bin/webscr HTTP/1.0
Content-Type: application/x-www-form-urlencoded
Content-Length: 906

cmd=_notify-validate&mc_gross=0.01&protection_eligibility=Eligible&address_status=confirmed&payer_id=HGQSL4P9DFKVE&tax=0.00&address_street=7905+4th+St&payment_date=08%3A11%3A55+Oct+01%2C+2010+PDT&payment_status=Completed&charset=windows-1252&address_zip=48130&first_name=JEREMY&mc_fee=0.01&address_country_code=US&address_name=JEREMY+LOE&notify_version=3.0&custom=6&payer_status=unverified&business=rich%40elegantlady.com&address_country=United+States&address_city=Dexter&quantity=1&verify_sign=AnNMT7nRteKS2auTkxdsRz9rRvvPAn.3IdTJPAIxsBlgRzYXlwn6o9cF&payer_email=jeremy.loe%40gmail.com&txn_id=2G4626889A822535W&payment_type=instant&last_name=LOE&address_state=MI&receiver_email=rich%40elegantlady.com&payment_fee=0.01&receiver_id=TWDJEV4ADH2AS&txn_type=web_accept&item_name=test&mc_currency=USD&item_number=4&residence_country=US&handling_amount=0.00&transaction_subject=6&payment_gross=0.01&shipping=0.00
October 1, 2010, 8:54 am
Res:VERIFIED
October 1, 2010, 8:54 am
Verified transcation
October 1, 2010, 8:54 am

			SELECT
				txn_id, ID_MEMBER
			from `pagantoo_smp1`.smf_seller_transactions 
			WHERE txn_id = '2G4626889A822535W'
October 1, 2010, 8:54 am

							SELECT
								title, price
							 FROM `pagantoo_smp1`.smf_seller_ad_packages
							 WHERE ID_PACKAGE = 4 LIMIT 1
October 1, 2010, 8:54 am
INSERT INTO `pagantoo_smp1`.smf_seller_transactions
						(ID_PACKAGE, ID_MEMBER, payment_status,payer_email,first_name,last_name,
						address_street,address_city,address_state,address_zip,address_country,
						memo,payment_type,payment_date,txn_id,pending_reason,reason_code,tax,
						mc_gross, mc_fee,mc_currency, quantity,ipndate,txn_type,shipping

						)
						VALUES
						(4, 6, 'Completed','jeremy.loe@gmail.com','JEREMY','LOE',
						'7905 4th St','Dexter','MI','48130','United States',
						'','instant','08:11:55 Oct 01, 2010 PDT','2G4626889A822535W','','','0.00',
						'0.01', '0.01', 'USD',1,'1285948489','web_accept','0.00'

						)
October 1, 2010, 8:54 am
Entering complete transaction
October 1, 2010, 8:54 am

	SELECT
		title, price, needsstock 
	FROM `pagantoo_smp1`.smf_seller_ad_packages 
	WHERE ID_PACKAGE = 4 LIMIT 1
October 1, 2010, 8:54 am
UPDATE `pagantoo_smp1`.smf_seller_transactions SET payment_status  = 'Completed'
		WHERE txn_id = '2G4626889A822535W' 
October 1, 2010, 8:54 am
Completed transaction