Page 3 of 3 FirstFirst 123
Results 21 to 28 of 28
  1. #21
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,453
    Plugin Contributions
    1

    Default Re: Delete Spam Customers

    Quote Originally Posted by swguy View Post
    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
    Last edited by shags38; 4 Sep 2019 at 02:01 AM.

  2. #22
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,077
    Plugin Contributions
    267

    Default Re: Delete Spam Customers

    Much appreciated.

    Are the dates in that query appropriate for the bad customers in your database?
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  3. #23
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,453
    Plugin Contributions
    1

    Default Re: Delete Spam Customers

    Quote Originally Posted by swguy View Post
    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

  4. #24
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,077
    Plugin Contributions
    267

    Default Re: Delete Spam Customers

    Build a query that works for you in phpMyAdmin. Then use it in the script.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  5. #25
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,453
    Plugin Contributions
    1

    Default Re: Delete Spam Customers

    Quote Originally Posted by swguy View Post
    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

  6. #26
    Join Date
    May 2006
    Location
    Montana
    Posts
    262
    Plugin Contributions
    20

    Default Re: Delete Spam Customers

    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

  7. #27
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,077
    Plugin Contributions
    267

    Default Re: Delete Spam Customers

    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.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  8. #28
    Join Date
    May 2006
    Location
    Montana
    Posts
    262
    Plugin Contributions
    20

    Default Re: Delete Spam Customers

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


    Quote Originally Posted by stellarweb View Post
    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

 

 
Page 3 of 3 FirstFirst 123

Similar Threads

  1. v155 Spam - fake customers
    By ma.r.a in forum General Questions
    Replies: 32
    Last Post: 4 Nov 2019, 10:15 PM
  2. v150 Spam Review Messages - 5000+ how to delete?
    By creamcrackers in forum General Questions
    Replies: 5
    Last Post: 24 Apr 2012, 04:55 PM
  3. All customers fields in ADMIN > CUSTOMERS are empty and I can't delete them!
    By plgaudreau in forum Managing Customers and Orders
    Replies: 1
    Last Post: 26 Feb 2008, 02:08 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR