Delete Spam Customers

[shags38]

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

Hi Scott - no error message, no error logs, simply the screen with;
Delete Spam Customers
Customers removed: 0

revisiting my process - I deleted your existing
$query = $db->Execute("SELECT * FROM " . TABLE_CUSTOMERS . " WHERE customers_firstname LIKE '%http%' OR customers_lastname LIKE '%http%'");

and replaced it with

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

so by chance is the date format correct?

cheers, Mike

P.S. I hope you are not adversely affected by the hurricane

[swguy]

Much appreciated.

Are the dates in that query appropriate for the bad customers in your database?

[shags38]

Much appreciated.

Are the dates in that query appropriate for the bad customers in your database?

Yes the dates are valid - I have actually answered my own question - I was just thinking out aloud wondering if the date format yyyy/mm/dd correlates to how it is in the db? .... in admin/customers the format is dd/mm/yyyy - I have tried using the latter format and still makes no difference so that isn't the problem.

cheers, Mike

[swguy]

Build a query that works for you in phpMyAdmin. Then use it in the script.

[shags38]

Build a query that works for you in phpMyAdmin. Then use it in the script.

Above my pay grade I think Scott - I've never built a query in phpMyAdmin, however I will look into it.

many thanks, Mike

[stellarweb]

Scott, thanks for this mod! I have had to install it on quite a few sites already!

I have encountered a 1.3.9h site that desperately needs this, but obviously the sql statement won't work because there were no "admin_pages" back then. There also is no way to set up the page to show up in admin (oh my how far the dev team has come since then!!). So.... hoping the files will work, but I don't have access to the database to re-write the SQL statement so the link shows up under the customers menu. Can you give me the code that would work with 1.3.9h?

THANKS!
Judy

[swguy]

The old 139 way of doing this was to create a dhtml file that contained the information that's in the admin_pages in more recent versions. If you look at admin/includes/boxes/customers_dhtml.php you will see the structure.

[stellarweb]

I thought about that after I finally got access to the database. Thanks Scott!

Scott, thanks for this mod! I have had to install it on quite a few sites already!

I have encountered a 1.3.9h site that desperately needs this, but obviously the sql statement won't work because there were no "admin_pages" back then. There also is no way to set up the page to show up in admin (oh my how far the dev team has come since then!!). So.... hoping the files will work, but I don't have access to the database to re-write the SQL statement so the link shows up under the customers menu. Can you give me the code that would work with 1.3.9h?

THANKS!
Judy

[thegoodlifestore]

Our spam customers seem to all have @mail.ru in the email address. Is there a way to code this to delete customer with @mail.ru in their email address?

[swguy]

If you read the extended help on my site, there is a FAQ question that answers this.