Return to forum

vintincha · May 18, 2022 at 8:18 AM

Rooter.io

Records:

1,065,707

Info Source:

leak-lookup.com/breaches

Breach Size:

631.14 MB

Columns:

`id` int(11) NOT NULL AUTO_INCREMENT,
`device_id` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
`device_spec` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
`app_version` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`is_celeb` tinyint(1) NOT NULL DEFAULT '0',
`email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`mobile` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` varchar(45) CHARACTER SET utf8 DEFAULT NULL COMMENT 'created, verified, banned , etc.',
`photo` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
`location` point NOT NULL COMMENT 'last updated location of the user. ',
`state_id` int(11) DEFAULT NULL,
`reputation` float(4,2) DEFAULT '0.00',
`city` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
`password` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
`mobile_verified` tinyint(1) DEFAULT '0',
`email_verified` tinyint(1) DEFAULT '0',
`device_type` varchar(45) COLLATE utf8_unicode_ci DEFAULT 'android',
`push_id` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
`total_points` int(11) NOT NULL DEFAULT '0',
`gems` int(11) NOT NULL DEFAULT '0',
`sendbird_access_token` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL,
`demo_game_played` tinyint(1) DEFAULT '0',
`demo_fantasy_played` tinyint(1) DEFAULT '0',
`invited_by` int(11) DEFAULT NULL,
`third_party_campaign` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`country_code` varchar(3) COLLATE utf8_unicode_ci DEFAULT 'IN',
`locale` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`communication_email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`banned` tinyint(1) NOT NULL DEFAULT '0',
`created_at` datetime DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`deleted` tinyint(1) DEFAULT '0',
`gender` enum('Male','Female','Other') COLLATE utf8_unicode_ci DEFAULT NULL,
`age` date DEFAULT NULL,
(1784,NULL,NULL,NULL,'Harish Goud',0,'599895266862038@facebook',NULL,NULL,'http://graph.facebook.com/599895266862038/picture?type=large',_binary '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,6.00,NULL,'$2a$10$S6aCPjN.93JMbmkiYZCPxu2alIXWw/Z5/X7brQKvLRAOKjdavpdbq',0,0,'Android','f8hsd1t_5gg:APA91bH8k-zkar6M6gfX3tPNZGvMjaOSBta-jcU2Y55L0to5hXwIGW0q4Fbtw6Ma24xb16SSV9SElsOhQ-HTlQ_vww62FRxy01K1gtt4HXPMEk71YBSY_4HS3oc1YU96Ar7ZZKikiA',1000,5,'80c28a5447696b649a474252950ab13cc39b711c',1,0,NULL,NULL,NULL,'en','[email protected]',0,'2016-10-02 08:39:35','2019-11-01 09:40:03',0,NULL,NULL),
(1785,NULL,NULL,NULL,'Ganga Dhar Gowd',0,'886835641448665@facebook',NULL,NULL,'http://graph.facebook.com/886835641448665/picture?type=large',_binary '\0\0\0\0\0\0\0ŘO\fS@x\\)@',17,6.00,'Bengaluru, IN','$2a$10$S6aCPjN.93JMbmkiYZCPxuXk3x7uIk4EVANOjyAk5sEq9zsDki6J.',0,0,'Android','dAIWs2_ntnI:APA91bF0YyQbTx2h3qhtRTra87Q20wmkE2r0LItg6JWI4Uym3c3E8oSJEo9sWzrzQ5AXh_mFzqsyrtxXQqPXlcq5adoKOYPzQBEyAe2jO6D5wD53MhhstI5PLzoy194oz5fWvt9kzy',1000,5,'f50790b2f2b2c686e31d655bc9203d8537c14ede',1,0,NULL,NULL,NULL,'en','[email protected]',0,'2016-10-02 08:47:09','2019-11-01 09:40:03',0,NULL,NULL),
(1786,NULL,NULL,NULL,'Aniket Singh',0,'766972373445784@facebook',NULL,NULL,'http://graph.facebook.com/766972373445784/picture?type=large',_binary '\0\0\0\0\0\0\0bS\VR@a#5>@',4,6.00,'Bathinda, IN','$2a$10$S6aCPjN.93JMbmkiYZCPxuqfQ963dcR7h.U7BP7iGyKnMJzJHl.z2',0,0,'Android','dZfNP_cGeDM:APA91bEFGq-q55_HtktBkjjmIdc44yX_SmdxzYdWXQtNn5K3GJKNODQadnSD7vYLP7G7WSFloEzeoriCy2Ai8OCbFx6czl3sXIFiI3CFoUFGMzdcB59FAPME7Zq1Zs2lykgW3OxO-o',1000,5,'113e606114c62108d56c27287881fdbb71ab00c1',1,0,NULL,NULL,NULL,'en','[email protected]',0,'2016-10-02 08:49:48','2019-11-01 09:40:03',0,NULL,NULL),
(1787,NULL,NULL,NULL,'Shantanu Ranjan Mishra',0,'684155061760782@facebook',NULL,NULL,'http://graph.facebook.com/684155061760782/picture?type=large',_binary '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',NULL,6.00,NULL,'$2a$10$S6aCPjN.93JMbmkiYZCPxum/ssjQNUyJJfMNZc22vdt3lI2B2fLTa',0,0,'Android','eXe5BnTUzJc:APA91bFfoHR_vp5qLdrBGP3aOP5HjxdvAWmG7IRvWpxbjq9VM_SezPQQk_Z48gKLOSMIg0f0p1Nl1STQAXzFW6abYuqPqQsBUz-pc08WRGDveDmO4UGrKa_QwEZjePa7Rzadp1QjkB',1000,5,'87399eeb01d5f24ad287563d7451011463f33ae8',1,0,NULL,NULL,NULL,'en','[email protected]',0,'2016-10-02 08:52:47','2019-11-01 09:40:03',0,NULL,NULL)

Hidden Content

You must register or login to view this content.

icecube100 · May 18, 2022 at 2:57 PM

Show some records,please.

vintincha · May 18, 2022 at 3:17 PM

(May 18, 2022, 02:57 PM)icecube100 Wrote: Show some records,please.

Added few, I am bad with sql, very confusing.

lazyass69 · May 21, 2022 at 4:57 AM

I saw this on telegram, an old breach?

Sebdraven · May 21, 2022 at 11:55 AM

thanks

Ecotage · May 21, 2022 at 10:58 PM

(May 21, 2022, 04:57 AM)lazyass69 Wrote: I saw this on telegram, an old breach?

Old data from 2021, released on RF

Ecotage · May 21, 2022 at 11:32 PM

(May 21, 2022, 02:07 PM)notJeremyHammond Wrote: Very confused format

If you having better india data send message bro

SQL dump but got the CSV split versions. https://anonfiles.com/P549E2i4yc/rooter.csv.tar_gz

Automation · October 21, 2022 at 3:04 AM

The link in this thread is dead. Please send a PM to a moderator to get your thread moved back to the Databases section.

Please also note that this is automated, if the link is still working please alert us. You can find a list of staff at https://breached.to/showteam.

penis · October 22, 2022 at 10:06 PM

Hello,

The link on this thread has been updated as of this post.

feomalkin · October 24, 2022 at 11:57 PM

Yes, just a record or two would be useful...