Search found 29 matches

by Yahalimu
Mon Sep 15, 2025 3:48 pm
Forum: Community Help & Support
Topic: DDOS BOT activity
Replies: 24
Views: 134138

Re: DDOS BOT activity

Nope, doesn't work on present version.. Excellent.
by Yahalimu
Mon Sep 15, 2025 3:26 pm
Forum: Community Help & Support
Topic: DDOS BOT activity
Replies: 24
Views: 134138

Re: DDOS BOT activity

It seems that what is happening requesting a category or 'New products' and also including the 'buy_now' action in the GET so it loads the whole category, adds it to the cart and then lists the shopping cart. This is very CPU intensive on the database especially if the cart has 2000 products in it. ...
by Yahalimu
Sat Sep 13, 2025 2:24 pm
Forum: Community Help & Support
Topic: DDOS BOT activity
Replies: 24
Views: 134138

Re: DDOS BOT activity

TBH as this is causing such an issue for us I think I'll do a quick and easy fix and just change the name of the action from 'buy_now' to something bespoke for now until I get cloudflare up and running. Fairly convinced they have marked the site as 'os-commerce' type so are using standard attacks fo...
by Yahalimu
Sat Sep 13, 2025 12:27 pm
Forum: Community Help & Support
Topic: DDOS BOT activity
Replies: 24
Views: 134138

Re: DDOS BOT activity

Hi, I may try them anyway, I believe you can give them a challenge if in certain countries which may probably stop them. They're not from the same ASN, they are originating from over 100 different countries so far, thousands of different IP's. Blocking 80 countries with iptables has made it more man...
by Yahalimu
Sat Sep 13, 2025 11:55 am
Forum: Community Help & Support
Topic: DDOS BOT activity
Replies: 24
Views: 134138

Re: DDOS BOT activity

Thanks. I am considering Cloudflare but as it seems like perfectly legitimate call not sure if it will help, as rate limiting won't work as there are thousands of IP's normally only making one fetch every few hours. At one point our MYSQL was having 58,000 queries per second. Retrieving a massive ca...
by Yahalimu
Sat Sep 13, 2025 11:19 am
Forum: Community Help & Support
Topic: DDOS BOT activity
Replies: 24
Views: 134138

DDOS BOT activity

Hi, Using an OLD version v1.0.5.0. We've recently been the victim of DDOS attacks from all over the world, for now I've banned most of the world apart from the US and Europe which has eased the situation but not stopped it. They are using the following type of URL: (example) domain/acopel-f400-35516...
by Yahalimu
Sun Aug 04, 2024 9:31 pm
Forum: Community Help & Support
Topic: Facebook Crawler
Replies: 7
Views: 4445

Re: Facebook Crawler

Probably go scrape data for their Llama AI. I blocked it via htaccess.
by Yahalimu
Fri Aug 02, 2024 11:17 pm
Forum: Community Help & Support
Topic: Phoenix SQL help please
Replies: 1
Views: 1756

Re: Phoenix SQL help please

Apologies, I realised I could just ask the AI, it came back with:
SELECT c.countries_iso_code_2 FROM orders o JOIN countries c ON o.billing_country = c.countries_name WHERE o.orders_id = 1234
Apologies for the bandwidth.
by Yahalimu
Fri Aug 02, 2024 10:55 pm
Forum: Community Help & Support
Topic: Phoenix SQL help please
Replies: 1
Views: 1756

Phoenix SQL help please

Hi. I need SQL queries to retrieve the country ISO codes(2 char) for customers billing address and order delivery addresses, by order_id. Can anyone help? As an aside, I've put the some of the schema and extra info into GPT4, works well to retrieve order info and sales stats etc. Creates SQL and I q...
by Yahalimu
Thu May 11, 2023 3:49 pm
Forum: Community Help & Support
Topic: Not charging VAT to channel islands
Replies: 5
Views: 241

Re: Not charging VAT to channel islands

Hi, We have some separate UK areas set up as separate countries. eg. UK_Scottish Highlands UK- Scottish Offshore Islands UK-Northern Ireland UK- Isle of Wight UK-Channel Islands UK-Gibraltar Precisely because some of them don't charge of VAT and different zone rate shipping charges for each area are...