COWOA (for ZC v1.5.x)

[BillyBoyle]

If you open up a fresh zen cart v1.5.0 admin orders.php file you will see the code is right.

I was just going by the main html_header.php file. was just wondering that's all, linking it to the other issue and badarac pointing out that the orders.php looked like it was a modified 1.3.9h file.
As stated just a learner and trying to learn.

Can I ask another question
When I was running the sql update it threw up a couple of errors: 1 of them probably cause I already have Fast and Easy installed (duplicate column names)
The other was related to the CONCAT('gID=',@configuration_group_id) copied direct from the sql file in the zencart 1.5 mods at the bottom of the file.
phpmyadmin returned an error stating page_params could not be NULL. And on looking in to my admin area COWOA config was 1, sitting in the wrong place on the menu and 2. had not settings with in the page. I had to manually set the gID= (in my case to 42) and all was good with the configuration menu showing in the correct place and now with the setting showing up.

I as I not knowledgeable in sql, as well as php. Finding answers and solutions takes me hours.
My question is, was it something I did or could this also need looked at for the next release?
The page_params for the menu location was gID=@configuration_group_id before I changed it manually.

Thanks again, it is always good to learn.

[countrycharm]

I was just going by the main html_header.php file. was just wondering that's all, linking it to the other issue and badarac pointing out that the orders.php looked like it was a modified 1.3.9h file.
As stated just a learner and trying to learn.

Can I ask another question
When I was running the sql update it threw up a couple of errors: 1 of them probably cause I already have Fast and Easy installed (duplicate column names)
The other was related to the CONCAT('gID=',@configuration_group_id) copied direct from the sql file in the zencart 1.5 mods at the bottom of the file.
phpmyadmin returned an error stating page_params could not be NULL. And on looking in to my admin area COWOA config was 1, sitting in the wrong place on the menu and 2. had not settings with in the page. I had to manually set the gID= (in my case to 42) and all was good with the configuration menu showing in the correct place and now with the setting showing up.

I as I not knowledgeable in sql, as well as php. Finding answers and solutions takes me hours.
My question is, was it something I did or could this also need looked at for the next release?
The page_params for the menu location was gID=@configuration_group_id before I changed it manually.

Thanks again, it is always good to learn.

I was just going by the main html_header.php file. was just wondering that's all, linking it to the other issue and badarac pointing out that the orders.php looked like it was a modified 1.3.9h file.
As stated just a learner and trying to learn.

I wasn't trying to be rude toward you. Sorry if you took it the wrong way.

It's probably because you have Fast and Easy checkout installed too. I would imagine installing both will cause conflict with each other since Fast and Easy checkout has COWOA already. Why would you want to install COWOA and Fast and Easy checkout together in the first place. That doesn't make a whole lot of sense to me.
I'm not trying to be rude toward you, I'm just trying to see why you would want both installed at the same time.

[BillyBoyle]

