Database Leaked - Vnpay.zaza.one Sql © Chucky Credits

[Chucky]

Database Leaked vnpay.zaza.one

​

INSERT INTO `merchant_bills` (`id`, `merchantId`, `mainCardId`, `caiWuId`, `amount`, `fee`, `bankFee`, `billType`, `isDone`, `isRefund`, `isApproved`, `isDf`, `isKU`, `dfFee`, `bankName`, `bankType`, `bankCode`, `bankCNAPS`, `bankSubName`, `bankAccount`, `bankOwner`, `merchant_bill_id`, `photos`, `memo`, `paidAt`, `createdAt`, `notifyUrl`, `bizInfo`) VALUES

INSERT INTO `loss_orders` (`id`, `orderId`, `stat`, `amount`, `fromDevice`, `reason`, `content`, `createdAt`) VALUES

INSERT INTO `api_logs` (`id`, `userId`, `apiValue`, `apiName`, `apiOption`, `apiResult`, `ua`, `ip`, `isDelete`, `createdAt`) VALUES​

Format - .SQL
Date - 2023
All Rows - 2kk
Website - vnpay.zaza.one

Spoiler: SAMPLE DATA

[/CENTER]

(667758, 10116, 111, 1, '1800000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '7200.00', 'SACOMBANK', '1', '', '', '', '070128565793', 'PHAM VAN DU', '917668_0726061504', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/d32f5390-2b7b-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-111","date":"2023-07-26T06:15:34.625Z"}]', '2023-07-26 06:15:34', '2023-07-26 06:15:04', 'http://subpay.3338533.com/Payout/Callback/GEPayVND/1', ''),
(667759, 10116, 89, 1, '500000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '2000.00', 'MB', '1', '', '', '', '39793979397926', 'LE VAN HUY', '917673_0726061609', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/0120cd10-2b7c-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-89","date":"2023-07-26T06:16:51.674Z"}]', '2023-07-26 06:16:51', '2023-07-26 06:16:10', 'http://subpay.3338533.com/Payout/Callback/GEPayVND/1', ''),
(667760, 10116, 75, 1, '300000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '1200.00', 'MB', '1', '', '', '', '899138889', 'NGUYEN VAN TRUONG', '917674_0726061614', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/02184c70-2b7c-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-75","date":"2023-07-26T06:16:53.289Z"}]', '2023-07-26 06:16:53', '2023-07-26 06:16:14', 'http://subpay.3338533.com/Payout/Callback/GEPayVND/1', ''),
(667761, 10116, 109, 1, '2222000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '8888.00', 'BIDV', '1', '', '', '', '33010000263349', 'HOANGTHITHU', '917675_0726061615', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/06dd75a0-2b7c-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-109","date":"2023-07-26T06:17:01.318Z"}]', '2023-07-26 06:17:01', '2023-07-26 06:16:15', 'http://subpay.3338533.com/Payout/Callback/GEPayVND/1', ''),
(667762, 10125, 114, 1, '1282000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '5128.00', 'MB', '1', '', '', '', '0961968836', 'TRAN CAO TRI', 'GEPAY1955805453316993', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/04f66620-2b7c-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-114","date":"2023-07-26T06:16:58.099Z"}]', '2023-07-26 06:16:58', '2023-07-26 06:16:23', 'https://api.kv999.today/kv999-ecp/notify/payout/gepay', ''),
(667763, 10116, 89, 1, '1400000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '5600.00', 'MB', '1', '', '', '', '797910032004', 'DO VAN CUONG', '917677_0726061728', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/2e82d7d0-2b7c-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-89","date":"2023-07-26T06:18:07.814Z"}]', '2023-07-26 06:18:07', '2023-07-26 06:17:28', 'http://subpay.3338533.com/Payout/Callback/GEPayVND/1', ''),
(667764, 10116, 117, 1, '400000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '1600.00', 'AGRIBANK', '1', '', '', '', '1903206368680', 'HUYNH THI THUY', '917678_0726061736', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/31ae4e30-2b7c-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-117","date":"2023-07-26T06:18:13.135Z"}]', '2023-07-26 06:18:13', '2023-07-26 06:17:36', 'http://subpay.3338533.com/Payout/Callback/GEPayVND/1', ''),
(667765, 10116, 75, 1, '208000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '832.00', 'VIETCOMBANK', '1', '', '', '', '0841000043229', 'DINH HONG CONG', '917680_0726061811', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/42a93ab0-2b7c-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-75","date":"2023-07-26T06:18:41.611Z"}]', '2023-07-26 06:18:41', '2023-07-26 06:18:11', 'http://subpay.3338533.com/Payout/Callback/GEPayVND/1', ''),
(667766, 10032, 104, 1, '980000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '0.00', 'AGRIBANK', '1', '', '', '', '6460205562593', 'huynh thanh son', '2307261318252658', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/501cae20-2b7c-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-104","date":"2023-07-26T06:19:04.185Z"}]', '2023-07-26 06:19:04', '2023-07-26 06:18:25', 'https://channel.58pos.cc/api/order/withdraw/notify/gepay_vn/gepay_vn2/', ''),
(667767, 10032, 117, 1, '1813000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '0.00', 'VIETCOMBANK', '1', '', '', '', '0801000225788', 'Pham thi thu trang', '2307261318252660', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/4c2709f0-2b7c-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-117","date":"2023-07-26T06:18:57.536Z"}]', '2023-07-26 06:18:57', '2023-07-26 06:18:25', 'https://channel.58pos.cc/api/order/withdraw/notify/gepay_vn/gepay_vn2/', ''),
(667768, 10116, 89, 1, '3000000.00', '0.00', '0.00', 'T0', 1, 0, 1, 1, 0, '12000.00', 'VIETINBANK', '1', '', '', '', '101600300887', 'LY QUOC MINH DUAN', '917681_0726061835', '["http://imgbill.oss-cn-hongkong.aliyuncs.com/575b14b0-2b7c-11ee-9a0c-738f48fd7401.png"]', '[{"text":"出款完畢","fromId":0,"name":"機器人-89","date":"2023-07-26T06:19:16.319Z"}]', '2023-07-26 06:19:16', '2023-07-26 06:18:35', 'http://subpay.3338533.com/Payout/Callback/GEPayVND/1', ''),


