Парсер csv-файла

Регулярное выражение для разбивки файла access_log

Параметры файла: текстовый, разделитель между полями - пробел, текстовые типы заключены в двойные кавычки, дата - в квадратные скобки.

\s".+?"|\s\[.+?\]|\s*[^ ]+

Собранную статистику "плохих" (статус 303 и 403) запросов можно посмотреть тут. Система "отсечения" срабатывает один раз в день на один "плохой" запрос и вносит URL с параметрами в статистику. На один день блокируются запросы с выловленного IP. На следующий день доступ опять появляется.

Господа горе-хакеры, даю подсказку - движок для этого сайта сделан точно не на базе wordpress, пожалуйста не тратьте своё время проверяя дырки wordpress, а то уже становится скучно, самые одарённые могут воспользоваться собранной статистикой и выработать альтернативные алгоритмы.

Пример вывода данных

Доступ к файлу статистики: 0600

строк в файле: 48 [08-11-2025 09:21:19]

IPURL
94.25.171.122 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/parse-csv/ HTTP/1.0" [08/Nov/2025:06:32:47 +0300] 12267 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36"
114.119.132.12 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET /reg/ HTTP/1.0" [08/Nov/2025:06:41:39 +0300] 11266 "https://3x7.su/tools/bank-tinkoff" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
    • "GET /articles/maximum-length-mysql-text-field-types/ HTTP/1.0" [08/Nov/2025:06:43:00 +0300] 12036 "https://3x7.su/articles/maximum-length-mysql-text-field-types/" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
66.249.66.203 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [08/Nov/2025:06:43:29 +0300] 18317 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
43.157.50.58 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [08/Nov/2025:06:51:36 +0300] 18220 "http://www.3x7.su" "Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1"
43.157.156.190 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [08/Nov/2025:06:53:17 +0300] 18425 "http://3x7.su" "Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1"
2a0f:ca80::49 ++
  • status: 403 - 2
url: 2
  1. 403 - 2
    • "GET /wp-login.php HTTP/1.0" [08/Nov/2025:06:55:26 +0300] 9227 "-" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)"
    • "GET /articles/wp-login.php HTTP/1.0" [08/Nov/2025:06:55:26 +0300] 8562 "-" "Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)"
51.68.111.199 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET / HTTP/1.0" [08/Nov/2025:07:00:33 +0300] 18347 "-" "Mozilla/5.0 (compatible; MJ12bot/v2.0.4; http://mj12bot.com/)"
    • "GET / HTTP/1.0" [08/Nov/2025:07:00:34 +0300] 18327 "-" "Mozilla/5.0 (compatible; MJ12bot/v2.0.4; http://mj12bot.com/)"
157.55.39.48 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/opisanie-tablic-1S-V77/ HTTP/1.0" [08/Nov/2025:07:20:59 +0300] 42354 "-" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36"
66.249.66.6 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /articles/key-code/ HTTP/1.0" [08/Nov/2025:07:29:00 +0300] 12726 "-" "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.7390.122 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"
114.119.139.148 +*
  • status: 200 - 2
  • status: 303 - 1
url: 3
  1. 200 - 2
    • "GET /articles/palitra-excel/ HTTP/1.0" [08/Nov/2025:07:45:04 +0300] 13605 "https://3x7.su/articles" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
    • "GET /articles/invert-color/ HTTP/1.0" [08/Nov/2025:07:46:30 +0300] 11782 "-" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
  2. 303 - 1
    • "GET /articles/invert-color HTTP/1.0" [08/Nov/2025:07:46:27 +0300] 243 "-" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
114.119.146.107 +*
  • status: 303 - 1
  • status: 200 - 1
url: 2
  1. 303 - 1
    • "GET /articles/html-special-char HTTP/1.0" [08/Nov/2025:07:47:50 +0300] 248 "-" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
  2. 200 - 1
    • "GET /articles/html-special-char/ HTTP/1.0" [08/Nov/2025:07:47:52 +0300] 16243 "-" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
114.119.154.87 +*
  • status: 200 - 2
  • status: 303 - 1
url: 3
  1. 200 - 2
    • "GET /tools/bank-tinkoff/ HTTP/1.0" [08/Nov/2025:07:53:07 +0300] 13558 "https://3x7.su/tools/bank-tinkoff" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
    • "GET /tools/convert/ HTTP/1.0" [08/Nov/2025:08:05:35 +0300] 11488 "https://3x7.su/tools/convert" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
  2. 303 - 1
    • "GET /tools/convert HTTP/1.0" [08/Nov/2025:08:05:34 +0300] 235 "https://3x7.su/tools/convert" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
95.108.213.150 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/ HTTP/1.0" [08/Nov/2025:08:07:06 +0300] 12976 "-" "Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)"
94.154.35.236 ++
  • status: 303 - 1
  • status: 404 - 1