@ countrycharm (I wasn't trying to be rude toward you. Sorry if you took it the wrong way.) absolutely no offence taken my friend. We all have the same gaol here I think. To live, to learn, to make the best god damn sites possible, and make a few bucks.

FEC abd COWOA together is wrong ??
Ah! that explains why my site went all funky...

Not following my own advice yet again. I could not see the benefits of FEC right away and miss read the install on the OP's site. (no offence, but not as well laid out as here.)

Anyway not running them together now. Took a couple of hours to put it on and about 2 days to remove it fix all the errors I had made and re-do backup. f*!&^ing good learning experience, will not be doing it again anytime soon.

It's all good anyways.

[boomup]

SQL error, WARNING: An Error occurred, please refresh the page and try again.

BTW, I installed FEC, and so how to fix it?

[countrycharm]

SQL error, WARNING: An Error occurred, please refresh the page and try again.

BTW, I installed FEC, and so how to fix it?

BillyBoyle had the same issue when he had Fast and Easy checkout installed and then trying to install COWOA together. The error you are getting It's probably because you have both installed. I would imagine installing both will cause conflict with each other since Fast and Easy checkout has COWOA already. Why would you want to install COWOA and Fast and Easy checkout together when both has COWOA. That doesn't make a whole lot of sense.

[DivaVocals]

I had issues with the install SQL and made some modifications which resolved the issues..
This line:

SET @configuration_group_id=0;

has been identified as problematic and should not included in the install SQL file. (http://www.zen-cart.com/showthread.p...es-please-note!)

I found a few other minor issues as well and re-worked the install SQL to get everything inline.. Wanted to share with the community..

Here's my modified install SQL file

ALTER TABLE customers ADD COWOA_account tinyint(1) NOT NULL default 0;
ALTER TABLE orders ADD COWOA_order tinyint(1) NOT NULL default 0;
INSERT INTO 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');
#
SELECT @t4:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'COWOA';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group VALUES ('', 'COWOA', 'Set Checkout Without an Account', '100', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SELECT @t4:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'COWOA';


INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES 
(NULL, 'COWOA', 'COWOA_STATUS', 'false', 'Activate COWOA Checkout? <br />Set to True to allow a customer to checkout without an account.', @t4, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Enable Order Status', 'COWOA_ORDER_STATUS', 'false', 'Enable The Order Status Function of COWOA?<br />Set to True so that a Customer that uses COWOA will receive an E-Mail with instructions on how to view the status of their order.', @t4, 11, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Enable E-Mail Only', 'COWOA_EMAIL_ONLY', 'false', 'Enable The E-Mail Order Function of COWOA?<br />Set to True so that a Customer that uses COWOA will only need to enter their E-Mail Address upon checkout if their Cart Balance is 0 (Free).', @t4, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Enable Forced Logoff', 'COWOA_LOGOFF', 'false', 'Enable The Forced LogOff Function of COWOA?<br />Set to True so that a Customer that uses COWOA will be logged off automatically after a sucessfull checkout. If they are getting a file download, then they will have to wait for the Status E-Mail to arrive in order to download the file.', @t4, 13, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');

UPDATE configuration SET configuration_value = 'True' WHERE configuration_title = 'Use split-login page';

/*
-- REGISTER COWOA ADMIN PAGES
*/
INSERT INTO admin_pages
VALUES ('configCOWOA','BOX_CONFIGURATION_COWOA','FILENAME_CONFIGURATION',CONCAT('gID=',@t4), 'configuration', 'Y', @t4);

Maybe when I've got a TON of free time I'll think about trying to create an auto-intaller for this add-on..

[DivaVocals]

Working on merging the COWOA orders.php file with the one for Super Orders, and discovered that there is an entire chunk of code which doesn't seem to belong to COWOA or for that matter to do anything at all.. Lines 663 - 714

<?php
  if (MODULE_ORDER_TOTAL_DOUBLEBOX_STATUS == 'true') {
    $orders_doublebox = $db->Execute("select orders_products_id  
                                    from " . TABLE_ORDERS_DOUBLEBOX . "  
                                    where orders_id = '" . zen_db_input($oID) . "' and wrap = 1");  

  if ($orders_doublebox->RecordCount() > 0) {
?>
      <tr>
        <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
      </tr>
      <tr>
        <td class="main"><table border="1" cellspacing="0" cellpadding="5">
          <tr>
            <td class="smallText" align="center"><strong><?php echo DOUBLEBOX_SUMMARY_HEADING; ?></strong></td>
          </tr>
<?php
       while (!$orders_doublebox->EOF) {
          $pos = -1;
          for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
              if ($order->products[$i]['orders_products_id'] == 
                  $orders_doublebox->fields['orders_products_id']) {
                  $pos = $i; 
                  break;
              }
          }
          $orders_doublebox->MoveNext();
          if ($pos == -1) {
             continue; // Should never happen
          }
          $i = $pos; 
          echo '<tr>';
          echo '<td class="accountProductDisplay">' . $order->products[$i]['name'];
          if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {
               echo '<br><nobr><small>';
               for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {
                       echo '&nbsp;&nbsp;- ' . $order->products[$i]['attributes'][$j]['option'] . ": " . nl2br(zen_output_string_protected($order->products[$i]['attributes'][$j]['value'])) . '<br>';
                    }
               echo '</small></nobr>';
          }
          echo '</td>'; 
          echo '</tr>'; 
       }
?>
        </table></td>
      </tr>
<?php
  } else { 
    echo '<tr><td>'. DOUBLEBOX_NO_TEXT . '</td></tr>'; 
  }
} 
?>

[DivaVocals]

Now I'm testing COWOA, and have a question.. There's an admin option to allow customers who COWOA to view their order status:

Enable The Order Status Function of COWOA?
Set to True so that a Customer that uses COWOA will receive an E-Mail with instructions on how to view the status of their order.

Clicking the link the customer receives takes me to the login page. How do I fix this so that customers checking our without an account can view their order status??

[DivaVocals]

Now I'm testing COWOA, and have a question.. There's an admin option to allow customers who COWOA to view their order status:


Clicking the link the customer receives takes me to the login page. How do I fix this so that customers checking our without an account can view their order status??

Edited to add:
This is the customer order status URL

Detailed Invoice: http : //clientlaserdiscvault(dot)overthehillweb(dot)com/index.php?main_page=account_history_info&order_id=20655

[lat9]

In one of the COWOA plugins, there was an order_status page that did not require the user to log in to view their status. The page required the user to enter the email address associated with the order and the order-number to gain access to the information.