Security Incident Xarakiri.ru Data Breach of 100K Users - Detected!

Compromised Data
Id,timestamp_x,login,password,checkword,active,name,last_name,email
Compromised Total Users
101,549
Data Breach Date
2022

Data Breach Details Discussion

Xarakiri.ru Data Breach of 100K Users - Detected!
http://xarakiri.ru
Russian restaurants with delivery in Novosibirsk suffered a data breach that impacted 100K users.

101,549 unique records


Contain this data
├ login
├ email
├ password (md5$salt)
├ address
├ vkontakte-id
├ device-information
└ name || full name


Tables:
├ user
├ user_cards
├ sale_order_props_value
├ sale_order
├ event
├ ipol_mshpStatistics
├ sale_buyer_stat
├ sale_order_props_value
├ sale_order
├ order_change
├ user_props_value
└ products

Sample of database content:
INSERT INTO `b_sale_order_props_value` (`ID`, `ORDER_ID`, `ORDER_PROPS_ID`, `NAME`, `VALUE`, `CODE`) VALUES
(1588, 342, 8, 'Улица', 'Краснообск пос (Краснообск)', 'STREET'),
(1589, 342, 11, 'Дом', '9', NULL),
(1590, 342, 12, 'Квартира', '88', 'FLAT'),
(1591, 342, 21, 'Старый ID', '241475', NULL),
(1970, 438, 8, 'Улица', 'Краснообск пос (Краснообск)', 'STREET'),
(1971, 438, 11, 'Дом', '9', NULL),
(1972, 438, 12, 'Квартира', '88', 'FLAT'),
(1973, 438, 21, 'Старый ID', '244486', NULL),
(2062, 461, 8, 'Улица', 'Краснообск пос (Краснообск)', 'STREET'),
(2063, 461, 11, 'Дом', '9', NULL),
(2064, 461, 12, 'Квартира', '88', 'FLAT'),
(2065, 461, 21, 'Старый ID', '245169', NULL),
(2387, 543, 8, 'Улица', 'Краснообск пос (Краснообск)', 'STREET'),
(2388, 543, 11, 'Дом', '9', NULL),
(2389, 543, 12, 'Квартира', '88', 'FLAT'),
(2390, 543, 21, 'Старый ID', '247166', NULL),


INSERT INTO `b_user` (`ID`, `TIMESTAMP_X`, `LOGIN`, `PASSWORD`, `CHECKWORD`, `ACTIVE`, `NAME`, `LAST_NAME`, `EMAIL`, `LAST_LOGIN`, `DATE_REGISTER`, `LID`, `PERSONAL_PROFESSION`, `PERSONAL_WWW`, `PERSONAL_ICQ`, `PERSONAL_GENDER`, `PERSONAL_BIRTHDATE`, `PERSONAL_PHOTO`, `PERSONAL_PHONE`, `PERSONAL_FAX`, `PERSONAL_MOBILE`, `PERSONAL_PAGER`, `PERSONAL_STREET`, `PERSONAL_MAILBOX`, `PERSONAL_CITY`, `PERSONAL_STATE`, `PERSONAL_ZIP`, `PERSONAL_COUNTRY`, `PERSONAL_NOTES`, `WORK_COMPANY`, `WORK_DEPARTMENT`, `WORK_POSITION`, `WORK_WWW`, `WORK_PHONE`, `WORK_FAX`, `WORK_PAGER`, `WORK_STREET`, `WORK_MAILBOX`, `WORK_CITY`, `WORK_STATE`, `WORK_ZIP`, `WORK_COUNTRY`, `WORK_PROFILE`, `WORK_LOGO`, `WORK_NOTES`, `ADMIN_NOTES`, `STORED_HASH`, `XML_ID`, `PERSONAL_BIRTHDAY`, `EXTERNAL_AUTH_ID`, `CHECKWORD_TIME`, `SECOND_NAME`, `CONFIRM_CODE`, `LOGIN_ATTEMPTS`, `LAST_ACTIVITY_DATE`, `AUTO_TIME_ZONE`, `TIME_ZONE`, `TIME_ZONE_OFFSET`, `TITLE`, `BX_USER_ID`, `LANGUAGE_ID`) VALUES

(320159, '2019-08-16 04:46:41', '79137309841', 'Z9YnhXii04568c9e3a06579e1eb25c3d38a5876a', 'kQramOeD43056d7eac3c2db5dc6f5087d13c46c2', 'Y', 'Роман', NULL, 'bavarcev@list.ru', '2019-08-16 12:48:31', '2019-08-16 11:41:35', NULL, NULL, NULL, NULL, '', NULL, NULL, '79137309841', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-08-16 11:46:41', NULL, NULL, 0, '2019-08-16 12:16:03', NULL, NULL, NULL, NULL, NULL, NULL),
(320165, '2019-08-16 04:55:55', 'andrew.belyaev@yandex.ru', '6Q_u%o7I88f272a48ab787b85f730dfbe7f40f7c', '1s3DnZcW8e86db173ecbde5fe491358e7462163b', 'Y', 'Андрей', 'Беляев', 'andrew.belyaev@yandex.ru', '2019-08-16 11:55:00', '2019-08-16 11:54:10', 's1', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '+7 (913) 920-69-23', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '1977-02-14', NULL, '2019-08-16 11:55:55', 'Анатольевич', '', 0, '2019-08-16 13:44:51', '', NULL, NULL, NULL, '9b138bf649a188d5e3811942540a7b4d', 'ru'),
(320172, '2019-08-16 05:28:53', 'maximdk@mail.ru', 'uU@1t/R3090bb43f74904481d29cb44162cb9dd9', 'E6U7n8ta6aac680f9140846011446abf9978630c', 'Y', 'Максим', 'Авраменко', 'maximdk@mail.ru', '2019-09-18 14:04:49', '2019-08-16 12:25:56', 's1', NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '+7 (913) 949-71-82', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '1968-08-16', NULL, '2019-08-16 12:28:53', 'Владимирович', '', 0, '2019-09-18 14:18:08', '', NULL, NULL, NULL, 'aac199b4799d5fc6a8d9687329424af3', 'ru'),
(320178, '2019-08-16 05:41:41', '79133811082', 'quqVPtvvadd3a3f4719430ed44854e22b70ba0a9', 'RqBJG80m8c21ef29f01e3a25d4f8f163f2186070', 'Y', 'Дима', 'Антипов', 'dirtylyi123@yandex.ru', '2019-08-16 12:41:00', '2019-08-16 12:40:45', NULL, NULL, NULL, NULL, '', NULL, NULL, '79133811082', NULL, '+7 (913) 381-10-82', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '1998-07-15', NULL, '2019-08-16 12:41:41', 'Алексеевич', NULL, 0, '2019-08-16 12:43:32', '', NULL, NULL, NULL, '530c56d5ffb35b4109997355765374de', NULL),
(320182, '2020-10-12 03:30:29', '79963762037', 'S2y~,Hk289dc78a14d992ec5f8ac33ec014ba79e', 'b7mnXuzW3399dbc5720ca2dd7df97f00f7aa2c6e', 'Y', 'ольга', 'Сычева', '79963762037@xarakiriphone.ru', '2022-07-02 14:39:26', '2019-08-16 12:58:02', NULL, NULL, NULL, NULL, '', NULL, NULL, '79963762037', NULL, '+7 (996) 376-20-37', NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '1961-08-24', NULL, '2020-08-22 14:07:00', 'Петровна', NULL, 0, '2019-10-03 11:19:13', '', NULL, NULL, NULL, '4c5c7ad74fbe4e8de8c0170f9f14bf89', NULL),
(320185, '2019-08-16 06:13:40', '79282805551', 'shzwXgfDa855532f29c2390aea0ac9a90f5d4299', '0n5FGZqqbb65e8128fe651222f1c7aed2c2c8be8', 'Y', 'юлия', NULL, 'yula__@mail.ru', '2019-08-16 14:26:53', '2019-08-16 13:13:18', NULL, NULL, NULL, NULL, '', NULL, NULL, '79282805551', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2019-08-16 13:13:40', NULL, NULL, 0, '2019-08-16 13:19:16', NULL, NULL, NULL, NULL,

INSERT INTO `b_sale_user_props_value` (`ID`, `USER_PROPS_ID`, `ORDER_PROPS_ID`, `NAME`, `VALUE`) VALUES
(865, 433, 1, 'Ф.И.О.', 'Герман'),
(866, 433, 3, 'Телефон', '+7 (952) 936-55-40'),
(867, 434, 1, 'Ф.И.О.', 'федор'),
(868, 434, 3, 'Телефон', '+7 (953) 777-52-11'),
(869, 435, 1, 'Ф.И.О.', 'Павел'),
(870, 435, 3, 'Телефон', '+7 (913) 933-05-91'),
(871, 436, 1, 'Ф.И.О.', 'Елена'),
(872, 436, 3, 'Телефон', '+7 (913) 927-67-34'),
(873, 437, 1, 'Ф.И.О.', 'Дарья'),
(874, 437, 3, 'Телефон', '+7 (913) 903-81-97'),
(875, 438, 1, 'Ф.И.О.', 'сергей'),
(876, 438, 3, 'Телефон', '+7 (905) 938-55-05'),
(877, 439, 1, 'Ф.И.О.', 'павел'),

Information

Submitted by
mightydawn
Insert date
Last update

Share this data breach

Top