[NamelessKing1337]

Hidden Content

You must register or login to view this content.

sample;


INSERT INTO `orders` (`id`, `order_id`, `name`, `email`, `phone`, `date_created`, `user_date_creation`, `payment_date`, `order_name`, `status`, `price`, `payed`, `manager`, `utm_source`, `utm_medium`, `utm_campaign`, `utm_content`, `utm_term`, `utm_banner`, `utm_phrase`, `report_ptoducttype`, `report_productname`, `report_productcategory`, `report_ordertype`, `linkorder`, `date_on`, `date_off`, `dana_dates`, `dana_participants`, `type`, `report_webinar1`, `report_webinar2`, `report_webinar3`, `report_webinar4`, `report_webinar5`, `report_webinar6`, `salebot_messenger`, `positions_price`, `id_polzovatelya`, `promocode`, `promoaction`, `id_zakaza`, `created_at_webhook`, `created_at`, `date_updated`, `paid_at_webhook`, `user_utm_source`, `user_utm_medium`, `user_utm_campaign`, `user_utm_content`, `user_utm_term`, `user_utm_group`, `user_gcpc`, `order_tags`, `offer_tags`, `paid_order`, `freeapplication`, `rejection_reason`, `location`) VALUES


(1, '1423311', 'Александр Алексеевич Квитченко', 'staak@yandex.ru', '+79067774284', '2025-10-01 00:08:43', '2023-07-03 00:00:00', NULL, 'Онлайн | Мастер - класс Игоря Будникова “Я не вывожу” | Регистрация', 'Завершен', 0.00, 0.00, '', '', '', '', '', '', '', '', '', 'Мастер - класс Игоря Будникова “Я не вывожу”', '', '', 'https://minddetox.getcourse.ru/sales/control/deal/update/id/731900751', '', '', '', '', '', '', 'Пришел', '', '', '', NULL, '', NULL, 322766853, '', '', 731900751, NULL, '2025-10-12 21:01:54', NULL, NULL, 'welcomebackhome.academy', 'referral', '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL),

[thelastwhitehat]

For anyone who wants to unlock this database, it doesn’t contain 5.7 million records (it has 74,837) and the .SQL file appears to be parsed or broken. See below:

Breach Analysis Spoiler

SQL file values seem to be completely missing compared to the INSERT query. After I fixed that with placeholder or NULL values, this is what I got.

MD5 hash of getcourse.ru.sql: E96D2261C5F645024F022A474E0FFBCA

File: getcourse.ru - orders.csv (43.78 MB)
Hash: 80555B0B00F9B3238E66C48B9B51B86E
Records: 74837
Unique Emails: 29273 (based on HIBP guidelines)
Breach Date: 2025-11-26 (estimated)
Records Range: 2014-05-30 <---> 2025-11-26

Detected date range for the column 'user_date_creation':
+-----+---------------------+---------------------+
|  #  |   oldest (dates)    |   newest (dates)    |
|-----+---------------------+---------------------|
|  1  | 2014-05-30 00:00:00 | 2025-11-26 00:00:00 |
|  2  | 2014-06-03 00:00:00 | 2025-11-25 00:00:00 |
|  3  | 2014-07-23 00:00:00 | 2025-11-24 00:00:00 |
|  4  | 2014-07-29 00:00:00 | 2025-11-23 00:00:00 |
|  5  | 2014-07-30 00:00:00 | 2025-11-22 00:00:00 |
+-----+---------------------+---------------------+


Detected values for the column 'email':
+---------+----------+---------+-----------+-----------+
|  total  |  unique  |  dupes  |  invalid  |  valid %  |
|---------+----------+---------+-----------+-----------|
|  74837  |  29532   |  45305  |     0     |   100%    |
+---------+----------+---------+-----------+-----------+


Detected values for the column 'phone':
+---------+----------+---------+-----------+-----------+
|  total  |  unique  |  dupes  |  invalid  |  valid %  |
|---------+----------+---------+-----------+-----------|
|  74837  |  27900   |  45884  |   1053    |    99%    |
+---------+----------+---------+-----------+-----------+


Top 10 email domains detected:
+-----+------------+---------+-----+
|  #  |   domain   |  count  |  %  |
|-----+------------+---------+-----|
|  1  |  mail.ru   |  9993   | 34% |
|  2  | gmail.com  |  9462   | 32% |
|  3  | yandex.ru  |  5183   | 18% |
|  4  |   bk.ru    |   885   | 3%  |
|  5  |  list.ru   |   615   | 2%  |
|  6  |  inbox.ru  |   508   | 2%  |
|  7  |   ya.ru    |   395   | 1%  |
|  8  | rambler.ru |   389   | 1%  |
|  9  | icloud.com |   322   | 1%  |
| 10  | yahoo.com  |   143   | 0%  |
+-----+------------+---------+-----+

[NamelessKing1337]

For anyone who wants to unlock this database, it doesn’t contain 5.7 million records (it has 74,837) and the .SQL file appears to be parsed or broken. See below:

Breach Analysis Spoiler

SQL file values seem to be completely missing compared to the INSERT query. After I fixed that with placeholder or NULL values, this is what I got.

MD5 hash of getcourse.ru.sql: E96D2261C5F645024F022A474E0FFBCA

File: getcourse.ru - orders.csv (43.78 MB)
Hash: 80555B0B00F9B3238E66C48B9B51B86E
Records: 74837
Unique Emails: 29273 (based on HIBP guidelines)
Breach Date: 2025-11-26 (estimated)
Records Range: 2014-05-30 <---> 2025-11-26

Detected date range for the column 'user_date_creation':
+-----+---------------------+---------------------+
|  #  |  oldest (dates)    |  newest (dates)    |
|-----+---------------------+---------------------|
|  1  | 2014-05-30 00:00:00 | 2025-11-26 00:00:00 |
|  2  | 2014-06-03 00:00:00 | 2025-11-25 00:00:00 |
|  3  | 2014-07-23 00:00:00 | 2025-11-24 00:00:00 |
|  4  | 2014-07-29 00:00:00 | 2025-11-23 00:00:00 |
|  5  | 2014-07-30 00:00:00 | 2025-11-22 00:00:00 |
+-----+---------------------+---------------------+


Detected values for the column 'email':
+---------+----------+---------+-----------+-----------+
|  total  |  unique  |  dupes  |  invalid  |  valid %  |
|---------+----------+---------+-----------+-----------|
|  74837  |  29532  |  45305  |    0    |  100%    |
+---------+----------+---------+-----------+-----------+


Detected values for the column 'phone':
+---------+----------+---------+-----------+-----------+
|  total  |  unique  |  dupes  |  invalid  |  valid %  |
|---------+----------+---------+-----------+-----------|
|  74837  |  27900  |  45884  |  1053    |    99%    |
+---------+----------+---------+-----------+-----------+


Top 10 email domains detected:
+-----+------------+---------+-----+
|  #  |  domain  |  count  |  %  |
|-----+------------+---------+-----|
|  1  |  mail.ru  |  9993  | 34% |
|  2  | gmail.com  |  9462  | 32% |
|  3  | yandex.ru  |  5183  | 18% |
|  4  |  bk.ru    |  885  | 3%  |
|  5  |  list.ru  |  615  | 2%  |
|  6  |  inbox.ru  |  508  | 2%  |
|  7  |  ya.ru    |  395  | 1%  |
|  8  | rambler.ru |  389  | 1%  |
|  9  | icloud.com |  322  | 1%  |
| 10  | yahoo.com  |  143  | 0%  |
+-----+------------+---------+-----+

yes my bad, moderators can change title, i cant change

[Ruddy124]

public since last year DEC but THX anyways