Post by comprido » Mon Sep 14, 2020 3:07 am

I'm having troubles since in Australia with my Opencart. I'm getting heaps of India/China registrations from fake customers.

To avoid overload my customer table I'm erasing all customers without orders:
DELETE `oc_customer` FROM `oc_customer` LEFT JOIN `oc_order` ON oc_customer.customer_id = oc_order.customer_id WHERE oc_order.customer_id Is Null;

Original post: viewtopic.php?t=88877&sid=684508f44cfc6 ... 5ffb4de781

Also blocking access from other countries through htaccess.

# Put countries to allow here
SetEnvIf GEOIP_COUNTRY_CODE AU AllowCountry
SetEnvIf GEOIP_COUNTRY_CODE NZ AllowCountry
Deny from all
Allow from env=AllowCountry

Aditionally you can edit admin/sale/customer.php and add these lines to the public function deleteCustomer($customer_id) so the query will run just by selecting any customer and clicking "Delete":

Code: Select all

// DELETE CUSTOMERS WITHOUT ORDERS SELECTING ONE OF THEM
$this->db->query("DELETE " . DB_PREFIX . "customer FROM " . DB_PREFIX . "customer LEFT JOIN " . DB_PREFIX . "order ON " . DB_PREFIX . "customer.customer_id = " . DB_PREFIX . "order.customer_id WHERE " . DB_PREFIX . "order.customer_id Is Null"); 

Pedro Martin - websitesbuilder.com.au
Checkout my free extensions: https://www.opencart.com/index.php?rout ... r=comprido


User avatar
New member

Posts

Joined
Mon Sep 10, 2012 11:46 pm

Post by JNeuhoff » Mon Sep 14, 2020 4:23 pm

You can use our Spambot Buster tool to prevent spambots from doing fake customer registrations and sending spam mails. Our tool uses an invisible honeypot trap and also checks for required mouse/touch/keyboard events to distinguish between genuine human users and spambots.

Override Engine * Integrated VQMod * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Rich Snippets * Google Tag Manager * Export/Import Tool * SpamBot Buster * Survey Plus


User avatar
Expert Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by EvolveWebHosting » Tue Sep 15, 2020 11:31 pm

reCaptcha should stop a lot of this or you can look into a firewall.

Image
Shared Hosting for $12 for the first year. Use the code $12ANNUAL and choose annual term. Free transfers too!
Detailed guide on how to install Opencart


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA

Post by comprido » Sat Sep 19, 2020 5:35 am

EvolveWebHosting wrote:
Tue Sep 15, 2020 11:31 pm
reCaptcha should stop a lot of this or you can look into a firewall.
Yeah, I try installing Google reCaptcha but couldn't make it work, then the one you see and still like that, they overpass.

Pedro Martin - websitesbuilder.com.au
Checkout my free extensions: https://www.opencart.com/index.php?rout ... r=comprido


User avatar
New member

Posts

Joined
Mon Sep 10, 2012 11:46 pm

Post by comprido » Sat Sep 19, 2020 5:36 am

JNeuhoff wrote:
Mon Sep 14, 2020 4:23 pm
You can use our Spambot Buster tool to prevent spambots from doing fake customer registrations and sending spam mails. Our tool uses an invisible honeypot trap and also checks for required mouse/touch/keyboard events to distinguish between genuine human users and spambots.
Beautiful. All my extensions are free. Do you make a swap?

Pedro Martin - websitesbuilder.com.au
Checkout my free extensions: https://www.opencart.com/index.php?rout ... r=comprido


User avatar
New member

Posts

Joined
Mon Sep 10, 2012 11:46 pm

Post by EvolveWebHosting » Sat Sep 19, 2020 11:11 pm

comprido wrote:
Sat Sep 19, 2020 5:35 am
EvolveWebHosting wrote:
Tue Sep 15, 2020 11:31 pm
reCaptcha should stop a lot of this or you can look into a firewall.
Yeah, I try installing Google reCaptcha but couldn't make it work, then the one you see and still like that, they overpass.
If reCaptcha isn't working for you, you may want to look into a firewall from someone like Astra, Sucuri, etc. We partner with Astra and feel they do a great job. Others may have differing opinions.

Image
Shared Hosting for $12 for the first year. Use the code $12ANNUAL and choose annual term. Free transfers too!
Detailed guide on how to install Opencart


User avatar
Active Member

Posts

Joined
Fri Mar 27, 2015 11:13 pm
Location - Denver, Colorado, USA

Post by johnp » Sun Oct 18, 2020 7:24 am

I use Ninja Firewall. There's a free version which is pretty good but the paid for version is well worth the money IMO.

https://nintechnet.com

Opencart 1.5.6.5/OC Bootstrap Pro/VQMOD 2.6.1 lover, user and geek.
Affordable Service £££ - Opencart Installs, Fixing, Development and Upgrades
Plus Ecommerce, Marketing, Mailing List Management and More
FREE Guidance and Advice at https://www.ecommerce-help.co.uk


User avatar
Active Member

Posts

Joined
Fri Mar 25, 2011 10:25 am
Location - Surrey, UK

Post by IP_CAM » Sun Oct 18, 2020 8:43 am

comprido wrote:
Mon Sep 14, 2020 3:07 am
Aditionally you can edit admin/sale/customer.php and add these lines to the public function deleteCustomer($customer_id)
admin/sale/customer.php
should be ;)
admin/model/sale/customer.php
I assume ...

Please don't send me OC Forum Personal Messages, just contact: jti@jacob.ch
---
OC 1.5.6.5 LIGHT Test Site: http://www.bigmax.ch/shop/
OC 1.5.6.5 V-PRO Test Site: http://www.openshop.li/shop/
My Github OC Site: https://github.com/IP-CAM
2'600+ FREE OC Extensions on the World's largest Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 7 guests