url: 2
  1. 303 - 1
    • "HEAD /archive.gz HTTP/1.0" [08/Nov/2025:08:12:13 +0300] - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36"
  2. 404 - 1
    • "HEAD /archive.gz/ HTTP/1.0" [08/Nov/2025:08:12:13 +0300] - "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36"
114.119.153.242 +*
  • status: 303 - 1
  • status: 404 - 1
url: 2
  1. 303 - 1
    • "GET /articles/regulyarnye-vyrajeniya/sa=U HTTP/1.0" [08/Nov/2025:08:13:29 +0300] 259 "https://anarim.az/img/search.php?newwindow=1&q=%D1%80%D0%B5%D0%B3%D1%83%D0%BB%D1%8F%D1%80%D0%BD%D1%8B%D0%B5%2B%D0%B2%D1%8B%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D1%8F%2B%D0%BE%D0%BD%D0%BB%D0%B0%D0%B9%D0%BD&sa=X&ved=2ahUKEwjwuoWf4q32AhXm-SoKHfCGDWMQ1QJ6BAgCEAQ" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
  2. 404 - 1
    • "GET /articles/regulyarnye-vyrajeniya/sa=U/ HTTP/1.0" [08/Nov/2025:08:13:31 +0300] 11315 "https://anarim.az/img/search.php?newwindow=1&q=%D1%80%D0%B5%D0%B3%D1%83%D0%BB%D1%8F%D1%80%D0%BD%D1%8B%D0%B5%2B%D0%B2%D1%8B%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D1%8F%2B%D0%BE%D0%BD%D0%BB%D0%B0%D0%B9%D0%BD&sa=X&ved=2ahUKEwjwuoWf4q32AhXm-SoKHfCGDWMQ1QJ6BAgCEAQ" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
185.157.97.241 +*
  • status: 200 - 2
url: 2
  1. 200 - 2
    • "GET / HTTP/1.0" [08/Nov/2025:08:16:32 +0300] 18320 "-" ""
    • "GET / HTTP/1.0" [08/Nov/2025:08:34:03 +0300] 18449 "-" ""
