08-20-2023, 11:29 PM
In May 2016, the cracking community forum known as Nulled.cr was hacked and 599k user accounts were leaked publicly. The compromised data included email and IP addresses, weak salted MD5 password hashes and hundreds of thousands of private messages between members.
Compromised data: Dates of birth, Email addresses, IP addresses, Passwords, Private messages, Usernames, Website activity
Code:
CREATE TABLE `members` (
`member_id` mediumint(8) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`member_group_id` smallint(3) NOT NULL DEFAULT '0',
`email` varchar(150) NOT NULL DEFAULT '',
`joined` int(10) NOT NULL DEFAULT '0',
`ip_address` varchar(46) NOT NULL DEFAULT '',
`posts` mediumint(7) DEFAULT '0',
`title` varchar(64) DEFAULT NULL,
`allow_admin_mails` tinyint(1) DEFAULT NULL,
`time_offset` varchar(10) DEFAULT NULL,
`skin` smallint(5) DEFAULT NULL,
`warn_level` int(10) DEFAULT NULL,
`warn_lastwarn` int(10) NOT NULL DEFAULT '0',
`language` mediumint(4) DEFAULT NULL,
`last_post` int(10) DEFAULT NULL,
`restrict_post` varchar(100) NOT NULL DEFAULT '0',
`view_sigs` tinyint(1) DEFAULT '1',
`view_img` tinyint(1) DEFAULT '1',
`bday_day` int(2) DEFAULT NULL,
`bday_month` int(2) DEFAULT NULL,
`bday_year` int(4) DEFAULT NULL,
`msg_count_new` int(2) NOT NULL DEFAULT '0',
`msg_count_total` int(3) NOT NULL DEFAULT '0',
`msg_count_reset` int(1) NOT NULL DEFAULT '0',
`msg_show_notification` int(1) NOT NULL DEFAULT '0',
`misc` varchar(128) DEFAULT NULL,
`last_visit` int(10) DEFAULT '0',
`last_activity` int(10) DEFAULT '0',
`dst_in_use` tinyint(1) DEFAULT '0',
`coppa_user` tinyint(1) DEFAULT '0',
`mod_posts` varchar(100) NOT NULL DEFAULT '0',
`auto_track` varchar(50) DEFAULT '0',
`temp_ban` varchar(100) DEFAULT '0',
`login_anonymous` char(3) NOT NULL DEFAULT '0&0',
`ignored_users` text,
`mgroup_others` varchar(255) NOT NULL DEFAULT '',
`org_perm_id` varchar(255) NOT NULL DEFAULT '',
`member_login_key` varchar(32) NOT NULL DEFAULT '',
`member_login_key_expire` int(10) NOT NULL DEFAULT '0',
`has_blog` text,
`blogs_recache` tinyint(1) DEFAULT NULL,
`has_gallery` tinyint(1) NOT NULL DEFAULT '0',
`members_auto_dst` tinyint(1) NOT NULL DEFAULT '1',
`members_display_name` varchar(255) NOT NULL DEFAULT '',
`members_seo_name` varchar(255) NOT NULL DEFAULT '',
`members_created_remote` tinyint(1) NOT NULL DEFAULT '0',
`members_cache` mediumtext,
`members_disable_pm` int(1) NOT NULL DEFAULT '0',
`members_l_display_name` varchar(255) NOT NULL DEFAULT '',
`members_l_username` varchar(255) NOT NULL DEFAULT '',
`failed_logins` text,
`failed_login_count` smallint(3) NOT NULL DEFAULT '0',
`members_profile_views` int(10) unsigned NOT NULL DEFAULT '0',
`members_pass_hash` varchar(32) NOT NULL DEFAULT '',
`members_pass_salt` varchar(5) NOT NULL DEFAULT '',
`member_banned` tinyint(1) NOT NULL DEFAULT '0',
`member_uploader` varchar(32) NOT NULL DEFAULT 'default',
`members_bitoptions` int(10) unsigned NOT NULL DEFAULT '0',
`fb_uid` bigint(20) unsigned NOT NULL DEFAULT '0',
`fb_emailhash` varchar(60) NOT NULL DEFAULT '',
`fb_lastsync` int(10) NOT NULL DEFAULT '0',
`members_day_posts` varchar(32) NOT NULL DEFAULT '0,0',
`live_id` varchar(32) DEFAULT NULL,
`twitter_id` varchar(255) NOT NULL DEFAULT '',
`twitter_token` varchar(255) NOT NULL DEFAULT '',
`twitter_secret` varchar(255) NOT NULL DEFAULT '',
`notification_cnt` mediumint(9) NOT NULL DEFAULT '0',
`tc_lastsync` int(10) NOT NULL DEFAULT '0',
`fb_session` varchar(200) NOT NULL DEFAULT '',
`fb_token` text,
`ips_mobile_token` varchar(64) DEFAULT NULL,
`unacknowledged_warnings` tinyint(1) DEFAULT NULL,
`ipsconnect_id` int(10) NOT NULL DEFAULT '0',
`ipsconnect_revalidate_url` text,
`chat_banned` tinyint(1) NOT NULL DEFAULT '0',
`ban_reason` varchar(255) DEFAULT NULL,
`cm_credits` float NOT NULL DEFAULT '0',
`cm_reg` int(11) NOT NULL DEFAULT '0',
`referred_by` int(11) NOT NULL DEFAULT '0',
`cm_no_sev` tinyint(1) DEFAULT '0',
`cim_profile_id` varchar(32) DEFAULT '',
`cim_payment_id` int(10) DEFAULT '0',
`cim_method` int(5) NOT NULL DEFAULT '0',
`cm_return_group` smallint(3) NOT NULL DEFAULT '0',
`leecherValue` double DEFAULT NULL,
`theme_color` int(12) DEFAULT NULL,
`transparent_header` int(1) NOT NULL DEFAULT '0',
`hide_borders` int(1) NOT NULL DEFAULT '0',
`twostepauth_enabled` tinyint(1) NOT NULL DEFAULT '0',
`twostepauth_frontend` tinyint(1) NOT NULL DEFAULT '1',
`twostepauth_secretkey` varchar(32) DEFAULT NULL,
`banned_posts_shown` int(1) DEFAULT '1',
`vip_expire_date` int(32) DEFAULT NULL,
`auth_key` varchar(32) NOT NULL,
`auth_key_md5` varchar(32) NOT NULL,
`hue_group_image` varchar(32) DEFAULT NULL,
`hue_value` int(4) NOT NULL,
`newsletter_email` varchar(55) NOT NULL,
`auth_banned` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`member_id`),
KEY `members_l_display_name` (`members_l_display_name`),
KEY `members_l_username` (`members_l_username`),
KEY `mgroup` (`member_group_id`,`member_id`),
KEY `member_groups` (`member_group_id`,`mgroup_others`),
KEY `bday_day` (`bday_day`),
KEY `bday_month` (`bday_month`),
KEY `member_banned` (`member_banned`),
KEY `members_bitoptions` (`members_bitoptions`),
KEY `ip_address` (`ip_address`),
KEY `failed_login_count` (`failed_login_count`),
KEY `joined` (`joined`),
KEY `fb_uid` (`fb_uid`),
KEY `twitter_id` (`twitter_id`),
KEY `email` (`email`),
KEY `blogs_recache` (`blogs_recache`)
) ENGINE=InnoDB AUTO_INCREMENT=599202 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `members`
--
LOCK TABLES `members` WRITE;
/*!40000 ALTER TABLE `members` DISABLE KEYS */;
INSERT INTO `members` VALUES (1,'OxideNigga',49,'staffnulled@nulled.cr',1421094657,'0.0.0.0',305,':doge:',0,'0',20,0,0,1,1461103732,'',1,1,1,1,1990,3,738,1,1,NULL,1462475974,1462476313,0,0,'','','1462476542:1548790142:999:d','1&1','a:0:{}','','','93b1d8ba3c99fed411284d7d5bfb4d5b',1463080774,'',NULL,0,1,'Oxide','oxide',0,'a:17:{s:11:\"report_temp\";a:1:{s:11:\"post_marker\";a:3:{s:5:\"forum\";a:1:{i:70;a:2:{s:4:\"info\";a:3:{s:2:\"id\";s:5:\"29627\";s:5:\"title\";s:53:\"MAKE $10 to $15 A DAY BY LISTENING TO MUSIC\";s:6:\"com_id\";s:1:\"2\";}s:3:\"gfx\";i:1;}}s:5:\"topic\";a:1:{i:161596;a:2:{s:4:\"info\";a:3:{s:2:\"id\";s:5:\"29627\";s:5:\"title\";s:53:\"MAKE $10 to $15 A DAY BY LISTENING TO MUSIC\";s:6:\"com_id\";s:1:\"2\";}s:3:\"gfx\";i:1;}}s:4:\"post\";a:1:{i:3979170;a:2:{s:4:\"info\";a:3:{s:2:\"id\";s:5:\"29627\";s:5:\"title\";s:53:\"MAKE $10 to $15 A DAY BY LISTENING TO MUSIC\";s:6:\"com_id\";s:1:\"2\";}s:3:\"gfx\";i:1;}}}}s:19:\"report_last_updated\";i:1461621086;s:10:\"report_num\";s:1:\"1\";s:13:\"msgAlertReset\";i:1462475975;s:7:\"friends\";a:255:{i:18;s:1:\"1\";i:58;s:1:\"1\";i:75;s:1:\"1\";i:160;s:1:\"1\";i:162;s:1:\"1\";i:334;s:1:\"1\";i:411;s:1:\"1\";i:508;s:1:\"1\";i:894;s:1:\"1\";i:1332;s:1:\"1\";i:1471;s:1:\"1\";i:1941;s:1:\"1\";i:2393;s:1:\"1\";i:2902;s:1:\"1\";i:2904;s:1:\"1\";i:3210;s:1:\"1\";i:3236;s:1:\"1\";i:3719;s:1:\"1\";i:4456;s:1:\"1\";i:4794;s:1:\"1\";i:4998;s:1:\"1\";i:5212;s:1:\"1\";i:5317;s:1:\"1\";i:5370;s:1:\"1\";i:5529;s:1:\"1\";i:6975;s:1:\"1\";i:7615;s:1:\"1\";i:7646;s:1:\"1\";i:8841;s:1:\"1\";i:9047;s:1:\"1\";i:9248;s:1:\"1\";i:11243;s:1:\"1\";i:13927;s:1:\"1\";i:14294;s:1:\"1\";i:14309;s:1:\"1\";i:15137;s:1:\"1\";i:15796;s:1:\"1\";i:17227;s:1:\"1\";i:17461;s:1:\"1\";i:18020;s:1:\"1\";i:18662;s:1:\"1\";i:19704;s:1:\"1\";i:19722;s:1:\"1\";i:20200;s:1:\"1\";i:20401;s:1:\"1\";i:20514;s:1:\"1\";i:20797;s:1:\"1\";i:21489;s:1:\"1\";i:22239;s:1:\"1\";i:22736;s:1:\"1\";i:27130;s:1:\"1\";i:27712;s:1:\"1\";i:28524;s:1:\"1\";i:28922;s:1:\"1\";i:29246;s:1:\"1\";i:30290;s:1:\"1\";i:32465;s:1:\"1\";i:33884;s:1:\"1\";i:34821;s:1:\"1\";i:35135;s:1:\"1\";i:35849;s:1:\"1\";i:35857;s:1:\"1\";i:36325;s:1:\"1\";i:36512;s:1:\"1\";i:36808;s:1:\"1\";i:37480;s:1:\"1\";i:38778;s:1:\"1\";i:39157;s:1:\"1\";i:39346;s:1:\"1\";i:39594;s:1:\"1\";i:39598;s:1:\"1\";i:40007;s:1:\"1\";i:44603;s:1:\"1\";i:45739;s:1:\"1\";i:46811;s:1:\"1\";i:47235;s:1:\"1\";i:48005;s:1:\"1\";i:49112;s:1:\"1\";i:49380;s:1:\"1\";i:51356;s:1:\"1\";i:52129;s:1:\"1\";i:54297;s:1:\"1\";i:54435;s:1:\"1\";i:56434;s:1:\"1\";i:57391;s:1:\"1\";i:63647;s:1:\"1\";i:63934;s:1:\"1\";i:68079;s:1:\"1\";i:68098;s:1:\"1\";i:69355;s:1:\"1\";i:69695;s:1:\"1\";i:69979;s:1:\"1\";i:70029;s:1:\"1\";i:70364;s:1:\"1\";i:73347;s:1:\"1\";i:73701;s:1:\"1\";i:76659;s:1:\"1\";i:76917;s:1:\"1\";i:78560;s:1:\"1\";i:83194;s:1:\"1\";i:84941;s:1:\"1\";i:86329;s:1:\"1\";i:87666;s:1:\"1\";i:90091;s:1:\"1\";i:91232;s:1:\"1\";i:92211;s:1:\"1\";i:92833;s:1:\"1\";i:93283;s:1:\"1\";i:99257;s:1:\"1\";i:99717;s:1:\"1\";i:101723;s:1:\"1\";i:102779;s:1:\"1\";i:104923;s:1:\"1\";i:105552;s:1:\"1\";i:106763;s:1:\"1\";i:107077;s:1:\"1\";i:113696;s:1:\"1\";i:113926;s:1:\"1\";i:114311;s:1:\"1\";i:115528;s:1:\"1\";i:119752;s:1:\"1\";i:120495;s:1:\"1\";i:120801;s:1:\"1\";i:126559;s:1:\"1\";i:131475;s:1:\"1\";i:140702;s:1:\"1\";i:143592;s:1:\"1\";i:147200;s:1:\"1\";i:147386;s:1:\"1\";i:153679;s:1:\"1\";i:154459;s:1:\"1\";i:154572;s:1:\"1\";i:155494;s:1:\"1\";i:156840;s:1:\"1\";i:158733;s:1:\"1\";i:162117;s:1:\"1\";i:162638;s:1:\"1\";i:163340;s:1:\"1\";i:163774;s:1:\"1\";i:165523;s:1:\"1\";i:166781;s:1:\"1\";i:170016;s:1:\"1\";i:170818;s:1:\"1\";i:173492;s:1:\"1\";i:177181;s:1:\"1\";i:179048;s:1:\"1\";i:182142;s:1:\"1\";i:182278;s:1:\"1\";i:195522;s:1:\"1\";i:201439;s:1:\"1\";i:205697;s:1:\"1\";i:208964;s:1:\"1\";i:210548;s:1:\"1\";i:213878;s:1:\"1\";i:215090;s:1:\"1\";i:218475;s:1:\"1\";i:219317;s:1:\"1\";i:220552;s:1:\"1\";i:221425;s:1:\"1\";i:223882;s:1:\"1\";i:229101;s:1:\"1\";i:229759;s:1:\"1\";i:232168;s:1:\"1\";i:239970;s:1:\"1\";i:246103;s:1:\"1\";i:247246;s:1:\"1\";i:248541;s:1:\"1\";i:248858;s:1:\"1\";i:253616;s:1:\"1\";i:263253;s:1:\"1\";i:265946;s:1:\"1\";i:270707;s:1:\"1\";i:271094;s:1:\"1\";i:289135;s:1:\"1\";i:291165;s:1:\"1\";i:293715;s:1:\"1\";i:294553;s:1:\"1\";i:299322;s:1:\"1\";i:300325;s:1:\"1\";i:307796;s:1:\"1\";i:308308;s:1:\"1\";i:308370;s:1:\"1\";i:317480;s:1:\"1\";i:320375;s:1:\"1\";i:321828;s:1:\"1\";i:324162;s:1:\"1\";i:324385;s:1:\"1\";i:327780;s:1:\"1\";i:330549;s:1:\"1\";i:340575;s:1:\"1\";i:341620;s:1:\"1\";i:342376;s:1:\"1\";i:342933;s:1:\"1\";i:342952;s:1:\"1\";i:347912;s:1:\"1\";i:349793;s:1:\"1\";i:350378;s:1:\"1\";i:362376;s:1:\"1\";i:363085;s:1:\"1\";i:368032;s:1:\"1\";i:371013;s:1:\"1\";i:371648;s:1:\"1\";i:373291;s:1:\"1\";i:376686;s:1:\"1\";i:378576;s:1:\"1\";i:380746;s:1:\"1\";i:381311;s:1:\"1\";i:382693;s:1:\"1\";i:400276;s:1:\"1\";i:404654;s:1:\"1\";i:405916;s:1:\"1\";i:407335;s:1:\"1\";i:408255;s:1:\"1\";i:408995;s:1:\"1\";i:409131;s:1:\"1\";i:410101;s:1:\"1\";i:410544;s:1:\"1\";i:412931;s:1:\"1\";i:417378;s:1:\"1\";i:420805;s:1:\"1\";i:421985;s:1:\"1\";i:422871;s:1:\"1\";i:428453;s:1:\"1\";i:430217;s:1:\"1\";i:431315;s:1:\"1\";i:431515;s:1:\"1\";i:448755;s:1:\"1\";i:455417;s:1:\"1\";i:456815;s:1:\"1\";i:458307;s:1:\"1\";i:458567;s:1:\"1\";i:459644;s:1:\"1\";i:462847;s:1:\"1\";i:467381;s:1:\"1\";i:471597;s:1:\"1\";i:474434;s:1:\"1\";i:477118;s:1:\"1\";i:478482;s:1:\"1\";i:480585;s:1:\"1\";i:480955;s:1:\"1\";i:486490;s:1:\"1\";i:489954;s:1:\"1\";i:491098;s:1:\"1\";i:492824;s:1:\"1\";i:497188;s:1:\"1\";i:508554;s:1:\"1\";i:510992;s:1:\"1\";i:512335;s:1:\"1\";i:520126;s:1:\"1\";i:529826;s:1:\"1\";i:553612;s:1:\"1\";i:567264;s:1:\"1\";i:578767;s:1:\"1\";i:581825;s:1:\"1\";i:590459;s:1:\"1\";}s:14:\"shoutbox_prefs\";s:185:\"a:6:{s:15:\"shoutbox_height\";i:478;s:16:\"shoutbox_gheight\";i:281;s:14:\"global_display\";i:1;s:15:\"enter_key_shout\";i:1;s:21:\"enable_quick_commands\";i:1;s:22:\"display_refresh_button\";i:1;}\";s:13:\"notifications\";a:24:{s:13:\"report_center\";a:1:{s:8:\"selected\";a:0:{}}s:11:\"new_comment\";a:1:{s:8:\"selected\";a:1:{i:0;s:5:\"email\";}}s:11:\"post_quoted\";a:1:{s:8:\"selected\";a:1:{i:0;s:5:\"email\";}}s:13:\"classify_leak\";a:1:{s:8:\"selected\";a:1:{i:0;s:6:\"inline\";}}s:9:\"new_likes\";a:1:{s:8:\"selected\";a:1:{i:0;s:5:\"email\";}}s:15:\"followed_topics\";a:1:{s:8:\"selected\";a:1:{i:0;s:5:\"email\";}}s:15:\"followed_forums\";a:1:{s:8:\"selected\";a:1:{i:0;s:5:\"email\";}}s:22:\"followed_topics_digest\";a:1:{s:8:\"selected\";a:1:{i:0;s:5:\"email\";}}s:22:\"followed_forums_digest\";a:1:{s:8:\"selected\";a:1:{i:0;s:5:\"email\";}}s:19:\"reputation_positive\";a:1:{s:8:\"selected\";a:1:{i:0;s:6:\"inline\";}}s:19:\"reputation_negative\";a:1:{s:8:\"selected\";a:1:{i:0;s:6:\"inline\";}}s:15:\"profile_comment\";a:1:{s:8:\"selected\";a:1:{i:0;s:6:\"inline\";}}s:14:\"friend_request\";a:1:{s:8:\"selected\";a:1:{i:0;s:6:\"inline\";}}s:22:\"friend_request_approve\";a:1:{s:8:\"selected\";a:1:{i:0;s:6:\"inline\";}}s:19:\"new_private_message\";a:1:{s:8:\"selected\";a:1:{i:0;s:5:\"email\";}}s:21:\"reply_private_message\";a:1:{s:8:\"selected\";a:1:{i:0;s:5:\"email\";}}s:22:\"invite_private_message\";a:1:{s:8:\"selected\";a:1:{i:0;s:5:\"email\";}}s:17:\"reply_your_status\";a:1:{s:8:\"selected\";a:0:{}}s:16:\"reply_any_status\";a:1:{s:8:\"selected\";a:0:{}}s:20:\"friend_status_update\";a:1:{s:8:\"selected\";a:0:{}}s:7:\"warning\";a:1:{s:8:\"selected\";a:0:{}}s:12:\"warning_mods\";a:1:{s:8:\"selected\";a:0:{}}s:24:\"pmviewer_keyword_monitor\";a:1:{s:8:\"selected\";a:0:{}}s:11:\"award_added\";a:1:{s:8:\"selected\";a:1:{i:0;s:6:\"inline\";}}}s:23:\"show_notification_popup\";i:0;s:10:\"rc_rss_key\";s:32:\"2570ab909388899ecba1187f545b3ad2\";s:13:\"gb_mark__c