Page 2 of 86 FirstFirst 12341252 ... LastLast
Results 11 to 20 of 853
  1. #11
    Join Date
    Jul 2011
    Location
    Glasgow, Scotland
    Posts
    113
    Plugin Contributions
    1

    Default Re: COWOA Updated and Combined for ZC v1.5.x

    Quote Originally Posted by countrycharm View Post
    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 [email protected]_group_id before I changed it manually.

    Thanks again, it is always good to learn.

  2. #12
    Join Date
    Jul 2007
    Posts
    2,169
    Plugin Contributions
    16

    Default Re: COWOA Updated and Combined for ZC v1.5.x

    Quote Originally Posted by BillyBoyle View Post
    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 [email protected]_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.
    Is your site Upgraded to the current version 1.5.4 Yet?
    zencart-upgrades-website-installation

  3. #13
    Join Date
    Jul 2011
    Location
    Glasgow, Scotland
    Posts
    113
    Plugin Contributions
    1

    Default Re: COWOA Updated and Combined for ZC v1.5.x

    @ 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.

  4. #14
    Join Date
    Jan 2012
    Posts
    48
    Plugin Contributions
    0

    Default Re: COWOA Updated and Combined for ZC v1.5.x

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

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

  5. #15
    Join Date
    Jul 2007
    Posts
    2,169
    Plugin Contributions
    16

    Default Re: COWOA Updated and Combined for ZC v1.5.x

    Quote Originally Posted by boomup View Post
    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.
    Is your site Upgraded to the current version 1.5.4 Yet?
    zencart-upgrades-website-installation

  6. #16
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: COWOA Updated and Combined for ZC v1.5.x

    I had issues with the install SQL and made some modifications which resolved the issues..
    This line:
    Code:
    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
    Code:
    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..
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  7. #17
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: COWOA Updated and Combined for ZC v1.5.x

    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

    Code:
    <?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>'; 
      }
    } 
    ?>
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  8. #18
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: COWOA Updated and Combined for ZC v1.5.x

    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??
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  9. #19
    Join Date
    Jan 2007
    Location
    Los Angeles, California, United States
    Posts
    10,023
    Plugin Contributions
    32

    Default Re: COWOA Updated and Combined for ZC v1.5.x

    Quote Originally Posted by DivaVocals View Post
    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
    My Site - Zen Cart & WordPress integration specialist
    I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

  10. #20
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,271
    Plugin Contributions
    78

    Default Re: COWOA Updated and Combined for ZC v1.5.x

    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.

 

 
Page 2 of 86 FirstFirst 12341252 ... LastLast

Similar Threads

  1. v139c COWOA Module (my update for ZC v1.3.x)
    By JTheed in forum All Other Contributions/Addons
    Replies: 398
    Last Post: 29 Oct 2014, 02:35 PM
  2. Installed FEC before COWOA, now COWOA config menu doesn't appear
    By i-make-robots in forum Addon Payment Modules
    Replies: 8
    Last Post: 12 Jan 2014, 01:34 PM
  3. v151 How to install COWOA (for ZC v1.5.x)
    By edgemeister in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 4 Apr 2013, 05:21 PM
  4. v151 Which COWOA Plugin? Fast and Easy or original COWOA ?
    By damon in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 8 Nov 2012, 03:44 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR