My Checkout Without Account Mod

Web host was finally able to help by amending the sql query as follows:

This is what needed to be run:
ALTER TABLE zen_customers ADD COWOA_account tinyint(1) NOT NULL default 0;
ALTER TABLE zen_orders ADD COWOA_order tinyint(1) NOT NULL default 0;
INSERT INTO zen_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');

Just basically adding zen_ in front of the table names.

Seems to be working fine.

Quote:

---

Originally Posted by bhensarl

Okay, so now I've got it working but to get it to work I've had to delete some of the code. Here's what I did. The install said:

Code:

---

/includes/templates/YOUR_TEMPLATE/templates/tpl_checkout_payment_default.php
====================================================================

FIND:
-

<?php
      }
      for ($j=0, $n2=sizeof($selection[$i]['fields']); $j<$n2; $j++) {
?>

<fieldset>

<legend><?php echo $selection[$i]['module']; ?></legend>

<?php echo $selection[$i]['redeem_instructions']; ?>

<div class="gvBal larger"><?php echo $selection[$i]['checkbox']; ?></div>

<label class="inputLabel"<?php echo ($selection[$i]['fields'][$j]['tag']) ? '

for="'.$selection[$i]['fields'][$j]['tag'].'"': ''; ?>><?php echo

$selection[$i]['fields'][$j]['title']; ?></label>

<?php echo $selection[$i]['fields'][$j]['field']; ?>

</fieldset>

<?php
      }
    }
?>

-

REPLACE WITH:
-

<?php
      }
      for ($j=0, $n2=sizeof($selection[$i]['fields']); $j<$n2; $j++) {
?>
<?php if(!($COWOA && $selection[$i]['module']==MODULE_ORDER_TOTAL_GV_TITLE)) {?>
<fieldset>
<legend><?php echo $selection[$i]['module']; ?></legend>
<?php echo $selection[$i]['redeem_instructions']; ?>
  <div class="gvBal larger"><?php echo $selection[$i]['checkbox']; ?></div>
  <label class="inputLabel"<?php echo ($selection[$i]['fields'][$j]['tag']) ? '
for="'.$selection[$i]['fields'][$j]['tag'].'"': ''; ?>><?php echo
$selection[$i]['fields'][$j]['title']; ?></label>

  <?php echo $selection[$i]['fields'][$j]['field']; ?>

  </fieldset>

  <?php } ?>
<?php
      }
    }
?>

-

---

I did not update the original code with the COWOA code. Each time I upload tpl_checkout_payment_default.php with the updated code, then attempt to purchase on the site, my purchase process stalls on the "...page=checkout_payment" page. The header displays normally, but the body of the page is blank. I suspect this is an error in the php, but I don't know where to go to fix it. My two questions are these:
1. What is the error in the php that causes the stop?, and
2. What am I losing by not having that bit of code in there.

Thanks in advance!
Brian

---

Just wondering if anybody found a fix to this problem b/c I'm seeing the same thing. I'm pretty obvious it's a php code problem but as Brian said, not sure where to look for this php error.

I've been to the link to download the plugin http://www.4shared.com/file/13859094...OWOA_138_.html but it says

Quote:

---

The file link that you requested is not valid

---

.

Has anyone got a copy of the zip file with all contents, including any installation instructions? Or is there a new location for downloading the plugin?

Thanks

Sorry, I wasn't aware that they require me to log in at least once a month in order to keep my files up. The new link is http://www.4shared.com/file/NPILagFC...OWOA_138_.html

Does anyone know how to override the admin/includes/classes/order.php when using the new 1.3.9 file? It looks like some items are not there anymore.

I'm in the process of configuring a 1.3.9 test cart so that I can see about upgrading the COWOA mod. I'll let everyone know if I'm successful. Cross your fingers! :smile:

We all wait with bated breath to hear how it goes!! Good luck. :thumbsup:

Hi all,

Im using Integrated COWOA 1.3.8

When i select a downloadable product

address field should be hidden in no_account page.

Any one there can help me pls??????? :wacko: :wacko:

I'm installing the COWOA add-on but I get an error when running the SQL code from the admin interface.

GETTING THE FOLLOWING ERROR WHEN EXECUTING THE COWOA.sql file:

1062 Duplicate entry 'Permanent Account Holders Only' for key 2
in:
[INSERT INTO zen_query_builder ( query_id , query_category , query_name , query_description , query_string ) VALUES ( '', 'email,newsletters', 'Permanent Account Holders Only', 'Send email only to permanent account holders ', 'select customers_email_address, customers_firstname, customers_lastname from TABLE_CUSTOMERS where COWOA_account != 1 order by customers_lastname, customers_firstname, customers_email_address');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Anyone run into this problem at all? If so, what was the solution?

Thanks!

Has anyone got this to work in 1.3.9b?

I am currently working on a new version of our website and would really like to add this - I have COWA on another site and it works really well but I want to upgrade my main site to 1.3.9.

Should I wait for an upgraded version of the mod? Any news on that?

cheers
Leah