Posts: 810
Threads: 810
Joined: Jul 2023
Jun 08, 2023, 07:04 PM
(This post was last modified: Jun 08, 2023, 07:04 PM by dedale.)
[center]Hello BreachForums Community,[/center]
[center]Today I have uploaded the R2Games (2017 forum breach) Database for you to download, thanks for reading and enjoy![/center]
[center]https://cdn.breachforums.rs/logo/r2games.png[/center]
[center]In early 2017, the forum for the gaming website R2 Games was hacked. R2 had previously appeared on HIBP in 2015 after a prior incident. This one exposed over 1 million unique user accounts and corresponding MD5 password hashes with no salt.[/center]
[center]Compromised data: Email addresses, Passwords, Usernames, Website activity[/center]
[center] [/center]
[right] Database Index <> How To Get Credits[/right]
Posts: 19,946
Threads: 357
Joined: Jun 2023
(Jun 08, 2023, 07:04 PM)dedale Wrote: Hello BreachForums Community,
Today I have uploaded the R2Games (2017 forum breach) Database for you to download, thanks for reading and enjoy!
In early 2017, the forum for the gaming website R2 Games was hacked. R2 had previously appeared on HIBP in 2015 after a prior incident. This one exposed over 1 million unique user accounts and corresponding MD5 password hashes with no salt.
Compromised data: Email addresses, Passwords, Usernames, Website activity
sample: CREATE TABLE `GDN_User` (
`UserID` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`Password` varbinary(100) NOT NULL,
`HashMethod` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
`Photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`Location` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`About` text COLLATE utf8_unicode_ci,
`Email` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`ShowEmail` tinyint(4) NOT NULL DEFAULT '0',
`Gender` enum('u','m','f') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'u',
`CountVisits` int(11) NOT NULL DEFAULT '0',
`CountInvitations` int(11) NOT NULL DEFAULT '0',
`CountNotifications` int(11) DEFAULT NULL,
`InviteUserID` int(11) DEFAULT NULL,
`DiscoveryText` text COLLATE utf8_unicode_ci,
`Preferences` text COLLATE utf8_unicode_ci,
`Permissions` text COLLATE utf8_unicode_ci,
`Attributes` text COLLATE utf8_unicode_ci,
`DateSetInvitations` datetime DEFAULT NULL,
`DateOfBirth` datetime DEFAULT NULL,
`DateFirstVisit` datetime DEFAULT NULL,
`DateLastActive` datetime DEFAULT NULL,
`LastIPAddress` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL,
`AllIPAddresses` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`DateInserted` datetime NOT NULL,
`InsertIPAddress` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL,
`DateUpdated` datetime DEFAULT NULL,
`UpdateIPAddress` varchar(39) COLLATE utf8_unicode_ci DEFAULT NULL,
`HourOffset` int(11) NOT NULL DEFAULT '0',
`Score` float DEFAULT NULL,
`Admin` tinyint(4) NOT NULL DEFAULT '0',
`Verified` tinyint(4) NOT NULL DEFAULT '0',
`Banned` tinyint(4) NOT NULL DEFAULT '0',
`Deleted` tinyint(4) NOT NULL DEFAULT '0',
`Points` int(11) NOT NULL DEFAULT '0',
`CountUnreadConversations` int(11) DEFAULT NULL,
`CountDiscussions` int(11) DEFAULT NULL,
`CountUnreadDiscussions` int(11) DEFAULT NULL,
`CountComments` int(11) DEFAULT NULL,
`CountDrafts` int(11) DEFAULT NULL,
`CountBookmarks` int(11) DEFAULT NULL,
`CountBadges` int(11) NOT NULL DEFAULT '0',
`RankID` int(11) DEFAULT NULL,
`RankProgression` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`UserID`),
KEY `FK_User_Name` (`Name`),
KEY `IX_User_Email` (`Email`),
KEY `IX_User_DateLastActive` (`DateLastActive`),
KEY `IX_User_DateInserted` (`DateInserted`)
) ENGINE=InnoDB AUTO_INCREMENT=14929 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
# TD`GDN_User`utf8_unicode_ci ;
INSERT INTO `GDN_User` VALUES
(1,'root','$P$BEFHEX8RREG4wW2orWplJE3C..eup21','Vanilla',\N,\N,\N,\N,'platform@r2games.com',0,'u',20,0,\N,\N,\N,'a:2:{s:16:\"PreviewThemeName\";s:0:\"\";s:18:\"PreviewThemeFolder\";s:0:\"\";}','','a:1:{s:12:\"TransientKey\";s:12:\"V5VH6N1FRGJF\";}',\N,'1975-09-16 00:00:00','2014-05-28 01:28:48','2015-07-24 05:55:31','218.17.162.82','218.17.158.33,218.17.162.82','2014-05-28 01:28:48','218.17.158.33','2014-05-28 01:28:48',\N,8,\N,1,0,0,0,0,\N,0,\N,0,\N,\N,0,\N,1),
(2,'System','57EC7TKXZ8R2UDRMYTZ3','Random','http://forum.es.r2games.com/applications/dashboard/design/images/usericon.png',\N,\N,\N,'system@domain.com',0,'u',0,0,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,\N,'2014-05-28 01:28:49',\N,\N,\N,0,\N,2,0,0,0,0,\N,0,\N,1,\N,\N,0,\N,1),
(3,'chungegogo','$P$BmtiyHps23IZZO5YXSohl/IPpbffPR0','Vanilla',\N,\N,\N,\N,'59@mail.r2games.com',0,'u',27,0,\N,\N,\N,\N,'','a:4:{s:19:\"ConfirmedEmailRoles\";a:1:{i:0;s:1:\"8\";}s:4:\"Salt\";s:6:\"h1lXAt\";s:9:\"r2_source\";s:7:\"R2Games\";s:12:\"TransientKey\";s:12:\"U602PNWMVI1L\";}',\N,\N,'2014-05-29 08:57:42','2016-03-01 03:58:56','206.161.229.226','206.161.229.226,218.17.162.82','2014-05-29 08:57:42','218.17.162.82',\N,\N,8,\N,0,0,0,0,0,\N,0,\N,0,\N,\N,0,\N,1),
(4,'admin','$P$BuqL6fGhOaqE6kgE1kwGelvsFbFb5U/','Vanilla',\N,\N,\N,\N,'forum@r2games.com',0,'u',59,0,1,\N,\N,'a:2:{s:16:\"PreviewThemeName\";s:0:\"\";s:18:\"PreviewThemeFolder\";s:0:\"\";}','','a:1:{s:12:\"TransientKey\";s:12:\"LC2R4H57JY1C\";}',\N,\N,'2014-05-29 09:03:17','2015-07-29 07:18:15','206.161.229.226','206.161.229.226,218.17.162.82','2014-05-29 09:03:17','218.17.162.82',\N,\N,8,\N,0,0,0,0,0,1,0,\N,0,\N,\N,0,\N,1),
(5,'Satius','312e801d26b1a3e7397528943e842a4a','R2Games',\N,\N,\N,\N,'41881737@mail.r2games.com',0,'u',0,0,\N,\N,\N,\N,'','a:5:{s:8:\"EmailKey\";s:8:\"UZZZYT5I\";s:19:\"ConfirmedEmailRoles\";a:1:{i:0;s:1:\"8\";}s:4:\"Salt\";s:6:\"6IGmBf\";s:9:\"r2_source\";s:7:\"R2Games\";s:12:\"TransientKey\";s:12:\"QVLHTVEWP6JW\";}',\N,\N,'2014-05-29 09:10:39','2014-05-29 09:23:17','223.255.242.73','223.255.242.73','2014-05-29 09:10:39','223.255.242.73',\N,\N,8,\N,0,0,0,0,0,\N,0,\N,0,\N,\N,0,\N,1),
(6,'tokyonana','$P$BN3QosznXC2ae5u30O6iohULM/AS/g.','Vanilla',\N,\N,\N,\N,'73490729@mail.r2games.com',0,'u',50,0,\N,\N,\N,'a:1:{s:17:\"ShowAllCategories\";b:0;}','','a:6:{s:19:\"ConfirmedEmailRoles\";a:1:{i:0;s:1:\"8\";}s:4:\"Salt\";s:6:\"NqOZXK\";s:9:\"r2_source\";s:7:\"R2Games\";s:12:\"TransientKey\";s:12:\"TIKRA16KBBAY\";s:24:\"CountDiscussionSpamCheck\";i:1;s:23:\"DateDiscussionSpamCheck\";s:19:\"2015-07-29 07:22:30\";}',\N,\N,'2014-06-10 09:22:17','2015-07-29 09:38:32','206.161.229.226','206.161.229.226,223.255.242.73','2014-06-10 09:22:17','223.255.242.73',\N,\N,8,\N,0,0,0,0,0,\N,0,\N,0,\N,\N,0,\N,1),
(7,'Bythewind','bc6fb86ec9fa6bf5a1e2ceae124f6884','R2Games',\N,\N,\N,\N,'18061231@mail.r2games.com',0,'u',9,0,\N,\N,\N,\N,'','a:4:{s:19:\"ConfirmedEmailRoles\";a:1:{i:0;s:1:\"8\";}s:4:\"Salt\";s:6:\"iT2EiD\";s:9:\"r2_source\";s:7:\"R2Games\";s:12:\"TransientKey\";s:12:\"QASAS8KWDP8T\";}',\N,\N,'2014-06-10 09:23:48','2014-07-07 06:34:09','223.255.242.73','113.108.221.36,218.17.162.82,223.255.242.73','2014-06-10 09:23:48','113.108.221.36',\N,\N,8,\N,0,0,0,0,0,\N,0,\N,0,\N,\N,0,\N,1),
(8,'Bigfoot77','e6efbc52e422bed0d3f1d00552521760','R2Games',\N,\N,\N,\N,'17077223@mail.r2games.com',0,'u',1,0,\N,\N,\N,\N,'','a:5:{s:8:\"EmailKey\";s:8:\"41AXV8HT\";s:19:\"ConfirmedEmailRoles\";a:1:{i:0;s:1:\"8\";}s:4:\"Salt\";s:6:\"loOCMy\";s:9:\"r2_source\";s:7:\"R2Games\";s:12:\"TransientKey\";s:12:\"NUEB01PDJ42Y\";}',\N,\N,'2014-06-12 08:25:47','2014-06-12 08:54:53','223.255.242.73','223.255.242.73','2014-06-12 08:25:47','223.255.242.73',\N,\N,8,\N,0,0,0,0,0,\N,0,\N,0,\N,\N,0,\N,1),
(9,'R2_Melissa','$P$B3lZ6j01SAoYjBIhwwgf2Nl8Aaa5zY0','Vanilla','userpics/430/14HAISUTKNFI.jpg',\N,\N,\N,'melissa@r2games.com',0,'u',287,0,11,\N,\N,'a:1:{s:17:\"ShowAllCategories\";b:0;}','','a:3:{s:12:\"TransientKey\";s:12:\"EKWU8NROIZA3\";s:15:\"CheckedComments\";a:0:{}s:18:\"CheckedDiscussions\";a:0:{}}',\N,\N,'2014-06-17 02:00:46','2016-02-22 10:02:58','218.17.162.82','218.17.162.82,223.255.242.73','2014-06-17 02:00:46','223.255.242.73','2014-12-20 01:29:23','223.255.242.73',8,\N,0,0,0,0,0,10,21,\N,22,3,\N,0,\N,1),
(10,'R2_Dani','$P$BJg7bqVd3etudd4AbyDxQ8Hs29657P1','Vanilla','userpics/778/FMAPKV0371SX.gif',\N,\N,\N,'daniela@r2games.com',0,'f',580,0,7,\N,\N,'a:11:{s:17:\"ShowAllCategories\";b:1;s:17:\"Popup.WallComment\";s:1:\"1\";s:21:\"Popup.ActivityComment\";s:1:\"1\";s:25:\"Email.ConversationMessage\";s:1:\"1\";s:25:\"Popup.ConversationMessage\";s:1:\"1\";s:21:\"Email.BookmarkComment\";b:0;s:23:\"Popup.DiscussionComment\";b:0;s:21:\"Popup.BookmarkComment\";s:1:\"1\";s:13:\"Popup.Mention\";s:1:\"1\";s:19:\"Email.RankPromotion\";b:0;s:19:\"Popup.RankPromotion\";s:1:\"1\";}','','a:2:{s:12:\"TransientKey\";s:12:\"IOT1M23CZSMO\";s:18:\"CheckedDiscussions\";a:0:{}}',\N,\N,'2014-06-17 03:14:36','2015-04-13 07:51:36','107.150.56.170','107.150.56.170,223.255.242.73','2014-06-17 03:14:36','223.255.242.73','2015-01-06 08:58:50','199.217.118.85',8,\N,0,0,0,0,0,4,68,\N,93,1,1,0,\N,1),
(11,'wolfchen','c70614af9eabae7a1d5880b80bb7f7ae','R2Games',\N,\N,\N,\N,'5013617@mail.r2games.com',0,'u',1,0,\N,\N,\N,\N,'','a:4:{s:19:\"ConfirmedEmailRoles\";a:1:{i:0;s:1:\"8\";}s:4:\"Salt\";s:6:\"0WKwaD\";s:9:\"r2_source\";s:7:\"R2Games\";s:12:\"TransientKey\";s:12:\"63I7JXAS1RNS\";}',\N,\N,'2014-06-19 09:06:43','2014-07-22 09:56:18','218.17.158.33','218.17.158.33,223.255.242.73','2014-06-19 09:06:43','223.255.242.73',\N,\N,0,\N,0,0,0,0,0,\N,0,\N,0,\N,\N,0,\N,1),
(12,'syncforumes','e56bb3cfe31b911eadc0f22a9c71dcb8','R2Games',\N,\N,\N,\N,'81101597@mail.r2games.com',0,'u',0,0,\N,\N,\N,\N,'','a:5:{s:8:\"EmailKey\";s:8:\"PJSEXN5R\";s:19:\"ConfirmedEmailRoles\";a:1:{i:0;s:1:\"8\";}s:4:\"Salt\";s:6:\"iEU9SS\";s:9:\"r2_source\";s:7:\"R2Games\";s:12:\"TransientKey\";s:12:\"UWNZVPF6NL7M\";}',\N,\N,'2014-06-20 09:35:23','2014-06-20 09:35:23','218.17.158.33','218.17.158.33','2014-06-20 09:35:23','218.17.158.33',\N,\N,8,\N,0,0,0,0,0,\N,0,\N,0,\N,\N,0,\N,1),
(13,'syncforum','0b9ed26be02b68fa8c3d18638dcb7928','R2Games',\N,\N,\N,\N,'syncforum@g.com',0,'u',0,0,\N,\N,\N,\N,'','a:5:{s:8:\"EmailKey\";s:8:\"1NDBYSII\";s:19:\"ConfirmedEmailRoles\";a:1:{i:0;s:1:\"8\";}s:4:\"Salt\";s:6:\"CJlRR1\";s:9:\"r2_source\";s:7:\"R2Games\";s:12:\"TransientKey\";s:12:\"ZMX5BZICC1YW\";}',\N,\N,'2014-06-20 09:54:59','2014-06-20 09:54:59','218.17.162.82','218.17.162.82','2014-06-20 09:54:59','218.17.162.82',\N,\N,8,\N,0,0,0,0,0,\N,0,\N,0,\N,\N,0,\N,1),
Posts: 9
Threads: 0
Joined: Jul 2024
Posts: 10
Threads: 0
Joined: Mar 2025
Diving into the R2Games 2017 breach time to review the past
|