

Malvarlin
Member-
Content Count
6 -
Joined
-
Last visited
Community Reputation
0 Neutral-
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)
-
I will give it a spin on my test store over the weekend and see what happens!
-
Malvarlin started following SemperFi Plugins and Fake Customer Registrations & spam
-
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.
-
Thanks for the reply. Can you recommend any replacement for these or at least the vertical menu?
-
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
-
Malvarlin joined the community
-
Did you manage to resolve this at all? I have the same plugin but now SemperFi have disappeared I want to replace it.