Return to forum

Toster · October 3, 2022 at 11:47 AM

52k lines. Database table:

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` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`displaygroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`passworddate` date NOT NULL DEFAULT '0000-00-00',
`email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`styleid` smallint(5) unsigned NOT NULL DEFAULT '0',
`parentemail` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`homepage` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`icq` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`aim` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`yahoo` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`msn` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`skype` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`google` char(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`status` mediumtext COLLATE utf8mb4_unicode_ci,
`showvbcode` smallint(5) unsigned NOT NULL DEFAULT '0',
`showbirthday` smallint(5) unsigned NOT NULL DEFAULT '2',
`usertitle` varchar(250) COLLATE utf8mb4_unicode_ci 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',
`reputation` int(11) NOT NULL DEFAULT '10',
`reputationlevelid` int(10) unsigned NOT NULL DEFAULT '1',
`timezoneoffset` varchar(4) COLLATE utf8mb4_unicode_ci 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',
`options` int(10) unsigned NOT NULL DEFAULT '167788559',
`privacy_options` mediumtext COLLATE utf8mb4_unicode_ci,
`notification_options` int(10) unsigned NOT NULL DEFAULT '1073741818',
`birthday` varchar(10) COLLATE utf8mb4_unicode_ci 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` varchar(45) COLLATE utf8mb4_unicode_ci 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',
`emailnotification` smallint(5) unsigned NOT NULL DEFAULT '0',
`pmtotal` smallint(5) unsigned NOT NULL DEFAULT '0',
`pmunread` smallint(5) unsigned NOT NULL DEFAULT '0',
`importuserid` bigint(20) NOT NULL DEFAULT '0',
`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) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`infractiongroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
`lastrepcheck` int(10) unsigned NOT NULL DEFAULT '0',
`cfrules_read_status` tinyint(1) 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',
`ncode_imageresizer_mode` enum('none','enlarge','samewindow','newwindow','lytebox','lightview','slimbox','thickbox','floatbox','shadowbox','greybox','roebox','lightwindow','awesomebox','highslide') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`ncode_imageresizer_maxwidth` smallint(5) unsigned DEFAULT NULL,
`ncode_imageresizer_maxheight` smallint(5) unsigned DEFAULT NULL,
`assetposthash` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`fbuserid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`fbjoindate` int(10) unsigned NOT NULL DEFAULT '0',
`fbname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`logintype` enum('vb','fb') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'vb',
`fbaccesstoken` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`newrepcount` smallint(5) unsigned NOT NULL DEFAULT '0',
`bloggroupreqcount` int(10) unsigned NOT NULL DEFAULT '0',
`showblogcss` 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',
`token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`scheme` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`autosubscribe` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`),
KEY `usergroupid` (`usergroupid`),
KEY `username` (`username`),
KEY `birthday` (`birthday`,`showbirthday`),
KEY `birthday_search` (`birthday_search`),
KEY `posts` (`posts`),
KEY `referrerid` (`referrerid`),
KEY `fbuserid` (`fbuserid`(250)),
KEY `email` (`email`),
KEY `lastactivity` (`lastactivity`),
KEY `joindate` (`joindate`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Sample:

(21900, 2, '', 0, 'vanhout', '2009-09-01', '[email protected]', 0, '', '', '', '', '', '', '', '', NULL, 2, 2, 'Junior Member', 0, 1251804251, 0, 1251804251, 1251806019, 0, 0, 10, 5, '1', 1, 0, 0, 0, 246438358, NULL, 939524090, '07-25-1989', '1989-07-25', -1, -1, '91.180.67.88', 0, 0, 0, 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '', '', 0, '', 'vb', '', 0, 0, 0, 0, 0, 0, '8a11957903651e14e14188ae87da8129 ZvY', 'legacy', 'ZvY', 0),
(21901, 2, '55', 0, 'Tika', '2009-09-01', '[email protected]', 0, '', '', '', '', '', '', '', '', NULL, 2, 1, 'Junior Member', 0, 1251805075, 0, 1253718048, 1253782127, 1253782127, 28, 10, 5, '1', 1, 0, 0, 0, 246439382, NULL, 939524090, '08-05-1970', '1970-08-05', -1, 2, '80.127.106.187', 0, 0, 0, 0, 3, 3, 0, 0, 0, 578514, 0, 0, 0, 0, '', 0, 0, 1, 16, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '', '', 0, '', 'vb', '', 0, 0, 0, 0, 0, 0, 'b217b7634b35c52c4dcfed95c92f461e :<p', 'legacy', ':<p', 0),
(21902, 2, '', 0, 'jer0en72', '2009-09-01', '[email protected]', 0, '', '', '', '', '', '', '', '', NULL, 2, 2, 'Junior Member', 0, 1251805085, 0, 1251805085, 1251805722, 0, 0, 10, 5, '1', 1, 0, 0, 0, 246437974, NULL, 939524090, '06-15-1972', '1972-06-15', -1, -1, '82.170.117.34', 0, 0, 0, 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '', '', 0, '', 'vb', '', 0, 0, 0, 0, 0, 0, '2d620fc7fdb7f66aaf2f3e1ea29b9f0d hss', 'legacy', 'hss', 0),
(21903, 2, '', 0, 'feighteenk', '2009-09-01', '[email protected]', 0, '', '', '', '', '', '', '', '', NULL, 2, 0, 'Junior Member', 0, 1251809635, 0, 1251897848, 1252072552, 1251895735, 3, 10, 5, '1', 1, 0, 0, 0, 246438358, NULL, 939524090, '02-10-1991', '1991-02-10', -1, -1, '195.241.189.29', 0, 0, 0, 0, 3, 2, 0, 0, 0, 569924, 0, 0, 0, 0, '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '', '', 0, '', 'vb', '', 0, 0, 0, 0, 0, 0, '7f95ea014565cc79d66c6835ca57474b $29', 'legacy', '$29', 0),
(21904, 2, '', 0, 'Superbikkel', '2009-09-01', '[email protected]', 0, '', '', '', '', '', '', '', '', NULL, 2, 1, 'Junior Member', 0, 1251823414, 0, 1251825389, 1252236860, 0, 0, 10, 5, '1', 1, 0, 0, 0, 246438102, NULL, 939524090, '01-12-1977', '1977-01-12', -1, -1, '217.123.216.175', 0, 0, 0, 0, 3, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '', '', 0, '', 'vb', '', 0, 0, 0, 0, 0, 0, 'b035f83b99864a44f3e25a99449150a0 ]8_', 'legacy', ']8_', 0),
(21905, 2, '', 0, 'boha', '2009-09-01', '[email protected]', 0, '', '', '', '', '', '', '', '', NULL, 2, 0, 'Junior Member', 0, 1251825568, 0, 1257974408, 1259518842, 1257936216, 3, 10, 5, '1', 1, 0, 0, 0, 246437974, NULL, 939524090, '11-11-1986', '1986-11-11', -1, -1, '212.45.53.122', 0, 0, 0, 0, 3, 1, 1, 0, 0, 597515, 0, 0, 0, 0, '', 0, 0, 1, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, '', '', 0, '', 'vb', '', 0, 0, 0, 0, 0, 0, 'e31a93763b880e5388cd3ba2a69c8d93 /Dp', 'legacy', '/Dp', 0),
(

Hidden Content

You must register or login to view this content.

louisthomas82 · October 3, 2022 at 5:26 PM

leak date?

Toster · October 3, 2022 at 5:27 PM

(October 3, 2022, 05:26 PM)louisthomas82 Wrote: leak date?

i dont know, sorry

UPD: Looking date, 2020-05-29

Automation · November 5, 2022 at 2:29 AM

The link in this thread is dead. Please send a PM to a moderator to get your thread moved back to the Databases section.

Please also note that this is automated, if the link is still working please alert us. You can find a list of staff at https://breached.to/showteam.

dedale · November 5, 2022 at 6:23 PM

Hello,

The link on this thread has been updated as of this post.

Automation · November 5, 2022 at 9:18 PM

The link in this thread is dead. Please send a PM to a moderator to get your thread moved back to the Databases section.

Please also note that this is automated, if the link is still working please alert us. You can find a list of staff at https://breached.to/showteam.

dedale · November 6, 2022 at 9:34 AM

Hello,

The link on this thread has been updated as of this post.

dns10958304 · November 7, 2022 at 8:27 AM

thanks for data