I have been trying to get this mod to work with COWOA for the last couple of days and I know that there is documentation about COWOA and this mod having compatibility issues due to the fact that COWOA clients are still entered into the database, but as they function completely separate other than that variable, I figured I could work out a way to make them play nice - and I think I did it.

I just wanted to post what I did here in the hopes that someone who has actual php knowledge would take a look and confirm that it won't cause conflicts in my coding.

What I did was go into the includes/modules/pages/subscribe/header.php and in the "check if email address exists in CUSTOMERS table or in SUBSCRIBERS table" section, I added

PHP Code:
$check_cust_COWOA_query "select count(*) as total from " TABLE_CUSTOMERS .
            
" where COWOA_account = '" zen_db_input($COWOA_account) . "'";
        
$check_cust_COWOA $db->Execute($check_cust_COWOA_query); 
underneath

PHP Code:
$check_cust_email_query "select count(*) as total from " TABLE_CUSTOMERS .
            
" where customers_email_address = '" zen_db_input($email_address) . "'";
        
$check_cust_email $db->Execute($check_cust_email_query); 
and then I changed
PHP Code:
if ($check_cust_email->fields['total'] > 0) { 
to

PHP Code:
if (($check_cust_email->fields['total'] > 0) && ($check_cust_COWOA == 'false')){ 
I followed the same steps in admin/subscription_manager.php.

Then I created a test COWOA order, signed up for a subscription and everything worked perfectly. I got a confirmation email and was able to confirm my subscription even though I had completed a COWOA order with the same email address.

I know that the mindset is that a COWOA client will most likely not want a subscription but after so many years in the customer service field, I wouldn't be surprised if a handful of them do. People can be so weird sometimes.