StellaMaris Update Root

180320

.htaccess

SetEnvIf GEOIP_COUNTRY_CODE RU AllowCountry

Deny from env=AllowCountry

With Clause with regex

http://www.sql.ru/forum/921216/regexp-udalenie-podstroki-iz-stroki-mezhdu-dvumya-shablonami

https://dev.mysql.com/doc/refman/8.0/en/with.html

WITH cte1 AS (SELECT a, b FROM table1), cte2 AS (SELECT c, d FROM table2) SELECT b, d FROM cte1 JOIN cte2 WHERE cte1.a = cte2.c;

with s as(select '"select j.FIO \"Фамилия, Имя Отчество\", PERSON_ID \"ID человека\""' str from dual)
select str,
regexp_replace(str, '\\"[^\"]*\\"', '')
from s;

StellaMaris

SELECT a.title, a.fulltext FROM maris01.xx2sk_content a WHERE a.fulltext LIKE '%<!--58dba6d87ab6e1490790104-->%' OR a.fulltext LIKE '%<!--/58dba6d87ab6e1490790104-->%'
;

Как взламывают сайты

https://habrahabr.ru/company/sprinthost/blog/125839/

https://joomla.shneider-host.ru/blog/optimizatsiia-i-bezopasnost-joomla/kak-ochistit-sait-joomla-ot-virusov

https://sucuri.net/guides/how-to-clean-hacked-joomla

https://sitecheck.sucuri.net/

Scripts to Clean

https://github.com/btoplak/Joomla-Anti-Malware-Scan-Script--JAMSS-/blob/master/jamss.php

Технические подробности работы резервного копирования ISPmanager

https://doc.ispsystem.ru/index.php/%D0%A2%D0%B5%D1%85%D0%BD%D0%B8%D1%87%D0%B5%D1%81%D0%BA%D0%B8%D0%B5_%D0%BF%D0%BE%D0%B4%D1%80%D0%BE%D0%B1%D0%BD%D0%BE%D1%81%D1%82%D0%B8_%D1%80%D0%B0%D0%B1%D0%BE%D1%82%D1%8B_%D1%80%D0%B5%D0%B7%D0%B5%D1%80%D0%B2%D0%BD%D0%BE%D0%B3%D0%BE_%D0%BA%D0%BE%D0%BF%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8F_ISPmanager

Шифрование

https://doc.ispsystem.ru/index.php/%D0%9C%D0%BE%D0%B4%D1%83%D0%BB%D1%8C_%D1%80%D0%B5%D0%B7%D0%B5%D1%80%D0%B2%D0%BD%D0%BE%D0%B3%D0%BE_%D0%BA%D0%BE%D0%BF%D0%B8%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D1%8F_%D1%88%D0%B8%D1%84%D1%80%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5

Hosting PlanetaHost.ru

http://cbi.planetahost.ru/

Mar

8p