X-Cart Snippets. More snippets will follow soon...
X-Cart Delete Duplicate User Accounts
If your authentication mode is currently set to 'Username' and you wish to change to 'Email', you may be prevented, due to you having user accounts that share the same email address.
Deleting them manually can be a pain, especially if there are lots of them, but these SQL patches will delete duplicate accounts in one go!