Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

luca75

Archived
  • Posts

    97
  • Joined

  • Last visited

Posts posted by luca75

  1. Hi, I have the same problem, have u found the solution ?

     

    Another, I don't want display the numers of votes and I don't want display numers of comment, can you help me guys ?

     

    Thank you

     

     

    The solution for who don't want display the numbers of comment and votes in the box is delete or comment this line

     

    $content .= "<tr class=\"pollFooter\"><td class=\"pollBoxText\"><center>" . $sum . " "._VOTES."</center>\n</td><td class=\"pollBoxText\"><center>" . $comments1  . " "._COMMENTS."</center>\n</td></tr>";

     

    in catalog/includes/boxes

  2. Fatal error: Cannot redeclare tep_db_connect() (previously declared in /home/anil/public_html/site/includes/functions/database.php:13) in /home/anil/public_html/site/includes/functions/database.php on line 13

     

    Hi, I have the same problem, have u found the solution ?

     

    Another, I don't want display the numers of votes and I don't want display numers of comment, can you help me guys ?

     

    Thank you

  3. I've installed this contribution and now I would like to put UNDER the product image the name of the images NOT to the left, when I can paste this code ?

     

    <?php echo '<b><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products_array[$i]['id'], 'NONSSL') . '"><u>' . $featured_products_array[$i]['name'] . '</u></a></b>'; ?>

     

     

    This is my file featured_product.php

    <?php
    /* 
     $Id: featured_products.php,v 2.51 2003/10/31 21:00:00 cieto Exp $
     
     cieto Featured Products 2.51 MS2 listing module
     [email protected]
    
    Made for:
     osCommerce, Open Source E-Commerce Solutions 
     http://www.oscommerce.com 
     Copyright (c) 2002 osCommerce 
     Released under the GNU General Public License 
     
    */
    ?>
    <table border="0" width="100%" cellspacing="0" cellpadding="2"> 
    <tr> 
    <?php 
     if (sizeof($featured_products_array) <> '0') { 
      $col = 0; 
       for($i=0; $i<sizeof($featured_products_array); $i++) { 
         if ($featured_products_array[$i]['specials_price']) { 
           $products_price = '<s>' .  $currencies->display_price($featured_products_array[$i]['price'], tep_get_tax_rate($featured_products_array[$i]['tax_class_id'])) . '</s>  <span class="productSpecialPrice">' . $currencies->display_price($featured_products_array[$i]['specials_price'], tep_get_tax_rate($featured_products_array[$i]['tax_class_id'])) . '</span>'; 
         } else { 
           $products_price = $currencies->display_price($featured_products_array[$i]['price'], tep_get_tax_rate($featured_products_array[$i]['tax_class_id'])); 
         } 
      $col++; 
    ?> 
    <td width="50%" valign="top" align="center"> 
    <table border="0" width="100%" cellspacing="0" cellpadding="2"> 
    <tr> 
    <td width="<?php echo SMALL_IMAGE_WIDTH + 10; ?>" rowspan="4" align="center" valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products_array[$i]['id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . $featured_products_array[$i]['image'], $featured_products_array[$i]['name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?></td> 
    <td width="80%" valign="top" class="main"><div align="center">
    
    
    <--<?php echo '<b><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products_array[$i]['id'], 'NONSSL') . '"><u>' . $featured_products_array[$i]['name'] . '</u></a></b>'; ?>-->
    
    
    </div></td> 
    </tr> 
    <tr> 
    <td valign="top" class="main"> 
    
             </td> 
    </tr> 
    <tr> 
    <td valign="top" class="main"></td> 
    </tr> 
    <tr> 
           <td align="center" valign="top" class="main">
            
            	 <br>
             </a>
          
           </td> 
    </tr> 
    </table> 
    </td> 
    <?php 
         if ((($col / FEATURED_PRODUCTS_COLUMNS) == floor($col / FEATURED_PRODUCTS_COLUMNS))) { 
    ?> 
    </tr> 
    <tr> 
    <td colspan="<?php echo FEATURED_PRODUCTS_COLUMNS; ?>" align="center" valign="top" class="main"><hr width="100%" size="1" noshade></td> 
    </tr> 
    <tr> 
     <?php 
     } 
    if (($i+1) != sizeof($featured_products_array)) { 
    ?> 
     <?php 
         } 
       } 
     } 
    ?> 
    </table>

     

     

    thank you

  4. I've installed this contribution http://www.oscommerce.com/community/contri...i+admins+levels

     

    but when I logged in ancd click on administration left panel on Member Groups or Members Access or File Access, I have this error:

     

    Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/domain.com/httpdocs/admin/includes/functions/database.php on line 107
    
    Warning: Cannot modify header information - headers already sent by (output started at /usr/local/psa/home/vhosts/domain.com/httpdocs/admin/includes/functions/database.php:107) in /usr/local/psa/home/vhosts/domain.com/httpdocs/admin/includes/functions/general.php on line 94

     

    please help me

     

    thank you

  5. I have installed this contribution and all patch on my test MS2.2 but when I add a second attribute for one product this is the error:

     

    1062 - Duplicate entry '' for key 1
    
    insert into products_attributes values ('', '28', '1', '1', '', '+','')
    
    [TEP STOP]

     

     

    For example:

     

    I have COLOR: white SIZE: large I add this no problem

    whe I add COLOR: red SIZE: large there is the error

     

     

     

     

    this is my products_attributes.php

    <?php

    /*

     $Id: products_attributes.php,v 1.52 2003/07/10 20:46:01 dgw_ Exp $

     

     osCommerce, Open Source E-Commerce Solutions

     http://www.oscommerce.com

     

     Copyright (c) 2003 osCommerce

     

     Released under the GNU General Public License

    */

     

     require('includes/application_top.php');

     $languages = tep_get_languages();

     

     $action = (isset($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '');

     

     if (tep_not_null($action)) {

       $page_info = '';

       if (isset($HTTP_GET_VARS['option_page'])) $page_info .= 'option_page=' . $HTTP_GET_VARS['option_page'] . '&';

       if (isset($HTTP_GET_VARS['value_page'])) $page_info .= 'value_page=' . $HTTP_GET_VARS['value_page'] . '&';

       if (isset($HTTP_GET_VARS['attribute_page'])) $page_info .= 'attribute_page=' . $HTTP_GET_VARS['attribute_page'] . '&';

       if (tep_not_null($page_info)) {

         $page_info = substr($page_info, 0, -1);

       }

     

       switch ($action) {

         case 'add_product_options':

           $products_options_id = tep_db_prepare_input($HTTP_POST_VARS['products_options_id']);

           $option_name_array = $HTTP_POST_VARS['option_name'];

     

           for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {

             $option_name = tep_db_prepare_input($option_name_array[$languages[$i]['id']]);

     

             tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS . " (products_options_id, products_options_name, language_id) values ('" . (int)$products_options_id . "', '" . tep_db_input($option_name) . "', '" . (int)$languages[$i]['id'] . "')");

           }

           tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));

           break;

         case 'add_product_option_values':

           $value_name_array = $HTTP_POST_VARS['value_name'];

           $value_id = tep_db_prepare_input($HTTP_POST_VARS['value_id']);

           $option_id = tep_db_prepare_input($HTTP_POST_VARS['option_id']);

     

           for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {

             $value_name = tep_db_prepare_input($value_name_array[$languages[$i]['id']]);

     

             tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES . " (products_options_values_id, language_id, products_options_values_name) values ('" . (int)$value_id . "', '" . (int)$languages[$i]['id'] . "', '" . tep_db_input($value_name) . "')");

           }

     

           tep_db_query("insert into " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " (products_options_id, products_options_values_id) values ('" . (int)$option_id . "', '" . (int)$value_id . "')");

     

           tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));

           break;

         case 'add_product_attributes':

           $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);

           $options_id = tep_db_prepare_input($HTTP_POST_VARS['options_id']);

           $values_id = tep_db_prepare_input($HTTP_POST_VARS['values_id']);

           $value_price = tep_db_prepare_input($HTTP_POST_VARS['value_price']);

           $price_prefix = tep_db_prepare_input($HTTP_POST_VARS['price_prefix']);

     

           tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES . " values ('', '" . (int)$products_id . "', '" . (int)$options_id . "', '" . (int)$values_id . "', '" . tep_db_input($value_price) . "', '" . tep_db_input($price_prefix) . "','')");

     

           if (DOWNLOAD_ENABLED == 'true') {

             $products_attributes_id = tep_db_insert_id();

     

             $products_attributes_filename = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_filename']);

             $products_attributes_maxdays = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxdays']);

             $products_attributes_maxcount = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxcount']);

     

             if (tep_not_null($products_attributes_filename)) {

               tep_db_query("insert into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " values (" . (int)$products_attributes_id . ", '" . tep_db_input($products_attributes_filename) . "', '" . tep_db_input($products_attributes_maxdays) . "', '" . tep_db_input($products_attributes_maxcount) . "','')");

             }

           }

     

           tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));

           break;

         case 'update_option_name':

           $option_name_array = $HTTP_POST_VARS['option_name'];

           $option_id = tep_db_prepare_input($HTTP_POST_VARS['option_id']);

     

           for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {

             $option_name = tep_db_prepare_input($option_name_array[$languages[$i]['id']]);

     

             tep_db_query("update " . TABLE_PRODUCTS_OPTIONS . " set products_options_name = '" . tep_db_input($option_name) . "' where products_options_id = '" . (int)$option_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'");

           }

     

           tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));

           break;

         case 'update_value':

           $value_name_array = $HTTP_POST_VARS['value_name'];

           $value_id = tep_db_prepare_input($HTTP_POST_VARS['value_id']);

           $option_id = tep_db_prepare_input($HTTP_POST_VARS['option_id']);

     

           for ($i=0, $n=sizeof($languages); $i<$n; $i ++) {

             $value_name = tep_db_prepare_input($value_name_array[$languages[$i]['id']]);

     

             tep_db_query("update " . TABLE_PRODUCTS_OPTIONS_VALUES . " set products_options_values_name = '" . tep_db_input($value_name) . "' where products_options_values_id = '" . tep_db_input($value_id) . "' and language_id = '" . (int)$languages[$i]['id'] . "'");

           }

     

           tep_db_query("update " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " set products_options_id = '" . (int)$option_id . "'  where products_options_values_id = '" . (int)$value_id . "'");

     

           tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));

           break;

         case 'update_product_attribute':

           $products_id = tep_db_prepare_input($HTTP_POST_VARS['products_id']);

           $options_id = tep_db_prepare_input($HTTP_POST_VARS['options_id']);

           $values_id = tep_db_prepare_input($HTTP_POST_VARS['values_id']);

           $value_price = tep_db_prepare_input($HTTP_POST_VARS['value_price']);

           $price_prefix = tep_db_prepare_input($HTTP_POST_VARS['price_prefix']);

           $attribute_id = tep_db_prepare_input($HTTP_POST_VARS['attribute_id']);

     

           tep_db_query("update " . TABLE_PRODUCTS_ATTRIBUTES . " set products_id = '" . (int)$products_id . "', options_id = '" . (int)$options_id . "', options_values_id = '" . (int)$values_id . "', options_values_price = '" . tep_db_input($value_price) . "', price_prefix = '" . tep_db_input($price_prefix) . "' where products_attributes_id = '" . (int)$attribute_id . "'");

     

           if (DOWNLOAD_ENABLED == 'true') {

             $products_attributes_filename = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_filename']);

             $products_attributes_maxdays = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxdays']);

             $products_attributes_maxcount = tep_db_prepare_input($HTTP_POST_VARS['products_attributes_maxcount']);

     

             if (tep_not_null($products_attributes_filename)) {

               tep_db_query("replace into " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " set products_attributes_id = '" . (int)$attribute_id . "', products_attributes_filename = '" . tep_db_input($products_attributes_filename) . "', products_attributes_maxdays = '" . tep_db_input($products_attributes_maxdays) . "', products_attributes_maxcount = '" . tep_db_input($products_attributes_maxcount) . "'");

             }

           }

     

           tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));

           break;

         case 'delete_option':

           $option_id = tep_db_prepare_input($HTTP_GET_VARS['option_id']);

     

           tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$option_id . "'");

     

           tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));

           break;

         case 'delete_value':

           $value_id = tep_db_prepare_input($HTTP_GET_VARS['value_id']);

     

           tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$value_id . "'");

           tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$value_id . "'");

           tep_db_query("delete from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_values_id = '" . (int)$value_id . "'");

     

           tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));

           break;

         case 'delete_attribute':

           $attribute_id = tep_db_prepare_input($HTTP_GET_VARS['attribute_id']);

     

           tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_attributes_id = '" . (int)$attribute_id . "'");

     

    // added for DOWNLOAD_ENABLED. Always try to remove attributes, even if downloads are no longer enabled

           tep_db_query("delete from " . TABLE_PRODUCTS_ATTRIBUTES_DOWNLOAD . " where products_attributes_id = '" . (int)$attribute_id . "'");

     

           tep_redirect(tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, $page_info));

           break;

       }

     }

    ?>

    <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

    <html <?php echo HTML_PARAMS; ?>>

    <head>

    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

    <title><?php echo TITLE; ?></title>

    <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

    <script language="javascript"><!--

    function go_option() {

     if (document.option_order_by.selected.options[document.option_order_by.selected.selectedIndex].value != "none") {

       location = "<?php echo tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . ($HTTP_GET_VARS['option_page'] ? $HTTP_GET_VARS['option_page'] : 1)); ?>&option_order_by="+document.option_order_by.selected.options[document.option_order_by.selected.selectedIndex].value;

     }

    }

    //--></script>

    </head>

    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">

    <!-- header //-->

    <?php require(DIR_WS_INCLUDES . 'header.php'); ?>

    <!-- header_eof //-->

     

    <!-- body //-->

    <table border="0" width="100%" cellspacing="2" cellpadding="2">

     <tr>

       <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

    <!-- left_navigation //-->

    <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

    <!-- left_navigation_eof //-->

       </table></td>

    <!-- body_text //-->

       <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <!-- options and values//-->

         <tr>

           <td width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="0">

             <tr>

               <td valign="top" width="50%"><table width="100%" border="0" cellspacing="0" cellpadding="2">

    <!-- options //-->

    <?php

     if ($action == 'delete_product_option') { // delete product option

       $options = tep_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . (int)$HTTP_GET_VARS['option_id'] . "' and language_id = '" . (int)$languages_id . "'");

       $options_values = tep_db_fetch_array($options);

    ?>

                 <tr>

                   <td class="pageHeading"> <?php echo $options_values['products_options_name']; ?> </td>

                   <td> <?php echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td>

                 </tr>

                 <tr>

                   <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

                     <tr>

                       <td colspan="3"><?php echo tep_black_line(); ?></td>

                     </tr>

    <?php

       $products = tep_db_query("select p.products_id, pd.products_name, pov.products_options_values_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pov.language_id = '" . (int)$languages_id . "' and pd.language_id = '" . (int)$languages_id . "' and pa.products_id = p.products_id and pa.options_id='" . (int)$HTTP_GET_VARS['option_id'] . "' and pov.products_options_values_id = pa.options_values_id order by pd.products_name");

       if (tep_db_num_rows($products)) {

    ?>

                     <tr class="dataTableHeadingRow">

                       <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ID; ?> </td>

                       <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT; ?> </td>

                       <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td>

                     </tr>

                     <tr>

                       <td colspan="3"><?php echo tep_black_line(); ?></td>

                     </tr>

    <?php

         $rows = 0;

         while ($products_values = tep_db_fetch_array($products)) {

           $rows++;

    ?>

                     <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">

                       <td align="center" class="smallText"> <?php echo $products_values['products_id']; ?> </td>

                       <td class="smallText"> <?php echo $products_values['products_name']; ?> </td>

                       <td class="smallText"> <?php echo $products_values['products_options_values_name']; ?> </td>

                     </tr>

    <?php

         }

    ?>

                     <tr>

                       <td colspan="3"><?php echo tep_black_line(); ?></td>

                     </tr>

                     <tr>

                       <td colspan="3" class="main"><br><?php echo TEXT_WARNING_OF_DELETE; ?></td>

                     </tr>

                     <tr>

                       <td align="right" colspan="3" class="main"><br><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, (isset($HTTP_GET_VARS['value_page']) ? 'value_page=' . $HTTP_GET_VARS['value_page'] . '&' : '') . (isset($HTTP_GET_VARS['attribute_page']) ? 'attribute_page=' . $HTTP_GET_VARS['attribute_page'] : ''), 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', ' cancel '); ?></a> </td>

                     </tr>

    <?php

       } else {

    ?>

                     <tr>

                       <td class="main" colspan="3"><br><?php echo TEXT_OK_TO_DELETE; ?></td>

                     </tr>

                     <tr>

                       <td class="main" align="right" colspan="3"><br><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_option&option_id=' . $HTTP_GET_VARS['option_id'], 'NONSSL') . '">'; ?><?php echo tep_image_button('button_delete.gif', ' delete '); ?></a>   <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, (isset($HTTP_GET_VARS['order_by']) ? 'order_by=' . $HTTP_GET_VARS['order_by'] . '&' : '') . (isset($HTTP_GET_VARS['page']) ? 'page=' . $HTTP_GET_VARS['page'] : ''), 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', ' cancel '); ?></a> </td>

                     </tr>

    <?php

       }

    ?>

                   </table></td>

                 </tr>

    <?php

     } else {

       if (isset($HTTP_GET_VARS['option_order_by'])) {

         $option_order_by = $HTTP_GET_VARS['option_order_by'];

       } else {

         $option_order_by = 'products_options_id';

       }

    ?>

                 <tr>

                   <td colspan="2" class="pageHeading"> <?php echo HEADING_TITLE_OPT; ?> </td>

                   <td align="right"><br><form name="option_order_by" action="<?php echo FILENAME_PRODUCTS_ATTRIBUTES; ?>"><select name="selected" onChange="go_option()"><option value="products_options_id"<?php if ($option_order_by == 'products_options_id') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_ID; ?></option><option value="products_options_name"<?php if ($option_order_by == 'products_options_name') { echo ' SELECTED'; } ?>><?php echo TEXT_OPTION_NAME; ?></option></select></form></td>

                 </tr>

                 <tr>

                   <td colspan="3" class="smallText">

    <?php

       $per_page = MAX_ROW_LISTS_OPTIONS;

       $options = "select * from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "' order by " . $option_order_by;

       if (!isset($option_page)) {

         $option_page = 1;

       }

       $prev_option_page = $option_page - 1;

       $next_option_page = $option_page + 1;

     

       $option_query = tep_db_query($options);

     

       $option_page_start = ($per_page * $option_page) - $per_page;

       $num_rows = tep_db_num_rows($option_query);

     

       if ($num_rows <= $per_page) {

         $num_pages = 1;

       } else if (($num_rows % $per_page) == 0) {

         $num_pages = ($num_rows / $per_page);

       } else {

         $num_pages = ($num_rows / $per_page) + 1;

       }

       $num_pages = (int) $num_pages;

     

       $options = $options . " LIMIT $option_page_start, $per_page";

     

       // Previous

       if ($prev_option_page)  {

         echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $prev_option_page) . '"> << </a> | ';

       }

     

       for ($i = 1; $i <= $num_pages; $i++) {

         if ($i != $option_page) {

           echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $i) . '">' . $i . '</a> | ';

         } else {

           echo '<b><font color=red>' . $i . '</font></b> | ';

         }

       }

     

       // Next

       if ($option_page != $num_pages) {

         echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_page=' . $next_option_page) . '"> >> </a>';

       }

    ?>

                   </td>

                 </tr>

                 <tr>

                   <td colspan="3"><?php echo tep_black_line(); ?></td>

                 </tr>

                 <tr class="dataTableHeadingRow">

                   <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_ID; ?> </td>

                   <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td>

                   <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ACTION; ?> </td>

                 </tr>

                 <tr>

                   <td colspan="3"><?php echo tep_black_line(); ?></td>

                 </tr>

    <?php

       $next_id = 1;

       $rows = 0;

       $options = tep_db_query($options);

       while ($options_values = tep_db_fetch_array($options)) {

         $rows++;

    ?>

                 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">

    <?php

         if (($action == 'update_option') && ($HTTP_GET_VARS['option_id'] == $options_values['products_options_id'])) {

           echo '<form name="option" action="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option_name', 'NONSSL') . '" method="post">';

           $inputs = '';

           for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {

             $option_name = tep_db_query("select products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where products_options_id = '" . $options_values['products_options_id'] . "' and language_id = '" . $languages[$i]['id'] . "'");

             $option_name = tep_db_fetch_array($option_name);

             $inputs .= $languages[$i]['code'] . ': <input type="text" name="option_name[' . $languages[$i]['id'] . ']" size="20" value="' . $option_name['products_options_name'] . '"> <br>';

           }

    ?>

                   <td align="center" class="smallText"> <?php echo $options_values['products_options_id']; ?><input type="hidden" name="option_id" value="<?php echo $options_values['products_options_id']; ?>"> </td>

                   <td class="smallText"><?php echo $inputs; ?></td>

                   <td align="center" class="smallText"> <?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', IMAGE_CANCEL); ?></a> </td>

    <?php

           echo '</form>' . "\n";

         } else {

    ?>

                   <td align="center" class="smallText"> <?php echo $options_values["products_options_id"]; ?> </td>

                   <td class="smallText"> <?php echo $options_values["products_options_name"]; ?> </td>

                   <td align="center" class="smallText"> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option&option_id=' . $options_values['products_options_id'] . '&option_order_by=' . $option_order_by . '&option_page=' . $option_page, 'NONSSL') . '">'; ?><?php echo tep_image_button('button_edit.gif', IMAGE_UPDATE); ?></a>  <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_product_option&option_id=' . $options_values['products_options_id'], 'NONSSL') , '">'; ?><?php echo tep_image_button('button_delete.gif', IMAGE_DELETE); ?></a> </td>

    <?php

         }

    ?>

                 </tr>

    <?php

         $max_options_id_query = tep_db_query("select max(products_options_id) + 1 as next_id from " . TABLE_PRODUCTS_OPTIONS);

         $max_options_id_values = tep_db_fetch_array($max_options_id_query);

         $next_id = $max_options_id_values['next_id'];

       }

    ?>

                 <tr>

                   <td colspan="3"><?php echo tep_black_line(); ?></td>

                 </tr>

    <?php

       if ($action != 'update_option') {

    ?>

                 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">

    <?php

         echo '<form name="options" action="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=add_product_options&option_page=' . $option_page, 'NONSSL') . '" method="post"><input type="hidden" name="products_options_id" value="' . $next_id . '">';

         $inputs = '';

         for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {

           $inputs .= $languages[$i]['code'] . ': <input type="text" name="option_name[' . $languages[$i]['id'] . ']" size="20"> <br>';

         }

    ?>

                   <td align="center" class="smallText"> <?php echo $next_id; ?> </td>

                   <td class="smallText"><?php echo $inputs; ?></td>

                   <td align="center" class="smallText"> <?php echo tep_image_submit('button_insert.gif', IMAGE_INSERT); ?> </td>

    <?php

         echo '</form>';

    ?>

                 </tr>

                 <tr>

                   <td colspan="3"><?php echo tep_black_line(); ?></td>

                 </tr>

    <?php

       }

     }

    ?>

               </table></td>

    <!-- options eof //-->

               <td valign="top" width="50%"><table width="100%" border="0" cellspacing="0" cellpadding="2">

    <!-- value //-->

    <?php

     if ($action == 'delete_option_value') { // delete product option value

       $values = tep_db_query("select products_options_values_id, products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$HTTP_GET_VARS['value_id'] . "' and language_id = '" . (int)$languages_id . "'");

       $values_values = tep_db_fetch_array($values);

    ?>

                 <tr>

                   <td colspan="3" class="pageHeading"> <?php echo $values_values['products_options_values_name']; ?> </td>

                   <td> <?php echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td>

                 </tr>

                 <tr>

                   <td><table border="0" width="100%" cellspacing="0" cellpadding="2">

                     <tr>

                       <td colspan="3"><?php echo tep_black_line(); ?></td>

                     </tr>

    <?php

       $products = tep_db_query("select p.products_id, pd.products_name, po.products_options_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS . " po, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and po.language_id = '" . (int)$languages_id . "' and pa.products_id = p.products_id and pa.options_values_id='" . (int)$HTTP_GET_VARS['value_id'] . "' and po.products_options_id = pa.options_id order by pd.products_name");

       if (tep_db_num_rows($products)) {

    ?>

                     <tr class="dataTableHeadingRow">

                       <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ID; ?> </td>

                       <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_PRODUCT; ?> </td>

                       <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td>

                     </tr>

                     <tr>

                       <td colspan="3"><?php echo tep_black_line(); ?></td>

                     </tr>

    <?php

         while ($products_values = tep_db_fetch_array($products)) {

           $rows++;

    ?>

                     <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">

                       <td align="center" class="smallText"> <?php echo $products_values['products_id']; ?> </td>

                       <td class="smallText"> <?php echo $products_values['products_name']; ?> </td>

                       <td class="smallText"> <?php echo $products_values['products_options_name']; ?> </td>

                     </tr>

    <?php

         }

    ?>

                     <tr>

                       <td colspan="3"><?php echo tep_black_line(); ?></td>

                     </tr>

                     <tr>

                       <td class="main" colspan="3"><br><?php echo TEXT_WARNING_OF_DELETE; ?></td>

                     </tr>

                     <tr>

                       <td class="main" align="right" colspan="3"><br><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, (isset($HTTP_GET_VARS['value_page']) ? 'value_page=' . $HTTP_GET_VARS['value_page'] . '&' : '') . (isset($HTTP_GET_VARS['attribute_page']) ? 'attribute_page=' . $attribute_page : ''), 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', ' cancel '); ?></a> </td>

                     </tr>

    <?php

       } else {

    ?>

                     <tr>

                       <td class="main" colspan="3"><br><?php echo TEXT_OK_TO_DELETE; ?></td>

                     </tr>

                     <tr>

                       <td class="main" align="right" colspan="3"><br><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_value&value_id=' . $HTTP_GET_VARS['value_id'], 'NONSSL') . '">'; ?><?php echo tep_image_button('button_delete.gif', ' delete '); ?></a>   <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '&option_page=' . $option_page . (isset($HTTP_GET_VARS['value_page']) ? '&value_page=' . $value_page : '') . (isset($HTTP_GET_VARS['attribute_page']) ? '&attribute_page=' . $attribute_page : ''), 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', ' cancel '); ?></a> </td>

                     </tr>

    <?php

       }

    ?>

                  </table></td>

                 </tr>

    <?php

     } else {

    ?>

                 <tr>

                   <td colspan="3" class="pageHeading"> <?php echo HEADING_TITLE_VAL; ?> </td>

                   <td> <?php echo tep_image(DIR_WS_IMAGES . 'pixel_trans.gif', '', '1', '53'); ?> </td>

                 </tr>

                 <tr>

                   <td colspan="4" class="smallText">

    <?php

       $per_page = MAX_ROW_LISTS_OPTIONS;

       $values = "select pov.products_options_values_id, pov.products_options_values_name, pov2po.products_options_id from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov left join " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po on pov.products_options_values_id = pov2po.products_options_values_id where pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_id";

       if (!isset($value_page)) {

         $value_page = 1;

       }

       $prev_value_page = $value_page - 1;

       $next_value_page = $value_page + 1;

     

       $value_query = tep_db_query($values);

     

       $value_page_start = ($per_page * $value_page) - $per_page;

       $num_rows = tep_db_num_rows($value_query);

     

       if ($num_rows <= $per_page) {

         $num_pages = 1;

       } else if (($num_rows % $per_page) == 0) {

         $num_pages = ($num_rows / $per_page);

       } else {

         $num_pages = ($num_rows / $per_page) + 1;

       }

       $num_pages = (int) $num_pages;

     

       $values = $values . " LIMIT $value_page_start, $per_page";

     

       // Previous

       if ($prev_value_page)  {

         echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'option_order_by=' . $option_order_by . '&value_page=' . $prev_value_page) . '"> << </a> | ';

       }

     

       for ($i = 1; $i <= $num_pages; $i++) {

         if ($i != $value_page) {

            echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, (isset($option_order_by) ? 'option_order_by=' . $option_order_by . '&' : '') . 'value_page=' . $i) . '">' . $i . '</a> | ';

         } else {

            echo '<b><font color=red>' . $i . '</font></b> | ';

         }

       }

     

       // Next

       if ($value_page != $num_pages) {

         echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, (isset($option_order_by) ? 'option_order_by=' . $option_order_by . '&' : '') . 'value_page=' . $next_value_page) . '"> >></a> ';

       }

    ?>

                   </td>

                 </tr>

                 <tr>

                   <td colspan="4"><?php echo tep_black_line(); ?></td>

                 </tr>

                 <tr class="dataTableHeadingRow">

                   <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_ID; ?> </td>

                   <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_NAME; ?> </td>

                   <td class="dataTableHeadingContent"> <?php echo TABLE_HEADING_OPT_VALUE; ?> </td>

                   <td class="dataTableHeadingContent" align="center"> <?php echo TABLE_HEADING_ACTION; ?> </td>

                 </tr>

                 <tr>

                   <td colspan="4"><?php echo tep_black_line(); ?></td>

                 </tr>

    <?php

       $next_id = 1;

       $rows = 0;

       $values = tep_db_query($values);

       while ($values_values = tep_db_fetch_array($values)) {

         $options_name = tep_options_name($values_values['products_options_id']);

         $values_name = $values_values['products_options_values_name'];

         $rows++;

    ?>

                 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">

    <?php

         if (($action == 'update_option_value') && ($HTTP_GET_VARS['value_id'] == $values_values['products_options_values_id'])) {

           echo '<form name="values" action="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_value', 'NONSSL') . '" method="post">';

           $inputs = '';

           for ($i = 0, $n = sizeof($languages); $i < $n; $i ++) {

             $value_name = tep_db_query("select products_options_values_name from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . (int)$values_values['products_options_values_id'] . "' and language_id = '" . (int)$languages[$i]['id'] . "'");

             $value_name = tep_db_fetch_array($value_name);

             $inputs .= $languages[$i]['code'] . ': <input type="text" name="value_name[' . $languages[$i]['id'] . ']" size="15" value="' . $value_name['products_options_values_name'] . '"> <br>';

           }

    ?>

                   <td align="center" class="smallText"> <?php echo $values_values['products_options_values_id']; ?><input type="hidden" name="value_id" value="<?php echo $values_values['products_options_values_id']; ?>"> </td>

                   <td align="center" class="smallText"> <?php echo "\n"; ?><select name="option_id">

    <?php

           $options = tep_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "' order by products_options_name");

           while ($options_values = tep_db_fetch_array($options)) {

             echo "\n" . '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '"';

             if ($values_values['products_options_id'] == $options_values['products_options_id']) {

               echo ' selected';

             }

             echo '>' . $options_values['products_options_name'] . '</option>';

           }

    ?>

                   </select> </td>

                   <td class="smallText"><?php echo $inputs; ?></td>

                   <td align="center" class="smallText"> <?php echo tep_image_submit('button_update.gif', IMAGE_UPDATE); ?> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, '', 'NONSSL') . '">'; ?><?php echo tep_image_button('button_cancel.gif', IMAGE_CANCEL); ?></a> </td>

    <?php

           echo '</form>';

         } else {

    ?>

                   <td align="center" class="smallText"> <?php echo $values_values["products_options_values_id"]; ?> </td>

                   <td align="center" class="smallText"> <?php echo $options_name; ?> </td>

                   <td class="smallText"> <?php echo $values_name; ?> </td>

                   <td align="center" class="smallText"> <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=update_option_value&value_id=' . $values_values['products_options_values_id'] . (isset($HTTP_GET_VARS['value_page']) ? '&value_page=' . $HTTP_GET_VARS['value_page'] : ''), 'NONSSL') . '">'; ?><?php echo tep_image_button('button_edit.gif', IMAGE_UPDATE); ?></a>  <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=delete_option_value&value_id=' . $values_values['products_options_values_id'], 'NONSSL') , '">'; ?><?php echo tep_image_button('button_delete.gif', IMAGE_DELETE); ?></a> </td>

    <?php

         }

         $max_values_id_query = tep_db_query("select max(products_options_values_id) + 1 as next_id from " . TABLE_PRODUCTS_OPTIONS_VALUES);

         $max_values_id_values = tep_db_fetch_array($max_values_id_query);

         $next_id = $max_values_id_values['next_id'];

       }

    ?>

                 </tr>

                 <tr>

                   <td colspan="4"><?php echo tep_black_line(); ?></td>

                 </tr>

    <?php

       if ($action != 'update_option_value') {

    ?>

                 <tr class="<?php echo (floor($rows/2) == ($rows/2) ? 'attributes-even' : 'attributes-odd'); ?>">

    <?php

         echo '<form name="values" action="' . tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES, 'action=add_product_option_values&value_page=' . $value_page, 'NONSSL') . '" method="post">';

    ?>

                   <td align="center" class="smallText"> <?php echo $next_id; ?> </td>

                   <td align="center" class="smallText"> <select name="option_id">

    <?php

         $options = tep_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . $languages_id . "' order by products_options_name");

         while ($options_values = tep_db_fetch_array($options)) {

           echo '<option name="' . $options_values['products_options_name'] . '" value="' . $options_values['products_options_id'] . '">' . $options_values

  6. Hi, I've installed wish list in MS 2.2 but in the page there are 6 wishlist boxes, I use also infobox contribution, this is the code of column_right.php:

     

     

    <?php
    /*
     $Id: column_right.php,v 1.15 2002/03/13 13:52:20 lango Exp $
    
     osCommerce, Open Source E-Commerce Solutions
     http://www.oscommerce.com
    
     Copyright (c) 2002 osCommerce
    
     Released under the GNU General Public License
    */
     $column_query = tep_db_query('select configuration_column as cfgcol, configuration_title as cfgtitle, configuration_value as cfgvalue, configuration_key as cfgkey, box_heading from ' . TABLE_THEME_CONFIGURATION . ' order by location');
     while ($column = tep_db_fetch_array($column_query)) {
    
         $column['cfgtitle'] = str_replace(' ', '_', $column['cfgtitle']);
         $column['cfgtitle'] = str_replace("'", '', $column['cfgtitle']);
    
    if ( ($column[cfgvalue] == 'yes') && ($column[cfgcol] == 'right')) {
    
    define($column['cfgkey'],$column['box_heading']);
    
    if ( file_exists(DIR_WS_BOXES . $column['cfgtitle'] . '.php') ) {
    require(DIR_WS_BOXES . $column['cfgtitle'] . '.php');
    if (tep_session_is_registered('customer_id')) include(DIR_WS_BOXES . 'wishlist.php');
    } 
    }
    }
    ?>
    <tr>
                       <td class="pageHeading" height="100%" valign="top">
    <?php 
    if ( file_exists('includes/classes/thema/' . SITE_THEMA . '/images/backend.gif')) {
    ?>
    <IMG SRC="includes/classes/thema/<?php echo SITE_THEMA;?>/images/backend.gif" width="100%">
    <?php
    }
    ?>
                       </td>
                     </tr>

  7. Hi, I'm new for BST 1.3,

    I have a stupid question maybe:

     

    how can working on a templates and now using a clodes templates for under construction time ?

     

    Anothe question:

     

    there are contribution there is IMPOSSIBLE to install in this BST

     

    Than you all

×
×
  • Create New...