forums.albiononline.com 300K

[Chucky]

forums.albiononline.com 300K

Dump Date: october 2020
Users Count: ~300k
Hashtype: Double Bcrypt

DROP TABLE IF EXISTS `wcf1_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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','bjoern@protofy.com','$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','JanS@DracoBlue.de','$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,''

To view the content, you need to Sign In or Register.

 

[hdwxsh]

Thanks for sharingThanks for sharing

 

[unicode]

Thanks you for the share

 

[yyyyyyyyyy]

thanks alot mate. i will check it out