Quote:
Originally Posted by mizzlewillz
One question , it has probably been answered before, but how would you check to see if an e-mail address already exists and stop another person from registering an identical e-mail address.
|
Go into phpMyAdmin and set the email field to "Unique" and MySQL will take care of it for you
OR login to X-Cart and use the following MySQL code snippet in the Patch SQL area:
Code:
ALTER TABLE `xcart_orders` ADD UNIQUE (
`email`
);
ALTER TABLE `xcart_customers` ADD UNIQUE (
`email`
);
You may need to add some error catching in include/register.php but atleast noone can register the same email twice.