06-15-2023, 05:10 PM
Data format: SQL
Breach Date: 2012
Data Counts: 23423
SQL Table format
Sample
Download Link
Breach Date: 2012
Data Counts: 23423
SQL Table format
`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 '33570831',
`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',
`assetposthash` varchar(32) NOT NULL DEFAULT '',
`fbuserid` varchar(255) NOT NULL DEFAULT '',
`fbjoindate` int(10) unsigned NOT NULL DEFAULT '0',
`fbname` varchar(255) NOT NULL DEFAULT '',
`logintype` enum('vb','fb') NOT NULL DEFAULT 'vb',
`fbaccesstoken` varchar(255) NOT NULL DEFAULT '',
`dbtech_infopanels_blocks` mediumtext,
`dbtech_infopanels_settings` int(10) unsigned NOT NULL DEFAULT '16383',
`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',
`importuserid` bigint(20) NOT NULL DEFAULT '0',
`dbtech_vbshout_banned` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_settings` int(10) unsigned NOT NULL DEFAULT '4095',
`dbtech_vbshout_shouts` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_shoutstyle` mediumtext,
`dbtech_vbshout_silenced` tinyint(1) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_shoutarea` varchar(15) NOT NULL DEFAULT 'default',
`dbtech_vbshout_pm` int(10) unsigned NOT NULL DEFAULT '0',
`dbtech_vbshout_soundsettings` mediumtext,
`dbtech_vbshout_shoutboxsize` int(10) NOT NULL DEFAULT '0',
`dbtech_vbshout_shoutboxsize_detached` int(10) NOT NULL DEFAULT '0',
`dbtech_vbshout_displayorder` mediumtext,Sample
VALUES ('1', '6', '', '0', 'champ', '9afa38c460617777a5e63d157ebc59a8', '2012-03-01', 'deathlysouls@hotmail.co.in', '0', '', '', '', '', '', '', '', '2', '2', 'Administrator', '0', '1297892400', '0', '1331933417', '1332161863', '1331750786', '0', '101', '63', '6', '0', '0', '0', '0', '0', '0', '12077143', '', '0000-00-00', '-1', '1', '', '0', '0', '0', '0', '-1', '1628', '95', 'Vxd6/6Co|mMj_TDH,z&vKd\"_7z!8\"O', '0', '0', '0', '', '0', '0', '13052', '99', '5', '40', '0', '0', '0', '0', '0', '0', '', '', '0', '', 'vb', '', 'a:3:{i:1;s:2:\"16\";i:2;s:1:\"5\";i:3;s:1:\"1\";}', '16383', '8', '4294967295', '4294967295', '0', '0', '8191', '1', 'a:1:{i:1;a:6:{s:4:\"bold\";s:1:\"0\";s:6:\"italic\";s:1:\"0\";s:9:\"underline\";s:1:\"0\";s:5:\"color\";s:7:\"DarkRed\";s:4:\"font\";s:6:\"Tahoma\";s:4:\"size\";s:4:\"11px\";}}', '0', 'default', '1332108665', '', '0', '0', '');Download Link