2a02:598:128:8a00::b00:6 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /figure/ HTTP/1.0" [08/Nov/2025:08:33:27 +0300] 12307 "-" "Mozilla/5.0 (compatible; SeznamBot/4.0; +https://o-seznam.cz/napoveda/vyhledavani/en/seznambot-crawler/)"
18.97.9.170 +*
  • status: 200 - 13
url: 13
  1. 200 - 13
    • "GET /reg/ HTTP/1.0" [08/Nov/2025:08:42:13 +0300] 11266 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /articles/maximum-length-mysql-int-field-types/ HTTP/1.0" [08/Nov/2025:08:47:03 +0300] 11841 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /articles/imap/ HTTP/1.0" [08/Nov/2025:08:49:08 +0300] 15299 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /tools/rnd/ HTTP/1.0" [08/Nov/2025:08:51:52 +0300] 11442 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /tools/ HTTP/1.0" [08/Nov/2025:08:53:41 +0300] 12976 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /tools/xml-parser/ HTTP/1.0" [08/Nov/2025:08:54:50 +0300] 15272 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /articles/jquery-post/ HTTP/1.0" [08/Nov/2025:08:55:47 +0300] 11520 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /figure/ HTTP/1.0" [08/Nov/2025:08:56:40 +0300] 12312 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /articles/cracked-by/ HTTP/1.0" [08/Nov/2025:09:06:32 +0300] 13922 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /articles/urbd/ HTTP/1.0" [08/Nov/2025:09:07:09 +0300] 14149 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /articles/mysql-date-function/ HTTP/1.0" [08/Nov/2025:09:09:06 +0300] 14444 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /articles/ssh/ HTTP/1.0" [08/Nov/2025:09:14:42 +0300] 15056 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
    • "GET /articles/key-code/ HTTP/1.0" [08/Nov/2025:09:20:48 +0300] 12728 "-" "CCBot/2.0 (https://commoncrawl.org/faq/)"
114.119.158.156 +*
  • status: 303 - 1
  • status: 200 - 1
url: 2
  1. 303 - 1
    • "GET /tools/parse-csv HTTP/1.0" [08/Nov/2025:09:05:16 +0300] 238 "https://baco.su/" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
  2. 200 - 1
    • "GET /tools/parse-csv/ HTTP/1.0" [08/Nov/2025:09:05:18 +0300] 15852 "https://baco.su/" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
114.119.156.99 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /tools/generator/ HTTP/1.0" [08/Nov/2025:09:09:33 +0300] 11420 "https://3x7.su/tools" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
114.119.140.221 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET /download/1S77/gruppirovschik-otchetov/ HTTP/1.0" [08/Nov/2025:09:10:54 +0300] 12247 "https://3x7.su/download/1S77/" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
114.119.151.208 +*
  • status: 303 - 1
  • status: 200 - 1
url: 2
  1. 303 - 1
    • "GET /tools/parse-csv HTTP/1.0" [08/Nov/2025:09:18:56 +0300] 237 "https://3x7.su/articles/bad-ip" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
  2. 200 - 1
    • "GET /tools/parse-csv/ HTTP/1.0" [08/Nov/2025:09:18:58 +0300] 16286 "https://3x7.su/articles/bad-ip" "Mozilla/5.0 (Linux; Android 7.0;) AppleWebKit/537.36 (KHTML, like Gecko) Mobile Safari/537.36 (compatible; PetalBot;+https://webmaster.petalsearch.com/site/petalbot)"
51.68.107.159 +*
  • status: 200 - 1
url: 1
  1. 200 - 1
    • "GET / HTTP/1.0" [08/Nov/2025:09:19:16 +0300] 18349 "-" "Mozilla/5.0 (compatible; MJ12bot/v2.0.4; http://mj12bot.com/)"

Качество запросов

статусрасшифровка
200

ссылок: 24

  1. /tools/parse-csv/, повторов: 3
  2. /reg/, повторов: 2
  3. /articles/maximum-length-mysql-text-field-types/, повторов: 1
  4. /, повторов: 8
  5. /articles/opisanie-tablic-1S-V77/, повторов: 1
  6. /articles/key-code/, повторов: 2
  7. /articles/palitra-excel/, повторов: 1
  8. /articles/invert-color/, повторов: 1
  9. /articles/html-special-char/, повторов: 1
  10. /tools/bank-tinkoff/, повторов: 1
  11. /tools/convert/, повторов: 1
  12. /tools/, повторов: 2
  13. /figure/, повторов: 2
  14. /articles/maximum-length-mysql-int-field-types/, повторов: 1
  15. /articles/imap/, повторов: 1
  16. /tools/rnd/, повторов: 1
  17. /tools/xml-parser/, повторов: 1
  18. /articles/jquery-post/, повторов: 1
  19. /articles/cracked-by/, повторов: 1
  20. /articles/urbd/, повторов: 1
  21. /articles/mysql-date-function/, повторов: 1
  22. /tools/generator/, повторов: 1
  23. /download/1S77/gruppirovschik-otchetov/, повторов: 1
  24. /articles/ssh/, повторов: 1

Всего запросов: 37 77.08%

403

ссылок: 2

  1. /wp-login.php, повторов: 1
  2. /articles/wp-login.php, повторов: 1

Всего запросов: 2 4.17%

303

ссылок: 6

  1. /articles/invert-color, повторов: 1
  2. /articles/html-special-char, повторов: 1
  3. /tools/convert, повторов: 1
  4. /archive.gz, повторов: 1
  5. /articles/regulyarnye-vyrajeniya/sa=U, повторов: 1
  6. /tools/parse-csv, повторов: 2

Всего запросов: 7 14.58%

404

ссылок: 2

  1. /archive.gz/, повторов: 1
  2. /articles/regulyarnye-vyrajeniya/sa=U/, повторов: 1

Всего запросов: 2 4.17%

Статсистика URL

URLCount
/articles/maximum-length-mysql-text-field-types/1
/wp-login.php1
/articles/wp-login.php1
/articles/opisanie-tablic-1S-V77/1
/articles/palitra-excel/1
/articles/invert-color1
/articles/invert-color/1
/articles/html-special-char1
/articles/html-special-char/1
/tools/bank-tinkoff/1
/tools/convert1
/tools/convert/1
/archive.gz1
/archive.gz/1
/articles/regulyarnye-vyrajeniya/sa=U1
/articles/regulyarnye-vyrajeniya/sa=U/1
/articles/maximum-length-mysql-int-field-types/1
/articles/imap/1
/tools/rnd/1
/tools/xml-parser/1
/articles/jquery-post/1
/articles/cracked-by/1
/articles/urbd/1
/articles/mysql-date-function/1
/tools/generator/1
/download/1S77/gruppirovschik-otchetov/1
/articles/ssh/1
/reg/2
/articles/key-code/2
/tools/2
/figure/2
/tools/parse-csv2
/tools/parse-csv/3
/8

Хронометраж IP

IPдата/время
94.25.171.122 [08/Nov/2025:06:32:47 +0300]
114.119.132.12 [08/Nov/2025:06:43:00 +0300]
66.249.66.203 [08/Nov/2025:06:43:29 +0300]
43.157.50.58 [08/Nov/2025:06:51:36 +0300]
43.157.156.190 [08/Nov/2025:06:53:17 +0300]
2a0f:ca80::49 [08/Nov/2025:06:55:26 +0300]
51.68.111.199 [08/Nov/2025:07:00:34 +0300]
157.55.39.48 [08/Nov/2025:07:20:59 +0300]
66.249.66.6 [08/Nov/2025:07:29:00 +0300]
114.119.139.148 [08/Nov/2025:07:46:30 +0300]
114.119.146.107 [08/Nov/2025:07:47:52 +0300]
114.119.154.87 [08/Nov/2025:08:05:35 +0300]
95.108.213.150 [08/Nov/2025:08:07:06 +0300]
94.154.35.236 [08/Nov/2025:08:12:13 +0300]
114.119.153.242 [08/Nov/2025:08:13:31 +0300]
2a02:598:128:8a00::b00:6 [08/Nov/2025:08:33:27 +0300]
185.157.97.241 [08/Nov/2025:08:34:03 +0300]
114.119.158.156 [08/Nov/2025:09:05:18 +0300]
114.119.156.99 [08/Nov/2025:09:09:33 +0300]
114.119.140.221 [08/Nov/2025:09:10:54 +0300]
114.119.151.208 [08/Nov/2025:09:18:58 +0300]
51.68.107.159 [08/Nov/2025:09:19:16 +0300]
18.97.9.170 [08/Nov/2025:09:20:48 +0300]

Вход


Регистрация