(26401, 10093, '/api/myInfo', '', '{}', '{"code":200,"data":{"id":10093,"setId":null,"mainMerchantId":null,"groupId":null,"roleId":null,"name":"VE9","type":"merchant","phone":"VE9","parentId":10003,"balance":0,"dfBalance":0,"dfRate":0,"xfRate":0,"isDfActive":1,"billableAmount":503966845.89,"billableT1Amount":0,"unBillableAmount":0,"managerBA":0,"isBan":0,"isApproved":1,"fixRate":0,"sellerRate":0,"guanXiaoRate":0,"providerBA":0,"providerUBA":0,"providerRate":0,"billType":0,"wxId":"","sign":"dbc89ea5794516f02b74f113c29ec646","isAutoBilling":1,"isBillManualAuth":1,"googleAuthLabel":"justpay99.com-10093","smsDayTurnover":0,"bizInfo":{"minDfAmount":0,"maxDfAmount":0,"billIpList":[],"manualBillIpList":["167.179.49.228","203.205.25.9","111.90.184.117"],"payIpList":[],"timeZone":"TW"},"createdAt":"2023-01-19 19:30:21","isDeleted":0,"isOnline":0,"lockedAmount":0,"isSetPaidPassword":true}}', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36', '111.90.184.117', 0, '2023-07-27 19:32:56'),
(26402, 10095, '/manage/getMerchantBills', '', '{"isDf":null,"amount":null,"startAt":"2023-06-30T17:00:00.000Z","endAt":"2023-07-31T16:59:59.000Z","isDone":false,"isRefund":false,"bankOwner":null,"bankAccount":null,"mainCardId":null,"merchantId":null,"modBy":null,"modEquals":null,"caiWuId":null,"isApproved":null,"id":null,"limit":100,"skip":0,"merchantBillId":"","bankName":null}', '{"code":200,"data":{"dataset":[{"id":675299,"merchantId":10096,"mainCardId":0,"caiWuId":1,"amount":2200000,"fee":0,"bankFee":0,"billType":"T0","isDone":0,"isRefund":0,"isApproved":1,"isDf":1,"isKU":0,"dfFee":0,"bankName":"TCB","bankType":"1","bankCode":"","bankCNAPS":"","bankSubName":"","bankAccount":"19033291146011","bankOwner":"NGUYEN VAN DOI","merchant_bill_id":"2045622_0727193136","photos":"[\\"http://imgbill.oss-cn-hongkong.aliyuncs.com/48d925b0-2cb4-11ee-9a0c-738f48fd7401.png\\"]","memo":"[{\\"text\\":\\"找不到[銀行]列表\\",\\"fromId\\":0,\\"name\\":\\"機器人-111\\",\\"date\\":\\"2023-07-27T19:32:12.413Z\\"}]","paidAt":null,"createdAt":"2023-07-28 02:31:36","notifyUrl":"http://subpay.1399444.cc/Payout/Callback/GEPayVND/14","bizInfo":"","setId":null,"name":"cwin888","xfRate":0,"isBillManualAuth":1,"caiWuName":"GEPAY1688","mainCardBankOwner":null,"mainCardBankName":null,"mainCardBankSubName":null,"mainCardBankAccount":null}],"count":1,"totalAmount":2200000}}', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36', '36.236.100.140', 0, '2023-07-27 19:32:56'),
(26403, 0, '/pay', '', '{"mchId":"10001","outTradeNo":"1505149_20230727193257","totalAmount":"100000","payMethod":"VNBANKQR","notifyUrl":"http://pay.3338533.com/DTPP/Money_2352/ServerCallback","bankCode":"VCB","sign":"6461486472035ffed001c8bfdb6e08f7"}', '{"code":200,"data":{"payUrl":"https://pay.justpay99.com/pay/vnbank/6380034"}}', NULL, '18.178.178.74', 0, '2023-07-27 19:32:57'),


(122573, NULL, 'deleted', '1000000.00', 'ACB #386-ＫＨＡＮＨ－ＡＣＢ－32476157', '無匹配訂單', '短信助手自动转发\n来自：ACB\n时间：2023-04-19 07:39:49\n内容：ACB: TK 32476157(VND) + 1,000,000 luc 06:39 19/04/2023. So du 1,409,380. GD: 4765081 GD 048236-041923 06:39:47', '2023-04-18 23:39:51'),
(122574, NULL, 'deleted', '200000.00', 'BIDV #342-ＮＡＭ－ＢＩＤＶ－78810000426422', '無匹配訂單', '短信助手自动转发\n来自：BIDV\n时间：2023-04-19 07:42:56\n内容：TK788xxx6422 tai BIDV +200,000VND vao 06:42 19/04/2023. So du:48,728,413VND. ND: CK76110000691313 4767428', '2023-04-18 23:43:01'),
(122575, NULL, 'deleted', '5000000.00', 'BIDV #342-ＮＡＭ－ＢＩＤＶ－78810000426422', '無匹配訂單', '短信助手自动转发\n来自：BIDV\n时间：2023-04-19 07:44:17\n内容：TK788xxx6422 tai BIDV +5,000,000VND vao 06:44 19/04/2023. So du:53,728,413VND. ND: CK67110000842221 4767430', '2023-04-18 23:44:22'),
(122576, NULL, 'deleted', '200000.00', 'BIDV #342-ＮＡＭ－ＢＩＤＶ－78810000426422', '無匹配訂單', '短信助手自动转发\n来自：BIDV\n时间：2023-04-19 07:51:49\n内容：TK788xxx6422 tai BIDV +200,000VND vao 06:51 19/04/2023. So du:53,928,413VND. ND: TKThe :102868115237, tai Vietinbank. QR - 4767470 -CTLNHIDI000004363066594-11-C', '2023-04-18 23:51:54'),
(122577, NULL, 'deleted', '100000.00', 'BIDV #342-ＮＡＭ－ＢＩＤＶ－78810000426422', '無匹配訂單', '短信助手自动转发\n来自：BIDV\n时间：2023-04-19 07:52:29\n内容：TK788xxx6422 tai BIDV +100,000VND vao 06:52 19/04/2023. So du:54,028,413VND. ND: TKThe :106877793130, tai Vietinbank. 4767471 -CTLNHIDI000004363068742-11-CRE-00', '2023-04-18 23:52:35'),
(122578, NULL, 'deleted', '310000.00', 'BIDV #342-ＮＡＭ－ＢＩＤＶ－78810000426422', '無匹配訂單', '短信助手自动转发\n来自：BIDV\n时间：2023-04-19 07:54:00\n内容：TK788xxx6422 tai BIDV +310,000VND vao 06:53 19/04/2023. So du:54,338,413VND. ND: CK31510001052309 4767479', '2023-04-18 23:54:06'),
(122579, NULL, 'deleted', '200000.00', 'BIDV #342-ＮＡＭ－ＢＩＤＶ－78810000426422', '無匹配訂單', '短信助手自动转发\n来自：BIDV\n时间：2023-04-19 07:57:13\n内容：TK788xxx6422 tai BIDV +200,000VND vao 06:56 19/04/2023. So du:54,538,413VND. ND: TKThe :3523205083552, tai Agribank. BIDV;78810000426422;4767495 -CTLNHIDI000004', '2023-04-18 23:57:19'),

[CENTER]

DOWNLOAD LINK:​

 

[me23]

Chinese Payment application

 

[komputahhakk]

Thank you for sharing

 

[cornerjo]

Great, thankyou for the share Chucky

 

[drudown500]

much appretiated for this one, can wait to check it out thanks brother

 

[dutch555]

thanks a lot for this great sharing

 

[Blackdragon]

Intresting on this post yeee.

 

[leakerofbase]

thank you, will use this

 

[Zezooo89]

Nice work my friend

 

[zeroday]

thank you dude

 

[Huller Mule]

thank you for the share this will help a lot