Quote Originally Posted by horsetags View Post
I have 1.3.9e and Integrated Cowoa (JTheed version) and working great except for the old problem of a customer buying with COWOA and then buying again and trying to register and Zen telling customer that they already have this email address.

I have tried to look through the threads, but can't find anything.

Any help would be great

Tia

Paul
If you had posted this in my thread for my version of COWOA
(http://www.zen-cart.com/forum/showthread.php?t=156174) you would have gotten an answer quicker. Anyway, here is the fix for that.

In /includes/modules/create_account.php look for this line around line 134:
Code:
     $check_email_query = "select count(*) as total
                            from " . TABLE_CUSTOMERS . "
                            where customers_email_address = '" . zen_db_input($email_address) . "'";
Change it to read like this (the and line is added)
Code:
    $check_email_query = "select count(*) as total
                            from " . TABLE_CUSTOMERS . "
                            where customers_email_address = '" . zen_db_input($email_address) . "'
                            and COWOA_account != 1";
This way when it searches thru the e-mails, if the record belongs to a COWOA customer, it gets skipped.