Delete Spam Customers

11 Jun 2019, 12:01

#1

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Delete Spam Customers

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

11 Jun 2019, 13:34

#2

delia

Totally Zenned

Join Date:: May 2006
Posts:: 2,383
Plugin Contributions:: 5

Re: Delete Spam Customers

I think you should state that you mean customers whose name starts with http. Not all create account spams use that.

11 Jun 2019, 13:43

#3

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Delete Spam Customers

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".

11 Jun 2019, 13:48

#4

delia

Totally Zenned

Join Date:: May 2006
Posts:: 2,383
Plugin Contributions:: 5

Re: Delete Spam Customers

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.

16 Aug 2019, 03:24

#5

shags38

Totally Zenned

Join Date:: Jan 2011
Posts:: 1,684
Plugin Contributions:: 0

Re: Delete Spam Customers

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

16 Aug 2019, 09:07

#6

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Delete Spam Customers

You might need to just use a date range or a customer id range.

16 Aug 2019, 09:28

#7

shags38

Totally Zenned

Join Date:: Jan 2011
Posts:: 1,684
Plugin Contributions:: 0

Re: Delete Spam Customers

swguy:
You might need to just use a date range or a customer id range.

it may be easier for me to delete directly from the db :)
have just installed Access Blocker by lat9 so between the two hopefully it will catch the majority.
(this plugin works brilliantly 'as is' for for the https)
cheers,
Mike

16 Aug 2019, 09:36

#8

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Delete Spam Customers

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.

16 Aug 2019, 23:06

#9

shags38

Totally Zenned

Join Date:: Jan 2011
Posts:: 1,684
Plugin Contributions:: 0

Re: Delete Spam Customers

swguy:
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.

Thanks for the advice Scott - the problem with setting a date range or customer i.d. range is that the spam accounts are mixed sporadically in with real accounts, or am I looking at it the wrong way?

17 Aug 2019, 00:17

#10

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Delete Spam Customers

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

20 Aug 2019, 01:05

#11

shags38

Totally Zenned

Join Date:: Jan 2011
Posts:: 1,684
Plugin Contributions:: 0

Re: Delete Spam Customers

swguy:
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

Thanks Scott - yes you are right - doing it multiple times will be worth the effort, and I am now using ZenNonCaptcha as well as Access Blocker as well as running your plugin - that should stop most of the intruders :)
So would you be kind enough to show me an example of how to put a date range code in the php file in lieu of or better still, in addition to, the https, such that it will actually work (I did some searches for code examples but there are so many variations)

many thanks, Mike

// Could also be based on date, customer_id, etc. 
$query = $db->Execute("SELECT * FROM " . TABLE_CUSTOMERS . " WHERE customers_firstname LIKE '%http%' OR customers_lastname LIKE '%http%'");

20 Aug 2019, 01:32

#12

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Delete Spam Customers

$query = $db->Execute("SELECT customers_info_id as customers_id FROM " . TABLE_CUSTOMERS_INFO . " WHERE customers_info_date_account_created >= '2018-08-01' and customers_info_date_account_created <= '2018-08-30'"

20 Aug 2019, 06:26

#13

shags38

Totally Zenned

Join Date:: Jan 2011
Posts:: 1,684
Plugin Contributions:: 0

Re: Delete Spam Customers

swguy:
$query = $db->Execute("SELECT customers_info_id as customers_id FROM " . TABLE_CUSTOMERS_INFO . " WHERE customers_info_date_account_created >= '2018-08-01' and customers_info_date_account_created <= '2018-08-30'"

Many thanks Scott - much appreciated!
cheers,
Mike

20 Aug 2019, 07:41

#14

shags38

Totally Zenned

Join Date:: Jan 2011
Posts:: 1,684
Plugin Contributions:: 0

Re: Delete Spam Customers

swguy:
$query = $db->Execute("SELECT customers_info_id as customers_id FROM " . TABLE_CUSTOMERS_INFO . " WHERE customers_info_date_account_created >= '2018-08-01' and customers_info_date_account_created <= '2018-08-30'"

Maybe I am doing something wrong, I cannot get this date range code to work :) - so I deleted the existing original https code and replaced it with this code [with closing );] and simply altered dates to suit a block of spam customers to remove >> saved the file and uploaded it to admin/delete_spam_customers.php >> then selected admin/customers/delete spam customers with the result being 0 customers removed - did this a number of times, once I altered date format to read month/date/year in line with how it shows in admin but that didn't help - so I am stumped.

Any assistance would be appreciated.

cheers,
Mike

03 Sep 2019, 18:52

#15

coins2012

New Zenner

Join Date:: Jan 2012
Posts:: 89
Plugin Contributions:: 0

Re: Delete Spam Customers

shags38:
Maybe I am doing something wrong, I cannot get this date range code to work :) - so I deleted the existing original https code and replaced it with this code [with closing );] and simply altered dates to suit a block of spam customers to remove >> saved the file and uploaded it to admin/delete_spam_customers.php >> then selected admin/customers/delete spam customers with the result being 0 customers removed - did this a number of times, once I altered date format to read month/date/year in line with how it shows in admin but that didn't help - so I am stumped.

