Hello 0DayForums Community,
Today I have uploaded the ClixSense Database for you to download, thanks for reading and enjoy!
![[Image: download]](https://freeupload.store/CUsu6/FEVopIzO98.png/download)
In September 2016, the paid-to-click site ClixSense suffered a data breach which exposed 2.4 million subscriber identities. The breached data was then posted online by the attackers who claimed it was a subset of a larger data breach totalling 6.6 million records. The leaked data was extensive and included names, physical, email and IP addresses, genders and birth dates, account balances and passwords stored as plaintext.
Compromised data: Account balances, Dates of birth, Email addresses, Genders, IP addresses, Names, Passwords, Payment histories, Payment methods, Physical addresses, Usernames, Website activity
Sample:
Code:
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'),(13,'csadmin','cZ3FVpK80lTu','first_car','buick','ClixSense','Admin','[email protected]','734 W. Liberty St','','Rome','NY','US','13440','cheque','Clix Sense Admin','active',2.2401,0.00,65535,'','en-us','1966-04-14','male',0,0,0,23501,368737,0,0,'2016-09-04 08:20:10','2014-12-12
14:14:08','2007-02-12 16:53:56','0000-00-00'),(2073765,'bobmk','345345','','','Robert','Mackay','[email protected]','4964 Shadowbend Circle','','Clarksville','TN','US','37043','cheque','Robert Mackay','closed',0.0000,0.00,10,'','en-us','1965-01-01','male',0,0,0,0,8193,0,0,'2007-06-14 14:31:13','0000-00-00 00:00:00','2007-02-13 16:57:25','0000-00-00'),(2073766,'dkm','millers2','','','Donna','Miller','[email protected]','4990 Shadowbend
Circle','','Clarksville','TN','US','37043','cheque','Donna Miller','closed',0.0000,0.00,50,'','en-us','1952-12-04','female',0,0,0,0,8193,0,0,'2010-11-05 09:10:21','0000-00-00
00:00:00','2007-02-17 14:22:05','0000-00-00'),(2073767,'ezwealth','1rich1','name_of_first_pet','precious','Kevin','Whitehorn','[email protected]','4420 Elk Ridge
Ct','','Farmington','NM','US','87401','paypal','[email protected]','active',318.2202,968.06,100,'','en-us','1960-06-24','male',555316256,10,0,0,2629696,0,0,'2016-09-06
15:00:16','2016-08-22 13:26:47','2007-02-21 16:15:20','2017-12-30'),(2073768,'isell','jeremy','','','Cheryl','Pope','[email protected]','3117 Brunk
Drive','','Springfield','IL','US','62712','cheque','Cheryl Pope','closed',0.0000,0.00,10,'','en-us','1963-11-02','female',0,10,0,0,8193,0,0,'2010-01-24 06:10:23','0000-00-00
00:00:00','2007-02-21 16:57:09','0000-00-00'),(2073769,'HarryTrades','brendakay','','','Harry','Boyd','[email protected]','4978 Shadowbend
Cr.','','Clarksville','TN','US','37043','cheque','Harry Boyd','closed',0.0000,0.00,10,'','en-us','1960-12-26','male',0,0,0,0,8193,0,0,'2008-06-03 19:21:57','0000-00-00
00:00:00','2007-02-22 20:51:48','0000-00-00'),(2073770,'woofer','bigbucks1','','','Daniel','Barks','[email protected]','5370 Reber PL','','St
Louis','MO','US','63139','cheque','Daniel Barks','closed',0.0000,0.00,10,'','en-us','1960-04-20','male',0,9,0,0,8193,0,0,'2008-01-06 06:10:06','0000-00-00 00:00:00','2007-02-22
20:54:47','0000-00-00'),(2073771,'scottsinct','bryce1','','','Scott','Stransky','[email protected]','70 Pacific St.','Apt 396B','Cambridge','MA','US','02139','cheque','Scott
Stransky','closed',0.0000,0.00,10,'','en-us','1983-12-26','male',0,9,0,0,8193,0,0,'2007-09-02 05:10:03','0000-00-00 00:00:00','2007-02-22 20:54:51','0000-00-00'),
(2073772,'utley','as3496','first_car','buick','john','bonnell','[email protected]','333 n contor ave','','idaho falls','ID','US','83402','cheque','john
bonnell','closed',0.0000,31.60,10,'','en-us','1969-10-07','male',0,9,0,117,8192,0,0,'2011-11-12 05:00:11','2011-08-13 20:36:28','2007-02-22 21:04:52','2009-03-05'),
(2073773,'tanmay','coolarnav','name_of_first_pet','Robin','Tanmay','Chauhan','[email protected]','93/77 Vijay
Path','Mansarovar','Jaipur','RJ','IN','302020','paypal','[email protected]','active',0.0000,36.68,20,'','en-us','1970-08-29','male',0,2073772,0,0,532608,0,0,'2016-07-
07 03:03:05','2016-07-07 03:03:06','2007-02-22 21:20:33','0000-00-00'),(2073774,'surferbob','sanflg','mothers_birthplace','Hungary','Robert','Novosad','[email protected]','8 -
3301 Pleasant Valley Rd.','','Vernon','BC','CA','V1T 4L4','paypal','[email protected]','active',3.7620,182.08,10,'','en-us','1951-08-13','male',0,9,0,0,2629696,0,0,'2016-09-06
06:45:12','2016-09-06 06:20:25','2007-02-22 21:22:07','2008-03-26'),(2073775,'oldreb','7760300xp','','','Thomas','Holtzclaw','[email protected]','2013 Youngland
Ave.','','Louisville','KY','US','40216','cheque','Thomas Holtzclaw','closed',0.0000,0.00,10,'','en-us','1941-07-05','male',0,9,0,0,8193,0,0,'2007-09-23 05:10:03','0000-00-00
00:00:00','2007-02-22 21:25:03','0000-00-00'),(2073776,'wildone','coffee','name_of_first_pet','emma','Dawn','Matthews','[email protected]','box
03','','Corvallis','MT','US','59828','paypal','[email protected]','closed',0.0000,115.92,10,'','en-us','1961-05-11','female',0,9,0,23,729216,2,0,'2014-12-05 05:00:48','2014-
09-05 13:59:15','2007-02-22 21:27:11','2011-02-16'),(2073777,'bunnyo38','rabbit','name_of_first_pet','kider','Bernice','Osterhout','[email protected]','78A Summit St','','New
Milford','PA','US','18834','paypal','[email protected]','closed',0.0000,79.21,10,'','en-us','1961-03-13','female',0,9,0,0,139332,0,0,'2016-06-28 15:41:21','2013-12-22
11:19:01','2007-02-22 21:41:55','2011-02-04'),(2073778,'aprilgrl','emvovyfh','grandfathers_occupation','farmer','Paula','Bullock','[email protected]','5005 Bonnameade
Dr.','','Hermitage','TN','US','37076','paypal','[email protected]','active',3.5232,299.91,10,'','en-us','1960-04-28','female',0,9,0,0,2826560,0,0,'2016-09-04 04:02:11','2016-09-
03 13:15:26','2007-02-22 21:46:10','2017-05-02'),(2073779,'Monteperini','password','','','Jason','Perini','[email protected]','872 lamplighter Dr. N.W.','','Palm
Bay','FL','US','32907','cheque','Jason Perini','closed',0.0000,0.00,10,'','en-us','1973-04-16','male',0,9,0,0,8193,0,0,'2007-06-19 14:50:13','0000-00-00 00:00:00','2007-02-22
21:48:43','0000-00-00'),(2073780,'ernie18','bobbyl18','name_of_first_pet','Buster','Ernie','Billman','[email protected]','1906 N Randall Ave
#6','','Janesville','WI','US','53545','paypal','[email protected]','closed',0.0000,271.22,10,'','en-us','1968-09-29','male',0,9,0,0,139264,0,0,'2012-05-27 04:00:16','2012-
02-26 15:41:25','2007-02-22 21:52:41','2012-02-25'),(2073781,'gerg','1milka','','','greg','cannone','[email protected]','4942 farmstead
ct','','woodstock','GA','US','30188','cheque','greg cannone','closed',0.0000,0.00,10,'','en-us','1972-04-15','male',0,9,0,0,8193,0,0,'2007-06-25 15:33:00','0000-00-00
00:00:00','2007-02-22 21:59:21','0000-00-00'),(2073782,'guitarriot120','redsox','','','David','Clark','[email protected]','15 Franklin
St.','','Douglas','MA','US','01516','cheque','David Clark','closed',0.0000,0.00,10,'','en-us','1991-04-23','male',0,9,0,0,8193,0,0,'2007-05-25 16:07:02','0000-00-00
00:00:00','2007-02-22 22:04:22','0000-00-00'),(2073783,'renegade155','sg030590','best_childwood_friend','jaime','sean','guthrie','[email protected]','3510 highland bluff
drive','','suwanee','GA','US','30024','cheque','Sean Guthrie','closed',0.0000,37.05,20,'','en-us','1987-03-05','male',0,9,0,0,8257,0,0,'2011-06-06 04:00:24','0000-00-00
00:00:00','2007-02-22 22:11:41','2008-11-08'),(2073784,'tenacalm','SPCS0748PjP','','','Patsy','Payne','[email protected]','5507 Cool Valley','','San
Antonio','TX','US','78242','cheque','Patsy j Payne','closed',0.0000,0.00,10,'','en-us','1948-08-01','female',0,0,0,0,8193,0,0,'2012-01-19 22:27:26','0000-00-00 00:00:00','2007-
02-22 22:15:18','2008-04-04'),(2073785,'AGNJoe','monkey','','','Joseph','Zeug','[email protected]','16457 S. Roy Street','','Oak Forest','IL','US','60452','cheque','Joseph
Zeug','closed',0.0000,12.74,10,'','en-us','1970-01-25','male',0,9,0,0,8193,0,0,'2007-08-19 05:10:03','0000-00-00 00:00:00','2007-02-22 22:16:38','0000-00-00'),
(2073786,'michale','purple','','','michale','stanberry','[email protected]','214 champagne st','','greenwood','MS','US','38930','cheque','Michale
Stanberry','closed',0.0000,0.00,10,'','en-us','1961-10-27','male',0,9,0,0,8193,0,0,'2007-05-29 14:04:24','0000-00-00 00:00:00','2007-02-22 22:18:28','0000-00-00'),
(2073787,'jhare373','theheartbreakkid','name_of_first_pet','sara','justin','hare','[email protected]','304 1st street apt 9e','apt
9e','liverpool','NY','US','13088','paypal','[email protected]','active',0.4270,42.27,10,'','en-us','1983-04-17','male',0,9,0,0,2629696,0,0,'2016-09-06 04:42:04','2016-09-06
04:39:34','2007-02-22 22:20:49','0000-00-00'),(2073788,'longtermcash','cmor23','mothers_birthplace','newton','Chris','Morrell','[email protected]','40 Pine Grove
Dr','','South Hadley','MA','US','01075','payza_in','[email protected]','active',29.2773,83.65,20,'','en-us','1965-10-23','male',0,10,0,2,532612,0,0,'2016-09-04
23:20:07','2016-08-14 00:57:31','2007-02-22 22:31:39','2017-06-22'),(2073789,'jhw157','harjo1953','name_of_first_pet','shoni','Joan','Wasserman','[email protected]','157 School
Lane','','Lido Beach','NY','US','11561','paypal','[email protected]','active',9.1430,359.91,10,'','en-us','1933-07-15','female',0,9,0,0,2629760,0,0,'2016-09-06 12:00:06','2016-08-09
17:21:34','2007-02-22 22:42:18','2013-03-05'),(2073790,'sandybest','derryberry','best_childwood_friend','Connie','Sandra','Best','[email protected]','105 Ranch
Road','','Cusseta','GA','US','31805','paypal','[email protected]','closed',0.0000,102.93,20,'','en-us','1953-03-06','female',0,9,0,0,12528,5,1,'2016-06-28
15:41:21','2011-10-01 07:20:04','2007-02-22 22:44:48','2012-05-13'),(2073791,'petra1000','truck1','mothers_birthplace','Vermont','william','sims','[email protected]','420 s
section st','','Nekoosa','WI','US','54457','paypal','[email protected]','suspended',91.8719,795.16,20,'','en-us','1957-12-09','male',0,9,0,0,4858240,0,0,'2016-06-14
22:25:54','2016-06-14 04:01:13','2007-02-22 22:54:03','2017-02-27'),(2073792,'caneurb','inglesito','name_of_first_pet','Kazan','Urbano','Canizares','[email protected]','256 Hoyt
St','','Buffalo','NY','US','14213','cheque','Urbano Canizares','closed',0.0000,146.23,10,'','en-us','1953-10-31','male',0,9,0,0,532480,0,0,'2012-10-26 04:00:20','2012-07-27
16:56:33','2007-02-22 22:56:57','2010-03-01'),(2073793,'cindyjanke','elizabeth','','','cindy','janke','[email protected]','2522 howard st
n.e.','','minneapolis','MN','US','55418','cheque','cindy janke','closed',0.0000,0.00,50,'','en-us','1954-10-21','female',0,9,0,0,8193,0,0,'2007-07-15 05:10:03','0000-00-00
00:00:00','2007-02-22 23:07:02','0000-00-00'),(2073794,'toonity','pugwomp','','','Norm','Klusman','[email protected]','PO Box 1461','','Waldport','OR','US','97394','cheque','Norman Klusman','closed',0.0000,10.53,10,'','en-us','1946-09-07','',0,9,0,0,8193,0,0,'2008-02-17 06:09:17','0000-00-00 00:00:00','2007-02-22 23:07:22','0000-00-00'),(2073795,'humhum','c0pbxg7','name_of_first_pet','mini','Denis','Chalifour','[email protected]','605, 52nd Street West','app 307','Quebec','QC','CA','G1H 7K7','paypal','[email protected]','active',1.7405,1247.31,10,'','en-us','1945-06-15','male',0,9,0,0,7023096,0,1,'2016-09-06 05:50:13','2016-09-06 05:16:40','2007-02-22 23:08:08','2017-02-21'),(2073796,'okbiz','justcs','','','Anne','Chaffin','[email protected]','417 SE 52nd Street','','Oklahoma City','OK','US','73129','cheque','Anne Chaffin','closed',0.0000,0.00,10,'','en-us','1943-12-06','female',0,9,0,0,8193,0,0,'2007-06-14 14:31:13','0000-00-00 00:00:00','2007-02-22 23:08:09','0000-00-00'),(2073797,'DawntheLeo','shelby','','','Dawn','Forbes','[email protected]','4431 45th STREET','','Sacramento','CA','US','95820-4540','cheque','Dawn Forbes','closed',0.0000,16.24,10,'','en-us','1969-08-19','female',0,9,0,0,8193,0,0,'2008-03-09 06:10:07','0000-00-00 00:00:00','2007-02-22 23:23:17','2008-02-23'),(2073798,'cisco','433cxs455','','','Cisco','Evert','[email protected]','504 N First Ave','','Oakdale','CA','US','95361','cheque','Cisco Evert','closed',0.0000,84.78,10,'','en-us','1930-09-07','male',0,9,0,0,8193,0,0,'2008-03-09 06:10:07','0000-00-00 00:00:00','2007-02-22 23:26:18','2008-03-02'),(2073799,'summertime','andrews10','mothers_birthplace','Bethel','Donna','Roos','[email protected]','4262 Aspen Drive #7','4262 Aspen Drive #7','Independence','KY','US','41051','paypal','[email protected]','active',53.8063,1147.28,10,'','en-us','1958-04-03','female',0,9,0,788,2695408,2,3,'2016-09-02 15:00:57','2016-09-06 12:08:46','2007-02-22 23:33:10','2017-04-16'),(2073800,'thomasphilips','georgie','name_of_first_pet','tommy','thomas','philips','[email protected]','16,meghdoot,pestomsagar,roadno.4,chembur','','mumbai','MH','IN',