R2Games (2017 forum breach)
2017
Domain:
r2games.com
Breach Count:
5,212,579
Region:
Global
Source:
File Size:
196.31 MB
Uncompressed File Size:
1.66 GB
File Count:
9
In 2017, R2Games, an online gaming company, experienced a significant data breach that compromised the personal information of millions of users. The breach exposed usernames, email addresses, and hashed passwords of approximately 5.2 million users. The leaked data was discovered by security researcher, Chris Vickery, and was later published on a hacker forum.
The breach is believed to have occurred through a vulnerability in R2Games website, which allowed attackers to gain unauthorized access to the companys databases. The compromised data was then exfiltrated and made available to other malicious actors.
Leaked Information:
Email
Password
User Name
Website activity
We have loaded this breach into our database.
File List:
R2Games Arabian Forum.sql
R2Games Brazilian Forum.sql
R2Games English Forum.sql
R2Games French Forum.sql
R2Games German Forum.sql
R2Games Russian Forum.sql
R2Games Spanish Forum.sql
R2Games Turkish Forum.sql
R2Games Russian Website.sql
File Content 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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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),
`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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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,'[email protected]',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),