Hello, Verified Database Network!
Thanks for checking us out, and have fun downloading Spanish forum Foro del Guardia Civil Dump, we just released!
The Spanish forum Foro del Guardia Civil experienced a data breach that affected 233k subscribers around September 2022. Usernames, Email addresses, Dates of Birth, IP Addresses, and Passwords stored as vBulletin hashes were among the data exposed as a result of the leak.
Password: leakeddatabases.com
Source: forodelguardiacivil.com
Amount: 233k lines
File Formatting: SQL File (.sql)
Fields:
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`, `assetposthash`, `fbuserid`, `fbjoindate`, `fbname`, `logintype`, `fbaccesstoken`, `newrepcount`, `bloggroupreqcount`, `showblogcss`, `importuserid`, `dl2_uploads`, `dl2_downloads`, `dl2_comments`, `vbseo_likes_in`, `vbseo_likes_out`, `vbseo_likes_unread`) VALUES
Sample:
(25, 2, '9,26', 0, 'LUCEN', 'bc65e54146bc5685af9efc39ec253923', '2013-07-10', 'luisvicom@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, '', 0, 1239655839, 0, 1661086049, 1661180050, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 5, 4, 'o09', 0, 0, 0, '', 0, 0, 1399, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 57, 0, 3, 0, 0, 0, 0),
(26, 2, '9,26', 0, 'firthuns', '92d1f2981f5c53d525a12e7ba6f495fb', '2013-07-10', 'firthuns@hotmail.com', 0, '', '', '', '', '', '', '', 2, 0, 'Guardia Civil', 0, 1239655983, 0, 1551993639, 1552501360, 1547108744, 777183, 29, 0, 0, '', 0, 0, 0, 0, 0, 11537623, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '6t7', 0, 0, 0, '', 0, 0, 842, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 60, 0, 0, 0, 0, 0, 0),
(27, 2, '9,26', 0, 'pablojones', '21537710f12074d9aafff45656021005', '2013-07-10', 'pamendiaz@gmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil', 0, 1239656031, 0, 1661931632, 1662140339, 1396863631, 230677, 31, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 10, 0, '`o<', 0, 0, 0, '', 0, 0, 2099, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 63, 0, 1, 0, 0, 0, 0),
(28, 2, '9,26', 0, 'ray1co', 'ffca453722223bcdbb422f943124f1b5', '2016-03-18', 'ray1co@yahoo.es', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil', 0, 1239656031, 0, 1458297308, 1458309789, 1458296676, 493736, 40, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '9,iG6zB1)$k/Mouf7I_qY6_uAJmBqm', 0, 0, 0, '', 0, 0, 806, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 64, 0, 0, 0, 0, 0, 0),
(29, 2, '9,26', 0, 'solo', '86f5eb9c2c84b3a8731161621f231f5c', '2013-07-10', 'jbarnes700@msn.com', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo', 0, 1239656038, 0, 1653552666, 1654019563, 1497857985, 632021, 138, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 3, 1, ',^?', 0, 0, 0, '', 0, 0, 1467, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 65, 0, 0, 0, 0, 0, 0),
(30, 2, '9,26', 0, 'pikochu', 'e40db3f5f9bc198848ef3bc42609e912', '2013-07-10', 'pikochu@hotmail.es', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo Mayor', 0, 1239656100, 0, 1632938882, 1639939793, 1540468803, 760463, 421, 0, 0, '1', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', -1, 2, '', 0, 0, 0, 0, 0, 6, 1, 'Y8A', 0, 0, 0, '', 0, 1, 5966, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 67, 0, 8, 0, 2, 2, 0),
(31, 2, '9,26', 0, 'John_McClane', 'fd697d92f95047f5354b4d1d2d0747d1', '2013-07-10', 'poligarcinuno@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo', 0, 1239656125, 0, 1472721565, 1477648376, 1437571928, 408016, 109, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 15, 15, 'v1W', 0, 0, 0, '', 0, 0, 821, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 69, 0, 0, 0, 0, 0, 0),
(32, 2, '9,26', 0, 'pope', '9e642a9ce287eeca54b5fc5afe5df492', '2013-07-10', 'franara37@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo', 0, 1239656142, 0, 1523894820, 1525173673, 1523694303, 692031, 147, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 10, 8, 'ouE', 0, 0, 0, '', 0, 0, 1446, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 70, 0, 11, 0, 0, 0, 0),
(33, 2, '9,26', 0, 'Carres', 'daf699b48e727cc239bc296800b54779', '2013-07-10', 'cxvp@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Sargento Primero', 0, 1239656160, 0, 1472132886, 1488020580, 1472132268, 546402, 1013, 0, 0, '0', 2, 0, 0, 0, 0, 26217671, '', '1000-01-01', -1, 1, '', 0, 0, 1445735733, 0, -1, 8, 8, 'Tky', 0, 0, 0, '', 0, 1, 95, 6, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 72, 0, 0, 0, 0, 0, 0),
(34, 2, '9,26', 0, 'RARGORN27', '6d0c5e00fcc632185984562f26abd888', '2014-11-04', 'djjavivi21@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil 1º', 0, 1239656170, 0, 0, 1415114501, 0, 0, 92, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 8, 8, ']oPC=hV9k[:*[U9kE\\Mn^Bh<jjo@?=', 0, 0, 0, '', 0, 0, 1008, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 74, 0, 0, 0, 0, 0, 0),
(35, 2, '9,26', 0, 'supertrigui1', 'e2a3627e37704996c8f751325f1ed9a5', '2013-07-10', 'supertrigui1@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo Mayor', 0, 1239656294, 0, 1647465664, 1647628318, 1643895704, 1006403, 315, 0, 0, '', 0, 0, 0, 0, 0, 11537623, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 'A1.', 0, 0, 0, '', 0, 0, 4034, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 79, 0, 0, 0, 0, 0, 0),
(36, 2, '9,26', 0, 'marcanoid', 'fb270582dc2cd1b89e750b9c35ebff5d', '2013-07-10', 'donquijote73@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil', 0, 1239656365, 0, 1661531317, 1661531317, 1608654995, 953613, 28, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '[H$', 0, 0, 0, '', 0, 0, 1729, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 80, 0, 3, 0, 0, 0, 0),
(37, 2, '9,26', 0, 'Turu_gc', 'b250a7a2dc737b2491abb7380c4dccbd', '2013-09-25', 'jgrobas86@hotmail.com', 10, '', '', '', '', '', '', '', 2, 0, 'Cabo 1º', 0, 1239656340, 0, 1648321189, 1649074139, 1635364277, 996085, 296, 0, 0, '0', 0, 0, 0, 0, 0, 9457223, '11-07-1986', '1986-11-07', -1, 2, '', 0, 0, 0, 0, 0, 10, 2, 's*VS6F.B85}M37P;yyiC]-1_ZlO\\a@', 0, 0, 0, '', 0, 1, 1203, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 81, 0, 2, 0, 0, 0, 0),
(38, 2, '9,26', 0, 'tapioca', '771e1d2efb35d37cddf7f435f419eecc', '2015-09-05', 'tapiocasevilla@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo', 0, 1239656471, 0, 0, 1433719671, 0, 0, 153, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 2, 2, 'JLkSQ1x@3;d{0\",^,};XBt\'yKV%iru', 0, 0, 0, '', 0, 0, 1108, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 83, 0, 0, 0, 0, 0, 0),
(39, 8, '9,26', 0, 'nevado', '1db8196903c61da708120689ca506053', '2013-07-10', 'nevado_55@yahoo.es', 0, '', '', '', '', '', '', '', 2, 2, 'B a n n e d', 0, 1239656460, 0, 1375194144, 1387585620, 1332080988, 0, 854, 0, 0, '0', 0, 0, 0, 0, 0, 11537623, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 1, 1, '547', 0, 0, 0, '', 0, 1, 2240, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 84, 0, 0, 0, 0, 0, 0),
(40, 2, '9,26', 0, 'california', '561394352d1a302abe35810dc9212486', '2013-07-10', 'mavicelx@gmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Sargento', 0, 1239656460, 0, 0, 0, 0, 0, 610, 0, 0, '0', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 1, 1, 'UnP', 0, 0, 0, '', 0, 1, 2318, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 85, 0, 0, 0, 0, 0, 0),
(41, 2, '9,26', 0, 'israel', '2c52ae87d08af9c61e8a8b235155476a', '2013-07-10', 'israel@iferent.org', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil 1º', 0, 1239656520, 0, 1478631373, 1639133921, 1394231848, 220091, 90, 0, 0, '', 0, 0, 0, 0, 0, 11537623, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 5, 4, 'wfa', 0, 0, 0, '', 0, 0, 2530, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 86, 0, 2, 0, 0, 0, 0),
(42, 2, '9,26', 0, 'Yereho', 'b09646ad0eb7e1326f0076b2732a5795', '2013-07-10', 'yereho@gmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo', 0, 1239656526, 0, 1628677588, 1659448586, 1430480427, 373083, 111, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 4, 1, 'PVW', 0, 0, 0, '', 0, 0, 2143, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 87, 0, 0, 0, 1, 0, 1),
(43, 2, '9,26', 0, 'taira', 'd5401a09d39d2141165593d5e00d8fa6', '2013-07-10', 'taira62@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil Alumno', 0, 1239656608, 0, 0, 1380961598, 0, 0, 9, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 4, 4, 'u,D', 0, 0, 0, '', 0, 0, 1332, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 89, 0, 0, 0, 0, 0, 0),
(44, 2, '9,26', 0, 'roble', '7dbb3274e85e7e75723be1e444c5e2e3', '2014-07-30', 'luisk2@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil 1º', 0, 1239656653, 0, 1647122952, 1656198736, 1541070275, 762128, 54, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 3, 1, '4Q6:IkShbUJ\\#\\\\knh7~I\'\"\'WY*.\'i', 0, 0, 0, '', 0, 0, 1042, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 90, 0, 1, 0, 0, 0, 0),
(45, 2, '9,26', 0, 'cofrade', '6b67da36f6a7da61f54e71af9c4e8d1e', '2014-10-27', 'cofrade86@gmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil 1º', 0, 1239656683, 0, 1392837655, 1414433855, 0, 0, 85, 0, 0, '', 0, 0, 0, 0, 0, 11537623, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 1, 1, '=.w21!F::nXn,I-a3Ft)a@K7<Vqcu(', 0, 0, 0, '', 0, 0, 906, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 92, 0, 2, 0, 0, 0, 0),
(46, 2, '9,26', 0, 'Socked', 'adfc4d0816e2b4bb0df7b9a0465e412e', '2015-12-23', 'iol80@hotmail.com', 0, '', '', '', '', '', '', '', 2, 3, 'General de Division', 0, 1239656700, -1, 1563749662, 1608429681, 1608429332, 953007, 10063, 0, 0, '0', 2, 0, 0, 0, 0, 45637079, '02-19-0000', '0000-02-19', 20, 2, '', 0, 2, 1423187684, 0, 0, 35, 3, '<GZ`@Kyv0J*eO!$?U0@yjjeUnEKDFx', 0, 0, 0, '', 0, 1, 81, 3, 1, 0, 0, 0, 0, 0, 0, 0, '34a92dc2eacd3d0b71714a821b9f465d', '', 0, '', 'vb', '', 0, 0, 1, 93, 0, 3, 0, 1, 4, 0),
(47, 2, '9,26', 0, 'jesus1960', 'c2f6ecef14e6eb8374b5d621680dcc2a', '2013-07-10', 'yolijesus17@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil Alumno', 0, 1239656737, 0, 1653052933, 1654447618, 0, 0, 1, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '\"\\K', 0, 0, 0, '', 0, 0, 652, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 95, 0, 0, 0, 0, 0, 0),
