September 15, 2022 at 12:43 PM
Dumped today 2022-09-15
Contains 98,051 users with vBulletin < v3.8.5 hashes + salts
Contains 98,051 users with vBulletin < v3.8.5 hashes + salts
-- Adminer 4.8.1 MySQL 5.5.5-10.2.37-MariaDB dump
SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT 0,
`username` varchar(100) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`styleid` smallint(5) unsigned NOT NULL DEFAULT 0,
`parentemail` varchar(50) NOT NULL DEFAULT '',
`homepage` varchar(100) NOT NULL DEFAULT '',
`icq` varchar(20) NOT NULL DEFAULT '',
`aim` varchar(20) NOT NULL DEFAULT '',
`yahoo` varchar(32) NOT NULL DEFAULT '',
`usertitle` varchar(250) NOT NULL DEFAULT '',
`customtitle` smallint(6) NOT NULL DEFAULT 0,
`joindate` int(10) unsigned NOT NULL DEFAULT 0,
`daysprune` smallint(6) NOT NULL DEFAULT 0,
`lastvisit` int(10) unsigned NOT NULL DEFAULT 0,
`lastactivity` int(10) unsigned NOT NULL DEFAULT 0,
`lastpost` int(10) unsigned NOT NULL DEFAULT 0,
`posts` int(10) unsigned NOT NULL DEFAULT 0,
`timezoneoffset` varchar(4) NOT NULL DEFAULT '',
`pmpopup` smallint(6) NOT NULL DEFAULT 0,
`avatarid` smallint(6) NOT NULL DEFAULT 0,
`options` int(10) unsigned NOT NULL DEFAULT 33570831,
`birthday` varchar(10) NOT NULL DEFAULT '0000-00-00',
`maxposts` smallint(6) NOT NULL DEFAULT -1,
`startofweek` smallint(6) NOT NULL DEFAULT 1,
`ipaddress` varchar(15) NOT NULL DEFAULT '',
`referrerid` int(10) unsigned NOT NULL DEFAULT 0,
`pmtotal` smallint(5) unsigned NOT NULL DEFAULT 0,
`pmunread` smallint(5) unsigned NOT NULL DEFAULT 0,
`passworddate` date NOT NULL DEFAULT '0000-00-00',
`salt` char(30) NOT NULL DEFAULT '',
`showvbcode` smallint(5) unsigned NOT NULL DEFAULT 0,
`msn` varchar(100) NOT NULL DEFAULT '',
`avatarrevision` int(10) unsigned NOT NULL DEFAULT 0,
`membergroupids` varchar(250) NOT NULL DEFAULT '',
`displaygroupid` smallint(5) unsigned NOT NULL DEFAULT 0,
`reputation` int(11) NOT NULL DEFAULT 10,
`reputationlevelid` int(10) unsigned NOT NULL DEFAULT 1,
`languageid` smallint(5) unsigned NOT NULL DEFAULT 0,
`threadedmode` smallint(5) unsigned NOT NULL DEFAULT 0,
`emailstamp` int(10) unsigned NOT NULL DEFAULT 0,
`autosubscribe` smallint(6) NOT NULL DEFAULT -1,
`birthday_search` date NOT NULL DEFAULT '0000-00-00',
`profilepicrevision` int(10) unsigned NOT NULL DEFAULT 0,
`showbirthday` smallint(5) unsigned NOT NULL DEFAULT 2,
`skype` varchar(32) NOT NULL DEFAULT '',
`adminoptions` int(10) unsigned NOT NULL DEFAULT 0,
`lastpostid` int(10) unsigned NOT NULL DEFAULT 0,
`sigpicrevision` int(10) unsigned NOT NULL DEFAULT 0,
`ipoints` int(10) unsigned NOT NULL DEFAULT 0,
`infractions` int(10) unsigned NOT NULL DEFAULT 0,
`warnings` int(10) unsigned NOT NULL DEFAULT 0,
`infractiongroupids` varchar(255) NOT NULL DEFAULT '',
`infractiongroupid` smallint(5) unsigned NOT NULL DEFAULT 0,
`profilevisits` int(10) unsigned NOT NULL DEFAULT 0,
`friendcount` int(10) unsigned NOT NULL DEFAULT 0,
`friendreqcount` int(10) unsigned NOT NULL DEFAULT 0,
`vmunreadcount` int(10) unsigned NOT NULL DEFAULT 0,
`vmmoderatedcount` int(10) unsigned NOT NULL DEFAULT 0,
`socgroupinvitecount` int(10) unsigned NOT NULL DEFAULT 0,
`socgroupreqcount` int(10) unsigned NOT NULL DEFAULT 0,
`pcunreadcount` int(10) unsigned NOT NULL DEFAULT 0,
`pcmoderatedcount` int(10) unsigned NOT NULL DEFAULT 0,
`gmmoderatedcount` int(10) unsigned NOT NULL DEFAULT 0,
`assetposthash` varchar(32) NOT NULL DEFAULT '',
`fbuserid` varchar(255) NOT NULL,
`fbjoindate` int(10) unsigned NOT NULL DEFAULT 0,
`fbname` varchar(255) NOT NULL,
`logintype` enum('vb','fb') NOT NULL DEFAULT 'vb',
`fbaccesstoken` varchar(255) NOT NULL,
`bloggroupreqcount` int(10) unsigned NOT NULL DEFAULT 0,
`showblogcss` int(11) NOT NULL DEFAULT 1,
`newrepcount` smallint(5) unsigned NOT NULL DEFAULT 0,
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday_search` (`birthday_search`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `posts` (`posts`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`),
KEY `email` (`email`),
KEY `lastactivity` (`lastactivity`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `user` (`userid`, `usergroupid`, `username`, `password`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `posts`, `timezoneoffset`, `pmpopup`, `avatarid`, `options`, `birthday`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `pmtotal`, `pmunread`, `passworddate`, `salt`, `showvbcode`, `msn`, `avatarrevision`, `membergroupids`, `displaygroupid`, `reputation`, `reputationlevelid`, `languageid`, `threadedmode`, `emailstamp`, `autosubscribe`, `birthday_search`, `profilepicrevision`, `showbirthday`, `skype`, `adminoptions`, `lastpostid`, `sigpicrevision`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `bloggroupreqcount`, `showblogcss`, `newrepcount`) VALUES
(1, 6, 'Editor', '817bc26c7f2b1d61f666953e2be99fc7', '[email protected]', 0, '', '', '', '', '', 'Administrators', 0, 1008167160, 30, 1161972140, 1161972120, 1071009478, 12, '-8', 0, 0, 45106775, '04-03-0000', 30, 1, '', 0, 0, 0, '2008-07-22', '5l)', 1, '', 0, '', 0, 10, 5, 0, 0, 0, -1, '0000-00-00', 0, 2, '', 0, 0, 0, 0, 0, 0, '', 0, 1063, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 1, 0),
(2, 6, 'A. Ko', '8f17f87e021ddfa7bdd3454df193c606', '', 0, '', 'http://swordforum.com/', '', '', '', 'Founder of SFI', 1, 1008199920, 0, 1663244090, 1663244333, 1269403662, 2584, '-8', 1, 0, 45772247, '', -1, 1, '', 0, 92, 0, '0000-00-00', 'Y7?', 1, '', 0, '', 0, 10, 5, 0, 0, 0, -1, '0000-00-00', 0, 2, '', 1, 0, 0, 0, 0, 0, '', 0, 41158, 0, 0, 2, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 1, 0),
(21100, 2, 'R Milliron', '5656108bb4c27ba5c2ed694ca50ad294', '[email protected]', 0, '', 'http://', '', '', '', 'Settled in Comfortably', 0, 1135882272, 0, 1136398046, 1136991680, 0, 0, '0', 1, 0, 45108567, '', -1, 1, '24.221.85.153', 0, 0, 0, '0000-00-00', '}0W', 1, '', 0, '', 0, 10, 5, 0, 0, 0, 1, '0000-00-00', 0, 2, '', 0, 0, 0, 0, 0, 0, '', 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 1, 0),
(3, 2, 'Genise Graham', 'fa75d0745a92c2d442d70cf4c3d9d30e', '[email protected]', 0, '', 'http://swordforum.com/', '', 'Bionic Fru', '', 'Editor', 1, 1008228180, 0, 1270748355, 1287270540, 1197264955, 125, '-7', 2, 0, 45637431, '06-17-0000', -1, 1, '64.199.40.118', 0, 101, 2, '2012-04-12', 'rRIM5.\"hC8[in5FElWR[^N.09G6hGP', 1, '', 0, '', 0, 10, 5, 0, 0, 0, 1, '0000-06-17', 0, 2, '', 0, 970928, 0, 0, 0, 0, '', 0, 841, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 1, 0),
(23, 6, 'Matt Goodman', 'a484147f5612806549ad33e0f5ad2978', '[email protected]', 0, '', 'http://www.signet-ring.com', '', '', '', 'SFI Server Administrator', 1, 1014094508, 30, 1252721697, 1253228399, 1252721686, 18, '-10', 0, 0, 45108567, '05-22-1978', 20, 1, '206.126.7.112', 0, 3, 0, '0000-00-00', '3>8', 1, '', 0, '', 0, 10, 5, 0, 0, 0, 1, '1978-05-22', 0, 2, '', 0, 0, 0, 0, 0, 0, '', 0, 623, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 1, 0),
Faces In Disguise

