Jump to content

Malvarlin

Member
  • Content Count

    6
  • Joined

  • Last visited

Community Reputation

0 Neutral
  1. OK so I exported all the customer data from my live store and imported it to the test database then ran the query below and it works DELETE FROM `CubeCart_customer` WHERE `first_name`=`last_name` and `order_count`=0 and CUSTOMER_ID NOT IN (SELECT CUSTOMER_ID FROM CubeCart_addressbook)
  2. I will give it a spin on my test store over the weekend and see what happens!
  3. As well as implementing the file mentioned above can anyone see any issues with using the following select statement to delete existing customers created by the hacker? SELECT * FROM `CubeCart_customer` WHERE `first_name`=`last_name` and `order_count`=0 and CUSTOMER_ID NOT IN (SELECT CUSTOMER_ID FROM CubeCart_addressbook) the above should show what will be deleted and should only get accounts with matching first and last name, no orders and no address's registered once happy with that i intend to run as a delete statement.
  4. Thanks for the reply. Can you recommend any replacement for these or at least the vertical menu?
  5. Can anyone confirm if the below SemperFi plugins still work with v 6.4.2 please, before I upgrade? Custom Foundation 5 v3.5 Site News with comments v7.1 Vertical Navigation Box v10.1 many thanks Paul
  6. Did you manage to resolve this at all? I have the same plugin but now SemperFi have disappeared I want to replace it.
×
×
  • Create New...