Any assistance would be appreciated.

cheers,
Mike

Here is a screen shot of what I have to deal with, this started about 6 months ago, I do have google captcha but not help with these people.

03 Sep 2019, 19:06

#16

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Delete Spam Customers

shags38:
Maybe I am doing something wrong, I cannot get this date range code to work :)

sorry it's really hard to write code on the forum. I missed the end paren. Let's space out the end quote too so it's obvious there's a single and then a double.

$query = $db->Execute("SELECT customers_info_id as customers_id FROM " . TABLE_CUSTOMERS_INFO . " WHERE customers_info_date_account_created >= '2018-08-01' and customers_info_date_account_created <= '2018-08-30' ");

03 Sep 2019, 19:09

#17

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Delete Spam Customers

Coins2012:
Here is a screen shot of what I have to deal with, this started about 6 months ago, I do have google captcha but not help with these people.

You might want to consider some of the blocking mods out there like Cindy's Access Blocker:
https://www.zen-cart.com/downloads.php?do=file&id=2237

04 Sep 2019, 00:33

#18

shags38

Totally Zenned

Join Date:: Jan 2011
Posts:: 1,684
Plugin Contributions:: 0

Re: Delete Spam Customers

swguy:
sorry it's really hard to write code on the forum. I missed the end paren. Let's space out the end quote too so it's obvious there's a single and then a double.

$query = $db->Execute("SELECT customers_info_id as customers_id FROM " . TABLE_CUSTOMERS_INFO . " WHERE customers_info_date_account_created >= '2018-08-01' and customers_info_date_account_created <= '2018-08-30' ");

many thanks for your response Scott - no joy I'm afraid - guess I will have to do it via the db or in admin (one at a time).

cheers,
Mike

04 Sep 2019, 00:43

#19

shags38

Totally Zenned

Join Date:: Jan 2011
Posts:: 1,684
Plugin Contributions:: 0

Re: Delete Spam Customers

Coins2012:
Here is a screen shot of what I have to deal with, this started about 6 months ago, I do have google captcha but not help with these people.

These types of fake customers are what I and many others have an issue with also. I have installed this plugin, as swguy suggested to you

You might want to consider some of the blocking mods out there like Cindy's Access Blocker:
https://www.zen-cart.com/downloads.php?do=file&id=2237

and it has helped to greatly reduce the number of these getting through - there will be a few here and there that do get through because the plugin relies on using a website that produces lists of known spam ip addresses and as such some ip addresses take a while to make the list - but it works well for me (even without captcha). The issue now is deleting hundreds and hundreds that got through before the plugin mentioned above was developed.

cheers,
Mike

04 Sep 2019, 00:44

#20

swguy

Administrator

Join Date:: Feb 2006
Posts:: 10,620
Plugin Contributions:: 212

Re: Delete Spam Customers

Mike, can you tell me specifically the error you are getting?