My Checkout Without Account Mod

[JTheed]

JTheed, not to be disrespectful, but DUH.
My point is that - from my clean backup - I've cut/pasted the codes as instructed five times now, each time with the same result.
I've left the site as-is right now, hoping that someone can tell me 1) if I did make a major mistake (and how to start looking for the problem), or 2) if the coding won't work with a fresh 1.3.9d install.

Well DUH lol, you may have left your sight as is, but did you leave a link to it ? Did you look at the log files?

I'll let CraftZombie answer your override question as this is her update to the mod. If you want to try mine (Because you say you are using a Clean 139 install) , just click on the MY MODS Site in my Signature ( of the Zen Cart files section here). You can even see the COWOA work there.

[PlayscaleMinis]

Thanks JTheed, I'll take a closer look after work (the day job, that is...)
Whoops, it hadn't occurred to me to find and read a log. Is it in the admin? I've never done this kind of programming before - I'm an HTML/graphics kind of gal.
The URL (not linked, I admit) was in the first post - playscaleminis.biz
Cheers,
Janean

[JTheed]

Thanks JTheed, I'll take a closer look after work (the day job, that is...)
Whoops, it hadn't occurred to me to find and read a log. Is it in the admin? I've never done this kind of programming before - I'm an HTML/graphics kind of gal.
The URL (not linked, I admit) was in the first post - playscaleminis.biz
Cheers,
Janean

Not to worry, this is how I learned/am learning it. The log files are stored in your cache folder. There are session and sql statements in there, look for the ones ending in .log.

[PlayscaleMinis]

Hi JTheed, your mod seems to be working for me for a clean 1.3.9 install. BUT PLEASE add to your install file a Step 7 - Turn the bleepin' thing ON in admin>config. I went through all sorts of mental gymnastics until I noticed COWOA added to that menu!!!!
Still building...
Janean

[PlayscaleMinis]

I take back the part about it working... I've got an endless loop. After filling out Billing Information, instead of continuing to Delivery Information, it loops back to the index.php?main_page=login page.

[JTheed]

I take back the part about it working... I've got an endless loop. After filling out Billing Information, instead of continuing to Delivery Information, it loops back to the index.php?main_page=login page.

Please go to this thread.
http://www.zen-cart.com/forum/showth...573#post899573

[sophia8]

Hi, I'm a web designer, and last month a client asked me to convert her site to Zencart. Never had any experience with ZC, so the last two weeks have been a big learning curve. However, I'm now on top of it, develoiped a custom template and nearly got it ready.
My client didn't want customers to log in, so I was delighted when I found the COWOA mod. But my install appears to have a bug during the checkout. When you fill in the billing information, then click through to Step 2, it takes you to the default template, with the default stylesheet. And you stay within the default template until you log out.
Obviously I can solve this by overwriting the default template stylesheet with my custom CSS. But that seems very awkward - aren't you supposed to leave the default template files untouched? And why should the link direct to the default template folder anyway?

I've checked to make sure that all the YOUR_TEMPLATE files are in my custom folder. And I've read through most of this thread, but I can't seem to find anything that would help me.
Also I'd like to know how you can stop forcing COWOA customers to log off.

[damiantaylor]

Thank you for this mod, it is working really well for me.
I have found one slight problem though.....

If a customer checks out without an account, then later signs up for a full account, you have two accounts with the same email address.
If I then send a gift certificate from admin, the customer gets 2 gift certificates with 2 different redemption codes!
You may be asking yourself why am I sending gift certificates? Well, I have a competition running where the prize is £30 of gift certificates.

I'm not sure if any emails that get sent from admin have this same problem but I'm guessing they would.

Has anyone come across this before and found a fix?

[damiantaylor]

I think I've fixed the duplicate email address/duplicate email send bug.
Zen Cart doesn't usually allow more than one account to have the same email address so I needed to limit the number of emails sent to 1 if a specific email address was selected.
The duplicate emails can get costly when sending Gift Certificates from Admin

