Site: Dailyorders.com
Affected Users: 1.4 Million
Country Of Origin: India
Columns: Table 1: Emails + Table 2: Password, FIrst Name, Last Name
Hash Type: Salted Md5 {-m 20 in hashcat)
Dump Date: April 6th 2025
Note About Parsing: Because of the way that Magento 1's database schema is organized, the emails and the hashes are in different tables. In order to create email:hash you will need to parse the columns as email:entity_id from the FIrst Table included (customer_entity) and you will need to parse Entity_id:hash:Salt from the second table included (customer_entity_varchar} take both parsed files and use a hash matching software like unified list manager or use the join command in bash to join together the two files on the entity_id column resulting in email:hash:salt output. Feel free to dm for help me if you have any trouble parsing.
Sample Lines:
Table 1 (customer_entity}
Table 2 {customer_entity_varchar)
Affected Users: 1.4 Million
Country Of Origin: India
Columns: Table 1: Emails + Table 2: Password, FIrst Name, Last Name
Hash Type: Salted Md5 {-m 20 in hashcat)
Dump Date: April 6th 2025
Note About Parsing: Because of the way that Magento 1's database schema is organized, the emails and the hashes are in different tables. In order to create email:hash you will need to parse the columns as email:entity_id from the FIrst Table included (customer_entity) and you will need to parse Entity_id:hash:Salt from the second table included (customer_entity_varchar} take both parsed files and use a hash matching software like unified list manager or use the join command in bash to join together the two files on the entity_id column resulting in email:hash:salt output. Feel free to dm for help me if you have any trouble parsing.
Sample Lines:
Table 1 (customer_entity}
Code:
(1412100, 1, 0, 1, 'kinkarmondal90036@gmail.com', 1, NULL, 1, '2020-12-29 02:52:00', '2020-12-29 05:52:58', 1, 0, '9091505152', NULL),
(1412101, 1, 0, 1, 'arjunramya422@gmail.com', 1, NULL, 1, '2020-12-29 00:55:50', '2020-12-29 05:55:51', 1, 0, '8197030751', NULL),
(1412102, 1, 0, 1, 'shreekardhanush@gmail.com', 1, NULL, 1, '2020-12-29 00:59:15', '2020-12-29 05:59:16', 1, 0, '7348911518', NULL),
(1412103, 1, 0, 1, 'shahidkhan12504@gmail.com', 1, NULL, 1, '2020-12-29 01:30:37', '2020-12-29 06:01:51', 1, 0, '9897837129', NULL),
(1412104, 1, 0, 1, 'dnandini@gmail.com', 1, NULL, 1, '2020-12-29 01:37:34', '2020-12-29 06:08:18', 1, 0, '8210355733', NULL),
(1412105, 1, 0, 1, 'roybinek132@gmail.com', 1, NULL, 1, '2020-12-29 02:08:51', '2020-12-29 10:22:27', 1, 0, '9864534235', NULL),Table 2 {customer_entity_varchar)
Code:
INSERT INTO `customer_entity_varchar` (`value_id`, `entity_type_id`, `attribute_id`, `entity_id`, `value`) VALUES
(345, 1, 5, 56, 'vijay'),
(346, 1, 7, 56, 'reddy'),
(347, 1, 12, 56, 'f30bb394f4da5880a6605607eaa582c0:bouEzgBFCoQTiiNRWkhmNFWa77j2Grn2'),
(348, 1, 3, 56, 'India'),
(411, 1, 5, 65, 'suman1'),
(412, 1, 7, 65, 'suman1'),
(413, 1, 12, 65, '3a90ff73bbbee579cd1f1cf38af60e2e:IJ9BoR0aPWPlev25fOiLIngrBP3XAnAl'),