Jump to content

AlexBen

Members
  • Content count

    1
  • Joined

  • Last visited

Posts posted by AlexBen


  1. Hi from Germany

     

    I have installed Actual Attribute Price v 1.7 and it works fine. My problem is I have products with and without attributes.

    The base price and the prices for products with attributes are shown on the product_info page. But I only want one price (if the product has no attributes only the base price will shown and if the products have attributes the base price will not shown )

    How can I fix the problem?

     

    attribute.png

     

     

    I thing, I have to change/insert the code in the product_info page like this. But I don't know how - my php is not very good.

     

    <?php if ($products_attributes['total'] >0) { <?php echo TEXT_PRODUCT_OPTIONS; ?> ........}

    else {<?php echo TEXT_PRICE; ?><?php echo $products_price; ?> } ?>

     

     

    I use osCommerce 2.2 ms2

    Here my product_info.php (only the lines I thing to change!):

     

             <table border="0" width="100%" cellspacing="0" cellpadding="0">
              <tr>
    		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
    	   </tr>
               <tr>
               <td class="main"><?php echo stripslashes($product_info['products_description']); ?></td>
              </tr>
              <tr>
    		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
    	   </tr>
              <tr>
               <td class="main"><?php echo TEXT_PRICE; ?><?php echo $products_price; ?></td>
              </tr>
              <tr>
    		<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
    	   </tr>
             </table>
    <?php
       $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");
       $products_attributes = tep_db_fetch_array($products_attributes_query);
       if ($products_attributes['total'] > 0) {
    ?>
             <table border="0" cellspacing="0" cellpadding="2">
               <tr>
                 <td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>
               </tr>
    <?php
         $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");
         while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
           $products_options_array = array();
           $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");
           while ($products_options = tep_db_fetch_array($products_options_query)) {
             $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);
             if ($products_options['options_values_price'] != '0') {
               $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';
             }
           }
    
           if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {
             $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];
           } else {
             $selected_attribute = false;
           }
    ?>
               <tr>
                 <td class="main"><?php //echo $products_options_name['products_options_name'] . ':'; ?></td>
                 <td class="main"><?php echo tep_draw_radio_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>
               </tr>
    <?php
         }
    ?>
             </table>
    <?php
       }
    ?>
    
    
    

     

     

    Any ideas are welcome.

     

    thanks

    Andreas

×