Sql Cloud [Es] Foro Del Guardia Civil
[ES] Foro del Guardia Civil
I repost it because the old link don't work anymore
In approximately September 2022, the Spanish forum Foro del Guardia Civil suffered a data breach that impacted 233k users. The leak led to the exposure of data including Usernames, Email addresses, Dates of birth, IP Addresses and Passwords stored as vBulletin hashes. Please note that there is quite a few botted entries due to the website not implementing any captcha.
format: sql
data: 2022
Compromised data: Usernames, Email addresses, Dates of birth, IP Addresses, Passwords
sample:
I repost it because the old link don't work anymore
In approximately September 2022, the Spanish forum Foro del Guardia Civil suffered a data breach that impacted 233k users. The leak led to the exposure of data including Usernames, Email addresses, Dates of birth, IP Addresses and Passwords stored as vBulletin hashes. Please note that there is quite a few botted entries due to the website not implementing any captcha.
format: sql
data: 2022
Compromised data: Usernames, Email addresses, Dates of birth, IP Addresses, Passwords
sample:
HTML:
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
(1, 2, '9,26', 0, 'Elmer', '713c90991d37d605394432196a323b50', '2013-08-01', 'elmer@hdz.me', 0, '', '', '', '', '', '', '', 2, 2, '', 0, 1373415780, 0, 1416656840, 1416656840, 0, 0, 0, 10, 1, '0', 0, 0, 0, 0, 0, 11552855, '', '1000-01-01', -1, 1, '', 0, 0, 0, 0, -1, 1, 0, 'OJT.#;A6\"B\"}G6>`Yn\"V&+902y_$~?', 0, 0, 0, '', 0, 0, 2920, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0),
(3, 2, '9,26', 0, 'jalexa', 'd015a5d107901e003cccee12adf9f425', '2013-07-10', 'jalexa@terra.es', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo', 0, 1239654347, 0, 1645093705, 1649753399, 1523527266, 691070, 145, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 1, 0, 'XNf', 0, 0, 0, '', 0, 0, 1874, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 10, 0, 1, 0, 0, 0, 0),
(4, 2, '9,26', 0, 'GABIESC', 'cbe416c8df5c89911cb7d30ae3f9f0e8', '2013-07-10', 'gabijackman@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil Alumno', 0, 1239654503, 0, 1662062015, 1662130067, 0, 0, 2, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, '5Y\\', 0, 0, 0, '', 0, 0, 2754, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 13, 0, 0, 0, 0, 0, 0),
(5, 2, '9,26', 0, 'jaime2', 'd66675ed8e3a642fbf5a5b5ae6adaf92', '2013-07-10', 'jaimep2004@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, '', 0, 1239654542, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 1, 1, 'z,X', 0, 0, 0, '', 0, 0, 1269, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 14, 0, 0, 0, 0, 0, 0),
(6, 8, '9,26', 0, 'jestoa', '5adca709adc497d9e9942b6dd7c9d2a4', '2013-07-10', 'jestoca@ono.com', 0, '', '', '', '', '', '', '', 2, 2, 'B a n n e d', 0, 1239654720, 0, 0, 0, 0, 0, 1, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 'H\"5', 0, 0, 0, '', 0, 0, 466, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 17, 0, 0, 0, 0, 0, 0),
(7, 2, '9,26', 0, 'especiales', 'c2d95a0474a9121a4dfedc48a9028a73', '2015-09-13', 'especialpepe@gmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil', 0, 1239654858, 0, 1660116924, 1660233608, 1528404055, 715253, 30, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 8, 7, 'GC\"R$Hfl4smrqnI\"9\\E;@}D9Ww5Fcj', 0, 0, 0, '', 0, 0, 1597, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 24, 0, 0, 0, 0, 0, 0),
(8, 2, '9,26', 0, 'faprado', '96fcd0b62ef6bdacb3c44aea76a80834', '2013-07-10', 'faprado@hotmail.es', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil Alumno', 0, 1239654977, 0, 0, 0, 0, 0, 10, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 2, 2, 'dn%', 0, 0, 0, '', 0, 0, 865, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 25, 0, 0, 0, 0, 0, 0),
(9, 2, '9,26', 0, 'MANOLETE', 'f3e1c7cc968ad361eb9bc8cbbdb4955b', '2013-07-10', 'pascualleon@hotmail.es', 10, '', '', '', '', '', '', '', 2, 2, 'Cabo Mayor', 0, 1239655080, 0, 1641900555, 1645782534, 1575189822, 850471, 316, 0, 0, '0', 1, 0, 0, 0, 0, 45096439, '', '1000-01-01', -1, 1, '', 0, 0, 0, 0, 0, 29, 2, 'P?_', 0, 0, 0, '', 0, 1, 6054, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 27, 0, 1, 0, 0, 0, 0),
(10, 2, '9,26', 0, 'darwader', 'af7556a5ee75eb0bfbcd66c3d02501da', '2013-07-10', 'soyolcina@yahoo.es', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil 1º', 0, 1239655146, 0, 1606116743, 1654775296, 1481889852, 576057, 52, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 6, 6, 'fo=', 0, 0, 0, '', 0, 0, 2440, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 29, 0, 3, 0, 0, 0, 0),
(11, 2, '9,26', 0, 'sssergio23', 'ba774603d1a35381734193f1cafd5b86', '2013-07-10', 'chinchilla_m@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil 1º', 0, 1239655171, 0, 1654208332, 1656920860, 1623409833, 982454, 50, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 1, 0, '4Zk', 0, 0, 0, '', 0, 0, 3201, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 30, 0, 0, 0, 0, 0, 0),
(12, 2, '9,26', 0, 'MCCLAUS', '7bf9eaa09d9fb072e48b630cf5799146', '2013-07-10', 'MCCLAUS6@HOTMAIL.COM', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo 1º', 0, 1239655200, 0, 1662200222, 1662206039, 1662200207, 1030018, 260, 0, 0, '0', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 'Vk0', 0, 0, 0, '', 0, 1, 2902, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 33, 0, 5, 0, 0, 0, 0),
(13, 2, '9,26', 2, 'PGE35', '7e67a4f28a6017e1d12c91befcf37323', '2017-12-01', 'pge35@forodelguardiacivil.com', 10, '', '', '', '', '', '', '', 2, 0, 'General de Brigada', 0, 1239655320, 0, 1661231505, 1661257403, 1659044075, 1025526, 9177, 0, 0, '0', 0, 0, 0, 0, 0, 525888, '', '1000-01-01', -1, 6, '', 0, 2, 1577191793, 0, -1, 5, 0, 'jbQd.jt2E+ElHBo2`%(k>!0st~$$vH', 0, 0, 0, '', 0, 3, 27290, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 37, 0, 14, 0, 4, 3, 1),
(14, 2, '9,26', 0, 'carrero', 'fbbfbf74ba8a853dcdbacc266788b28f', '2013-07-10', 'carrero_gc@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo', 0, 1239655364, 0, 1662133904, 1662179246, 1659042891, 1025524, 190, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 21, 0, 'NY9', 0, 0, 0, '', 0, 0, 6560, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 38, 0, 3, 0, 0, 0, 0),
(15, 2, '9,26', 0, 'notodo', 'acbf83b434fefa6d6dd5a5847340880a', '2013-07-10', 'f.arezo@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil', 0, 1239655430, 0, 1560914479, 1561437432, 1500620740, 641652, 42, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 4, 4, ',UF', 0, 0, 0, '', 0, 0, 3688, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 40, 0, 4, 0, 0, 0, 0),
(16, 2, '9,26', 0, 'PRUSI', 'd14f396d983619095ac62a93274db5f7', '2013-07-10', 'jigm163030@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, '', 0, 1239655462, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 2, 2, 'd}I', 0, 0, 0, '', 0, 0, 924, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 41, 0, 0, 0, 0, 0, 0),
(17, 2, '9,26', 0, 'solapa', '20c1a6c5b124ef2e265666f232c202a2', '2013-07-10', 'ceyoehi@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil', 0, 1239655495, 0, 0, 0, 0, 0, 21, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 2, 2, 'y$=', 0, 0, 0, '', 0, 0, 886, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 42, 0, 0, 0, 0, 0, 0),
(18, 2, '9,26', 0, 'texas', '992d8f51976da3e8a8f9e918c3aeca19', '2013-07-10', 'ammgc@msn.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil', 0, 1239655524, 0, 1558509313, 1558603755, 1534152550, 737638, 32, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 3, 1, 'sh-', 0, 0, 0, '', 0, 0, 2469, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 44, 0, 0, 0, 0, 0, 0),
(20, 2, '9,26', 0, 'diramuser', 'dbc8862109347cfb82a01781c3720a81', '2013-07-10', 'checo424@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil Alumno', 0, 1239655662, 0, 0, 0, 0, 0, 8, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 5, 5, 'Y!=', 0, 0, 0, '', 0, 0, 903, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 50, 0, 0, 0, 0, 0, 0),
(21, 2, '9,26', 0, 'jocker', '0e111cbbdac1e08a284ac4ef036e66ed', '2013-07-10', 'lim_bickitt@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil', 0, 1239655684, 0, 1499332428, 1528828830, 0, 0, 23, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 1, 1, 'w5w', 0, 0, 0, '', 0, 0, 2183, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 51, 0, 0, 0, 0, 0, 0),
(22, 2, '9,26', 0, 'lclmelilla', '3e303adbdb2e5c471c9700d138d51190', '2013-07-10', 'casabonalopez@hotmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Cabo', 0, 1239655711, 0, 1540884075, 1549372079, 1461823389, 529310, 170, 0, 0, '', 0, 0, 0, 0, 0, 11537623, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 1, 1, 'dlc', 0, 0, 0, '', 0, 0, 1384, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 53, 0, 5, 0, 0, 0, 0),
(23, 2, '9,26', 0, 'superwander', 'f47647422c98c9240b59f4b0d91ef1d9', '2013-07-10', 'wander@japaricio45.jazztel.es', 0, '', '', '', '', '', '', '', 2, 2, 'Guardia Civil 1º', 0, 1239655796, 0, 1526405662, 1526459139, 1461747164, 505410, 50, 0, 0, '', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 3, 1, 'tT)', 0, 0, 0, '', 0, 0, 2079, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 54, 0, 3, 0, 0, 0, 0),
(24, 2, '9,26', 0, 'KEKO', '82e22aad968717f5f4eb29a431f7ffe1', '2013-07-10', 'nuncaeltiempoesperdido@hotmail.com', 0, '', 'http://www.pieldetoro.net', '', '::::::::::::::::::::', '@@@@@@@@@@@@@@@@', '@@@@@@@@@@@@@@@@', '', 2, 2, 'Sargento', 0, 1239655740, 0, 0, 0, 1335539467, 0, 923, 0, 0, '0', 0, 0, 0, 0, 0, 11537495, '', '1000-01-01', 0, 0, '', 0, 0, 0, 0, 0, 3, 3, 'U#c', 0, 0, 0, '', 0, 1, 2849, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 0, '', 'vb', '', 0, 0, 1, 55, 0, 0, 0, 0, 0, 0),
(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),
View hidden content is available for registered users!
Last edited:
