Pharmaceutical Website Social-Apteka.ru 473k User Data Compromised!

[whlx]

Social-Apteka.ru, a pharmaceutical website, experienced a severe data breach involving two databases, compromising a total of 473,863 records. The breached information includes personal details such as names, phone numbers, addresses, and email addresses. Below are the specifics for each database:

Database 1: User Information

• Fields: Phone, Last Name, First Name, Patronymic, Date of Birth, Email, Login, Last Login, Date Registered
• Records: 141,030

Database 2: Order Details

• Fields: Phone, Last Name, First Name, Patronymic, Email, Pharmacy Name, Pharmacy Code, City, Delivery Address, Comment
• Records: 332,833

Social-apteka.ru_(заказы)_332k.txt

`ID`,`LID`,`PERSON_TYPE_ID`,`PAYED`,`DATE_PAYED`,`EMP_PAYED_ID`,`CANCELED`,`DATE_CANCELED`,`EMP_CANCELED_ID`,`REASON_CANCELED`,`STATUS_ID`,`DATE_STATUS`,`EMP_STATUS_ID`,`PRICE_DELIVERY`,`PRICE_PAYMENT`,`ALLOW_DELIVERY`,`DATE_ALLOW_DELIVERY`,`EMP_ALLOW_DELIVERY_ID`,`DEDUCTED`,`DATE_DEDUCTED`,`EMP_DEDUCTED_ID`,`REASON_UNDO_DEDUCTED`,`MARKED`,`DATE_MARKED`,`EMP_MARKED_ID`,`REASON_MARKED`,`RESERVED` ,`PRICE`,`CURRENCY`,`DISCOUNT_VALUE`,`USER_ID`,PAY_SYSTEM_ID`,`DELIVERY_ID`,`DATE_INSERT`,`DATE_UPDATE`,`USER_DESCRIPTION`,`ADDITIONAL_INFO`,`PS_STATUS`,`PS_STATUS_CODE`,`PS_STATUS_DESCRIPTION`,`PS_STATUS_MESSAGE`,`PS_SUM`,`PS_CURRENCY`,`PS_RESPONSE_DATE`,`COMMENTS`,`TAX_VALUE`,`STAT_GID`,`SUM_PAID`,`IS_RECURRING`,`RECURRING_ID`,`PAY_VOUCHER_NUM`,`PAY_VOUCHER_DATE`,`LOCKED_BY`,`DATE_LOCK`,`RECOUNT_FLAG`,`AFFILIATE_ID`,`DELIVERY_DOC_NUM`,`DELIVERY_DOC_DATE`,`UPDATED_1C`,`STORE_ID`,`ORDER_TOPIC`,`CREATED_BY`,`RESPONSIBLE_ID`,`COMPANY_ID`,`DATE_PAY_BEFORE`,`DATE_BILL`,`ACCOUNT_NUMBER`,`TRACKING_NUMBER`,`XML_ID`,`ID_1C`,`VERSION_1C`,`VERSION`,`EXTERNAL_ORDER`,`RUNNING`,`BX_USER_ID`,`ORDER_HASH`,`SEARCH_CONTENT`,`IS_SYNC_B24`,`ITEMS`
10, 's1', 1, 'N', NULL, NULL, 'Y', '2018-09-05 18:46:17', NULL, NULL, 'FG', '2019-06-25 11:51:11', 1, 0.0000, 0.0000, 'N', NULL, NULL, 'N', NULL, NULL, NULL, 'N', NULL, NULL, NULL, 'N', 2998.0000, 'RUB', 0.0000, 1, NULL, NULL, '2018-09-05 18:46:17', '2019-06-25 11:51:12', 'ФИО: Бульботка Вячеслав \nТелефон: +74954954951 \nEmail: bulbotka@gmail.com \nНазвание аптеки: Аптека №142 \nКод аптеки: 10379 \nАдрес доставки: ул. Социалистическая, 140', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 0.00, NULL, 0.00, 'N', NULL, NULL, NULL, 1, '2018-09-05 18:47:09', 'Y', NULL, NULL, NULL, 'N', NULL, NULL, 1, NULL, NULL, NULL, NULL, '52A', NULL, 'bx_f41b2678c8a28f547ecd94f665ca199e', NULL, NULL, 3, 'N', 'N', NULL, 'faf7bca84c6fc7d1f48fee6d3a33ec74', NULL, 'N', '',
11, 's1', 1, 'N', NULL, NULL, 'Y', '2018-09-05 18:50:33', NULL, NULL, 'FG', '2019-06-25 11:51:11', 1, 0.0000, 0.0000, 'N', NULL, NULL, 'N', NULL, NULL, NULL, 'N', NULL, NULL, NULL, 'N', 990.0000, 'RUB', 0.0000, 1, NULL, NULL, '2018-09-05 18:50:33', '2019-06-25 11:51:11', 'ФИО: Бульботка Вячеслав \nТелефон: 74959595955 \nEmail: bulbotka@gmail.com \nНазвание аптеки: Аптека №142 \nКод аптеки: 10379 \nАдрес доставки: ул. Социалистическая, 140', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 0.00, NULL, 0.00, 'N', NULL, NULL, NULL, 1, '2018-09-05 18:57:41', 'Y', NULL, NULL, NULL, 'N', NULL, NULL, 1, NULL, NULL, NULL, NULL, '53A', NULL, 'bx_3207a8de18ac92744b9aec40a08335c3', NULL, NULL, 3, 'N', 'N', NULL, 'a0cd4f74a13cbeadeeb2aa9b0ff006a5', NULL, 'N', '',
12, 's1', 1, 'N', NULL, NULL, 'N', NULL, NULL, NULL, 'F', '2018-09-11 22:03:55', NULL, 0.0000, 0.0000, 'N', NULL, NULL, 'N', NULL, NULL, NULL, 'N', NULL, NULL, NULL, 'N', 1336.0000, 'RUB', 0.0000, 1, NULL, NULL, '2018-09-05 18:56:31', '2018-09-11 22:03:56', 'ФИО: Бульботка Вячеслав \r\nТелефон: 74959595955 \r\nEmail: bulbotka@gmail.com \r\nНазвание аптеки: Аптека №142 \r\nКод аптеки: 10379 \r\nАдрес доставки: ул. Социалистическая, 140', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Y', 0.00, NULL, 0.00, 'N', NULL, NULL, NULL, 1, '2018-09-05 18:56:42', 'Y', NULL, NULL, NULL, 'N', NULL, NULL, 1, NULL, NULL, NULL, NULL, '54A', NULL, 'bx_4c9f40522239d130f922001944b563ca', NULL, NULL, 3, 'N', 'N', NULL, 'ebcfb530c51b15b13d464b6c4edc439e', NULL, 'N', '',

Social-apteka.ru_(users)_141k.txt

`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`,`BLOCKED`,`PASSWORD_EXPIRED`
1, '2023-08-18 15:50:43', '7777777777', '$6$VUwPEfhbMoRiL2Qr$w0YWV9ek0bnfX6qLqGJn7AM7xWZoMqoSWzKS25uT0rN7xZP8mugidTPeN77N3LSFH9k4/iN2PODDUIrRUZe9u/', '$6$S4G5SB0bHLe2Ftyv$s.biJ1TR6QoymYktsP6N9vZcuXEiz8dVMxpymlFhMGFwoDVV9h6glWZJIIQmSoevDkGbCdfifb1qZBkw.Qw.Y1', 'Y', 'Социальная', 'Аптека', 'ag@idweb.ru', '2023-08-29 00:57:51', '2018-07-23 16:02:40', 's1', '', '', '', 'F', NULL, NULL, '+77777777777', '', '74959595955', '', '', '', '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', NULL, '', '', NULL, '', '1999-10-06', NULL, '2023-02-06 10:03:13', 'Отчество1', NULL, 0, NULL, '', NULL, 10800, '', 'ad2f97f264fba14b9ee8f61013b49752', 'ru', 'N', '',
4, '2018-08-31 18:38:10', 'retailcrm', 'iiNkkcyN5ddf3acf4e194cfb96cec8147b917e81', 'FcSdmp68c52d5109561ec331d0ce110b71cb03fd', 'Y', 'retailcrm', 'retailcrm', 'retailcrm@retailcrm.com', NULL, '2018-08-31 18:38:10', 'ru', 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, NULL, NULL, NULL, NULL, NULL, NULL, '2018-08-31 18:38:10', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', '',
6, '2018-09-04 14:11:29', 'otziv@social-apteka.ru', 'Y2X0xHL16183b5953c6b2791221372ef25127fe1', 'CltHEjsX88ac8373ee517d2bff3b5b9f4c0b7125', 'Y', 'Модерация на сайте', 'процесс', 'otziv@social-apteka.ru', NULL, '2018-09-04 13:19:21', 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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-09-04 13:19:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'N', '',

 

[TGBYHNujm]

thanks brother