JHAVERI broker/investment users database leak
by - Thursday, January 1, 1970 at 12:00 AM
Date: November 2022

Tables:
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `role` int(11) NOT NULL COMMENT '0-Superadmin, 1 -Subbroker , 2 - Another Role',
  `userRights` text COLLATE utf8_unicode_ci NOT NULL,
  `sunbroker_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `sub_email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `sub_additionalemail` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `contactNo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `bankName` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `bank_account` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `ifscCode` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `gst_No` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `equity_sub_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `subbroker_arn` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `euin` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `address` text COLLATE utf8_unicode_ci NOT NULL,
  `products` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
Rows: ~2000
Format: .sql ( only users table )

The origin is not 100% sure. The dump may belong somehow to https://www.jhaveritrade.com/ but most likely is directly from the app https://play.google.com/store/apps/details?id=com.wave.JeTradePlus.
The data ranges from early 2018 up to today, although there have been no recent registrations. Status reports in the DB are still being generated.

Example:
INSERT INTO `users` VALUES ('2','YASH JHAVERI-6  (PRERNA NARESH PUROHIT)','[email protected]','$2y$10$bB8rt/sQsFHFv2rb2WHpyua5/GG7EZuGpfkVcU53NFoNw03yKQN.S','j1KD0bP0DF7EV2pVcmgOldsaLKi5se1ZGexS0foJfDO7xgMMwUnnWLhzA33Y','1','','1211','[email protected]','','9909945955','','','','','','','','','','0000-00-00 00:00:00','2017-11-09 17:11:16'),('3','PRAMESH INVESTMENT  WAGHODIA','[email protected]','$2y$10$qs2O1MtSihSZDyJLYhWWHuatszery98I/DbKjeNv/0MYru.lFXLAO','6gDGjv9sRio4vKJq2vEYDbMvkzoM6RsTcFDU5PN8Duy3XmfM6A6LRclenLsO','1','','1228','[email protected]','','9825246177','','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00'),('4','NIMISHA MAHESHKUMAR PATEL','[email protected]','$2y$10$yYdGfNWljm9djsa63A0O.OfEY0OhoWn4ExJi9BN5C/oN1OdHSy0bW','6gDGjv9sRio4vKJq2vEYDbMvkzoM6RsTcFDU5PN8Duy3XmfM6A6LRclenLsO','1','','1232','[email protected]','','9924151600','','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00'),('5','RAJNIKANT S PATEL','[email protected]','$2y$10$NQNsNmbRtDGOgByZ7hIcP.3ZqHu/A2rWRt2P2I/XqjU79GtyH76PO','6gDGjv9sRio4vKJq2vEYDbMvkzoM6RsTcFDU5PN8Duy3XmfM6A6LRclenLsO','1','','1233','[email protected]','','9925223468','','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00'),('6','BHARAT JAYANTILAL GANDHI','[email protected]','$2y$10$4b0uJpnnz7tuXSC7XZwXgelXN.Uj4AyXFzvE7o6Qnm2JZ4YLXpNiS','6gDGjv9sRio4vKJq2vEYDbMvkzoM6RsTcFDU5PN8Duy3XmfM6A6LRclenLsO','1','','1246','[email protected]','','9825119036','','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00'),('7','INVEX CONSULTANCY (JYOTI MASAND)','[email protected]','$2y$10$cB6Kwc3T.o2Qlkw32RYfdOAPKnDKPb5/SEPNwol7UFpwCX6gXdcye','6gDGjv9sRio4vKJq2vEYDbMvkzoM6RsTcFDU5PN8Duy3XmfM6A6LRclenLsO','1','','1259','[email protected]','','9376217259','','','','','','','','','','0000-00-00 00:00:00','0000-00-00 00:00:00')


Hidden Content
You must register or login to view this content.
Reply


 Users viewing this thread: JHAVERI broker/investment users database leak: No users currently viewing.