Albion Online Database
Oct 2020
Domain:
forums.albiononline.com
Breach Count:
292,587
Region:
Global
News Report:
Leak from:
File Size:
28.63 MB
Uncompressed File Size:
78.14 MB
File Count:
1
The Albion Online database leak occurred in 2020, where an unauthorized party gained access to the games database and stole 292,587 records. The leaked information includes player data such as usernames, email addresses, and passwords, which were stored in plain text. This means that hackers can easily decode the passwords and gain access to compromised accounts.
The leaked data also includes player information such as character names, guild affiliations, and transactional data, including in-game purchases and exchanges. The leak also revealed sensitive information about game mechanics and market pricing, which could be used for malicious purposes such as market manipulation.
The security breach is believed to have occurred due to a vulnerability in the games authentication system, which was exploited by the hackers. The game developers, Sandbox Interactive, acknowledged the breach and assured players that they are working to contain the damage and prevent future breaches.
Leaked Information:
User Name
Email
Password
IP Address
We have loaded this breach into our database.
File List:
albion_online_forums.sql
File Content Sample:
CREATE TABLE `wcf1_user` (
`userID` int(10) NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`accessToken` char(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`languageID` int(10) NOT NULL DEFAULT '0',
`registrationDate` int(10) NOT NULL DEFAULT '0',
`styleID` int(10) NOT NULL DEFAULT '0',
`banned` tinyint(1) NOT NULL DEFAULT '0',
`banReason` mediumtext COLLATE utf8_unicode_ci,
`banExpires` int(10) NOT NULL DEFAULT '0',
`activationCode` int(10) NOT NULL DEFAULT '0',
`lastLostPasswordRequestTime` int(10) NOT NULL DEFAULT '0',
`lostPasswordKey` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`lastUsernameChange` int(10) NOT NULL DEFAULT '0',
`newEmail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`oldUsername` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`quitStarted` int(10) NOT NULL DEFAULT '0',
`reactivationCode` int(10) NOT NULL DEFAULT '0',
`registrationIpAddress` varchar(39) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`avatarID` int(10) DEFAULT NULL,
`disableAvatar` tinyint(1) NOT NULL DEFAULT '0',
`disableAvatarReason` text COLLATE utf8_unicode_ci,
`disableAvatarExpires` int(10) NOT NULL DEFAULT '0',
`enableGravatar` tinyint(1) NOT NULL DEFAULT '0',
`gravatarFileExtension` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`signature` text COLLATE utf8_unicode_ci,
`signatureEnableBBCodes` tinyint(1) NOT NULL DEFAULT '1',
`signatureEnableHtml` tinyint(1) NOT NULL DEFAULT '0',
`signatureEnableSmilies` tinyint(1) NOT NULL DEFAULT '1',
`disableSignature` tinyint(1) NOT NULL DEFAULT '0',
`disableSignatureReason` text COLLATE utf8_unicode_ci,
`disableSignatureExpires` int(10) NOT NULL DEFAULT '0',
`lastActivityTime` int(10) NOT NULL DEFAULT '0',
`profileHits` int(10) NOT NULL DEFAULT '0',
`rankID` int(10) DEFAULT NULL,
`userTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`userOnlineGroupID` int(10) DEFAULT NULL,
`activityPoints` int(10) NOT NULL DEFAULT '0',
`notificationMailToken` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`authData` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`likesReceived` mediumint(7) NOT NULL DEFAULT '0',
`socialNetworkPrivacySettings` text COLLATE utf8_unicode_ci,
`wbbPosts` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`userID`),
KEY `username` (`username`),
KEY `registrationDate` (`registrationDate`),
KEY `styleID` (`styleID`),
KEY `activationCode` (`activationCode`),
KEY `registrationData` (`registrationIpAddress`,`registrationDate`),
KEY `activityPoints` (`activityPoints`),
KEY `likesReceived` (`likesReceived`),
KEY `9b09180ae281646112d44b9aa2fc5048_fk` (`avatarID`),
KEY `b9271ea6487420ab6ca3153da2379a0f_fk` (`rankID`),
KEY `9fe2b1b2816319e14e168cdaa92175e7_fk` (`userOnlineGroupID`),
KEY `wbbPosts` (`wbbPosts`),
KEY `authData` (`authData`),
KEY `email` (`email`),
CONSTRAINT `9b09180ae281646112d44b9aa2fc5048_fk` FOREIGN KEY (`avatarID`) REFERENCES `wcf1_user_avatar` (`avatarID`) ON DELETE SET NULL,
CONSTRAINT `9fe2b1b2816319e14e168cdaa92175e7_fk` FOREIGN KEY (`userOnlineGroupID`) REFERENCES `wcf1_user_group` (`groupID`) ON DELETE SET NULL,
CONSTRAINT `b9271ea6487420ab6ca3153da2379a0f_fk` FOREIGN KEY (`rankID`) REFERENCES `wcf1_user_rank` (`rankID`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=293291 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wcf1_user`
--
LOCK TABLES `wcf1_user` WRITE;
/*!40000 ALTER TABLE `wcf1_user` DISABLE KEYS */;
INSERT INTO `wcf1_user` VALUES (1,'SuperAdmin','[email protected]','$2a$08$wfvBWyna2kGDEcXETw4YaO94ZR13W7ZKVcl2ptREKpQUPHxoD01Xu','97167f3fda7003ceedcef6860a61272859942b4a',2,1442354755,0,0,'',0,0,0,'',0,'','',0,0,'',NULL,0,'',0,0,'','',1,0,1,0,'',0,1508779580,6678,1,';',4,0,'','',0,'',0),(2,'JanS','[email protected]','$2a$08$fcV1Rc9ULcsXdHZo0V4LN.JOEvzXvI0pyWJFhr0QS4.v/4eWmtlsO','35d04de8d17b1b77b33cd2a19335fca4901c0e74',2,1385849897,0,0,'',0,0,0,'',0,'','',0,0,'',NULL,0,'',0,0,'jpg','',1,0,1,0,'',0,1405891498,3,12,';',3,0,'','',0,NULL,0),(3,'root','[email protected]','smf2:0a2085ad2a5e75b1f0349a9ec75c86859bb5343e:b341','f2d0631fc4107d7a724db9ecb39fde47811c799b',2,1358775699,0,0,'',0,0,0,'',0,'','',0,0,'88.75.92.29',NULL,0,'',0,0,'','',1,0,1,0,'',0,1360508089,2124,12,';',3,0,'','',0,NULL,0),(4,'Bercilak','[email protected]','$2a$08$2AlYHZC/qeRVYUx9pMcZCu4pnWGReZCOVaiTBwspjKvp.Asth.bF2','831188a937a213a65f885c6138ea2149ca62e844',2,1358776290,0,0,'',0,0,0,'',0,'','',0,0,'87.189.116.1',6,0,'',0,0,'','',1,0,1,0,'',0,1531587885,75250,10,'Founder;1',7,19218,'','',6816,NULL,2341),(5,'Merdian','[email protected]','$2a$08$wXn2wpeOSy39dUc7Kebah.Rsby4zSsZL1ygWACtdpXO17dMaNTqQq','184b6689253e2ac25f73fdee8c09ed3f23a06a3a',2,1358777089,0,0,'',0,0,0,'',0,'','',0,0,'79.248.91.103',NULL,0,'',0,0,'','',1,0,1,0,'',0,1389304585,847,12,';',3,30,'','',0,NULL,2),(6,'michaelm','[email protected]','$2a$08$BMuqNcDRUZXqp7kCILlpFOJ3w0BZeIhgNBZJWJ2qHPcFn.ShtIQ3S','64aa74e2eecb8bdbf6f62fdd6243fe4a6c0f6501',2,1358876398,0,0,'',0,0,0,'',0,'','',0,0,'86.25.58.42',NULL,0,'',0,0,'','',1,0,1,0,'',0,1451670848,716,12,';',3,50,'','',0,NULL,6),(12,'arrisb','[email protected]','$2a$08$K0fQWdSzwCqVr5dlN.jVCePOp6CqLq59WUBHhWLP2KdzaD6IoKIT.','51fd88a5f797599597524aba1671245df557f262',2,1362391713,0,0,NULL,0,0,0,'',0,'','',0,0,'46.65.118.28',NULL,0,NULL,0,0,'','',1,0,1,0,NULL,0,1477136480,64,12,';1',3,5,'','',0,NULL,1),(13,'MadDave','[email protected]','$2a$08$X2dLlnOlJW1qjWTL/85/uOEyWuDVCzEuZeOlc6QHWksC3uULfFuay','f8c14f4be1f6344913fac13ed4b9871fe3fa7c29',2,1362481223,0,0,'',0,0,0,'',0,'','',0,0,'84.189.173.127',13,0,'',0,0,'','',1,0,1,0,'',0,1565622819,12175,11,'Tech Lead;',8,912,'','',197,NULL,141),(14,'flasher213','[email protected]','smf2:eceb19f7c6dc15792ffece6864bf4ac0b5be11cd:d775','02fa463de7dd182431f8a5877b57f65478b381c7',2,1362482001,0,0,NULL,0,0,0,'',0,'','',0,0,'91.61.64.71',NULL,0,NULL,0,0,'','',1,0,1,0,NULL,0,0,150,12,';',3,0,'','',0,NULL,0),
`userID` int(10) NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`accessToken` char(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`languageID` int(10) NOT NULL DEFAULT '0',
`registrationDate` int(10) NOT NULL DEFAULT '0',
`styleID` int(10) NOT NULL DEFAULT '0',
`banned` tinyint(1) NOT NULL DEFAULT '0',
`banReason` mediumtext COLLATE utf8_unicode_ci,
`banExpires` int(10) NOT NULL DEFAULT '0',
`activationCode` int(10) NOT NULL DEFAULT '0',
`lastLostPasswordRequestTime` int(10) NOT NULL DEFAULT '0',
`lostPasswordKey` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`lastUsernameChange` int(10) NOT NULL DEFAULT '0',
`newEmail` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`oldUsername` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`quitStarted` int(10) NOT NULL DEFAULT '0',
`reactivationCode` int(10) NOT NULL DEFAULT '0',
`registrationIpAddress` varchar(39) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`avatarID` int(10) DEFAULT NULL,
`disableAvatar` tinyint(1) NOT NULL DEFAULT '0',
`disableAvatarReason` text COLLATE utf8_unicode_ci,
`disableAvatarExpires` int(10) NOT NULL DEFAULT '0',
`enableGravatar` tinyint(1) NOT NULL DEFAULT '0',
`gravatarFileExtension` varchar(3) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`signature` text COLLATE utf8_unicode_ci,
`signatureEnableBBCodes` tinyint(1) NOT NULL DEFAULT '1',
`signatureEnableHtml` tinyint(1) NOT NULL DEFAULT '0',
`signatureEnableSmilies` tinyint(1) NOT NULL DEFAULT '1',
`disableSignature` tinyint(1) NOT NULL DEFAULT '0',
`disableSignatureReason` text COLLATE utf8_unicode_ci,
`disableSignatureExpires` int(10) NOT NULL DEFAULT '0',
`lastActivityTime` int(10) NOT NULL DEFAULT '0',
`profileHits` int(10) NOT NULL DEFAULT '0',
`rankID` int(10) DEFAULT NULL,
`userTitle` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`userOnlineGroupID` int(10) DEFAULT NULL,
`activityPoints` int(10) NOT NULL DEFAULT '0',
`notificationMailToken` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`authData` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`likesReceived` mediumint(7) NOT NULL DEFAULT '0',
`socialNetworkPrivacySettings` text COLLATE utf8_unicode_ci,
`wbbPosts` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`userID`),
KEY `username` (`username`),
KEY `registrationDate` (`registrationDate`),
KEY `styleID` (`styleID`),
KEY `activationCode` (`activationCode`),
KEY `registrationData` (`registrationIpAddress`,`registrationDate`),
KEY `activityPoints` (`activityPoints`),
KEY `likesReceived` (`likesReceived`),
KEY `9b09180ae281646112d44b9aa2fc5048_fk` (`avatarID`),
KEY `b9271ea6487420ab6ca3153da2379a0f_fk` (`rankID`),
KEY `9fe2b1b2816319e14e168cdaa92175e7_fk` (`userOnlineGroupID`),
KEY `wbbPosts` (`wbbPosts`),
KEY `authData` (`authData`),
KEY `email` (`email`),
CONSTRAINT `9b09180ae281646112d44b9aa2fc5048_fk` FOREIGN KEY (`avatarID`) REFERENCES `wcf1_user_avatar` (`avatarID`) ON DELETE SET NULL,
CONSTRAINT `9fe2b1b2816319e14e168cdaa92175e7_fk` FOREIGN KEY (`userOnlineGroupID`) REFERENCES `wcf1_user_group` (`groupID`) ON DELETE SET NULL,
CONSTRAINT `b9271ea6487420ab6ca3153da2379a0f_fk` FOREIGN KEY (`rankID`) REFERENCES `wcf1_user_rank` (`rankID`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=293291 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `wcf1_user`
--
LOCK TABLES `wcf1_user` WRITE;
/*!40000 ALTER TABLE `wcf1_user` DISABLE KEYS */;
INSERT INTO `wcf1_user` VALUES (1,'SuperAdmin','[email protected]','$2a$08$wfvBWyna2kGDEcXETw4YaO94ZR13W7ZKVcl2ptREKpQUPHxoD01Xu','97167f3fda7003ceedcef6860a61272859942b4a',2,1442354755,0,0,'',0,0,0,'',0,'','',0,0,'',NULL,0,'',0,0,'','',1,0,1,0,'',0,1508779580,6678,1,';',4,0,'','',0,'',0),(2,'JanS','[email protected]','$2a$08$fcV1Rc9ULcsXdHZo0V4LN.JOEvzXvI0pyWJFhr0QS4.v/4eWmtlsO','35d04de8d17b1b77b33cd2a19335fca4901c0e74',2,1385849897,0,0,'',0,0,0,'',0,'','',0,0,'',NULL,0,'',0,0,'jpg','',1,0,1,0,'',0,1405891498,3,12,';',3,0,'','',0,NULL,0),(3,'root','[email protected]','smf2:0a2085ad2a5e75b1f0349a9ec75c86859bb5343e:b341','f2d0631fc4107d7a724db9ecb39fde47811c799b',2,1358775699,0,0,'',0,0,0,'',0,'','',0,0,'88.75.92.29',NULL,0,'',0,0,'','',1,0,1,0,'',0,1360508089,2124,12,';',3,0,'','',0,NULL,0),(4,'Bercilak','[email protected]','$2a$08$2AlYHZC/qeRVYUx9pMcZCu4pnWGReZCOVaiTBwspjKvp.Asth.bF2','831188a937a213a65f885c6138ea2149ca62e844',2,1358776290,0,0,'',0,0,0,'',0,'','',0,0,'87.189.116.1',6,0,'',0,0,'','',1,0,1,0,'',0,1531587885,75250,10,'Founder;1',7,19218,'','',6816,NULL,2341),(5,'Merdian','[email protected]','$2a$08$wXn2wpeOSy39dUc7Kebah.Rsby4zSsZL1ygWACtdpXO17dMaNTqQq','184b6689253e2ac25f73fdee8c09ed3f23a06a3a',2,1358777089,0,0,'',0,0,0,'',0,'','',0,0,'79.248.91.103',NULL,0,'',0,0,'','',1,0,1,0,'',0,1389304585,847,12,';',3,30,'','',0,NULL,2),(6,'michaelm','[email protected]','$2a$08$BMuqNcDRUZXqp7kCILlpFOJ3w0BZeIhgNBZJWJ2qHPcFn.ShtIQ3S','64aa74e2eecb8bdbf6f62fdd6243fe4a6c0f6501',2,1358876398,0,0,'',0,0,0,'',0,'','',0,0,'86.25.58.42',NULL,0,'',0,0,'','',1,0,1,0,'',0,1451670848,716,12,';',3,50,'','',0,NULL,6),(12,'arrisb','[email protected]','$2a$08$K0fQWdSzwCqVr5dlN.jVCePOp6CqLq59WUBHhWLP2KdzaD6IoKIT.','51fd88a5f797599597524aba1671245df557f262',2,1362391713,0,0,NULL,0,0,0,'',0,'','',0,0,'46.65.118.28',NULL,0,NULL,0,0,'','',1,0,1,0,NULL,0,1477136480,64,12,';1',3,5,'','',0,NULL,1),(13,'MadDave','[email protected]','$2a$08$X2dLlnOlJW1qjWTL/85/uOEyWuDVCzEuZeOlc6QHWksC3uULfFuay','f8c14f4be1f6344913fac13ed4b9871fe3fa7c29',2,1362481223,0,0,'',0,0,0,'',0,'','',0,0,'84.189.173.127',13,0,'',0,0,'','',1,0,1,0,'',0,1565622819,12175,11,'Tech Lead;',8,912,'','',197,NULL,141),(14,'flasher213','[email protected]','smf2:eceb19f7c6dc15792ffece6864bf4ac0b5be11cd:d775','02fa463de7dd182431f8a5877b57f65478b381c7',2,1362482001,0,0,NULL,0,0,0,'',0,'','',0,0,'91.61.64.71',NULL,0,NULL,0,0,'','',1,0,1,0,NULL,0,0,150,12,';',3,0,'','',0,NULL,0),