SQL eccie.net

[tudos]

слито с рейда, форум на движке vBulletin, название в шапке
таблица юзеров, 530к строк
дамп января 2021 года

Спойлер: поля

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 '0000-00-00',
`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 '33554447',
`birthday` char(10) NOT NULL DEFAULT '',
`birthday_search` date NOT NULL DEFAULT '0000-00-00',
`maxposts` smallint(6) NOT NULL DEFAULT '-1',
`startofweek` smallint(6) NOT NULL DEFAULT '1',
`ipaddress` char(15) 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',
`showcybstats` tinyint(1) NOT NULL DEFAULT '1',
`invitation` int(10) unsigned NOT NULL DEFAULT '100',
`caninvitation` tinyint(3) unsigned NOT NULL DEFAULT '1',
`reviewcount` int(10) NOT NULL DEFAULT '0',
`ncode_imageresizer_mode` enum('none','enlarge','samewindow','newwindow') DEFAULT NULL,
`ncode_imageresizer_maxwidth` smallint(5) unsigned DEFAULT NULL,
`ncode_imageresizer_maxheight` smallint(5) unsigned DEFAULT NULL,
`beenreviewed` smallint(5) unsigned NOT NULL DEFAULT '0',
`agreed` int(10) unsigned NOT NULL DEFAULT '0',
`lastpopup` int(10) unsigned NOT NULL DEFAULT '0',
`ASvBapi_cladsearch_url` varchar(250) DEFAULT NULL,
`ASvBapi_cladsearch_url_lastrequest` int(10) DEFAULT NULL,
`hasphotos` tinyint(1) DEFAULT '0',
`image_location` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `referrerid` (`referrerid`),
KEY `lastactivity` (`lastactivity`),
KEY `joindate` (`joindate`),
KEY `posts` (`posts`),
KEY `idx_ip_user` (`ipaddress`,`userid`),
KEY `idx_email` (`email`),
KEY `reviewcount` (`reviewcount`),
KEY `image_location` (`image_location`)
) ENGINE=InnoDB 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`, `showcybstats`, `invitation`, `caninvitation`, `reviewcount`, `ncode_imageresizer_mode`, `ncode_imageresizer_maxwidth`, `ncode_imageresizer_maxheight`, `beenreviewed`, `agreed`, `lastpopup`, `ASvBapi_cladsearch_url`, `ASvBapi_cladsearch_url_lastrequest`, `hasphotos`, `image_location`) VALUES
(1, 66, '', 0, 'Owner', '916f7859e9909b0d272440c28dbbf1bf', '2010-01-01', 'eccie09@gmail.com', 0, '', '', '', '', '', '', '', 2, 2, 'Account Disabled', 0, 1236555540, 0, 1592170951, 1592171149, 1329444263, 28022, 118, 10, 1, '-6', 0, 0, 1, 0, 0, 45091159, '', '0000-00-00', -1, 1, '', 0, 0, 0, 0, -1, 91, 30, 'F$t', 0, 0, 0, '', 0, 0, 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 100, 1, 1, NULL, NULL, NULL, 4, 0, 0, NULL, 2147483647, NULL, NULL),
(2, 6, '59', 6, 'TBONE', '2103dd44aa5de422a5bbb6100a80d810', '2013-09-16', 'tbone@eccie.net', 16, '', '', '', '', '', '', '', 2, 0, '', 2, 1236344760, 0, 1609954581, 1610035796, 1605885491, 0, 2915, 10, 5, '-6', 0, 0, 1, 0, 0, 12062547, '', '0000-00-00', -1, 1, '76.185.223.105', 0, 0, 0, 0, -1, 978, 0, '*Bj8lpnU.Gnr4A<H3z7jb+=.^]NkoA', 0, 0, 0, '', 0, 0, 18, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 100, 1, 0, NULL, NULL, NULL, 0, 1333501742, 1358631909, NULL, 2147483647, NULL, NULL),
(3, 6, '59', 0, 'T.O.B.', '108d7c0e21126cc3f8888e6c475156a1', '2013-11-06', 'Theoriginalbecky@yahoo.com', 0, '', '', '', '', '', '', '', 2, 0, 'Retired', 1, 1236702900, 0, 1600570828, 1605387841, 1574649941, 0, 1343, 10, 5, '-6', 0, 0, 6, 0, 0, 45625175, '', '0000-00-00', 40, 1, '76.187.68.123', 0, 0, 0, 0, -1, 644, 3, 'e3fCj@wo9Gu(]Ena3@T&;s-FT7l^El', 0, 0, 0, '', 0, 1, 27, 3, 0, 0, 0, 0, 0, 0, 0, 0, 1, 100, 1, 0, NULL, NULL, NULL, 0, 1444869830, 1358582077, NULL, 2147483647, 1, NULL),
(6, 32, '', 32, 'chipper', 'fd163ea06eedde3d3f6330c61b5b68f7', '2019-09-09', 'chipper75234@yahoo.com', 0, '', '', '', '', '', '', '', 2, 2, 'Ambassador', 0, 1237233840, 0, 1571079925, 1580436779, 1567610819, 1061754285, 6572, 10, 5, '-6', 0, 167, 0, 0, 0, 45096279, '08-23-1939', '1939-08-23', -1, 1, '12.74.232.80', 0, 0, 1530296051, 0, -1, 70, 0, 'i<ffX44)+eF8<R1~j={H$wBj*0OSem', 0, 0, 0, '', 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 100, 1, 25, NULL, NULL, NULL, 3, 1333563011, 1358546624, NULL, 2147483647, NULL, NULL),

хеш : естественно vBulletin (-m 2611 hashcat mod)

eccie.net

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

пароль местный

 

[Nobody699]

Thanks a lot

 

[rtftp]

а можно перезалить? линк битый

 

[ice80]

thanks for the link

Quake3 пиндосик посты набивает, не к добру это. его "thanks for link" за битую ссылку как бы намекает