> Can we somehow implement the blacklist blocks to be added to the .htaccess? rather than running a script.
No. In fact it's a bad idea having a long list of blacklisted IPs in .htaccess. With 300 IPs you add about 100 msec (0.1 seconds) per request, including media files. Each page load results in several requests (typically: 40 to 100), running at most 8 in parallel. So the average time you would add per page load would be in the ballpark area of one second under ideal circumstances (one concurrent page load). In real world situations you would be slowing down each page load noticeably, in the area of 2-3 seconds. This is a genuinely Bad Idea.
> my concern is we currently get at occasions 47 hack attempts in a few minutes/seconds and would like an instant block from the site.
I think you should be looking into an attack mitigation service such as CloudFlare. They should hold back most of those attacks. The few that make it through can be fended off by Admin Tools without much trouble.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!