unix.com Forums Database
May 2021
Domain:
unix.com
Breach Count:
169,328
Region:
Global
Source:
-
File Size:
12.73 MB
Uncompressed File Size:
89.70 MB
File Count:
1
In 2021, the Unix.com Forums Database suffered a leak that exposed the personal data of over 169,000 users. The leaked information included users email addresses, usernames, passwords, home addresses, dates of birth, IP addresses, and regions.
The leak occurred due to a vulnerability in the forum software, which was exploited by an unidentified attacker. The adversary was able to gain unauthorized access to the database and extract the sensitive information before it was discovered.
The leaked data included a wide range of personal details, from basic information like email addresses and usernames to more sensitive data like home addresses and dates of birth. The exposure of this information has raised serious concerns about the potential risks to the affected users.
It is not clear if the stolen passwords were encrypted or plaintext, but in any case, the leak has significant implications for the security and privacy of the users. The incident highlights the importance of robust security measures and regular updates to prevent such breaches from occurring.
Leaked Information:
Email
User Name
Password
Address
Date Of Birth
IP Address
Region
We have loaded this breach into our database.
File List:
unix.com_may2021_vB_168k.sql
File Content Sample:
CREATE TABLE `user` (
`userid` int(10) UNSIGNED NOT NULL,
`usergroupid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`styleid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`parentemail` varchar(50) NOT NULL DEFAULT '',
`homepage` varchar(100) NOT NULL DEFAULT '',
`icq` varchar(20) NOT NULL DEFAULT '',
`aim` varchar(20) NOT NULL DEFAULT '',
`yahoo` varchar(32) NOT NULL DEFAULT '',
`usertitle` varchar(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',
`posts` int(10) UNSIGNED NOT NULL DEFAULT '0',
`timezoneoffset` varchar(4) NOT NULL DEFAULT '',
`avatarid` smallint(6) NOT NULL DEFAULT '0',
`options` int(10) UNSIGNED NOT NULL DEFAULT '0',
`birthday` varchar(10) NOT NULL DEFAULT '0000-00-00',
`maxposts` smallint(6) NOT NULL DEFAULT '-1',
`startofweek` smallint(6) NOT NULL DEFAULT '1',
`ipaddress` varchar(45) NOT NULL,
`referrerid` int(10) UNSIGNED NOT NULL DEFAULT '0',
`pmpopup` smallint(6) NOT NULL DEFAULT '0',
`pmtotal` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`pmunread` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`passworddate` date NOT NULL DEFAULT '1000-01-01',
`salt` char(30) NOT NULL,
`showvbcode` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`msn` varchar(100) NOT NULL COMMENT 'Neo: Using this for storing bbverify cookie read during registration',
`avatarrevision` int(10) UNSIGNED NOT NULL DEFAULT '0',
`membergroupids` varchar(250) NOT NULL DEFAULT '',
`displaygroupid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`reputation` int(11) NOT NULL DEFAULT '10',
`reputationlevelid` int(10) UNSIGNED NOT NULL DEFAULT '1',
`languageid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`threadedmode` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`emailstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
`autosubscribe` smallint(6) NOT NULL DEFAULT '-1',
`birthday_search` date NOT NULL DEFAULT '1000-01-01',
`profilepicrevision` int(10) UNSIGNED NOT NULL DEFAULT '0',
`showbirthday` smallint(5) UNSIGNED NOT NULL DEFAULT '2',
`skype` varchar(32) NOT NULL DEFAULT '',
`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) NOT NULL DEFAULT '',
`infractiongroupid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`threads` int(10) UNSIGNED NOT NULL DEFAULT '0',
`emailDate` int(11) NOT NULL,
`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',
`cfrules_read_status` tinyint(1) NOT NULL DEFAULT '0',
`credits` double NOT NULL DEFAULT '0',
`credits_numrefs` int(10) UNSIGNED NOT NULL DEFAULT '0',
`credits_saved` double NOT NULL DEFAULT '0',
`credits_canspend` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
`credits_score` int(11) NOT NULL DEFAULT '0',
`credits_interest` int(10) UNSIGNED NOT NULL DEFAULT '0',
`credits_statement` varchar(255) NOT NULL DEFAULT 'none',
`credits_alert` varchar(255) NOT NULL DEFAULT 'none',
`credits_canearn` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
`casino_cash` int(11) DEFAULT '0',
`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',
`facebook` varchar(20) DEFAULT NULL,
`myspace` varchar(20) DEFAULT NULL COMMENT 'using xing in this field',
`twitter` varchar(20) DEFAULT NULL,
`youtube` varchar(20) DEFAULT NULL,
`linkedin` varchar(20) DEFAULT NULL,
`hyves` varchar(20) DEFAULT NULL,
`pm_attachments` int(10) UNSIGNED NOT NULL DEFAULT '0',
`social_int` tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
`country_iso2` varchar(2) DEFAULT NULL,
`geoip_region` varchar(20) DEFAULT NULL,
`ua_type` varchar(15) NOT NULL DEFAULT 'unknown',
`google_auth` varchar(256) DEFAULT NULL COMMENT 'secret key for google authenticator'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `user`
--
INSERT INTO `user` (`userid`, `usergroupid`, `username`, `password`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `posts`, `timezoneoffset`, `avatarid`, `options`, `birthday`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `pmpopup`, `pmtotal`, `pmunread`, `passworddate`, `salt`, `showvbcode`, `msn`, `avatarrevision`, `membergroupids`, `displaygroupid`, `reputation`, `reputationlevelid`, `languageid`, `threadedmode`, `emailstamp`, `autosubscribe`, `birthday_search`, `profilepicrevision`, `showbirthday`, `skype`, `adminoptions`, `lastpostid`, `sigpicrevision`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `threads`, `emailDate`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `showcybstats`, `cfrules_read_status`, `credits`, `credits_numrefs`, `credits_saved`, `credits_canspend`, `credits_score`, `credits_interest`, `credits_statement`, `credits_alert`, `credits_canearn`, `casino_cash`, `post_thanks_user_amount`, `post_thanks_thanked_posts`, `post_thanks_thanked_times`, `facebook`, `myspace`, `twitter`, `youtube`, `linkedin`, `hyves`, `pm_attachments`, `social_int`, `country_iso2`, `geoip_region`, `ua_type`, `google_auth`) VALUES
(302180584, 2, 'skiisalot', '1dc8e8c70f6fcc928e0a96744a6b93ab', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1536080558, 0, 1536080558, 1536080869, 0, 0, '-5', 0, 45095254, '', -1, -1, '66.29.165.154', 0, 1, 0, 0, '2018-09-04', ';\".', 2, 'activated', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1536080592, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'US', 'Utah', 'browser', NULL),
(302180583, 11, 'badssk', 'b48c09a7af5d4e002a8ccb8eee45fc2e', '[email protected]', 0, '', '', '', '', '', 'Banned', 0, 1536060314, 0, 1536060314, 1536063706, 1536063698, 0, '2', 0, 45095318, '', -1, -1, '185.252.187.50', 0, 1, 0, 0, '2018-09-04', 'nBe', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 303022610, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 5250, 0, 0, 1, 0, 1536063380, 'none', 'none', 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 'unknown', NULL),
(302180582, 2, 'ccenews', '55429a02485e7551522cbc3c57ac0b13', '[email protected]', 0, '', 'https://cce.com.vn/', '', '', '', 'Registered User', 0, 1536052486, 0, 1536052486, 1536055480, 0, 0, '-5', 0, 45094998, '', -1, -1, '183.80.74.115', 0, 1, 0, 0, '2018-09-04', '7Hf', 2, 'init', 1, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 1, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1536053092, 'none', 'none', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, 0, 'VN', 'Ho Chi Minh', 'browser', NULL),
(302180581, 2, 'linhle0117', 'f3239796c4b0135c064b8157c9000a4f', '[email protected]', 0, '', 'http://nesanet.org/', '', '', '', 'Registered User', 0, 1536052117, 0, 1536050541, 1536052662, 0, 0, '-5', 0, 45094998, '10-15-1994', -1, -1, '183.80.74.115', 0, 1, 0, 0, '2018-09-04', 'Yzk', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '1994-10-15', 1, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1536052249, 'none', 'none', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, 0, 'GB', 'London, City of', 'browser', NULL),
(302180580, 2, 'Pollardd', 'c82d5fd7867585422356091965b2c6cc', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1536030731, 0, 1536045323, 1536062225, 1536032570, 1, '10', 0, 45094998, '', -1, -1, '1.129.108.216', 0, 1, 0, 0, '2018-09-03', '{ak', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 5890, 0, 0, 1, 0, 1536030785, 'none', 'none', 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'AU', 'New South Wales', 'browser', NULL),
(302180579, 2, 'peterfarge', '13cd9750a7d8ca517062dca36a8495bd', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1536006203, 0, 1536090560, 1536094481, 1536072217, 4, '-5', 0, 45094998, '', -1, -1, '91.66.10.244', 0, 1, 0, 0, '2018-09-03', 'E=B', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 303022618, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 6740, 0, 0, 1, 0, 1536006267, 'none', 'none', 1, 0, 3, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'DE', 'Berlin', 'browser', NULL),
(302180578, 2, 'geofreyr', '2964ccfc88397ec775cd9c3f26c3f6cc', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1535981181, 0, 1535981181, 1535981287, 0, 0, '12', 0, 45095254, '', -1, -1, '118.148.119.49', 0, 1, 0, 0, '2018-09-03', 'yrs', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535981220, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'NZ', 'Auckland', 'browser', NULL),
(302180577, 3, 'Gayathri K P', '9779dde59c727c2e68146947f46829a9', '[email protected]', 0, '', '', '', '', '', 'Users Awaiting Email Confirmation', 0, 1535965332, 0, 1535965332, 1535965572, 0, 0, '5.5', 0, 45094998, '', -1, -1, '124.124.65.141', 0, 1, 0, 0, '2018-09-03', 'HPD', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535965350, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'IN', 'Karnataka', 'browser', NULL),
(302180576, 2, 'MeriIbarra', '0dad5952ecd962e195bf5023836973e8', '[email protected]', 0, '', 'http://www.creatorofchange.com/user-profile/tabid/90/userId/868757/Default.aspx', '', '', '', 'Registered User', 0, 1535918421, 0, 1535918421, 1535919015, 0, 0, '-5', 0, 45094998, '08-04-1980', -1, -1, '49.148.28.131', 0, 1, 0, 0, '2018-09-02', 'Xcq', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '1980-08-04', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535919012, 'none', 'none', 0, 0, 0, 0, 0, 'https://www.facebook', '', 'https://twitter.com/', '', '', '', 0, 2, 'PH', 'Rizal', 'browser', NULL),
(302180575, 2, 'vikas135791', 'a5be4f6e52a5c5e3c38a96126b985f2f', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1535917286, 0, 1535917286, 1535917299, 0, 0, '-5', 0, 45095126, '', -1, -1, '67.216.181.5', 0, 1, 0, 0, '2018-09-02', 'Cde', 2, 'activated', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535917298, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'US', 'Michigan', 'browser', NULL),
(302180574, 2, 'AntwanNgy', 'd5a39cf986d11469a4bf3dd435ecf3f0', '[email protected]', 0, '', 'http://www.casinoechtgeldspelen.com/', '', '', '', 'Registered User', 0, 1535879791, 0, 1535879791, 1535888396, 0, 0, '-5', 0, 45094998, '05-25-1971', -1, -1, '192.227.248.92', 0, 1, 0, 0, '2018-09-02', 'C`_', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '1971-05-25', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535888393, 'none', 'none', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, 0, 'US', 'New York', 'browser', NULL),
(302180573, 2, 'v0dka', 'f771f8231159ff9a5d39e281dfe19c5c', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1535875045, 0, 1535875045, 1535875195, 0, 0, '3', 0, 45094998, '', -1, -1, '88.248.245.186', 0, 1, 0, 0, '2018-09-02', '>nP', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535875090, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'TR', 'Konya', 'browser', NULL),
(302180572, 3, 'JackSchenk', 'b0f12365f1544048bc336b4856f84b0e', '[email protected]', 0, '', '', '', '', '', 'Users Awaiting Email Confirmation', 0, 1535850173, 0, 1535850173, 1535896496, 0, 0, '-5', 0, 45094998, '', -1, -1, '173.234.154.71', 0, 1, 0, 0, '2018-09-01', '}k\'', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535896494, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'US', 'New York', 'browser', NULL),
`userid` int(10) UNSIGNED NOT NULL,
`usergroupid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`username` varchar(100) NOT NULL DEFAULT '',
`password` varchar(32) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`styleid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`parentemail` varchar(50) NOT NULL DEFAULT '',
`homepage` varchar(100) NOT NULL DEFAULT '',
`icq` varchar(20) NOT NULL DEFAULT '',
`aim` varchar(20) NOT NULL DEFAULT '',
`yahoo` varchar(32) NOT NULL DEFAULT '',
`usertitle` varchar(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',
`posts` int(10) UNSIGNED NOT NULL DEFAULT '0',
`timezoneoffset` varchar(4) NOT NULL DEFAULT '',
`avatarid` smallint(6) NOT NULL DEFAULT '0',
`options` int(10) UNSIGNED NOT NULL DEFAULT '0',
`birthday` varchar(10) NOT NULL DEFAULT '0000-00-00',
`maxposts` smallint(6) NOT NULL DEFAULT '-1',
`startofweek` smallint(6) NOT NULL DEFAULT '1',
`ipaddress` varchar(45) NOT NULL,
`referrerid` int(10) UNSIGNED NOT NULL DEFAULT '0',
`pmpopup` smallint(6) NOT NULL DEFAULT '0',
`pmtotal` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`pmunread` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`passworddate` date NOT NULL DEFAULT '1000-01-01',
`salt` char(30) NOT NULL,
`showvbcode` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`msn` varchar(100) NOT NULL COMMENT 'Neo: Using this for storing bbverify cookie read during registration',
`avatarrevision` int(10) UNSIGNED NOT NULL DEFAULT '0',
`membergroupids` varchar(250) NOT NULL DEFAULT '',
`displaygroupid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`reputation` int(11) NOT NULL DEFAULT '10',
`reputationlevelid` int(10) UNSIGNED NOT NULL DEFAULT '1',
`languageid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`threadedmode` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`emailstamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
`autosubscribe` smallint(6) NOT NULL DEFAULT '-1',
`birthday_search` date NOT NULL DEFAULT '1000-01-01',
`profilepicrevision` int(10) UNSIGNED NOT NULL DEFAULT '0',
`showbirthday` smallint(5) UNSIGNED NOT NULL DEFAULT '2',
`skype` varchar(32) NOT NULL DEFAULT '',
`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) NOT NULL DEFAULT '',
`infractiongroupid` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`threads` int(10) UNSIGNED NOT NULL DEFAULT '0',
`emailDate` int(11) NOT NULL,
`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',
`cfrules_read_status` tinyint(1) NOT NULL DEFAULT '0',
`credits` double NOT NULL DEFAULT '0',
`credits_numrefs` int(10) UNSIGNED NOT NULL DEFAULT '0',
`credits_saved` double NOT NULL DEFAULT '0',
`credits_canspend` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
`credits_score` int(11) NOT NULL DEFAULT '0',
`credits_interest` int(10) UNSIGNED NOT NULL DEFAULT '0',
`credits_statement` varchar(255) NOT NULL DEFAULT 'none',
`credits_alert` varchar(255) NOT NULL DEFAULT 'none',
`credits_canearn` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
`casino_cash` int(11) DEFAULT '0',
`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',
`facebook` varchar(20) DEFAULT NULL,
`myspace` varchar(20) DEFAULT NULL COMMENT 'using xing in this field',
`twitter` varchar(20) DEFAULT NULL,
`youtube` varchar(20) DEFAULT NULL,
`linkedin` varchar(20) DEFAULT NULL,
`hyves` varchar(20) DEFAULT NULL,
`pm_attachments` int(10) UNSIGNED NOT NULL DEFAULT '0',
`social_int` tinyint(4) UNSIGNED NOT NULL DEFAULT '0',
`country_iso2` varchar(2) DEFAULT NULL,
`geoip_region` varchar(20) DEFAULT NULL,
`ua_type` varchar(15) NOT NULL DEFAULT 'unknown',
`google_auth` varchar(256) DEFAULT NULL COMMENT 'secret key for google authenticator'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `user`
--
INSERT INTO `user` (`userid`, `usergroupid`, `username`, `password`, `email`, `styleid`, `parentemail`, `homepage`, `icq`, `aim`, `yahoo`, `usertitle`, `customtitle`, `joindate`, `daysprune`, `lastvisit`, `lastactivity`, `lastpost`, `posts`, `timezoneoffset`, `avatarid`, `options`, `birthday`, `maxposts`, `startofweek`, `ipaddress`, `referrerid`, `pmpopup`, `pmtotal`, `pmunread`, `passworddate`, `salt`, `showvbcode`, `msn`, `avatarrevision`, `membergroupids`, `displaygroupid`, `reputation`, `reputationlevelid`, `languageid`, `threadedmode`, `emailstamp`, `autosubscribe`, `birthday_search`, `profilepicrevision`, `showbirthday`, `skype`, `adminoptions`, `lastpostid`, `sigpicrevision`, `ipoints`, `infractions`, `warnings`, `infractiongroupids`, `infractiongroupid`, `threads`, `emailDate`, `profilevisits`, `friendcount`, `friendreqcount`, `vmunreadcount`, `vmmoderatedcount`, `socgroupinvitecount`, `socgroupreqcount`, `pcunreadcount`, `pcmoderatedcount`, `gmmoderatedcount`, `showcybstats`, `cfrules_read_status`, `credits`, `credits_numrefs`, `credits_saved`, `credits_canspend`, `credits_score`, `credits_interest`, `credits_statement`, `credits_alert`, `credits_canearn`, `casino_cash`, `post_thanks_user_amount`, `post_thanks_thanked_posts`, `post_thanks_thanked_times`, `facebook`, `myspace`, `twitter`, `youtube`, `linkedin`, `hyves`, `pm_attachments`, `social_int`, `country_iso2`, `geoip_region`, `ua_type`, `google_auth`) VALUES
(302180584, 2, 'skiisalot', '1dc8e8c70f6fcc928e0a96744a6b93ab', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1536080558, 0, 1536080558, 1536080869, 0, 0, '-5', 0, 45095254, '', -1, -1, '66.29.165.154', 0, 1, 0, 0, '2018-09-04', ';\".', 2, 'activated', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1536080592, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'US', 'Utah', 'browser', NULL),
(302180583, 11, 'badssk', 'b48c09a7af5d4e002a8ccb8eee45fc2e', '[email protected]', 0, '', '', '', '', '', 'Banned', 0, 1536060314, 0, 1536060314, 1536063706, 1536063698, 0, '2', 0, 45095318, '', -1, -1, '185.252.187.50', 0, 1, 0, 0, '2018-09-04', 'nBe', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 303022610, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 5250, 0, 0, 1, 0, 1536063380, 'none', 'none', 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, 'unknown', NULL),
(302180582, 2, 'ccenews', '55429a02485e7551522cbc3c57ac0b13', '[email protected]', 0, '', 'https://cce.com.vn/', '', '', '', 'Registered User', 0, 1536052486, 0, 1536052486, 1536055480, 0, 0, '-5', 0, 45094998, '', -1, -1, '183.80.74.115', 0, 1, 0, 0, '2018-09-04', '7Hf', 2, 'init', 1, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 1, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1536053092, 'none', 'none', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, 0, 'VN', 'Ho Chi Minh', 'browser', NULL),
(302180581, 2, 'linhle0117', 'f3239796c4b0135c064b8157c9000a4f', '[email protected]', 0, '', 'http://nesanet.org/', '', '', '', 'Registered User', 0, 1536052117, 0, 1536050541, 1536052662, 0, 0, '-5', 0, 45094998, '10-15-1994', -1, -1, '183.80.74.115', 0, 1, 0, 0, '2018-09-04', 'Yzk', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '1994-10-15', 1, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1536052249, 'none', 'none', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, 0, 'GB', 'London, City of', 'browser', NULL),
(302180580, 2, 'Pollardd', 'c82d5fd7867585422356091965b2c6cc', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1536030731, 0, 1536045323, 1536062225, 1536032570, 1, '10', 0, 45094998, '', -1, -1, '1.129.108.216', 0, 1, 0, 0, '2018-09-03', '{ak', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 5890, 0, 0, 1, 0, 1536030785, 'none', 'none', 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'AU', 'New South Wales', 'browser', NULL),
(302180579, 2, 'peterfarge', '13cd9750a7d8ca517062dca36a8495bd', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1536006203, 0, 1536090560, 1536094481, 1536072217, 4, '-5', 0, 45094998, '', -1, -1, '91.66.10.244', 0, 1, 0, 0, '2018-09-03', 'E=B', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 303022618, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 6740, 0, 0, 1, 0, 1536006267, 'none', 'none', 1, 0, 3, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'DE', 'Berlin', 'browser', NULL),
(302180578, 2, 'geofreyr', '2964ccfc88397ec775cd9c3f26c3f6cc', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1535981181, 0, 1535981181, 1535981287, 0, 0, '12', 0, 45095254, '', -1, -1, '118.148.119.49', 0, 1, 0, 0, '2018-09-03', 'yrs', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535981220, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'NZ', 'Auckland', 'browser', NULL),
(302180577, 3, 'Gayathri K P', '9779dde59c727c2e68146947f46829a9', '[email protected]', 0, '', '', '', '', '', 'Users Awaiting Email Confirmation', 0, 1535965332, 0, 1535965332, 1535965572, 0, 0, '5.5', 0, 45094998, '', -1, -1, '124.124.65.141', 0, 1, 0, 0, '2018-09-03', 'HPD', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535965350, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'IN', 'Karnataka', 'browser', NULL),
(302180576, 2, 'MeriIbarra', '0dad5952ecd962e195bf5023836973e8', '[email protected]', 0, '', 'http://www.creatorofchange.com/user-profile/tabid/90/userId/868757/Default.aspx', '', '', '', 'Registered User', 0, 1535918421, 0, 1535918421, 1535919015, 0, 0, '-5', 0, 45094998, '08-04-1980', -1, -1, '49.148.28.131', 0, 1, 0, 0, '2018-09-02', 'Xcq', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '1980-08-04', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535919012, 'none', 'none', 0, 0, 0, 0, 0, 'https://www.facebook', '', 'https://twitter.com/', '', '', '', 0, 2, 'PH', 'Rizal', 'browser', NULL),
(302180575, 2, 'vikas135791', 'a5be4f6e52a5c5e3c38a96126b985f2f', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1535917286, 0, 1535917286, 1535917299, 0, 0, '-5', 0, 45095126, '', -1, -1, '67.216.181.5', 0, 1, 0, 0, '2018-09-02', 'Cde', 2, 'activated', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535917298, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'US', 'Michigan', 'browser', NULL),
(302180574, 2, 'AntwanNgy', 'd5a39cf986d11469a4bf3dd435ecf3f0', '[email protected]', 0, '', 'http://www.casinoechtgeldspelen.com/', '', '', '', 'Registered User', 0, 1535879791, 0, 1535879791, 1535888396, 0, 0, '-5', 0, 45094998, '05-25-1971', -1, -1, '192.227.248.92', 0, 1, 0, 0, '2018-09-02', 'C`_', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '1971-05-25', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535888393, 'none', 'none', 0, 0, 0, 0, 0, '', '', '', '', '', '', 0, 0, 'US', 'New York', 'browser', NULL),
(302180573, 2, 'v0dka', 'f771f8231159ff9a5d39e281dfe19c5c', '[email protected]', 0, '', '', '', '', '', 'Registered User', 0, 1535875045, 0, 1535875045, 1535875195, 0, 0, '3', 0, 45094998, '', -1, -1, '88.248.245.186', 0, 1, 0, 0, '2018-09-02', '>nP', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535875090, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'TR', 'Konya', 'browser', NULL),
(302180572, 3, 'JackSchenk', 'b0f12365f1544048bc336b4856f84b0e', '[email protected]', 0, '', '', '', '', '', 'Users Awaiting Email Confirmation', 0, 1535850173, 0, 1535850173, 1535896496, 0, 0, '-5', 0, 45094998, '', -1, -1, '173.234.154.71', 0, 1, 0, 0, '2018-09-01', '}k\'', 2, 'init', 0, '', 0, 10, 6, 1, 0, 0, 1, '0000-00-00', 0, 0, '', 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1535896494, 'none', 'none', 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 'US', 'New York', 'browser', NULL),