ClixSense
Sep 4, 2016
Domain:
clixsense.com
Breach Count:
2,424,784
Region:
Global
Source:
-
File Size:
163.78 MB
Uncompressed File Size:
768.61 MB
File Count:
1
In 2016, a major data breach occurred on the crowdsourcing platform ClixSense, exposing the personal information of 2,424,784 users. The leaked data included usernames, email addresses, IP addresses, and hashed passwords.
The leak was the result of an SQL injection vulnerability in the ClixSense website. This vulnerability allowed attackers to access and download the user database. The breach was discovered by security researcher Vinny Troia, who notified ClixSense of the issue.
ClixSense responded to the breach by resetting all user passwords and implementing additional security measures. However, the leaked data is still available online, and it is possible that it will be used for identity theft or other malicious purposes.
Leaked Information:
Account balances
Date Of Birth
Email
Gender
IP Address
Full Name
Password
Payment histories
Payment methods
Address
User Name
Website activity
We have loaded this breach into our database.
File List:
ClixSense.com.sql
File Content Sample:
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(25) COLLATE latin1_general_ci NOT NULL,
`password` varbinary(25) NOT NULL,
`security_question` enum('mothers_birthplace','best_childwood_friend','name_of_first_pet','favorite_teacher','favorite_historical_person','grandfathers_occupation','favorite_actor','first_boyfriend_name','first_car') COLLATE latin1_general_ci NOT NULL,
`security_answer` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`first_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`last_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(50) COLLATE latin1_general_ci NOT NULL,
`address1` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`address2` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`city` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`state` varchar(3) COLLATE latin1_general_ci NOT NULL,
`country` char(2) COLLATE latin1_general_ci NOT NULL,
`zip` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`withdrawal_method` enum('paypal','paypal_micro','alertpay','cheque','cheque_int','liberty_reserve','payza','payza_in','paytoo','neteller','tango') COLLATE latin1_general_ci NOT NULL DEFAULT 'paypal',
`payable_to` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`status` enum('pending','active','closed','suspended','incomplete') COLLATE latin1_general_ci NOT NULL DEFAULT 'active',
`balance` decimal(11,4) NOT NULL,
`withdrawn` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
`cashout_balance` smallint(5) unsigned NOT NULL DEFAULT '20',
`reputation` varchar(101) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`preferred_language` enum('en-us') COLLATE latin1_general_ci NOT NULL DEFAULT 'en-us',
`date_of_birth` date NOT NULL,
`gender` enum('male','female') COLLATE latin1_general_ci NOT NULL,
`ssn` int(10) unsigned NOT NULL,
`sponsor_user_id` int(10) unsigned NOT NULL,
`sponsor_campaign_id` mediumint(8) unsigned NOT NULL,
`ad_credits` mediumint(8) unsigned NOT NULL,
`options` mediumint(8) unsigned NOT NULL,
`toolbar_sound_alert` tinyint(3) unsigned NOT NULL,
`avatar_version` tinyint(3) unsigned NOT NULL,
`dtstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`news_last_seen_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`register_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`subscribed_until` date NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`),
KEY `password` (`password`),
KEY `last_name` (`last_name`),
KEY `status` (`status`),
KEY `country` (`country`),
KEY `register_date` (`register_date`),
KEY `sponsor_user_id` (`sponsor_user_id`,`sponsor_campaign_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9750006 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'trishmk','clixgem2','','','Patricia','Mackay','[email protected]','4964 Shadowbend Circle','','Clarksville','TN','US','37043','cheque','Patricia A. Mackay','closed',0.0000,0.00,100,'','en-us','0000-00-00','female',0,0,0,0,8193,0,0,'2014-08-23 04:01:02','0000-00-00 00:00:00','2007-01-16 21:00:13','0000-00-00'),(2,'Medscan','vivmcc','','','Chris','McConnell','[email protected]','1361 Shady Grove Rd','','Clarksville','TN','US','37043','cheque','Chris L McConnell','closed',0.0000,0.00,100,'','en-us','0000-00-00','male',0,1,0,0,8193,0,0,'2010-03-06 06:10:22','0000-00-00 00:00:00','2007-01-16 21:00:47','0000-00-00'),(3,'mindless01','sense12','name_of_first_pet','Jim Grago','John','McConnell','[email protected]','4975 Shadowbend Circle','','Clarksville','TN','US','37043','cheque','John McConnell','closed',0.0000,20.90,500,'','en-us','0000-00-00','male',0,0,0,50036,532480,0,0,'2015-03-19 04:00:55','2014-12-18 13:32:19','2007-01-16 21:01:29','2011-06-21'),(4,'crayo','harf42','','','Koy','Kragh','[email protected]','931 Kingsbury Drive','Apt C','Clarksville','TN','US','37043','cheque','Koy N. Kragh','suspended',0.0000,0.00,10,'','en-us','1977-03-02','male',0,0,0,0,8193,0,0,'2011-03-08 20:00:33','0000-00-00 00:00:00','2007-01-17 15:21:27','0000-00-00'),(5,'jasm78','jotaX7820','first_car','clio','JoГЈo','Marques','[email protected]','Apartado 901','','PortimГЈo','','PT','8500-823','payza_in','[email protected]','active',58.3287,217.00,20,'','en-us','1978-06-13','male',0,0,0,0,7942650,0,10,'2016-09-06 15:20:11','2016-09-06 14:21:34','2007-01-17 16:53:22','2011-12-26'),(6,'ktest01','harf42','','','KTEST','KTEST','[email protected]','555 Pejorative Way','','CVille','TN','US','37040','cheque','Aunt Jemima','suspended',0.0000,0.00,10,'','en-us','1969-01-10','',0,4,0,0,8193,0,0,'2011-03-08 20:00:06','0000-00-00 00:00:00','2007-01-18 16:47:57','0000-00-00'),(7,'admin','P@ssw0rd123!ff','first_car','buick','Jim','Grago','[email protected]','210 Bates Retreat','','Hampstead','NC','US','28443','cheque','Jim','active',39.4956,20.00,500,'','en-us','1966-04-14','male',0,0,0,0,2728170,0,0,'2016-09-06 15:40:12','2016-09-03 22:14:24','2007-01-19 15:27:27','2010-11-09'),(8,'JANEMOSELEY','DADDYPOP82','','','JANE','MOSELEY','[email protected]','3710 MARTHA\'S CHAPEL ROAD','','CUNNINGHAM','TN','US','37052','cheque','JANE MOSELEY','suspended',0.0000,0.00,10,'','en-us','1949-05-21','female',0,0,0,0,10257,0,2,'2012-11-09 23:59:10','0000-00-00 00:00:00','2007-01-26 18:48:20','0000-00-00'),(9,'sp1915','soldier1','name_of_first_pet','Daisy','Susan','Davenport','[email protected]','32545 Flagstaff Avenue','','Thousand Palms','CA','US','92276','paypal','[email protected]','active',1.7863,9038.51,10,'','en-us','1955-02-19','female',175487577,0,0,0,2699416,0,16,'2016-09-06 15:40:19','2016-09-06 12:15:51','2007-02-01 16:46:14','2017-02-27'),(10,'marceps','aftvlz354907012','mothers_birthplace','Oakland','Marc','Gaston','[email protected]','7','','Baguio City','','PH','2600','paypal','[email protected]','closed',0.0000,7096.60,250,'','en-us','1949-05-20','male',538543191,3760784,0,0,600180,0,1,'2016-06-21 18:32:25','2016-06-17 00:44:39','2007-02-01 18:15:59','2017-02-27'),(11,'smitty718','military','mothers_birthplace','lewiston maine','Garold','Smith','[email protected]','718 Erie Blvd. West','','Rome','NY','US','13440','paypal','[email protected]','active',0.2890,722.34,20,'','en-us','1966-02-01','female',0,2073989,0,0,2629632,1,0,'2016-09-02 04:40:10','2016-08-21 16:04:29','2007-02-11 16:21:37','2014-03-01'),(12,'David','thirty33','','','David','Baron','[email protected]','809 Kingsbury Rd.','','Clarksville','TN','US','37040','cheque','David A Baron','closed',0.0000,117.02,50,'','en-us','1981-12-12','male',0,0,0,0,8193,0,0,'2008-12-21 06:10:08','0000-00-00 00:00:00','2007-02-12 15:03:38','0000-00-00'),
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(25) COLLATE latin1_general_ci NOT NULL,
`password` varbinary(25) NOT NULL,
`security_question` enum('mothers_birthplace','best_childwood_friend','name_of_first_pet','favorite_teacher','favorite_historical_person','grandfathers_occupation','favorite_actor','first_boyfriend_name','first_car') COLLATE latin1_general_ci NOT NULL,
`security_answer` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`first_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`last_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(50) COLLATE latin1_general_ci NOT NULL,
`address1` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`address2` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`city` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`state` varchar(3) COLLATE latin1_general_ci NOT NULL,
`country` char(2) COLLATE latin1_general_ci NOT NULL,
`zip` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`withdrawal_method` enum('paypal','paypal_micro','alertpay','cheque','cheque_int','liberty_reserve','payza','payza_in','paytoo','neteller','tango') COLLATE latin1_general_ci NOT NULL DEFAULT 'paypal',
`payable_to` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`status` enum('pending','active','closed','suspended','incomplete') COLLATE latin1_general_ci NOT NULL DEFAULT 'active',
`balance` decimal(11,4) NOT NULL,
`withdrawn` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
`cashout_balance` smallint(5) unsigned NOT NULL DEFAULT '20',
`reputation` varchar(101) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`preferred_language` enum('en-us') COLLATE latin1_general_ci NOT NULL DEFAULT 'en-us',
`date_of_birth` date NOT NULL,
`gender` enum('male','female') COLLATE latin1_general_ci NOT NULL,
`ssn` int(10) unsigned NOT NULL,
`sponsor_user_id` int(10) unsigned NOT NULL,
`sponsor_campaign_id` mediumint(8) unsigned NOT NULL,
`ad_credits` mediumint(8) unsigned NOT NULL,
`options` mediumint(8) unsigned NOT NULL,
`toolbar_sound_alert` tinyint(3) unsigned NOT NULL,
`avatar_version` tinyint(3) unsigned NOT NULL,
`dtstamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`news_last_seen_on` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`register_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`subscribed_until` date NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`),
KEY `password` (`password`),
KEY `last_name` (`last_name`),
KEY `status` (`status`),
KEY `country` (`country`),
KEY `register_date` (`register_date`),
KEY `sponsor_user_id` (`sponsor_user_id`,`sponsor_campaign_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9750006 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'trishmk','clixgem2','','','Patricia','Mackay','[email protected]','4964 Shadowbend Circle','','Clarksville','TN','US','37043','cheque','Patricia A. Mackay','closed',0.0000,0.00,100,'','en-us','0000-00-00','female',0,0,0,0,8193,0,0,'2014-08-23 04:01:02','0000-00-00 00:00:00','2007-01-16 21:00:13','0000-00-00'),(2,'Medscan','vivmcc','','','Chris','McConnell','[email protected]','1361 Shady Grove Rd','','Clarksville','TN','US','37043','cheque','Chris L McConnell','closed',0.0000,0.00,100,'','en-us','0000-00-00','male',0,1,0,0,8193,0,0,'2010-03-06 06:10:22','0000-00-00 00:00:00','2007-01-16 21:00:47','0000-00-00'),(3,'mindless01','sense12','name_of_first_pet','Jim Grago','John','McConnell','[email protected]','4975 Shadowbend Circle','','Clarksville','TN','US','37043','cheque','John McConnell','closed',0.0000,20.90,500,'','en-us','0000-00-00','male',0,0,0,50036,532480,0,0,'2015-03-19 04:00:55','2014-12-18 13:32:19','2007-01-16 21:01:29','2011-06-21'),(4,'crayo','harf42','','','Koy','Kragh','[email protected]','931 Kingsbury Drive','Apt C','Clarksville','TN','US','37043','cheque','Koy N. Kragh','suspended',0.0000,0.00,10,'','en-us','1977-03-02','male',0,0,0,0,8193,0,0,'2011-03-08 20:00:33','0000-00-00 00:00:00','2007-01-17 15:21:27','0000-00-00'),(5,'jasm78','jotaX7820','first_car','clio','JoГЈo','Marques','[email protected]','Apartado 901','','PortimГЈo','','PT','8500-823','payza_in','[email protected]','active',58.3287,217.00,20,'','en-us','1978-06-13','male',0,0,0,0,7942650,0,10,'2016-09-06 15:20:11','2016-09-06 14:21:34','2007-01-17 16:53:22','2011-12-26'),(6,'ktest01','harf42','','','KTEST','KTEST','[email protected]','555 Pejorative Way','','CVille','TN','US','37040','cheque','Aunt Jemima','suspended',0.0000,0.00,10,'','en-us','1969-01-10','',0,4,0,0,8193,0,0,'2011-03-08 20:00:06','0000-00-00 00:00:00','2007-01-18 16:47:57','0000-00-00'),(7,'admin','P@ssw0rd123!ff','first_car','buick','Jim','Grago','[email protected]','210 Bates Retreat','','Hampstead','NC','US','28443','cheque','Jim','active',39.4956,20.00,500,'','en-us','1966-04-14','male',0,0,0,0,2728170,0,0,'2016-09-06 15:40:12','2016-09-03 22:14:24','2007-01-19 15:27:27','2010-11-09'),(8,'JANEMOSELEY','DADDYPOP82','','','JANE','MOSELEY','[email protected]','3710 MARTHA\'S CHAPEL ROAD','','CUNNINGHAM','TN','US','37052','cheque','JANE MOSELEY','suspended',0.0000,0.00,10,'','en-us','1949-05-21','female',0,0,0,0,10257,0,2,'2012-11-09 23:59:10','0000-00-00 00:00:00','2007-01-26 18:48:20','0000-00-00'),(9,'sp1915','soldier1','name_of_first_pet','Daisy','Susan','Davenport','[email protected]','32545 Flagstaff Avenue','','Thousand Palms','CA','US','92276','paypal','[email protected]','active',1.7863,9038.51,10,'','en-us','1955-02-19','female',175487577,0,0,0,2699416,0,16,'2016-09-06 15:40:19','2016-09-06 12:15:51','2007-02-01 16:46:14','2017-02-27'),(10,'marceps','aftvlz354907012','mothers_birthplace','Oakland','Marc','Gaston','[email protected]','7','','Baguio City','','PH','2600','paypal','[email protected]','closed',0.0000,7096.60,250,'','en-us','1949-05-20','male',538543191,3760784,0,0,600180,0,1,'2016-06-21 18:32:25','2016-06-17 00:44:39','2007-02-01 18:15:59','2017-02-27'),(11,'smitty718','military','mothers_birthplace','lewiston maine','Garold','Smith','[email protected]','718 Erie Blvd. West','','Rome','NY','US','13440','paypal','[email protected]','active',0.2890,722.34,20,'','en-us','1966-02-01','female',0,2073989,0,0,2629632,1,0,'2016-09-02 04:40:10','2016-08-21 16:04:29','2007-02-11 16:21:37','2014-03-01'),(12,'David','thirty33','','','David','Baron','[email protected]','809 Kingsbury Rd.','','Clarksville','TN','US','37040','cheque','David A Baron','closed',0.0000,117.02,50,'','en-us','1981-12-12','male',0,0,0,0,8193,0,0,'2008-12-21 06:10:08','0000-00-00 00:00:00','2007-02-12 15:03:38','0000-00-00'),