kamelion0927:
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
$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
$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
if ($check_cust_email->fields['total'] > 0) {
>
> to
>
> ```php
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.
I found a hole in my logic.
First,
if (($check_cust_email->fields['total'] > 0) && ($check_cust_COWOA == 'false')){
should actually be
if (($check_cust_email->fields['total'] > 0) && ($check_cust_COWOA->fields['total'] == 0)){
but even if this field is changed, it will let any subscription go through.
I created an account, placed an order and when I sign up for a newsletter subscription, it will still go through even though I specified (I thought) it shouldn't in the code.
Oh well. It isn't a huge deal, but now it's personal. If someone with coding knowledge has time, I would love to know why a subscription request is going through when it shouldn't (i.e. what I'm doing wrong in the code).
