API tools faq
paste
Joker0day

ipn#5

Joker0day
Feb 21st, 2018
309
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.37 KB | None | 0 0
raw download clone embed print report
  1. `rate` ,
  2. `zhangdan` ,
  3. `note` ,
  4. `bizhong`,
  5. paypal
  6. )
  7. VALUES (
  8. NULL , '94.22', '6821', now(), 'paypal', 'ansonzy@gmail.com', '', '', '', 'CAD','ansonzy@gmail.com'
  9. );
  10. succeed _liqinhongxiaupdate user set paypal='ansonzy@gmail.com',paypal_name='yanzhuang',verify_paypal=0,paypal_addr='winnipegyan zhuang',paypal_country='CA',residence_country='CA',address_status=1 where email='ansonzy@gmail.com'
  11. succeed _Array
  12. (
  13. [mc_gross] => 95.39
  14. [invoice] => 6822|js3671@columbia.edu
  15. [protection_eligibility] => Ineligible
  16. [address_status] => confirmed
  17. [payer_id] => S3XCAK3KM3GW8
  18. [tax] => 0.00
  19. [address_street] => 523 W 112TH ST
  20. APT 2B
  21. [payment_date] => 12:59:49 Jan 21, 2011 PST
  22. [payment_status] => Completed
  23. [charset] => gb2312
  24. [address_zip] => 10025
  25. [first_name] => Jinghuai
  26. [mc_fee] => 3.35
  27. [address_country_code] => US
  28. [address_name] => Jinghuai Sun
  29. [notify_version] => 3.0
  30. [custom] =>
  31. [payer_status] => verified
  32. [business] => mjfcard2010@126.com
  33. [address_country] => United States
  34. [address_city] => NEW YORK
  35. [quantity] => 1
  36. [verify_sign] => AQU0e5vuZCvSg-XJploSa.sGUDlpAc0PQxh0RhRDRpZTpWuvncT2j3tl
  37. [payer_email] => js3671@columbia.edu
  38. [txn_id] => 3P282013KU553513G
  39. [payment_type] => instant
  40. [last_name] => Sun
  41. [address_state] => NY
  42. [receiver_email] => mjfcard2010@126.com
  43. [payment_fee] => 3.35
  44. [receiver_id] => SKAYE6N55VFTY
  45. [txn_type] => web_accept
  46. [item_name] => 158card
  47. [mc_currency] => USD
  48. [item_number] =>
  49. [residence_country] => US
  50. [handling_amount] => 0.00
  51. [transaction_subject] => 158card
  52. [payment_gross] => 95.39
  53. [shipping] => 0.00
  54. )
  55.  
  56. sql=SELECT *
  57. FROM `dingdan`
  58. WHERE `money` = '95.39' and dingdanid=6822 and stat=0 and bizhong_en='USD'
  59. sql=UPDATE `dingdan` SET `zhifu_time` =now(),stat='1',paypal='js3671@columbia.edu',payment_date=now(),paypal_name='JinghuaiSun',verify_paypal=1,paypal_addr='NEW YORKJinghuai Sun',paypal_country='US',residence_country='US' WHERE `dingdan`.`dingdanid` =6822 LIMIT 1
  60. succeed _liqinhongxiaINSERT INTO `ka`.`chongzhi_record` (
  61. `id` ,
  62. `money` ,
  63. `s_id` ,
  64. `time` ,
  65. `type` ,
  66. `user_name` ,
  67. `rate` ,
  68. `zhangdan` ,
  69. `note` ,
  70. `bizhong`,
  71. paypal
  72. )
  73. VALUES (
  74. NULL , '95.39', '6822', now(), 'paypal', 'js3671@columbia.edu', '', '', '', 'USD','js3671@columbia.edu'
  75. );
  76. succeed _liqinhongxiaupdate user set paypal='js3671@columbia.edu',paypal_name='JinghuaiSun',verify_paypal=1,paypal_addr='NEW YORKJinghuai Sun',paypal_country='US',residence_country='US',address_status=1 where email='js3671@columbia.edu'
  77. succeed _Array
  78. (
  79. [mc_gross] => 38.37
  80. [invoice] => 6823|maoyue2004@hotmail.com
  81. [protection_eligibility] => Ineligible
  82. [address_status] => confirmed
  83. [payer_id] => MTYBPPUXG6EEN
  84. [tax] => 0.00
  85. [address_street] => 807 College Ave
  86. Apt 29
  87. [payment_date] => 13:29:11 Jan 21, 2011 PST
  88. [payment_status] => Completed
  89. [charset] => gb2312
  90. [address_zip] => 29631
  91. [first_name] => Yue
  92. [mc_fee] => 1.53
  93. [address_country_code] => US
  94. [address_name] => Yue Mao
  95. [notify_version] => 3.0
  96. [custom] =>
  97. [payer_status] => verified
  98. [business] => mjfcard2010@126.com
  99. [address_country] => United States
  100. [address_city] => Clemson
  101. [quantity] => 1
  102. [verify_sign] => AB8uKJ-cgis5XVZJfu8yXdO6dhrpASmhYUAwjbUkmDLeT0hTmpO7zVXm
  103. [payer_email] => maoyue2004@hotmail.com
  104. [txn_id] => 16P296324E114063M
  105. [payment_type] => instant
  106. [last_name] => Mao
  107. [address_state] => SC
  108. [receiver_email] => mjfcard2010@126.com
  109. [payment_fee] => 1.53
  110. [receiver_id] => SKAYE6N55VFTY
  111. [txn_type] => web_accept
  112. [item_name] => 158card
  113. [mc_currency] => USD
  114. [item_number] =>
  115. [residence_country] => US
  116. [handling_amount] => 0.00
  117. [transaction_subject] => 158card
  118. [payment_gross] => 38.37
  119. [shipping] => 0.00
  120. )
  121.  
  122. sql=SELECT *
  123. FROM `dingdan`
  124. WHERE `money` = '38.37' and dingdanid=6823 and stat=0 and bizhong_en='USD'
  125. sql=UPDATE `dingdan` SET `zhifu_time` =now(),stat='1',paypal='maoyue2004@hotmail.com',payment_date=now(),paypal_name='YueMao',verify_paypal=1,paypal_addr='ClemsonYue Mao',paypal_country='US',residence_country='US' WHERE `dingdan`.`dingdanid` =6823 LIMIT 1
  126. succeed _liqinhongxiaINSERT INTO `ka`.`chongzhi_record` (
  127. `id` ,
  128. `money` ,
  129. `s_id` ,
  130. `time` ,
  131. `type` ,
  132. `user_name` ,
  133. `rate` ,
  134. `zhangdan` ,
  135. `note` ,
  136. `bizhong`,
  137. paypal
  138. )
  139. VALUES (
  140. NULL , '38.37', '6823', now(), 'paypal', 'maoyue2004@hotmail.com', '', '', '', 'USD','maoyue2004@hotmail.com'
  141. );
  142. succeed _liqinhongxiaupdate user set paypal='maoyue2004@hotmail.com',paypal_name='YueMao',verify_paypal=1,paypal_addr='ClemsonYue Mao',paypal_country='US',residence_country='US',address_status=1 where email='maoyue2004@hotmail.com'
  143. succeed _Array
  144. (
  145. [mc_gross] => 95.39
  146. [invoice] => 6824|dylanzhenyi@yahoo.com.cn
  147. [protection_eligibility] => Ineligible
  148. [address_status] => confirmed
  149. [payer_id] => MXEN9XBN8RU32
  150. [tax] => 0.00
  151. [address_street] => London Square Apartment
  152. [payment_date] => 13:33:22 Jan 21, 2011 PST
  153. [payment_status] => Completed
  154. [charset] => gb2312
  155. [address_zip] => 75244
  156. [first_name] => Zhenyi
  157. [mc_fee] => 3.35
  158. [address_country_code] => US
  159. [address_name] => Zhenyi Zhu
  160. [notify_version] => 3.0
  161. [custom] =>
  162. [payer_status] => verified
  163. [business] => mjfcard2010@126.com
  164. [address_country] => United States
  165. [address_city] => Dallas
  166. [quantity] => 1
  167. [verify_sign] => A8RQ0F8gkUzMctcqZ4r9aZzwD7JUA0ElBEAWuIJZBeKJJfL2Jty0hxyD
  168. [payer_email] => dylanzhenyi@yahoo.com.cn
  169. [txn_id] => 7YD170928F411904Y
  170. [payment_type] => instant
  171. [last_name] => Zhu
  172. [address_state] => TX
  173. [receiver_email] => mjfcard2010@126.com
  174. [payment_fee] => 3.35
  175. [receiver_id] => SKAYE6N55VFTY
  176. [txn_type] => web_accept
  177. [item_name] => 158card
  178. [mc_currency] => USD
  179. [item_number] =>
  180. [residence_country] => US
  181. [handling_amount] => 0.00
  182. [transaction_subject] => 158card
  183. [payment_gross] => 95.39
  184. [shipping] => 0.00
  185. )
  186.  
  187. sql=SELECT *
  188. FROM `dingdan`
  189. WHERE `money` = '95.39' and dingdanid=6824 and stat=0 and bizhong_en='USD'
  190. sql=UPDATE `dingdan` SET `zhifu_time` =now(),stat='1',paypal='dylanzhenyi@yahoo.com.cn',payment_date=now(),paypal_name='ZhenyiZhu',verify_paypal=1,paypal_addr='DallasZhenyi Zhu',paypal_country='US',residence_country='US' WHERE `dingdan`.`dingdanid` =6824 LIMIT 1
  191. succeed _liqinhongxiaINSERT INTO `ka`.`chongzhi_record` (
  192. `id` ,
  193. `money` ,
  194. `s_id` ,
  195. `time` ,
  196. `type` ,
  197. `user_name` ,
  198. `rate` ,
  199. `zhangdan` ,
  200. `note` ,
  201. `bizhong`,
  202. paypal
  203. )
  204. VALUES (
  205. NULL , '95.39', '6824', now(), 'paypal', 'dylanzhenyi@yahoo.com.cn', '', '', '', 'USD','dylanzhenyi@yahoo.com.cn'
  206. );
  207. succeed _liqinhongxiaupdate user set paypal='dylanzhenyi@yahoo.com.cn',paypal_name='ZhenyiZhu',verify_paypal=1,paypal_addr='DallasZhenyi Zhu',paypal_country='US',residence_country='US',address_status=1 where email='dylanzhenyi@yahoo.com.cn'
  208. succeed _Array
  209. (
  210. [mc_gross] => 27.31
  211. [invoice] => 6826|cat4s@hotmail.com
  212. [protection_eligibility] => Ineligible
  213. [address_status] => unconfirmed
  214. [payer_id] => 7KVFSAGKYU9GA
  215. [tax] => 0.00
  216. [address_street] => YANSHANYANGERYULI 16#1-102
  217. [payment_date] => 13:48:36 Jan 21, 2011 PST
  218. [payment_status] => Completed
  219. [charset] => gb2312
  220. [address_zip] => 102502
  221. [first_name] => XIANG
  222. [mc_fee] => 1.09
  223. [address_country_code] => CN
  224. [address_name] => XIANG MENG
  225. [notify_version] => 3.0
  226. [custom] =>
  227. [payer_status] => unverified
  228. [business] => mjfcard2010@126.com
  229. [address_country] => China
  230. [address_city] => FANGSHAN
  231. [quantity] => 1
  232. [verify_sign] => ApBHX6qbpxJW-Ll3oP22LSbo0WeuAp09xz34ZcA7bAJoIWcB-D.KBq6S
  233. [payer_email] => cat4s@hotmail.com
  234. [txn_id] => 6T858202L19137057
  235. [payment_type] => instant
  236. [last_name] => MENG
  237. [address_state] => Beijing
  238. [receiver_email] => mjfcard2010@126.com
  239. [payment_fee] =>
  240. [receiver_id] => SKAYE6N55VFTY
  241. [txn_type] => web_accept
  242. [item_name] => 158card
  243. [mc_currency] => EUR
  244. [item_number] =>
  245. [residence_country] => CN
  246. [receipt_id] => 4716-8135-8885-4722
  247. [handling_amount] => 0.00
  248. [transaction_subject] => 158card
  249. [payment_gross] =>
  250. [shipping] => 0.00
  251. )
  252.  
  253. sql=SELECT *
  254. FROM `dingdan`
  255. WHERE `money` = '27.31' and dingdanid=6826 and stat=0 and bizhong_en='EUR'
  256. sql=UPDATE `dingdan` SET `zhifu_time` =now(),stat='1',paypal='cat4s@hotmail.com',payment_date=now(),paypal_name='XIANGMENG',verify_paypal=0,paypal_addr='FANGSHANXIANG MENG',paypal_country='CN',residence_country='CN' WHERE `dingdan`.`dingdanid` =6826 LIMIT 1
  257. succeed _liqinhongxiaINSERT INTO `ka`.`chongzhi_record` (
  258. `id` ,
  259. `money` ,
  260. `s_id` ,
  261. `time` ,
  262. `type` ,
  263. `user_name` ,
  264. `rate` ,
  265. `zhangdan` ,
  266. `note` ,
  267. `bizhong`,
  268. paypal
  269. )
  270. VALUES (
  271. NULL , '27.31', '6826', now(), 'paypal', 'cat4s@hotmail.com', '', '', '', 'EUR','cat4s@hotmail.com'
  272. );
  273. succeed _liqinhongxiaupdate user set paypal='cat4s@hotmail.com',paypal_name='XIANGMENG',verify_paypal=0,paypal_addr='FANGSHANXIANG MENG',paypal_country='CN',residence_country='CN',address_status=0 where email='cat4s@hotmail.com'
  274. succeed _Array
  275. (
  276. [mc_gross] => 38.06
  277. [invoice] => 6827|lovetingle4ever@hotmail.com
  278. [protection_eligibility] => Ineligible
  279. [address_status] => confirmed
  280. [payer_id] => UXJRCPYQHAA3Y
  281. [tax] => 0.00
  282. [address_street] => 88 woodhall RD
  283. [payment_date] => 13:59:17 Jan 21, 2011 PST
  284. [payment_status] => Completed
  285. [charset] => gb2312
  286. [address_zip] => L3S 1L6
  287. [first_name] => Le
  288. [mc_fee] => 1.52
  289. [address_country_code] => CA
  290. [address_name] => Le Luo
  291. [notify_version] => 3.0
  292. [custom] =>
  293. [payer_status] => unverified
  294. [business] => mjfcard2010@126.com
  295. [address_country] => Canada
  296. [address_city] => markham
  297. [quantity] => 1
  298. [verify_sign] => AiPC9BjkCyDFQXbSkoZcgqH3hpacAjs4ilVW0qVteknBpzB45h0.X3RD
  299. [payer_email] => lovetingle4ever@hotmail.com
  300. [txn_id] => 62W972516F291942E
  301. [payment_type] => instant
  302. [last_name] => Luo
  303. [address_state] => Ontario
  304. [receiver_email] => mjfcard2010@126.com
  305. [payment_fee] =>
  306. [receiver_id] => SKAYE6N55VFTY
  307. [txn_type] => web_accept
  308. [item_name] => 158card
  309. [mc_currency] => CAD
  310. [item_number] =>
  311. [residence_country] => CA
  312. [handling_amount] => 0.00
  313. [transaction_subject] => 158card
  314. [payment_gross] =>
  315. [shipping] => 0.00
  316. )
  317.  
  318. sql=SELECT *
  319. FROM `dingdan`
  320. WHERE `money` = '38.06' and dingdanid=6827 and stat=0 and bizhong_en='CAD'
  321. sql=UPDATE `dingdan` SET `zhifu_time` =now(),stat='1',paypal='lovetingle4ever@hotmail.com',payment_date=now(),paypal_name='LeLuo',verify_paypal=0,paypal_addr='markhamLe Luo',paypal_country='CA',residence_country='CA' WHERE `dingdan`.`dingdanid` =6827 LIMIT 1
  322. succeed _liqinhongxiaINSERT INTO `ka`.`chongzhi_record` (
  323. `id` ,
  324. `money` ,
  325. `s_id` ,
  326. `time` ,
  327. `type` ,
  328. `user_name` ,
  329. `rate` ,
  330. `zhangdan` ,
  331. `note` ,
  332. `bizhong`,
  333. paypal
  334. )
  335. VALUES (
  336. NULL , '38.06', '6827', now(), 'paypal', 'lovetingle4ever@hotmail.com', '', '', '', 'CAD','lovetingle4ever@hotmail.com'
  337. );
  338. succeed _liqinhongxiaupdate user set paypal='lovetingle4ever@hotmail.com',paypal_name='LeLuo',verify_paypal=0,paypal_addr='markhamLe Luo',paypal_country='CA',residence_country='CA',address_status=1 where email='lovetingle4ever@hotmail.com'
  339. succeed _Array
  340. (
  341. [mc_gross] => 95.39
  342. [invoice] => 6828|dylanzhenyi@yahoo.com.cn
  343. [protection_eligibility] => Ineligible
  344. [address_status] => confirmed
  345. [payer_id] => MXEN9XBN8RU32
  346. [tax] => 0.00
  347. [address_street] => London Square Apartment
  348. [payment_date] => 14:11:54 Jan 21, 2011 PST
  349. [payment_status] => Completed
  350. [charset] => gb2312
  351. [address_zip] => 75244
  352. [first_name] => Zhenyi
  353. [mc_fee] => 3.35
  354. [address_country_code] => US
  355. [address_name] => Zhenyi Zhu
  356. [notify_version] => 3.0
  357. [custom] =>
  358. [payer_status] => verified
  359. [business] => mjfcard2010@126.com
  360. [address_country] => United States
  361. [address_city] => Dallas
  362. [quantity] => 1
  363. [verify_sign] => AGu.hbwMxRXoqDiyy-IJNOnULnvNAojYBOddxYhise8YuH6VlFpGDJlu
  364. [payer_email] => dylanzhenyi@yahoo.com.cn
  365. [txn_id] => 8KK950597F5511218
  366. [payment_type] => instant
  367. [last_name] => Zhu
  368. [address_state] => TX
  369. [receiver_email] => mjfcard2010@126.com
  370. [payment_fee] => 3.35
  371. [receiver_id] => SKAYE6N55VFTY
  372. [txn_type] => web_accept
  373. [item_name] => 158card
  374. [mc_currency] => USD
  375. [item_number] =>
  376. [residence_country] => US
  377. [handling_amount] => 0.00
  378. [transaction_subject] => 158card
  379. [payment_gross] => 95.39
  380. [shipping] => 0.00
  381. )
  382.  
  383. sql=SELECT *
  384. FROM `dingdan`
  385. WHERE `money` = '95.39' and dingdanid=6828 and stat=0 and bizhong_en='USD'
  386. sql=UPDATE `dingdan` SET `zhifu_time` =now(),stat='1',paypal='dylanzhenyi@yahoo.com.cn',payment_date=now(),paypal_name='ZhenyiZhu',verify_paypal=1,paypal_addr='DallasZhenyi Zhu',paypal_country='US',residence_country='US' WHERE `dingdan`.`dingdanid` =6828 LIMIT 1
  387. succeed _liqinhongxiaINSERT INTO `ka`.`chongzhi_record` (
  388. `id` ,
  389. `money` ,
  390. `s_id` ,
  391. `time` ,
  392. `type` ,
  393. `user_name` ,
  394. `rate` ,
  395. `zhangdan` ,
  396. `note` ,
  397. `bizhong`,
  398. paypal
  399. )
  400. VALUES (
  401. NULL , '95.39', '6828', now(), 'paypal', 'dylanzhenyi@yahoo.com.cn', '', '', '', 'USD','dylanzhenyi@yahoo.com.cn'
  402. );
  403. succeed _liqinhongxiaupdate user set paypal='dylanzhenyi@yahoo.com.cn',paypal_name='ZhenyiZhu',verify_paypal=1,paypal_addr='DallasZhenyi Zhu',paypal_country='US',residence_country='US',address_status=1 where email='dylanzhenyi@yahoo.com.cn'
  404. succeed _Array
  405. (
  406. [mc_gross] => 120.98
  407. [invoice] => 6829|emoryoyo@gmail.com
  408. [protection_eligibility] => Ineligible
  409. [address_status] => confirmed
  410. [payer_id] => F4YXAB37TJVRG
  411. [tax] => 0.00
  412. [address_street] => Alumni Quad Waterbury #5885
  413. 1400 Washington Ave
  414. [payment_date] => 14:34:46 Jan 21, 2011 PST
  415. [payment_status] => Completed
  416. [charset] => gb2312
  417. [address_zip] => 12222
  418. [first_name] => YANG
  419. [mc_fee] => 4.17
  420. [address_country_code] => US
  421. [address_name] => YANG SONG
  422. [notify_version] => 3.0
  423. [custom] =>
  424. [payer_status] => verified
  425. [business] => mjfcard2010@126.com
  426. [address_country] => United States
  427. [address_city] => Albany
  428. [quantity] => 1
  429. [verify_sign] => ADmhMw5gqASpvy.X38.nDdwooKz7ArOz8XhtMXlBei46AKtiyifniEXL
  430. [payer_email] => emorysong826@hotmail.com
  431. [txn_id] => 8RB85175XW938792K
  432. [payment_type] => instant
  433. [last_name] => SONG
  434. [address_state] => NY
  435. [receiver_email] => mjfcard2010@126.com
  436. [payment_fee] => 4.17
  437. [receiver_id] => SKAYE6N55VFTY
  438. [txn_type] => web_accept
  439. [item_name] => 158card
  440. [mc_currency] => USD
  441. [item_number] =>
  442. [residence_country] => US
  443. [handling_amount] => 0.00
  444. [transaction_subject] => 158card
  445. [payment_gross] => 120.98
  446. [shipping] => 0.00
  447. )
  448.  
  449. sql=SELECT *
  450. FROM `dingdan`
  451. WHERE `money` = '120.98' and dingdanid=6829 and stat=0 and bizhong_en='USD'
  452. sql=UPDATE `dingdan` SET `zhifu_time` =now(),stat='1',paypal='emorysong826@hotmail.com',payment_date=now(),paypal_name='YANGSONG',verify_paypal=1,paypal_addr='AlbanyYANG SONG',paypal_country='US',residence_country='US' WHERE `dingdan`.`dingdanid` =6829 LIMIT 1
  453. succeed _liqinhongxiaINSERT INTO `ka`.`chongzhi_record` (
  454. `id` ,
  455. `money` ,
  456. `s_id` ,
  457. `time` ,
  458. `type` ,
  459. `user_name` ,
  460. `rate` ,
  461. `zhangdan` ,
  462. `note` ,
  463. `bizhong`,
  464. paypal
  465. )
  466. VALUES (
  467. NULL , '120.98', '6829', now(), 'paypal', 'emoryoyo@gmail.com', '', '', '', 'USD','emorysong826@hotmail.com'
  468. );
  469. succeed _liqinhongxiaupdate user set paypal='emorysong826@hotmail.com',paypal_name='YANGSONG',verify_paypal=1,paypal_addr='AlbanyYANG SONG',paypal_country='US',residence_country='US',address_status=1 where email='emoryoyo@gmail.com'
  470. succeed _Array
  471. (
  472. [mc_gross] => 113.07
  473. [invoice] => 6830|stawer1000@hotmail.com
  474. [protection_eligibility] => Ineligible
  475. [address_status] => confirmed
  476. [payer_id] => BPFLWEPGLVFWJ
  477. [tax] => 0.00
  478. [address_street] => 515 galt,verdun
  479. [payment_date] => 14:42:50 Jan 21, 2011 PST
  480. [payment_status] => Completed
  481. [charset] => gb2312
  482. [address_zip] => h4g 2p5
  483. [first_name] => shaojun
  484. [mc_fee] => 3.92
  485. [address_country_code] => CA
  486. [address_name] => shaojun situ
  487. [notify_version] => 3.0
  488. [custom] =>
  489. [payer_status] => unverified
  490. [business] => mjfcard2010@126.com
  491. [address_country] => Canada
  492. [address_city] => montreal
  493. [quantity] => 1
  494. [verify_sign] => AVfSQ5PLCwiNa3zy.rOy.Na-EbloAfBllfFZfCBdxflPPtfkoMtTsFiY
  495. [payer_email] => stawer1000@hotmail.com
  496. [txn_id] => 5BX23336S87897809
  497. [payment_type] => instant
  498. [last_name] => situ
  499. [address_state] => Quebec
  500. [receiver_email] => mjfcard2010@126.com
  501. [payment_fee] =>
  502. [receiver_id] => SKAYE6N55VFTY
  503. [txn_type] => web_accept
  504. [item_name] => 158card
  505. [mc_currency] => CAD
  506. [item_number] =>
  507. [residence_country] => CA
  508. [receipt_id] => 3944-4486-9600-0318
  509. [handling_amount] => 0.00
  510. [transaction_subject] => 158card
  511. [payment_gross] =>
  512. [shipping] => 0.00
  513. )
  514.  
  515. sql=SELECT *
  516. FROM `dingdan`
  517. WHERE `money` = '113.07' and dingdanid=6830 and stat=0 and bizhong_en='CAD'
  518. sql=UPDATE `dingdan` SET `zhifu_time` =now(),stat='1',paypal='stawer1000@hotmail.com',payment_date=now(),paypal_name='shaojunsitu',verify_paypal=0,paypal_addr='montrealshaojun situ',paypal_country='CA',residence_country='CA' WHERE `dingdan`.`dingdanid` =6830 LIMIT 1
  519. succeed _liqinhongxiaINSERT INTO `ka`.`chongzhi_record` (
  520. `id` ,
  521. `money` ,
  522. `s_id` ,
  523. `time` ,
  524. `type` ,
  525. `user_name` ,
  526. `rate` ,
  527. `zhangdan` ,
  528. `note` ,
  529. `bizhong`,
  530. paypal
  531. )
  532. VALUES (
  533. NULL , '113.07', '6830', now(), 'paypal', 'stawer1000@hotmail.com', '', '', '', 'CAD','stawer1000@hotmail.com'
  534. );
  535. succeed _liqinhongxiaupdate user set paypal='stawer1000@hotmail.com',paypal_name='shaojunsitu',verify_paypal=0,paypal_addr='montrealshaojun situ',paypal_country='CA',residence_country='CA',address_status=1 where email='stawer1000@hotmail.com'
  536. succeed _Array
  537. (
  538. [mc_gross] => 19.03
  539. [invoice] => 6832|shz155@hotmail.com
  540. [protection_eligibility] => Ineligible
  541. [address_status] => unconfirmed
  542. [payer_id] => TUT7RAKKQAFUY
  543. [tax] => 0.00
  544. [address_street] => 203F-1121 mckercher dr.
  545. [payment_date] => 15:02:29 Jan 21, 2011 PST
  546. [payment_status] => Completed
  547. [charset] => gb2312
  548. [address_zip] => s7h 5b8
  549. [first_name] => shaoliang
  550. [mc_fee] => 0.91
  551. [address_country_code] => CA
  552. [address_name] => shaoliang zhu
  553. [notify_version] => 3.0
  554. [custom] =>
  555. [payer_status] => unverified
  556. [business] => mjfcard2010@126.com
  557. [address_country] => Canada
  558. [address_city] => saskatoon
  559. [quantity] => 1
  560. [verify_sign] => AwD4sJJmdrzDKNGw7KMAMuZSx1AHAeT0xco12uTws1yZLXslFriulMHY
  561. [payer_email] => shz155@hotmail.com
  562. [txn_id] => 695629275R852622H
  563. [payment_type] => instant
  564. [last_name] => zhu
  565. [address_state] => Saskatchewan
  566. [receiver_email] => mjfcard2010@126.com
  567. [payment_fee] =>
  568. [receiver_id] => SKAYE6N55VFTY
  569. [txn_type] => web_accept
  570. [item_name] => 158card
  571. [mc_currency] => CAD
  572. [item_number] =>
  573. [residence_country] => CA
  574. [handling_amount] => 0.00
  575. [transaction_subject] => 158card
  576. [payment_gross] =>
  577. [shipping] => 0.00
  578. )
  579.  
  580. sql=SELECT *
  581. FROM `dingdan`
  582. WHERE `money` = '19.03' and dingdanid=6832 and stat=0 and bizhong_en='CAD'
  583. sql=UPDATE `dingdan` SET `zhifu_time` =now(),stat='1',paypal='shz155@hotmail.com',payment_date=now(),paypal_name='shaoliangzhu',verify_paypal=0,paypal_addr='saskatoonshaoliang zhu',paypal_country='CA',residence_country='CA' WHERE `dingdan`.`dingdanid` =6832 LIMIT 1
  584. succeed _liqinhongxiaINSERT INTO `ka`.`chongzhi_record` (
  585. `id` ,
  586. `money` ,
  587. `s_id` ,
  588. `time` ,
  589. `type` ,
  590. `user_name` ,
  591. `rate` ,
  592. `zhangdan` ,
  593. `note` ,
  594. `bizhong`,
  595. paypal
  596. )
  597. VALUES (
  598. NULL , '19.03', '6832', now(), 'paypal', 'shz155@hotmail.com', '', '', '', 'CAD','shz155@hotmail.com'
  599. );
  600. succeed _liqinhongxiaupdate user set paypal='shz155@hotmail.com',paypal_name='shaoliangzhu',verify_paypal=0,paypal_addr='saskatoonshaoliang zhu',paypal_country='CA',residence_country='CA',address_status=0 where email='shz155@hotmail.com'
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!