[boo]

In approximately August 2013, the fantasy MMORPG game DragonNest suffered a data breach. The breach included Bios, Email addresses, Genders, Geographic Locations, IP Addresses, Names, Usernames and Passwords stored as plaintext hashes. In total, 3.1 million users were affected.

Compromised data: Bios, Email addresses, Genders, Geographic Locations, IP Addresses, Names, Usernames, Passwords



Sample:

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`cid` char(15) NOT NULL DEFAULT '',
`fid` bigint(20) DEFAULT NULL,
`fmail` varchar(255) DEFAULT NULL,
`f_full_name` varchar(255) DEFAULT NULL,
`username` varchar(255) NOT NULL,
`password` varchar(255) DEFAULT NULL,
`gender` enum('M','F') DEFAULT NULL,
`locale` varchar(3) DEFAULT NULL,
`timezone` varchar(4) DEFAULT NULL,
`last_ip` varchar(15) DEFAULT NULL,
`first_ip` varchar(15) DEFAULT NULL,
`profile_views` int(10) DEFAULT NULL,
`totalPosts` int(10) DEFAULT NULL,
`totalTopics` mediumint(8) unsigned DEFAULT NULL,
`region_id` int(10) DEFAULT NULL,
`status` smallint(6) DEFAULT NULL,
`filename` varchar(255) DEFAULT NULL,
`currentLogin` datetime DEFAULT NULL,
`lastLogin` datetime DEFAULT NULL,
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
`message` varchar(255) DEFAULT NULL,
`signature` text,
`about` text,
`fav_anime` text,
`fav_games` text,
`fav_tv_shows` text,
`fav_movies` text,
`fav_books` text,
`remarks` text,
PRIMARY KEY (`id`),
UNIQUE KEY `uc_userCID` (`cid`),
KEY `fid` (`fid`),
KEY `cid_username_index` (`cid`,`username`),
KEY `username_cid_index` (`username`,`cid`),
KEY `first_ip_created_index` (`first_ip`,`created`)
) ENGINE=InnoDB AUTO_INCREMENT=3148551 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('20', 'T1010141716653H', '0', '', '', ' 我是超人', '', 'M', '', '', '115.42.208.82', '115.42.208.82', '14', '2', '0', '0', '0', 'moji_01.gif', '2010-10-26 11:07:21', '2010-10-25 18:19:03', '2010-10-14 17:16:02', '2012-04-02 07:11:31', 'it works!', '<p>\r\n this thing ALSO need to style leh</p>\r\n', '<p>\r\n this thing need to style leh</p>\r\n', 'Naruto', 'Dota', 'Criss Angel, Top Chef, Flashforward, Heroes', 'Iron Man', '', '');
INSERT INTO `users` VALUES ('24', 'T0708250613603A', '0', '', '', 'hwayster', '', 'M', '', '', '115.42.208.82', '115.42.208.82', '0', '0', '0', '0', '0', '05.gif', '2010-10-25 15:37:26', null, '2010-10-25 15:37:26', '2010-10-25 15:37:26', '', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('25', 'T0709171018014G', '0', '', '', 'ah_hway', '', 'M', '', '', '115.42.208.82', '115.42.208.82', '0', '2', '0', '0', '0', '05.gif', '2010-10-25 15:45:00', null, '2010-10-25 15:45:00', '2010-10-25 16:26:43', 'does not have an About Me write up :c(\n', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('26', 'T0710011890023X', '0', '', '', 'mimimi', '', 'M', '', '', '115.42.208.82', '115.42.208.82', '0', '0', '0', '0', '0', '04.png', '2010-10-26 10:33:57', '2010-10-25 15:49:07', '2010-10-25 15:49:07', '2010-10-26 10:58:08', '', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('27', 'T1010251811366D', '0', '', '', 'ID', '', 'M', '', '', '115.42.208.82', '115.42.208.82', '34', '0', '0', '0', '0', '03.png', '2010-10-26 10:53:27', '2010-10-25 18:43:13', '2010-10-25 18:41:40', '2011-11-28 13:24:03', '01010100 01101000 01101001 01110011 00100000 01110111 01100101 01100010 01110011 01101001 01110100 01100101 00100000 01110011 01110101 01100', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('28', 'T1009021799220X', '0', '', '', 'The Gardener', '', 'M', '', '', '116.12.134.130', '116.12.134.130', '44', '4', '0', '0', '0', '01.png', '2011-09-27 17:31:22', '2011-09-23 15:15:15', '2010-10-28 13:16:30', '2011-11-21 03:29:15', 'Harlow!', '<p>We are games!</p>', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('29', 'T1010291118206J', '503108686', 'eric@quaffs.com', 'Eric Chia', '超人ä¸é£ž', '', 'M', '', '', '116.12.134.130', '116.12.134.130', '2', '0', '0', '0', '0', 'fb/fb_29.jpg', '2012-04-05 08:30:55', '2012-02-21 11:28:05', '2010-10-29 11:31:04', '2012-04-05 16:31:16', 'I can\'t fly but my vibe is so fly', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('30', 'T0710011892025X', null, '', null, 'Purin', '', 'M', '', '', '112.204.183.205', '116.12.134.130', '8520', '1142', '341', '0', '1', 'fb/fb_30.gif', '2012-12-08 16:53:12', '2012-10-08 10:01:06', '2010-10-29 11:57:33', '2013-06-10 04:27:51', 'ser anu po itong promo code', '<p>\r\n .....</p>\r\n', 'soy muy genial', 'Persona The Animation', 'Rpg\'s\r\nFps\'s\r\nAction\'s', '', '', '', '');
INSERT INTO `users` VALUES ('31', 'T1011021794227X', '0', '', '', 'Cherry Administrator', '', 'M', '', '', '116.14.168.122', '116.14.168.122', '4055', '95', '83', '0', '0', 'admin_01.png', '2011-07-09 15:52:09', '2011-07-07 10:11:34', '2010-11-02 17:29:47', '2013-01-26 13:28:56', '', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('32', 'T0709242094007X', null, '', '', 'lemonduck', '', 'M', '', '', '116.12.134.130', '116.12.134.130', '16', '130', '11', '0', '0', 'mod_03.png', '2012-05-28 23:07:38', '2012-05-14 17:04:59', '2010-11-10 17:56:25', '2012-05-28 23:07:38', 'I\'m not a spammer!', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('33', 'T0709061013946C', '0', '', '', 'Hway', '', 'M', '', '', '116.12.134.130', '116.12.134.130', '3', '20', '2', '0', '0', 'dn_04.png', '2012-05-22 06:53:41', '2012-05-21 03:18:12', '2010-11-12 15:58:09', '2012-05-22 06:54:19', 'Post a status message...', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('34', 'T0801200319743B', '0', '', '', 'Waimod', '', 'M', '', '', '182.55.200.16', '115.42.208.82', '1073', '141', '10', '0', '0', 'mod_02.png', '2012-05-23 19:20:28', '2012-04-23 11:52:36', '2010-11-12 17:18:06', '2013-05-27 18:43:17', 'Dude... I love Cherry', '', '<p>\r\n If you read other forum, you might know me from before.</p>\r\n', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('35', 'T1011082199237X', '0', '', '', 'AuroraWoo!', '', 'M', '', '', '116.12.134.130', '116.12.134.130', '1', '20', '4', '0', '0', '01.png', '2010-11-12 20:41:28', '2010-11-12 20:07:53', '2010-11-12 18:38:38', '2010-11-13 14:12:04', '', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('36', 'T0709121915434J', '681960700', 'zephyr0_@hotmail.com', 'Ian Lim', 'Corinori', '', 'M', '', '', '116.15.203.10', '116.12.134.130', '109', '34', '7', '0', '0', 'mousehunt_02.png', '2012-05-08 15:38:34', '2012-04-30 16:49:25', '2010-11-12 19:39:56', '2012-05-08 23:38:17', 'Hairy merrY Cherry Nairy~', '', '<p>\r\n Hello...I'm a merry hairy cherry~</p>\r\n', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('37', 'T1011151195238X', '0', '', '', 'Pompipi', 'bd7a5bc2c146a147c322d3ae64ae6c4ff2b41a78', 'M', '', '', '116.12.134.130', '116.12.134.130', '44', '2', '0', '0', '0', 'mod_02.png', '2010-11-26 10:37:12', '2010-11-18 15:52:26', '2010-11-15 12:34:29', '2011-11-25 08:49:14', '', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('38', 'T1011151194239X', '0', '', '', 'GreenTea', '', 'M', '', '', '202.55.72.138', '175.156.154.73', '1171', '1040', '43', '0', '0', 'mod_02.png', '2012-05-28 14:30:12', '2012-05-25 06:43:04', '2010-11-15 12:35:27', '2013-05-27 20:33:40', 'Post a status message...', '<p>\r\n <span style=\"color:#00ff00;\">Pokka Green Tea</span></p>\r\n', '<p>\r\n Why is your Forum nick Green Tea? Cause I'm always be found drinking Pokka Green Tea on a daily basis, i think perhaps i should be Pokka Green Tea Ambassador =p</p>\r\n<p>\r\n I'm a Cherry Credit Forum Moderator from Singapore. My hobbies during my own personal time would always be, movie, drama and Kpop. I'm do play online games as well ^_^</p>\r\n', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('39', 'T1011151195240X', '0', '', '', 'Fleur', '', 'M', '', '', '116.12.134.130', '116.12.134.130', '37', '1', '0', '0', '0', 'admin_01.png', '2010-11-19 13:09:41', '2010-11-15 12:37:46', '2010-11-15 12:37:46', '2011-11-28 20:59:12', '', '', '', '', '', '', '', '', '');
INSERT INTO `users` VALUES ('40', 'T1011151195241X', '0', '', '', 'cloudy', '', 'M', '', '', '116.12.134.130', '116.12.134.130', '0', '0', '0', '0', '0', '02.png', '2010-11-15 12:43:50', '2010-11-15 12:42:03', '2010-11-15 12:42:03', '2010-11-15 12:43:50', '', '', '', '', '', '', '', '', '');