Delete Spam Customers allows you to bulk delete customer accounts created by
bad guys. It cleans out all database records for the bad account.
It's available here: https://www.zen-cart.com/downloads.php?do=file&id=2253
Printable View
Delete Spam Customers allows you to bulk delete customer accounts created by
bad guys. It cleans out all database records for the bad account.
It's available here: https://www.zen-cart.com/downloads.php?do=file&id=2253
I think you should state that you mean customers whose name starts with http. Not all create account spams use that.
You can adjust the query as needed to capture the pattern used by the bad guys.
And the current query is not "starts with http" - rather, it's "contains http".
gads, how ocd are you :) You are right. I do try to be specific but... Was just thinking about someone who ran across the plugin who might think it works for other spam customers as well. They use it and will complain that it doesn't work.
Thanks for this useful plugin - so how can we make this work for the myriad (50/day plus) of fake customers formatted along the lines of the examples below - cheers;
first name: KocXreTJRvjk
surname: FLIgRmQvaVdJ
and
first name: Holographicmoy
surname: zvusalmeomfnxzpGP ..... this one is very common with the GP on the end
You might need to just use a date range or a customer id range.
Be careful ... the reason I created the mod is that it's hard to delete from the DB without leaving straggling parts of a spam ID. Refer to the code to see all the tables touched.
you might have to do this 3 or 4 times (set the range, upload, run the file, set the range, upload, run the file ...) but at least you know the bad ones will be cleaned out properly.
Also as another suggestion, take a look at ZenNonCaptcha. It has really cut down on spam for my clients that are using it.
https://www.zen-cart.com/downloads.php?do=file&id=2207