In file includes/functions/audience.php, I have changed function get_audience_sql_query to:

  function get_audience_sql_query($selected_entry, $query_category='email') {
    // This is used to take the query_name selected in the drop-down menu or singular customer email address and
  // generate the SQL Select query to be used to build the list of email addresses to be sent to
  // it only returns a query name and query string (SQL SELECT statement)
  // the query string is then used in a $db->Execute() command for later parsing and emailing.
  global $db;
  $query_name='';
  $queries_list = $db->Execute("select query_name, query_string from " . TABLE_QUERY_BUILDER . " " .
                 "where query_category like '%" . $query_category . "%'");
//                 "where query_category = '" . $query_category . "'");

  while (!$queries_list->EOF) {
      if ($selected_entry == $queries_list->fields['query_name']) {
      $query_name   = $queries_list->fields['query_name'];
        $query_string = parsed_query_string($queries_list->fields['query_string']);
//echo 'GET_AUD_EM_ADDR_QRY:<br />query_name='.$query_name.'<br />query_string='.$query_string;
      }
    $queries_list->MoveNext();
  }
  //if no match found against queries listed in database, then $selected_entry must be an email address
  if ($query_name=='' && $query_category=='email') {
        $cust_email_address = zen_db_prepare_input($selected_entry);
        $query_name   = $cust_email_address;
        $query_string = "select customers_firstname, customers_lastname, customers_email_address
                              from " . TABLE_CUSTOMERS . "
                              where customers_email_address = '" . zen_db_input($cust_email_address) . "' limit 1";
    }
  //send back a 1-row array containing the query_name and the SQL query_string
  return array('query_name'=>$query_name, 'query_string'=>$query_string);
}

All I added was the 'limit 1' code in red.
If an expert can take a look and let me know if my change will mess something else up I'd really appreciate it.
Otherwise, if all is ok (it looks good in my testing) and anyone else is facing the same duplicate email issues, the above should fix it.

[JTheed]

I think I've fixed the duplicate email address/duplicate email send bug.
Zen Cart doesn't usually allow more than one account to have the same email address so I needed to limit the number of emails sent to 1 if a specific email address was selected.
The duplicate emails can get costly when sending Gift Certificates from Admin

In file includes/functions/audience.php, I have changed function get_audience_sql_query to:

  function get_audience_sql_query($selected_entry, $query_category='email') {
    // This is used to take the query_name selected in the drop-down menu or singular customer email address and
  // generate the SQL Select query to be used to build the list of email addresses to be sent to
  // it only returns a query name and query string (SQL SELECT statement)
  // the query string is then used in a $db->Execute() command for later parsing and emailing.
  global $db;
  $query_name='';
  $queries_list = $db->Execute("select query_name, query_string from " . TABLE_QUERY_BUILDER . " " .
                 "where query_category like '%" . $query_category . "%'");
//                 "where query_category = '" . $query_category . "'");

  while (!$queries_list->EOF) {
      if ($selected_entry == $queries_list->fields['query_name']) {
      $query_name   = $queries_list->fields['query_name'];
        $query_string = parsed_query_string($queries_list->fields['query_string']);
//echo 'GET_AUD_EM_ADDR_QRY:<br />query_name='.$query_name.'<br />query_string='.$query_string;
      }
    $queries_list->MoveNext();
  }
  //if no match found against queries listed in database, then $selected_entry must be an email address
  if ($query_name=='' && $query_category=='email') {
        $cust_email_address = zen_db_prepare_input($selected_entry);
        $query_name   = $cust_email_address;
        $query_string = "select customers_firstname, customers_lastname, customers_email_address
                              from " . TABLE_CUSTOMERS . "
                              where customers_email_address = '" . zen_db_input($cust_email_address) . "' limit 1";
    }
  //send back a 1-row array containing the query_name and the SQL query_string
  return array('query_name'=>$query_name, 'query_string'=>$query_string);
}

All I added was the 'limit 1' code in red.
If an expert can take a look and let me know if my change will mess something else up I'd really appreciate it.
Otherwise, if all is ok (it looks good in my testing) and anyone else is facing the same duplicate email issues, the above should fix it.

Change the query line to this:

        $query_string = "select customers_firstname, customers_lastname, customers_email_address
 from " . TABLE_CUSTOMERS . "
 where customers_email_address = '" .     zen_db_input($cust_email_address) . "'  
  and COWOA_account == '0'";

This way the accounts that used COWOA will not be included.