• XSS.stack #1 – первый литературный журнал от юзеров форума

SQL База сайта e-spotrebice.sk / Магазин бытовой техники

N9XDZ

(L1) cache
Пользователь
Регистрация
19.08.2020
Сообщения
680
Решения
1
Реакции
846
Гарант сделки
2
Депозит
0.0002
Магизн по продаже бытовой техники в Словакии

Сайт: e-spotrebice.sk
Строк: 3602592
Дата утечки: 2017-07-12
SQL:
CREATE TABLE `ps_address` (
  `id_address` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_country` int(10) unsigned NOT NULL,
  `id_state` int(10) unsigned DEFAULT NULL,
  `id_customer` int(10) unsigned NOT NULL DEFAULT '0',
  `id_manufacturer` int(10) unsigned NOT NULL DEFAULT '0',
  `id_supplier` int(10) unsigned NOT NULL DEFAULT '0',
  `id_warehouse` int(10) unsigned NOT NULL DEFAULT '0',
  `alias` varchar(32) NOT NULL,
  `company` varchar(48) DEFAULT NULL,
  `lastname` varchar(32) NOT NULL,
  `firstname` varchar(32) NOT NULL,
  `address1` varchar(128) NOT NULL,
  `address2` varchar(128) DEFAULT NULL,
  `postcode` varchar(12) DEFAULT NULL,
  `city` varchar(64) NOT NULL,
  `other` text,
  `phone` varchar(32) DEFAULT NULL,
  `phone_mobile` varchar(32) DEFAULT NULL,
  `vat_number` varchar(32) DEFAULT NULL,
  `dni` varchar(16) DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `date_upd` datetime NOT NULL,
  `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_address`),
  KEY `address_customer` (`id_customer`),
  KEY `id_country` (`id_country`),
  KEY `id_state` (`id_state`),
  KEY `id_manufacturer` (`id_manufacturer`),
  KEY `id_supplier` (`id_supplier`)
) ENGINE=InnoDB AUTO_INCREMENT=36407 DEFAULT CHARSET=utf8;

(18822,1,1,0,1,6,'Tina','Mišurová','tina.misurova@gmail.com','a5538e34f37b547d43768e09e8b07d31','2017-06-15 00:08:17','0000-00-00',1,'95.102.36.84','2017-06-15 08:08:17',0,'ed8c3f1c4b7a7827555d5af30e3b9196',NULL,1,0,0,'2017-06-15 08:08:17','2017-06-15 08:08:17',0,NULL,NULL,NULL,NULL,'0.000000',0,0),
(5818,1,1,0,3,6,'Klaudia','Conkova','claudia2@azet.sk','51658eaf06eb5c613f917dbbff17023b','2014-08-30 01:49:01','0000-00-00',0,NULL,'0000-00-00 00:00:00',0,'6a7189f8c191d093564e170db2a3e376',NULL,1,1,0,'2014-08-30 09:49:01','2014-08-30 09:49:01',0,NULL,NULL,NULL,NULL,'0.000000',0,0),
(3147,1,1,9,1,6,'Peter','Handzuš','kozel71@azet.sk','0157e328ad8e2f41f4da456da0efcea6','2013-11-22 00:33:46',NULL,0,NULL,NULL,0,'dba9dd3150cf659f434a5d39dbd00965',NULL,1,1,0,'2013-11-22 07:33:46','2013-11-22 07:33:46',1,NULL,NULL,NULL,NULL,'0.000000',0,60),
(13960,1,1,0,3,6,'Milan','Vamosi','milanvamosi@atlas.sk','bf28878190beabbbe8be8255545da5d0','2016-09-01 06:09:46','0000-00-00',0,NULL,'0000-00-00 00:00:00',0,'ee7535bb3677c552ab03e429b70b86ca',NULL,1,1,0,'2016-09-01 14:09:46','2016-09-01 14:09:46',0,NULL,NULL,NULL,NULL,'0.000000',0,0),
(3693,1,1,0,3,6,'Marián','Cisár','cisar.marian@gmail.com','63c3835d39d2ce62f337aef4dcdd169b','2014-02-07 06:28:19','0000-00-00',0,NULL,'0000-00-00 00:00:00',0,'944762d9eed3f40a776bd1d96574ef01',NULL,1,1,0,'2014-02-07 13:28:19','2014-02-07 13:28:19',0,NULL,NULL,NULL,NULL,'0.000000',0,0),
(55713,'martin.kupec0@gmail.com','order_conf','[e-spotrebice] Potvrdenie objednávky',6,'2017-05-25 21:22:13'),
(25654,'grajciar@mados.sk','order_conf','[e-spotrebice] Potvrdenie objednávky',6,'2016-06-22 14:38:09'),
(102,'mst1@centrum.sk','order_conf','[e-spotrebice] Potvrdenie objednávky',6,'2015-04-16 22:14:19'),
(2346,'info@e-spotrebice.sk','new_order','[e-spotrebice] New order : #20151749 - 401401390',6,'2015-05-25 11:17:17'),
(56026,'gustav.szenczi@gmail.com','account','[e-spotrebice] Vitajte!',6,'2017-05-30 06:34:33'),
(24769,'grajciar@mados.sk','new_order','[e-spotrebice] New order : #20161730 - 930596821',6,'2016-06-06 09:22:00'),
(4857,'olisblek@gmail.com','shipped','[e-spotrebice] Odoslané',6,'2015-07-07 12:16:09'),
(2768,'peter@e-spotrebice.sk','new_order','[e-spotrebice] New order : #20151821 - 622548430',6,'2015-06-01 12:53:27'),
(23489,'grajciar@mados.sk','new_order','[e-spotrebice] New order : #20161472 - 112331673',6,'2016-05-09 11:53:43'),
(42389,'info@e-spotrebice.sk','new_order','[e-spotrebice] New order : #20165233 - 362016685',6,'2016-12-15 12:18:42'),
(31446,'tiboregly@aol.com','shipped','[e-spotrebice] Odoslané',6,'2016-09-08 12:02:52'),
(28977,'majka.laza@gmail.com','shipped','[e-spotrebice] Odoslané',6,'2016-08-12 11:29:42'),
(26911,'info@e-spotrebice.sk','new_order','[e-spotrebice] New order : #20162135 - 777906725',6,'2016-07-14 20:00:57'),
(16388,'grajciar@mados.sk','new_order','[e-spotrebice] New order : #20154305 - 764531130',6,'2015-12-18 17:09:43'),
(4069,1,1,0,3,6,'Michal ','Bdzoch','michal@tomifa.sk','09f0b94e822bf82aa050c8882fc7fcb7','2014-03-18 12:33:35','0000-00-00',0,NULL,'0000-00-00 00:00:00',0,'f3dfb5e71986e987c6c3e4043b100433',NULL,1,1,0,'2014-03-18 19:33:35','2014-03-18 19:33:35',0,NULL,NULL,NULL,NULL,'0.000000',0,0),
(56660,'grajciar@mados.sk','new_order','[e-spotrebice] New order : #20172632 - 171383882',6,'2017-06-06 08:55:15'),
(54901,'grajciar@mados.sk','new_order','[e-spotrebice] New order : #20172275 - 527797398',6,'2017-05-17 09:47:38'),
(14137,'boginony@gmail.com','shipped','[e-spotrebice] Odoslané',6,'2015-11-20 12:48:54'),
(9582,1,1,0,3,6,'Gabriela','Pecháčová','Gabriela.pechacova@gmail.com','bf85fa998f576783f4d1ef1341730c03','2015-08-10 14:28:03','0000-00-00',0,NULL,'0000-00-00 00:00:00',0,'acb58ebf6a3e795b73c3900e7dff6991',NULL,1,1,0,'2015-08-10 22:28:03','2015-08-10 22:28:03',0,NULL,NULL,NULL,NULL,'0.000000',0,0),
(54939,'info@e-spotrebice.sk','new_order','[e-spotrebice] New order : #20172284 - 984908874',6,'2017-05-17 15:52:08'),
(45778,'vismekm@gmail.com','shipped','[e-spotrebice] Odoslané',6,'2017-01-24 07:12:21'),
(4664,1,1,0,1,6,'Marcel','Varga','varmarcel@gmail.com','3335cca0c9ce5edf5e2876293b20af5c','2014-05-18 11:36:20','0000-00-00',0,NULL,'0000-00-00 00:00:00',0,'feed42fe68bd5727a32126d387595257',NULL,1,0,0,'2014-05-18 19:36:20','2014-05-18 19:36:20',0,NULL,NULL,NULL,NULL,'0.000000',0,0),
(35465,'info@e-spotrebice.sk','new_order','[e-spotrebice] New order : #20163841 - 067178596',6,'2016-10-17 11:03:04'),
(11175,'grajciar@mados.sk','new_order','[e-spotrebice] New order : #20153345 - 695856413',6,'2015-10-08 12:52:55'),
(18746,1,1,0,3,6,'Ondrej','Fabula','fabula58@centrum.sk','eb30183b5813f0a16a4bd8eb3c669157','2017-06-11 10:05:14','0000-00-00',1,'195.12.128.138','2017-06-11 18:05:14',0,'e6ccf81eaa893a6268cc46f9df09f78c',NULL,1,1,0,'2017-06-11 18:05:14','2017-06-11 18:05:14',0,'PlastConvert s.r.o.',NULL,NULL,NULL,'0.000000',0,0),
(38416,'jozef.podstavek1902@zoznam.sk','shipped','[e-spotrebice] Odoslané',6,'2016-11-14 08:45:39'),
(12906,1,1,0,3,6,'Slavomír','Garaj','slavomir@garaj.name','820ed7ff91564727eec94c2de12f0fb4','2016-06-13 00:22:21','0000-00-00',1,'213.81.205.74','2016-06-13 08:22:21',0,'688eb6b304b22887ba60fb6001999980',NULL,1,1,0,'2016-06-13 08:22:21','2016-06-13 08:22:21',0,'Nedozierne možnosti s.r.o.',NULL,NULL,NULL,'0.000000',0,0),
(8674,'info@e-spotrebice.sk','new_order','[e-spotrebice] New order : #20152901 - 127481756',6,'2015-09-02 08:25:52'),
(17126,1,1,0,3,6,'Peter','Gemersky','peter.gemersky@gmail.com','6eae43ce71a969db00373a8959eed15a','2017-02-20 09:02:46','0000-00-00',0,NULL,'0000-00-00 00:00:00',0,'d324c33fd45cb3a4cc53aa31abffd413',NULL,1,1,0,'2017-02-20 16:02:46','2017-02-20 16:02:46',0,NULL,NULL,NULL,NULL,'0.000000',0,0),
(49274,'mhutnan@gmail.com','order_conf','[e-spotrebice] Potvrdenie objednávky',6,'2017-03-08 08:45:23'),
(1418,1,6,0,15943,20165067,0,'open','pekaco@slovanet.sk','ft6Qcj7sSYtk','2016-12-08 14:38:25','2016-12-08 14:38:25'),
(1464,1,6,1,0,0,0,'open','marek.lulo.luley@gmail.com','MDst3Awnaar7','2016-12-29 17:52:19','2016-12-29 17:52:19'),
(5037,'ibradova@gmail.com','order_conf','[e-spotrebice] Potvrdenie objednávky',6,'2015-07-10 04:59:59'),
(50689,'novosad.peter@retepslovakia.sk','order_conf','[e-spotrebice] Potvrdenie objednávky',6,'2017-03-29 07:13:39'),
(29550,'danielaondrusova@gmail.com','shipped','[e-spotrebice] Odoslané',6,'2016-08-18 09:06:23'),
(1734,'info@e-spotrebice.sk','new_order','[e-spotrebice] New order : #20151636 - 867396122',6,'2015-05-14 08:32:31'),
(24483,'zuzana.lisicka@gmail.com','shipped','[e-spotrebice] Odoslané',6,'2016-05-31 06:02:37'),
(20151,'hnatic@saske.sk','order_conf','[e-spotrebice] Potvrdenie objednávky',6,'2016-02-28 23:49:35'),
(38204,'grajciar@mados.sk','new_order','[e-spotrebice] New order : #20164396 - 160516542',6,'2016-11-10 18:24:52'),
(22477,'tomas.reg80@gmail.com','order_conf','[e-spotrebice] Potvrdenie objednávky',6,'2016-04-15 19:45:57'),
(2110,'robinbobin@azet.sk','shipped','[e-spotrebice] Odoslané',6,'2015-05-20 13:12:26'),
(2187,1,1,9,1,6,'Stanislav','Košík Ml.','contikosik@gmail.com','a6fe32e07bdd137e9c8c307b6d783d07','2013-06-26 13:57:55',NULL,0,NULL,NULL,0,'0925e706244d2ae994f80a266f0127ac',NULL,1,1,0,'2013-06-26 21:57:55','2013-06-26 21:57:55',1,NULL,NULL,NULL,NULL,'0.000000',0,60),
(29406,'volckova.mirka@gmail.com','shipped','[e-spotrebice] Odoslané',6,'2016-08-17 09:13:31'),
(19415,'grajciar@mados.sk','new_order','[e-spotrebice] New order : #20160612 - 506418737',6,'2016-02-17 22:03:26'),
(20423,'info@e-spotrebice.sk','new_order','[e-spotrebice] New order : #20160832 - 731864806',6,'2016-03-03 09:01:11'),
(7648,'marek.bilancik@gmail.com','order_canceled','[e-spotrebice] Zrušené',6,'2015-08-18 12:37:40'),
(16714,1,1,0,3,6,'Mojmír','Prídavok','pridavok@gmail.com','f8fd388bf00ac7ee2122a763b8d245eb','2017-01-23 16:36:55','0000-00-00',1,'88.212.36.9','2017-01-23 23:36:55',0,'e9c6e05019258b1991e53820db8b3380',NULL,1,1,0,'2017-01-23 23:36:55','2017-01-23 23:36:55',0,NULL,NULL,NULL,NULL,'0.000000',0,0),
(34366,'boss85@centrum.sk','account','[e-spotrebice] Vitajte!',6,'2016-10-07 21:27:51'),
(13250,'martingasparek@gmail.com','order_conf','[e-spotrebice] Potvrdenie objednávky',6,'2015-11-09 11:20:43'),
(34063,'monika.budajova@savba.sk','order_conf','[e-spotrebice] Potvrdenie objednávky',6,'2016-10-05 09:32:49'),
(3609,1,1,0,3,6,'Luboslav','Špilák','burkot1@tiscali.cz','483ddccca6f2ad1a73cf861f71d7ed94','2014-01-27 04:48:04','0000-00-00',0,NULL,'0000-00-00 00:00:00',0,'ae756e434ac9db61c0262caad2581581',NULL,1,1,0,'2014-01-27 11:48:04','2014-01-27 11:48:04',0,NULL,NULL,NULL,NULL,'0.000000',0,0),
(15495,'info@excel-design.sk','shipped','[e-spotrebice] Odoslané',6,'2015-12-07 10:08:26'),

 


Напишите ответ...
  • Вставить:
Прикрепить файлы
Верх