Posts: 63
Threads: 7
Joined: Aug 2023
10-09-2023, 06:03 AM
(This post was last modified: 10-09-2023, 06:42 AM by themob.)
Hello BreachForums Community,
Today I have uploaded the onlinestore.it ( Large Household Appliances ) for you to download, when I take the lines with emails, there are 1.38M lines, thanks for reading and enjoy!
1,380,000+ lines in total.
Compromised data: Email, Alias, Company, Lastname, Firstname, Address, Address, Zip, City, Phone2, Mobilephone, Vat, Dni, Sdi, Pec, Ip, Password, Orders
Not dumped by me.
Sample of tables (total 495 tables)
Quote:`psos_address_format` (`id_country`, `format`)
`psos_address` (`id_address`, `id_country`, `id_state`, `id_customer`, `id_manufacturer`, `id_supplier`, `id_warehouse`, `alias`, `company`, `lastname`, `firstname`, `address1`, `address2`, `postcode`, `city`, `other`, `phone`, `phone_mobile`, `vat_number`, `dni`, `sdi`, `pec`, `date_add`, `date_upd`, `active`, `deleted`)
`psos_advancedpopup` (`id_advancedpopup`, `id_shop`, `name`, `date_init`, `date_end`, `secs_to_display`, `secs_to_display_cart`, `secs_to_close`, `dont_display_again`, `priority`, `locked`, `show_customer_newsletter`, `show_customer_not_newsletter`, `show_on_view_page_nbr`, `show_every_nbr_hours`, `nb_products`, `nb_products_comparator`, `back_opacity_value`, `controller_exceptions`, `groups`, `customers`, `products`, `countries`, `zones`, `categories`, `categories_selected`, `manufacturers`, `suppliers`, `cms`, `languages`, `active`, `display_on_load`, `display_after_cart`, `display_on_exit`, `display_on_click`, `display_on_click_selector`, `close_on_background`, `blur_background`, `color_background`, `open_effect`, `position`, `cart_amount`, `cart_amount_from`, `cart_amount_to`, `display_mobile`, `display_tablet`, `display_desktop`, `display_ip_string`, `date_add`, `date_upd`)
`psos_amazonpay_address_reference` (`id`, `id_address`, `amazon_order_reference_id`, `amazon_hash`)
`psos_amz_address` (`id`, `id_address`, `amazon_order_reference_id`, `amazon_hash`)
`psos_amz_carts` (`id`, `id_customer`, `id_cart`, `amazon_order_reference_id`, `cart`)
`psos_amz_transactions` (`amz_tx_id`, `amz_tx_order_reference`, `amz_tx_type`, `amz_tx_time`, `amz_tx_expiration`, `amz_tx_amount`, `amz_tx_amount_refunded`, `amz_tx_status`, `amz_tx_reference`, `amz_tx_code`, `amz_tx_amz_id`, `amz_tx_customer_informed`, `amz_tx_last_change`, `amz_tx_last_update`, `amz_tx_order`)
`psos_bnl_customer_token` (`id`, `id_customer`, `token`, `created_at`, `updated_at`)
`psos_bnl_module_payments` (`id`, `order_id`, `cart_id`, `transaction_type`, `transaction_id`, `payment_id`, `order_reference`, `serverUrl`, `token`, `id_customer`, `status`, `is_refunded`, `is_captured`, `method`, `created_at`, `updated_at`)
`psos_cart_product` (`id_cart`, `id_product`, `id_address_delivery`, `id_shop`, `id_product_attribute`, `id_customization`, `quantity`, `date_add`)
`psos_cart_rule` (`id_cart_rule`, `id_customer`, `date_from`, `date_to`, `description`, `quantity`, `quantity_per_user`, `priority`, `partial_use`, `code`, `minimum_amount`, `minimum_amount_tax`, `minimum_amount_currency`, `minimum_amount_shipping`, `country_restriction`, `carrier_restriction`, `group_restriction`, `cart_rule_restriction`, `product_restriction`, `shop_restriction`, `free_shipping`, `reduction_percent`, `reduction_amount`, `reduction_tax`, `reduction_currency`, `reduction_product`, `reduction_exclude_special`, `gift_product`, `gift_product_attribute`, `highlight`, `active`, `date_add`, `date_upd`)
`psos_cart` (`id_cart`, `id_shop_group`, `id_shop`, `id_carrier`, `delivery_option`, `id_lang`, `id_address_delivery`, `id_address_invoice`, `id_currency`, `id_customer`, `id_guest`, `secure_key`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `allow_seperated_package`, `date_add`, `date_upd`, `checkout_session_data`)
`psos_connections` (`id_connections`, `id_shop_group`, `id_shop`, `id_guest`, `id_page`, `ip_address`, `date_add`, `http_referer`)
`psos_contact` (`id_contact`, `email`, `customer_service`, `position`)
`psos_customer_group` (`id_customer`, `id_group`)
`psos_customer_message` (`id_customer_message`, `id_customer_thread`, `id_employee`, `message`, `file_name`, `ip_address`, `user_agent`, `date_add`, `date_upd`, `private`, `read`)
`psos_customer_thread` (`id_customer_thread`, `id_shop`, `id_lang`, `id_contact`, `id_customer`, `id_order`, `id_product`, `status`, `email`, `token`, `date_add`, `date_upd`)
`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`)
`psos_employee` (`id_employee`, `id_profile`, `id_lang`, `lastname`, `firstname`, `email`, `passwd`, `last_passwd_gen`, `stats_date_from`, `stats_date_to`, `stats_compare_from`, `stats_compare_to`, `stats_compare_option`, `preselect_date_range`, `bo_color`, `bo_theme`, `bo_css`, `default_tab`, `bo_width`, `bo_menu`, `active`, `optin`, `id_last_order`, `id_last_customer_message`, `id_last_customer`, `last_connection_date`, `reset_password_token`, `reset_password_validity`)
`psos_guest` (`id_guest`, `id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`)
`psos_hicookieconsent` (`id_consent`, `id_shop`, `ip_address`, `id_guest`, `id_customer`, `id_web_browser`, `id_operating_system`, `consents`, `date_add`, `date_upd`)
`psos_iqitwishlist_product` (`id_iqitwishlist_product`, `id_product`, `id_product_attribute`, `id_customer`, `id_shop`)
`psos_message` (`id_message`, `id_cart`, `id_customer`, `id_employee`, `id_order`, `message`, `private`, `date_add`)
`psos_of_shipping_rule` (`id_of_shipping_rule`, `name`, `id_customer`, `date_from`, `date_to`, `time_from`, `time_to`, `priority`, `minimum_amount`, `minimum_amount_tax`, `minimum_amount_currency`, `minimum_amount_restriction`, `maximum_amount`, `maximum_amount_tax`, `maximum_amount_currency`, `maximum_amount_restriction`, `country_restriction`, `zone_restriction`, `state_restriction`, `city_restriction`, `carrier_restriction`, `group_restriction`, `of_shipping_rule_restriction`, `product_restriction`, `shop_restriction`, `dimension_restriction`, `zipcode_restriction`, `package_restriction`, `gender_restriction`, `nb_supplier_min`, `nb_supplier_max`, `type`, `percent`, `amount`, `formula`, `currency`, `tax_rules_group`, `product`, `quantity_per_product`, `active`, `date_add`, `date_upd`)
`psos_opc_customer_address` (`id_customer`, `id_address`, `object`, `default`)
`psos_opc_field_customer` (`id`, `id_field`, `id_customer`, `object`, `id_address`, `id_option`, `value`, `date_upd`)
`psos_opc_social_network` (`id`, `id_shop`, `id_customer`, `code_network`, `network`)
`psos_order_invoice` (`id_order_invoice`, `id_order`, `number`, `delivery_number`, `delivery_date`, `total_discount_tax_excl`, `total_discount_tax_incl`, `total_paid_tax_excl`, `total_paid_tax_incl`, `total_products`, `total_products_wt`, `total_shipping_tax_excl`, `total_shipping_tax_incl`, `shipping_tax_computation_method`, `total_wrapping_tax_excl`, `total_wrapping_tax_incl`, `shop_address`, `note`, `date_add`)
`psos_orders` (`id_order`, `reference`, `id_shop_group`, `id_shop`, `id_carrier`, `id_lang`, `id_customer`, `id_cart`, `id_currency`, `id_address_delivery`, `id_address_invoice`, `current_state`, `secure_key`, `payment`, `conversion_rate`, `module`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `shipping_number`, `total_discounts`, `total_discounts_tax_incl`, `total_discounts_tax_excl`, `total_paid`, `total_paid_tax_incl`, `total_paid_tax_excl`, `total_paid_real`, `total_products`, `total_products_wt`, `total_shipping`, `total_shipping_tax_incl`, `total_shipping_tax_excl`, `carrier_tax_rate`, `total_wrapping`, `total_wrapping_tax_incl`, `total_wrapping_tax_excl`, `round_mode`, `round_type`, `invoice_number`, `delivery_number`, `invoice_date`, `delivery_date`, `valid`, `date_add`, `date_upd`)
`psos_psgdpr_log` (`id_gdpr_log`, `id_customer`, `id_guest`, `client_name`, `id_module`, `request_type`, `date_add`, `date_upd`)
`psos_quantity_discount_rule_condition` (`id_quantity_discount_rule_condition`, `id_quantity_discount_rule`, `id_quantity_discount_rule_group`, `id_type`, `id_customer`, `customer_default_group`, `customer_newsletter`, `customer_vat`, `customer_signedup_date_from`, `customer_signedup_date_to`, `customer_signedup_days`, `customer_orders_nb_operator`, `customer_orders_nb`, `customer_orders_nb_date_from`, `customer_orders_nb_date_to`, `customer_orders_nb_days`, `customer_orders_nb_prod_operator`, `customer_orders_nb_prod`, `customer_orders_amount_operator`, `customer_orders_amount`, `customer_orders_amount_currency`, `customer_orders_amount_tax`, `customer_orders_amount_shipping`, `customer_orders_amount_discount`, `customer_orders_amount_date_from`, `customer_orders_amount_date_to`, `customer_orders_amount_days`, `customer_orders_amount_orders`, `customer_orders_amount_interval`, `customer_first_order`, `customer_membership_operator`, `customer_membership`, `customer_birthday`, `customer_years_from`, `customer_years_to`, `cart_amount_operator`, `cart_amount`, `cart_amount_currency`, `cart_amount_tax`, `cart_amount_shipping`, `cart_amount_discount`, `cart_weight_operator`, `cart_weight`, `products_all_met`, `products_nb_all_met`, `products_operator`, `products_amount`, `products_amount_currency`, `products_amount_tax`, `products_nb_operator`, `products_nb`, `products_nb_same`, `products_nb_same_attributes`, `products_nb_same_category`, `products_nb_dif_operator`, `products_nb_dif`, `products_nb_dif_cat_operator`, `products_nb_dif_cat`, `product_price_from`, `product_price_from_currency`, `product_price_from_tax`, `product_price_to`, `product_price_to_currency`, `product_price_to_tax`, `product_stock_operator`, `product_stock_amount`, `products_default_category`, `apply_discount_to_special`, `group_products_by`, `filter_by_product`, `filter_by_attribute`, `filter_by_feature`, `filter_by_category`, `filter_by_supplier`, `filter_by_manufacturer`, `filter_by_price`, `filter_by_stock`, `schedule`, `url_string`)
`psos_rcpgtagmanager_user_tracking_data` (`id_customer`, `ip`, `uuid`, `tracking_data`, `date_add`)
`psos_shop_group` (`id_shop_group`, `name`, `share_customer`, `share_order`, `share_stock`, `active`, `deleted`)
`psos_soisy_basic` (`id_soisy_basic`, `id_shop`, `id_cart`, `id_customer`, `order_reference`, `token`, `total_cart`, `total_paid`, `payment_status`, `sandbox`, `created_at`, `updated_at`)
`psos_soisy_order` (`id_soisy_order`, `id_shop`, `id_cart`, `id_order`, `order_reference`, `id_customer`, `id_payment`, `context`, `token`, `total_cart`, `total_paid`, `last_event_id`, `callbacks_history`, `sandbox`, `date_add`, `date_upd`)
`psos_specific_price` (`id_specific_price`, `id_specific_price_rule`, `id_cart`, `id_product`, `id_shop`, `id_shop_group`, `id_currency`, `id_country`, `id_group`, `id_customer`, `id_product_attribute`, `price`, `from_quantity`, `reduction`, `reduction_tax`, `reduction_type`, `from`, `to`)
`psos_tobewebto_fattura_elettronica` (`id_tobewebto_fattura_elettronica`, `id_customer`, `tobewebto_sdicode`, `tobewebto_pec`
Download
Hidden Content
You must register or login to view this content.
Posts: 15,401
Threads: 359
Joined: Jun 2023
(10-09-2023, 06:03 AM)themob Wrote: Hello BreachForums Community,
Today I have uploaded the onlinestore.it ( Large Household Appliances ) for you to download, when I take the lines with emails, there are 1.38M lines, thanks for reading and enjoy!
1,380,000+ lines in total.
Compromised data: Email, Alias, Company, Lastname, Firstname, Address, Address, Zip, City, Phone2, Mobilephone, Vat, Dni, Sdi, Pec, Ip, Password, Orders
Not dumped by me. Hello, please add a sample to the topic in the form of 5-10 lines within a few hours, otherwise I will have to move the topic to a remote one (any user can also add a sample by leaving a message in the topic)
Posts: 63
Threads: 7
Joined: Aug 2023
Posts: 250
Threads: 134
Joined: Jun 2023
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', 'anonymous@psgdpr.com', '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', 'giovanni.favero@mocainteractive.com', '$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', 'noreply@dev.onlinestore.it', '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', 'andrea.maddalena@libero.it', '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', 'domenico@marmiroli.it', '$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', 'support@uebix.com', '$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', 'test@test.it', '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', 'prisca.belfiore@gmail.com', '$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', 'testorder@simplesurance.de', '$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', 'nunzfede+sandbox@amazon.com', '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', 'nunzfede+sandbox@amazon.com', '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', 'plutopippo@yuum.it', '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', 'nunzfede+sandbox@amazon.com', '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', 'andrea.m@onlinestore.it', '$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', 'panax@hotmail.it', '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'),
Ban reason: Several doxing attempts. (Permanent)
Posts: 67
Threads: 1
Joined: Aug 2023
Posts: 2,525
Threads: 72
Joined: Jun 2023
Ok thanks for sharing the onlinestore.it db Bro
Ban reason: Leeching. (Permanent)
Posts: 160
Threads: 8
Joined: Aug 2023
thx, interesting bd, good work!
Posts: 226
Threads: 36
Joined: Aug 2023
(10-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', 'anonymous@psgdpr.com', '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', 'giovanni.favero@mocainteractive.com', '$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', 'noreply@dev.onlinestore.it', '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', 'andrea.maddalena@libero.it', '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', 'domenico@marmiroli.it', '$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', 'support@uebix.com', '$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', 'test@test.it', '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', 'prisca.belfiore@gmail.com', '$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', 'testorder@simplesurance.de', '$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', 'nunzfede+sandbox@amazon.com', '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', 'nunzfede+sandbox@amazon.com', '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', 'plutopippo@yuum.it', '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', 'nunzfede+sandbox@amazon.com', '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', 'andrea.m@onlinestore.it', '$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', 'panax@hotmail.it', '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 ?
Posts: 250
Threads: 134
Joined: Jun 2023
(10-11-2023, 09:52 AM)Cindy Wrote: (10-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', 'anonymous@psgdpr.com', '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', 'giovanni.favero@mocainteractive.com', '$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', 'noreply@dev.onlinestore.it', '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', 'andrea.maddalena@libero.it', '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', 'domenico@marmiroli.it', '$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', 'support@uebix.com', '$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', 'test@test.it', '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', 'prisca.belfiore@gmail.com', '$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', 'testorder@simplesurance.de', '$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', 'nunzfede+sandbox@amazon.com', '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', 'nunzfede+sandbox@amazon.com', '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', 'plutopippo@yuum.it', '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', 'nunzfede+sandbox@amazon.com', '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', 'andrea.m@onlinestore.it', '$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', 'panax@hotmail.it', '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
Ban reason: Several doxing attempts. (Permanent)
Posts: 15,401
Threads: 359
Joined: Jun 2023
Can anyone confirm the reality of the leak?(News or the presence of your accounts in the leak).I will be very grateful for your help in this.
|
