In July 2022, the Direct Download Community ExVagos suffered a data breach that impacted 2.1 million members. The breach included Usernames, Email addresses, Dates of birth, IP Addresses and Passwords stored as vBulletin hashes.
Sample:
Compromised data: Usernames, Email addresses, Dates of birth, IP Addresses, Passwords
Sample:
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`usergroupid` smallint(5) unsigned NOT NULL DEFAULT 0,
`membergroupids` char(250) NOT NULL DEFAULT '',
`displaygroupid` smallint(5) unsigned NOT NULL DEFAULT 0,
`username` varchar(100) NOT NULL DEFAULT '',
`password` char(32) NOT NULL DEFAULT '',
`passworddate` date NOT NULL DEFAULT '1000-01-01',
`email` char(100) NOT NULL DEFAULT '',
`styleid` smallint(5) unsigned NOT NULL DEFAULT 0,
`parentemail` char(50) NOT NULL DEFAULT '',
`homepage` char(100) NOT NULL DEFAULT '',
`icq` char(20) NOT NULL DEFAULT '',
`aim` char(20) NOT NULL DEFAULT '',
`yahoo` char(32) NOT NULL DEFAULT '',
`msn` char(100) NOT NULL DEFAULT '',
`skype` char(32) NOT NULL DEFAULT '',
`showvbcode` smallint(5) unsigned NOT NULL DEFAULT 0,
`showbirthday` smallint(5) unsigned NOT NULL DEFAULT 2,
`usertitle` char(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,
`lastpostid` int(10) unsigned NOT NULL DEFAULT 0,
`posts` int(10) unsigned NOT NULL DEFAULT 0,
`reputation` int(11) NOT NULL DEFAULT 10,
`reputationlevelid` int(10) unsigned NOT NULL DEFAULT 1,
`timezoneoffset` char(4) NOT NULL DEFAULT '',
`pmpopup` smallint(6) NOT NULL DEFAULT 0,
`avatarid` smallint(6) NOT NULL DEFAULT 0,
`avatarrevision` int(10) unsigned NOT NULL DEFAULT 0,
`profilepicrevision` int(10) unsigned NOT NULL DEFAULT 0,
`sigpicrevision` int(10) unsigned NOT NULL DEFAULT 0,
`options` int(10) unsigned NOT NULL DEFAULT 15,
`birthday` char(10) NOT NULL DEFAULT '',
`birthday_search` date NOT NULL DEFAULT '1000-01-01',
`maxposts` smallint(6) NOT NULL DEFAULT -1,
`startofweek` smallint(6) NOT NULL DEFAULT 1,
`ipaddress` varchar(45) NOT NULL DEFAULT '',
`referrerid` int(10) unsigned NOT NULL DEFAULT 0,
`languageid` smallint(5) unsigned NOT NULL DEFAULT 0,
`emailstamp` int(10) unsigned NOT NULL DEFAULT 0,
`threadedmode` smallint(5) unsigned NOT NULL DEFAULT 0,
`autosubscribe` smallint(6) NOT NULL DEFAULT -1,
`pmtotal` smallint(5) unsigned NOT NULL DEFAULT 0,
`pmunread` smallint(5) unsigned NOT NULL DEFAULT 0,
`salt` char(30) NOT NULL DEFAULT '',
`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,
`adminoptions` int(10) 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,
`post_thanks_user_amount` int(10) unsigned NOT NULL DEFAULT 0,
`post_thanks_thanked_posts` int(10) unsigned NOT NULL DEFAULT 0,
`post_thanks_thanked_times` int(10) unsigned NOT NULL DEFAULT 0,
`vbseo_likes_in` int(10) unsigned NOT NULL DEFAULT 0,
`vbseo_likes_out` int(10) unsigned NOT NULL DEFAULT 0,
`vbseo_likes_unread` int(10) unsigned NOT NULL DEFAULT 0,
`invitation` int(10) unsigned NOT NULL DEFAULT 100,
`caninvitation` tinyint(3) unsigned NOT NULL DEFAULT 1,
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`)
) ENGINE=InnoDB AUTO_INCREMENT=2124397 DEFAULT CHARSET=latin1;
INSERT INTO `user` (`userid`, `usergroupid`, `membergroupids`, `displaygroupid`, `username`, `password`, `passworddate`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `msn`, `skype`, `showvbcode`, `showbirthday`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `lastpostid`, `posts`, `reputation`, `reputationlevelid`, `timezoneoffset`, `pmpopup`, `avatarid`, `avatarrevision`, `profilepicrevision`, `sigpicrevision`, `options`, `birthday`, `birthday_search`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `languageid`, `emailstamp`, `threadedmode`, `autosubscribe`, `pmtotal`, `pmunread`, `salt`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `adminoptions`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `post_thanks_user_amount`, `post_thanks_thanked_posts`, `post_thanks_thanked_times`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`, `invitation`, `caninvitation`) VALUES
(1, 19, '', 0, 'ELvictor', '695a2850a68813e99b5da20e5f38742b', '2008-09-15', 'elvictor@exvagos.es', 0, '', '', '', '', '', '', '', 2, 3, 'Miembro fundador', 1, 1221449580, 0, 1658167151, 1658349585, 1636987761, 6396850, 12155, 669467, 15, 2, 1, 0, 4, 1, 3, 60296791, '12-10-0000', '0000-12-10', -1, 2, '', 0, 3, 1618864035, 0, 0, 6, 0, 'c_k', 0, 0, 0, '', 0, 0, 10747, 101, 0, 0, 0, 0, 0, 0, 0, 0, 41949, 11878, 132964, 0, 0, 0, 100, 1)
,(2, 16, '', 0, 'acozme', 'c9fca2b136e88cd10db7de861a720ecb', '2012-02-10', 'andrescozme@hotmail.com', 0, '', '', '', '', '', '', '', 1, 3, 'Colaborador', 1, 1221485460, 0, 1597961819, 1647974331, 1355494020, 2172969, 681, 52666, 15, 1, 1, 0, 4, 1, 0, 35130583, '08-17-1979', '1979-08-17', -1, 1, '201.221.13.42', 0, 0, 0, 0, -1, 304, 0, 'KlB', 0, 0, 0, '', 0, 0, 9426, 10, 25, 0, 0, 0, 0, 0, 0, 0, 499, 564, 10564, 0, 0, 0, 100, 1)
,(3, 9, '', 0, 'Anatevka', '56c5e28ba343dff507929c56c7502347', '2008-09-15', 'Ani-Bond@hotmail.com', 0, '', 'http://anatevka-lanave.blogspot.com', '', '', '', '', '', 1, 0, 'Permisos Limitados', 0, 1221496980, 0, 1227721949, 1247271055, 1223334637, 11022, 2, 90, 6, 1, 0, 0, 3, 0, 0, 45091927, '', '1000-01-01', -1, -1, '190.30.80.127', 0, 0, 0, 0, -1, 4, 0, 've_', 0, 0, 0, '', 0, 3, 140, 6, 0, 0, 0, 0, 0, 0, 0, 0, 7, 2, 28, 0, 0, 0, 100, 1)
,(6, 8, 1, 1, 'jmm00044', 'd4c7de9acd6d4f73b21fae6a5b85d895', '2008-09-17', '', 0, '', '', '', '', '', '', '', 1, 3, 'Guest', 0, 1221576300, -1, 1346259749, 1346259749, 1288521960, 1042827, 6450, 222567, 15, 1, 1, 0, 3, 1, 0, 45616327, '', '1000-01-01', -1, 1, '', 0, 0, 1288282957, 0, -1, 10, 1, 'L%3', 200, 1, 0, '', 0, 0, 9068, 13, 0, 1, 0, 0, 0, 0, 0, 0, 8638, 5091, 44347, 0, 0, 0, 100, 1)
,(7, 16, '', 0, 'zazi', 'be38d6f7a8ad64d51a0d1f300f7ba18d', '2008-09-23', 'sasisoto@tripod.de', 0, '', '', '', '', '', '', '', 2, 3, 'Colaborador', 0, 1221586260, -1, 1278128863, 1281782630, 1274541929, 794976, 4377, 121936, 15, 1, 0, 0, 3, 1, 0, 45616855, '09-30-1967', '1967-09-30', -1, 2, '', 0, 0, 1224053327, 0, 0, 132, 7, 'ebf', 0, 0, 0, '', 0, 0, 1921, 21, 3, 27, 0, 0, 0, 0, 0, 0, 14771, 4052, 24398, 0, 0, 0, 100, 1)
,(8, 16, '', 0, 'Karl Bartos', 'a34896375d93bbeed84c4dcc96f11597', '2008-09-22', 'jurgenneunbauer@gmail.com', 0, '', '', '', '', '', '', '', 1, 3, 'Colaborador', 0, 1221611280, -1, 1658004418, 1658354786, 1643553167, 6643438, 2752, 76795, 15, 1, 1, 0, 3, 0, 1, 45096919, '05-31-1952', '1952-05-31', -1, 1, '', 0, 0, 1612794428, 0, -1, 68, 0, '6kj', 4294967295, 4294967295, 0, '', 0, 0, 2375, 18, 0, 0, 0, 0, 0, 0, 0, 0, 6392, 2500, 15407, 0, 0, 0, 93, 1)
,(9, 16, '', 16, 'hobbit33', 'db904edf60d0aa3800d4ca6c02f88a55', '2008-10-04', 'hobbit.delacomarca@gmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Colaborador', 0, 1221702300, -1, 1289269002, 1291299908, 1288480872, 1042445, 6730, 184108, 15, -4, 2, 0, 5, 0, 0, 45621207, '01-27-1971', '1971-01-27', 10, 1, '', 0, 0, 1283262641, 0, 1, 46, 45, 'P\"p', 0, 0, 0, '', 0, 0, 3966, 56, 1, 26, 0, 0, 0, 0, 0, 0, 30322, 5565, 36291, 0, 0, 0, 100, 1)
,(10, 16, '', 0, 'angel8386', 'b4c7b00395787d0b52ccfe08bc2225ad', '2009-09-17', 'zeratul_4@hotmail.com', 0, '', '', '', '', 'imperator_4@hotmail.com', 'zeratul_4@hotmail.com', 'angel21047', 1, 2, 'Colaborador', 0, 1221737880, 0, 1376742082, 1587340271, 1376739994, 2728351, 7505, 99055, 15, -8, 1, 0, 12, 1, 2, 45620695, '03-08-1986', '1986-03-08', -1, 2, '', 0, 0, 1287289457, 0, -1, 82, 0, '8~Q', 0, 0, 0, '', 0, 0, 2612, 71, 1, 5, 0, 0, 0, 0, 0, 0, 15205, 5132, 19810, 0, 0, 0, 100, 1)
,(11, 16, '', 0, 'Salvador Perez', '1473ab9cf4845a24ccef18ab9e13e692', '2011-08-27', 'salvadorperez@exvagos.es', 0, '', '', '', '', '', 'samper66@hotmail.com', '', 1, 2, 'Colaborador', 0, 1221737940, -1, 1577631940, 1577655802, 1517373617, 3816584, 4997, 248447, 15, 1, 2, 0, 3, 0, 0, 45616983, '11-06-1959', '1959-11-06', -1, -1, '', 0, 0, 1465752345, 0, 0, 126, 3, '4(;', 0, 0, 0, '', 0, 0, 4402, 63, 0, 1, 0, 0, 0, 0, 0, 0, 10160, 4851, 49713, 0, 0, 0, 100, 1)
,(13, 9, '', 0, 'Retirado13', 'bf8389f25e5b7d224f3d805a6821ec22', '2008-09-20', 'viktor10_4@EXhotmail.com', 0, '', '', '', '', '', '', '', 0, 0, 'Pedido de baja', 2, 1221754440, -1, 1313012345, 1331422680, 1224357720, 0, 22, 180, 15, 1, 0, 0, 1, 1, 0, 33555520, '', '1000-01-01', -1, 2, '', 0, 0, 1223138166, 0, -1, 9, 0, '$TP', 0, 0, 0, '', 0, 0, 120, 0, 1, 0, 0, 0, 0, 0, 0, 0, 21, 14, 39, 0, 0, 0, 100, 1)
,(14, 16, '', 0, 'Herroldch', 'bcb7c3ab96f85c9b5b26452836306b16', '2008-09-30', 'herroldch@gmail.com', 0, '', '', '', '', '', '', '', 1, 2, 'Colaborador', 0, 1221758160, -1, 1658322900, 1658363620, 1657978340, 6911406, 6673, 115445, 15, 1, 1, 0, 3, 0, 4, 45616983, '01-22-1977', '1977-01-22', -1, 1, '', 0, 0, 1573494257, 0, 2, 113, 0, '{ZC', 0, 0, 0, '', 0, 0, 3251, 48, 0, 0, 0, 0, 0, 0, 0, 0, 8217, 4385, 22991, 0, 0, 0, 100, 1)
,(15, 9, '', 9, 'bumbles', 'aa3e9ee7dbd58d866c9d2f90914a0903', '2008-09-18', 'maricel3435@hotmail.com', 0, '', '', '', '', '', '', '', 1, 0, 'Curioseando', 0, 1221758220, -1, 1486948462, 1499468770, 1223402732, 11735, 31, 235, 7, 1, 1, 0, 3, 1, 1, 45092183, '09-04-0000', '0000-09-04', -1, -1, '', 0, 0, 1223508132, 0, 0, 11, 0, '#k5', 0, 0, 0, '', 0, 0, 93, 3, 1, 0, 0, 0, 0, 0, 0, 0, 58, 20, 51, 0, 0, 0, 100, 1)
,(16, 19, '', 0, 'JuMG', '4a4ddd2c507468081c78985bdf84b8b6', '2008-09-20', 'juanmi113@yahoo.es', 0, '', '', '', '', '', '', '', 2, 0, 'Miembro BRONCE', 0, 1221825000, -1, 1354313545, 1363557251, 1264893257, 650317, 510, 10840, 15, 1, 0, 0, 3, 0, 0, 45616983, '', '1000-01-01', -1, 2, '', 0, 0, 0, 0, -1, 47, 7, 'Z)=', 0, 0, 0, '', 0, 0, 467, 4, 1, 0, 0, 0, 0, 0, 0, 0, 266, 364, 2174, 0, 0, 0, 100, 1)
,(17, 16, '', 0, 'ZeusOurense', '0ebd25385bd05e8febf2b1bbffaabd65', '2008-09-19', 'hlfzeus@gmail.com', 0, '', '', '', '', '', '', '', 1, 0, 'Colaborador', 0, 1221825060, -1, 1654152008, 1654508009, 1650441045, 6771556, 11488, 266720, 15, 1, 1, 0, 5, 5, 0, 35130567, '08-21-1988', '1988-08-21', -1, 1, '', 0, 0, 1343031720, 0, 0, 53, 0, 'B_L', 0, 0, 0, '', 0, 0, 7765, 2, 0, 0, 0, 0, 0, 0, 0, 0, 46611, 10125, 53316, 0, 0, 0, 100, 1)
,(18, 16, '', 16, 'Sergioj', '9d821a24ec5b80c92ca10b610566b3d6', '2012-03-31', 'sergijavier@gmail.com', 0, '', '', '', '', '', '', '', 2, 3, 'Colaborador', 0, 1221826200, -1, 1648052463, 1648654167, 1648052291, 6728982, 18189, 467515, 15, 1, 1, 0, 8, 3, 3, 45617111, '09-18-1963', '1963-09-18', -1, 1, '', 0, 0, 1647767085, 0, 0, 141, 0, '7k\"', 0, 0, 0, '', 0, 0, 6544, 69, 0, 0, 0, 0, 0, 0, 0, 0, 52975, 15874, 93424, 0, 0, 0, 97, 1)
,(19, 16, '', 0, 'Sol', 'f7294463f5fd3990d53b1fa3a85ef8b0', '2008-10-05', 'sonsolesmorenomayoral@hotmail.com', 0, '', '', '', '', '', 'sonsolesmorenomayoral@hotmail.com', 'SonsolesMoreno', 1, 2, 'Colaborador', 1, 1221826380, -1, 1344196620, 1531332128, 1344182640, 1892489, 1584, 76104, 15, 1, 0, 0, 3, 0, 0, 45616375, '06-18-1958', '1958-06-18', -1, 1, '', 0, 0, 0, 0, 0, 137, 100, '0{M', 0, 0, 0, '', 0, 0, 2578, 52, 7, 25, 0, 0, 0, 0, 0, 0, 7161, 1477, 15227, 0, 0, 0, 100, 1)