Posts: 185
Threads: 12
Joined: Sep 2023
Ok thanks for sharing the onlinestore.it db
Posts: 41
Threads: 2
Joined: Jul 2023
Posts: 257
Threads: 8
Joined: Oct 2023
Oct 25, 2023, 06:13 AM
(This post was last modified: Oct 25, 2023, 06:13 AM by timi90.)
is the link working or not? @ themob @ windowxp @ dedale
Posts: 1
Threads: 0
Joined: Jul 2023
This file does not exist - can you re-upload it pls?
Posts: 512
Threads: 16
Joined: Sep 2023
This data should be good, this website should have been maintained for more than 2 months, it is likely to go down
Posts: 257
Threads: 8
Joined: Oct 2023
(Oct 11, 2023, 12:10 PM)emo Wrote: (Oct 11, 2023, 09:52 AM)Cindy Wrote: (Oct 09, 2023, 07:33 AM)emo Wrote: sample
CREATE TABLE `psos_customer` (
`id_customer` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_shop` int(11) unsigned NOT NULL DEFAULT 1,
`id_gender` int(10) unsigned NOT NULL,
`id_default_group` int(10) unsigned NOT NULL DEFAULT 1,
`id_lang` int(10) unsigned DEFAULT NULL,
`id_risk` int(10) unsigned NOT NULL DEFAULT 1,
`company` varchar(255) DEFAULT NULL,
`siret` varchar(14) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`passwd` varchar(255) NOT NULL,
`last_passwd_gen` timestamp NOT NULL DEFAULT current_timestamp(),
`birthday` date DEFAULT NULL,
`newsletter` tinyint(1) unsigned NOT NULL DEFAULT 0,
`ip_registration_newsletter` varchar(15) DEFAULT NULL,
`newsletter_date_add` datetime DEFAULT NULL,
`optin` tinyint(1) unsigned NOT NULL DEFAULT 0,
`website` varchar(128) DEFAULT NULL,
`outstanding_allow_amount` decimal(20,6) NOT NULL DEFAULT 0.000000,
`show_public_prices` tinyint(1) unsigned NOT NULL DEFAULT 0,
`max_payment_days` int(10) unsigned NOT NULL DEFAULT 60,
`secure_key` varchar(32) NOT NULL DEFAULT '-1',
`note` text DEFAULT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT 0,
`is_guest` tinyint(1) NOT NULL DEFAULT 0,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
`reset_password_token` varchar(40) DEFAULT NULL,
`reset_password_validity` datetime DEFAULT NULL,
PRIMARY KEY (`id_customer`),
KEY `customer_email` (`email`),
KEY `customer_login` (`email`,`passwd`),
KEY `id_customer_passwd` (`id_customer`,`passwd`),
KEY `id_gender` (`id_gender`),
KEY `id_shop_group` (`id_shop_group`),
KEY `id_shop` (`id_shop`,`date_add`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `psos_customer` (`id_customer`, `id_shop_group`, `id_shop`, `id_gender`, `id_default_group`, `id_lang`, `id_risk`, `company`, `siret`, `ape`, `firstname`, `lastname`, `email`, `passwd`, `last_passwd_gen`, `birthday`, `newsletter`, `ip_registration_newsletter`, `newsletter_date_add`, `optin`, `website`, `outstanding_allow_amount`, `show_public_prices`, `max_payment_days`, `secure_key`, `note`, `active`, `is_guest`, `deleted`, `date_add`, `date_upd`, `reset_password_token`, `reset_password_validity`) VALUES
(1, 1, 1, 1, 3, 1, 0, '', '', '', 'Anonymous', 'Anonymous', '[email protected]', 'prestashop', '2020-02-12 12:06:50', '0000-00-00', 0, '', '0000-00-00 00:00:00', 1, '', 0.000000, 0, 0, 'c6152a346aa99bd0b7e91e73ac3d0c00', '', 0, 0, 0, '2020-02-12 18:06:50', '2020-02-12 18:06:50', '', '0000-00-00 00:00:00'),
(3, 1, 1, 1, 3, 1, 0, NULL, NULL, NULL, 'Giovanni', 'Favero', '[email protected]', '$2y$10$UKZwoKQbjNKGJMspQ4S4eOJPWFW1VR5ftGES1zNdkC2NGRiGR03oG', '2020-03-06 07:03:27', '0000-00-00', 0, NULL, '0000-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, 'd0ad87b9583415e11511151c08f5a826', NULL, 1, 0, 0, '2020-03-06 13:03:27', '2020-11-13 09:16:43', NULL, '0000-00-00 00:00:00'),
(4, 1, 1, 0, 3, 1, 1, NULL, NULL, NULL, 'OPC PTS Not Delete', 'OPC PTS Not Delete', '[email protected]', '04febcaaf1e2d6921877ed66998fe4f2', '2020-03-10 16:07:50', '0000-00-00', 0, NULL, NULL, 0, NULL, 0.000000, 0, 60, '54af231ecb05c9f97035192dd9809a08', NULL, 0, 0, 1, '2020-03-10 17:07:50', '2020-03-10 17:07:50', NULL, NULL),
(5, 1, 1, 1, 2, 1, 0, NULL, NULL, NULL, 'Andrea', 'Maddalena', '[email protected]', '58bc960f092d803308501140a930b631', '2020-03-13 14:47:04', '0000-00-00', 1, NULL, '20
20-04-12 01:17:48', 0, NULL, 0.000000, 0, 0, '7724ab820c0e31f6b6d08e3e0f20df63', NULL, 1, 1, 0, '2020-03-13 20:47:04', '2020-04-12 01:18:48', NULL, '0000-00-00 00:00:00'),
(7, 1, 1, 0, 3, 1, 0, NULL, NULL, NULL, 'Domenico', 'Marmiroli', '[email protected]', '$2y$10$qcqBfu7AMkYzjqjhhC3.AO9mpsRIAjOpXzUFb7HVPjuy4oIr2g8gm', '2020-03-25 10:47:12', '0000-00-00
', 0, NULL, '2020-03-25 17:47:12', 1, NULL, 0.000000, 0, 0, 'ef38590095c821b93a3afb69455face0', NULL, 1, 0, 0, '2020-03-25 17:47:12', '2021-01-08 07:37:24', NULL, '0000-00-00 00:00:0
0'),
(12, 1, 1, 0, 3, 1, 0, NULL, NULL, NULL, 'Antonino', 'Di Bella', '[email protected]', '$2y$10$YBKlZ4DzJCMTdiEDWxLQB.tCcI.ei4/Mmh8biAFnNZLoVk30LEVIC', '2020-03-30 04:06:38', '0000-00-00', 0,
'91.191.183.49', '2020-05-25 22:58:46', 0, NULL, 0.000000, 0, 0, 'd1711c7573fe01e57cfff5d102ac930f', NULL, 1, 0, 0, '2020-03-30 12:06:38', '2020-11-13 09:16:43', NULL, '0000-00-00
00:00:00'),
(13, 1, 1, 0, 2, 1, 0, NULL, NULL, NULL, 'Test', 'Test', '[email protected]', '4fc16758924375b86c63323ce48db383', '2020-04-01 08:12:21', '0000-00-00', 0, NULL, '0000-00-00 00:00:00', 0, NUL
L, 0.000000, 0, 0, 'f548fe4f1ec2aee499eea87d1147af71', NULL, 1, 1, 0, '2020-04-01 16:12:21', '2020-04-01 16:12:21', NULL, '0000-00-00 00:00:00'),
(14, 1, 1, 0, 3, 1, 0, NULL, NULL, NULL, 'Prisca', 'Belfiore', '[email protected]', '$2y$10$3v5QoJlzeVG9OWYjk4ZWdOaoju4QEShrvz6y/5/1SgVoE2ZjQrRLS', '2022-03-17 08:39:25', '0000-00-00
', 0, NULL, '0000-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, 'cca5c75b69c1e429d09ad551dd61ccdd', NULL, 1, 0, 0, '2020-04-02 14:15:40', '2022-03-17 08:39:25', NULL, '0000-00-00 00:00:0
0'),
(15, 1, 1, 0, 3, 1, 0, NULL, NULL, NULL, 'Test', 'Order', '[email protected]', '$2y$10$8dMVfKn3Rs/H4ecMdtgNJuOiuSpXdkYA98aI1IJ6RlESiZxrxnBqy', '2020-04-07 07:55:36', '0000-00-00', 0,
NULL, '0000-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, 'd502ad5d1336beb39688e7472975f93c', NULL, 1, 0, 0, '2020-04-07 15:55:36', '2020-11-13 09:16:43', NULL, '0000-00-00 00:00:00'),
(18, 1, 1, 0, 2, 1, 0, NULL, NULL, NULL, 'Amazon', 'Pay TEST', '[email protected]', '8ceaa2220fb86a452095d7032fb9c1f1', '2020-04-14 06:53:18', '0000-00-00', 0, NULL, '00
00-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, 'ff9fbb4972b555f25dcd1da6087d7020', NULL, 1, 1, 0, '2020-04-14 14:53:18', '2020-04-14 15:39:45', NULL, '0000-00-00 00:00:00'),
(19, 1, 1, 0, 2, 1, 0, NULL, NULL, NULL, 'Amazon', 'Pay TEST', '[email protected]', '989e2ce74bdaaf14ce1f5c53ff8bb72b', '2020-04-14 08:25:59', '0000-00-00', 0, NULL, '00
00-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, '2eac79e8dbd5d0138b0ebe7b68a2d057', NULL, 1, 1, 0, '2020-04-14 16:25:59', '2020-04-14 16:27:34', NULL, '0000-00-00 00:00:00'),
(20, 1, 1, 0, 2, 1, 0, NULL, NULL, NULL, 'Pluto', 'Pippo', '[email protected]', 'bfc8b0183a99002356c0aa06cf161c73', '2020-04-16 02:18:40', '0000-00-00', 1, NULL, '2020-04-16
10:18:40', 0, NULL, 0.000000, 0, 0, '50d4ee5eb6f72fd299b28759772f28d6', NULL, 1, 1, 0, '2020-04-16 10:18:40', '2020-04-16 10:19:08', NULL, '0000-00-00 00:00:00'),
(21, 1, 1, 0, 2, 1, 0, NULL, NULL, NULL, 'Amazon', 'Pay TEST', '[email protected]', '30137e0eba32941fbad673b5625689ce', '2020-04-16 06:42:36', '0000-00-00', 0, NULL, '00
00-00-00 00:00:00', 0, NULL, 0.000000, 0, 0, 'd752d6b2419bcc5839d7ca232e831a9e', NULL, 1, 1, 0, '2020-04-16 14:42:36', '2020-04-16 14:45:26', NULL, '0000-00-00 00:00:00'),
(22, 1, 1, 0, 3, 1, 0, NULL, NULL, NULL, 'Andrea', 'Maddalena', '[email protected]', '$2y$10$QGMHuMDp7kSwguhSALWb4uA9GLjptmac04ywMyPyAKoXMV5LfBaBm', '2020-04-17 03:24:41', '0000-00-00
', 0, NULL, '2020-04-17 11:24:41', 0, NULL, 0.000000, 0, 0, 'fde6ff762408e2c10c62e97538b13e1e', NULL, 1, 0, 0, '2020-04-17 11:24:41', '2022-09-21 09:26:21', 'e8245885a9c4deb3f305c13ccc
21f9ca94c9b2aa', '2020-05-22 16:57:34'),
(23, 1, 1, 0, 2, 1, 0, NULL, NULL, NULL, 'Simone', 'Panattoni', '[email protected]', '6c95d05758ad648e2b6635dbdbf2dc1a', '2020-05-21 03:56:46', '0000-00-00', 1, '213.136.152.128',
'2020-09-07 11:41:57', 0, NULL, 0.000000, 0, 0, 'a4f5fc165a74158f17ca4b6ee6b51598', NULL, 1, 1, 0, '2020-05-21 11:56:46', '2020-05-21 11:56:58', NULL, '0000-00-00 00:00:00'),
How many users are there ?
Running `rg -oIN '[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+' onlinestore.it_db.sql | sort -fu | wc -l` I counted 273,604 unique emails
Would be great if someone (with skills, so unlikely me) shares a cleaded CSV version.
Posts: 26
Threads: 10
Joined: Oct 2023
Please update the link, it doesn't work anymore
Posts: 93
Threads: 21
Joined: Aug 2023
Posts: 34
Threads: 16
Joined: Jun 2023
@ themob can you reupload?
Posts: 76
Threads: 7
Joined: Aug 2023
Link is updated
@windowxp @LonJReedy @coolworker378 @timi90 @Admiral @angellove09 @hzanonim @mihinull @ zimablue
Let me know if you can't see that hidden content. I already report my own post for the mods to edit and put the new link
|
