Jump to content

fasiso

Members
  • Content count

    75
  • Joined

  • Last visited

Posts posted by fasiso


  1. Hi;

     

    I see the log and the date is in the right format. I change the customer address because it was false and the module works ok.

     

    But I get a blank page in checkout_shipping.php when the product is not available.

     

    PHP Fatal error: Cannot use string offset as an array in /var/www/vhosts/httpdocs/tienda/includes/modules/shipping/upsxml.php on line 321, referer: http://www.etz.es/tienda/shopping_cart.php?sort=3a

     

    $_type = $_type . ", ".$this->servicesTimeintransit[$type]["date"];

     

    Thank you very much for your help.


  2. Hi everybody!

     

    After upgrade php4 to php5 I get a blank page with

     

    PHP Fatal error: Cannot use string offset as an array in /includes/modules/shipping/upsxml.php on line 325

    The line 325 is:

    $eta_array = explode("-", $this->servicesTimeintransit[$type]["date"]);

     

    I have UPSXML 1.2.2 (Thanks Janz)

     

    Any help would be apreciated. Thanks in advance.


  3. Hi everybody!

     

    I´ve installed 2.0b and works more or less because when I have more than 3000 products I get mysql error.

     

    Well my trouble is when I try to uninstall or upgrade this contribution for example to 2.1c always I get a blank page in catalog directory and not upgrade admin control panel under Configuration => SEO URL

     

    Please could you help me?

     

    Thanks in advance.


  4. Hello

    Advanced search works ok but when order by price i get this error at advanced_search_result.php.

     

    1109 - Unknown table 'p2pef' in where clause

     

    select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials_retail_prices s on p.products_id = s.products_id , categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '3' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%123456%' or p.products_model like '%123456%' or m.manufacturers_name like '%123456%' or p2pef.products_extra_fields_value like '%123456%' or pd.products_description like '%123456%') )

     

    [TEP STOP]

    These are the contributions I've installed

    Separate Price Per Customer v4.1.1 Spanish

    Extra Fields v2.0j

     

    I look for similar questions but i can?t found the solution.

     

    <?php
    /*
     $Id: advanced_search_result.php,v 1.72 2003/06/23 06:50:11 project3000 Exp $
     adapted for Separate Pricing Per Customer 2005/02/06
    
     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');
    
     require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ADVANCED_SEARCH);
    
     $error = false;
    
     if ( (isset($HTTP_GET_VARS['keywords']) && empty($HTTP_GET_VARS['keywords'])) &&
       (isset($HTTP_GET_VARS['dfrom']) && (empty($HTTP_GET_VARS['dfrom']) || ($HTTP_GET_VARS['dfrom'] == DOB_FORMAT_STRING))) &&
       (isset($HTTP_GET_VARS['dto']) && (empty($HTTP_GET_VARS['dto']) || ($HTTP_GET_VARS['dto'] == DOB_FORMAT_STRING))) &&
       (isset($HTTP_GET_VARS['pfrom']) && !is_numeric($HTTP_GET_VARS['pfrom'])) &&
       (isset($HTTP_GET_VARS['pto']) && !is_numeric($HTTP_GET_VARS['pto'])) ) {
    $error = true;
    
    $messageStack->add_session('search', ERROR_AT_LEAST_ONE_INPUT);
     } else {
    $dfrom = '';
    $dto = '';
    $pfrom = '';
    $pto = '';
    $keywords = '';
    
    if (isset($HTTP_GET_VARS['dfrom'])) {
      $dfrom = (($HTTP_GET_VARS['dfrom'] == DOB_FORMAT_STRING) ? '' : $HTTP_GET_VARS['dfrom']);
    }
    
    if (isset($HTTP_GET_VARS['dto'])) {
      $dto = (($HTTP_GET_VARS['dto'] == DOB_FORMAT_STRING) ? '' : $HTTP_GET_VARS['dto']);
    }
    
    if (isset($HTTP_GET_VARS['pfrom'])) {
      $pfrom = $HTTP_GET_VARS['pfrom'];
    }
    
    if (isset($HTTP_GET_VARS['pto'])) {
      $pto = $HTTP_GET_VARS['pto'];
    }
    
    if (isset($HTTP_GET_VARS['keywords'])) {
      $keywords = $HTTP_GET_VARS['keywords'];
    }
    
    $date_check_error = false;
    if (tep_not_null($dfrom)) {
      if (!tep_checkdate($dfrom, DOB_FORMAT_STRING, $dfrom_array)) {
    	$error = true;
    	$date_check_error = true;
    
    	$messageStack->add_session('search', ERROR_INVALID_FROM_DATE);
      }
    }
    
    if (tep_not_null($dto)) {
      if (!tep_checkdate($dto, DOB_FORMAT_STRING, $dto_array)) {
    	$error = true;
    	$date_check_error = true;
    
    	$messageStack->add_session('search', ERROR_INVALID_TO_DATE);
      }
    }
    
    if (($date_check_error == false) && tep_not_null($dfrom) && tep_not_null($dto)) {
      if (mktime(0, 0, 0, $dfrom_array[1], $dfrom_array[2], $dfrom_array[0]) > mktime(0, 0, 0, $dto_array[1], $dto_array[2], $dto_array[0])) {
    	$error = true;
    
    	$messageStack->add_session('search', ERROR_TO_DATE_LESS_THAN_FROM_DATE);
      }
    }
    
    $price_check_error = false;
    if (tep_not_null($pfrom)) {
      if (!settype($pfrom, 'double')) {
    	$error = true;
    	$price_check_error = true;
    
    	$messageStack->add_session('search', ERROR_PRICE_FROM_MUST_BE_NUM);
      }
    }
    
    if (tep_not_null($pto)) {
      if (!settype($pto, 'double')) {
    	$error = true;
    	$price_check_error = true;
    
    	$messageStack->add_session('search', ERROR_PRICE_TO_MUST_BE_NUM);
      }
    }
    
    if (($price_check_error == false) && is_float($pfrom) && is_float($pto)) {
      if ($pfrom >= $pto) {
    	$error = true;
    
    	$messageStack->add_session('search', ERROR_PRICE_TO_LESS_THAN_PRICE_FROM);
      }
    }
    
    if (tep_not_null($keywords)) {
      if (!tep_parse_search_string($keywords, $search_keywords)) {
    	$error = true;
    
    	$messageStack->add_session('search', ERROR_INVALID_KEYWORDS);
      }
    }
     }
    
     if (empty($dfrom) && empty($dto) && empty($pfrom) && empty($pto) && empty($keywords)) {
    $error = true;
    
    $messageStack->add_session('search', ERROR_AT_LEAST_ONE_INPUT);
     }
    
     if ($error == true) {
    tep_redirect(tep_href_link(FILENAME_ADVANCED_SEARCH, tep_get_all_get_params(), 'NONSSL', true, false));
     }
    
     $breadcrumb->add(NAVBAR_TITLE_1, tep_href_link(FILENAME_ADVANCED_SEARCH));
     $breadcrumb->add(NAVBAR_TITLE_2, tep_href_link(FILENAME_ADVANCED_SEARCH_RESULT, tep_get_all_get_params(), 'NONSSL', true, false));
    ?>
    <!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; ?>">
    <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
    <title><?php echo TITLE; ?></title>
    <link rel="stylesheet" type="text/css" href="stylesheet.css">
    </head>
    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
    <!-- header //-->
    <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
    <!-- header_eof //-->
    
    <!-- body //-->
    <table border="0" width="100%" cellspacing="3" cellpadding="3">
     <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
    <!-- 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">
      <tr>
    	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
    	  <tr>
    		<td class="pageHeading"><?php echo HEADING_TITLE_2; ?></td>
    		<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_browse.gif', HEADING_TITLE_2, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
    	  </tr>
    	</table></td>
      </tr>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
    	<td>
    <?php
    // create column list
     $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
    				   'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
    				   'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
    				   'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
    				   'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
    				   'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
    				   'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,
    				   'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);
    
     asort($define_list);
    
     $column_list = array();
     reset($define_list);
     while (list($key, $value) = each($define_list)) {
    if ($value > 0) $column_list[] = $key;
     }
    
      // BOF Separate Pricing Per Customer
     if(!tep_session_is_registered('sppc_customer_group_id')) { 
     $customer_group_id = '0';
     } else {
      $customer_group_id = $sppc_customer_group_id;
     }
      // EOF Separate Pricing Per Customer
    
     $select_column_list = '';
    
     for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
    switch ($column_list[$i]) {
      case 'PRODUCT_LIST_MODEL':
    	$select_column_list .= 'p.products_model, ';
    	break;
      case 'PRODUCT_LIST_MANUFACTURER':
    	$select_column_list .= 'm.manufacturers_name, ';
    	break;
      case 'PRODUCT_LIST_QUANTITY':
    	$select_column_list .= 'p.products_quantity, ';
    	break;
      case 'PRODUCT_LIST_IMAGE':
    	$select_column_list .= 'p.products_image, ';
    	break;
      case 'PRODUCT_LIST_WEIGHT':
    	$select_column_list .= 'p.products_weight, ';
    	break;
    }
     }
    
      // BOF Separate Pricing Per Customer
      $status_tmp_product_prices_table = false;
      $status_need_to_get_prices = false;
      // find out if sorting by price has been requested
      if ( (isset($HTTP_GET_VARS['sort'])) && (ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) && (substr($HTTP_GET_VARS['sort'], 0, 1) <= sizeof($column_list)) ){
    $_sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);
    if ($column_list[$_sort_col-1] == 'PRODUCT_LIST_PRICE') {
      $status_need_to_get_prices = true;
      }
      }
    
      if ((tep_not_null($pfrom) || tep_not_null($pto) || $status_need_to_get_prices == true) && $customer_group_id != '0') { 
      $product_prices_table = TABLE_PRODUCTS_GROUP_PRICES.$customer_group_id;
      // the table with product prices for a particular customer group is re-built only a number of times per hour
      // (setting in /includes/database_tables.php called MAXIMUM_DELAY_UPDATE_PG_PRICES_TABLE, in minutes)
      // to trigger the update the next function is called (new function that should have been
      // added to includes/functions/database.php)
      tep_db_check_age_products_group_prices_cg_table($customer_group_id);
      $status_tmp_product_prices_table = true;   
      } elseif ((tep_not_null($pfrom) || tep_not_null($pto) || $status_need_to_get_prices == true) && $customer_group_id == '0') {
      // to be able to sort on retail prices we *need* to get the special prices instead of leaving them
      // NULL and do product_listing the job of getting the special price
      // first make sure that table exists and needs no updating
      tep_db_check_age_specials_retail_table();
      $status_tmp_special_prices_table = true;
      } // end elseif ((tep_not_null($pfrom) || (tep_not_null($pfrom)) && .... 
    
      if ($status_tmp_product_prices_table == true) {
      $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, tmp_pp.products_price, p.products_tax_class_id, if(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price ";
      } elseif ($status_tmp_special_prices_table == true) {
     $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price ";	
      } else {
     $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, NULL as final_price ";	
      }
      // next line original select query
      // $select_str = "select distinct " . $select_column_list . " m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price ";
    
    
     if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {
    $select_str .= ", SUM(tr.tax_rate) as tax_rate ";
     }
    
      if ($status_tmp_product_prices_table == true) {
     $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";
      } elseif ($status_tmp_special_prices_table == true) {
     $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id , " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";
      } else {// START: Extra Fields Contribution
    //  $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";
     $from_str = "from (" . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS . " p2pef on p.products_id=p2pef.products_id) left join " . TABLE_MANUFACTURERS . " m on m.manufacturers_id=p.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_CATEGORIES . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c";
    // END: Extra Fields Contribution
    
      }
     // EOF Separate Pricing Per Customer
     if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {
    if (!tep_session_is_registered('customer_country_id')) {
      $customer_country_id = STORE_COUNTRY;
      $customer_zone_id = STORE_ZONE;
    }
    $from_str .= " left join " . TABLE_TAX_RATES . " tr on p.products_tax_class_id = tr.tax_class_id left join " . TABLE_ZONES_TO_GEO_ZONES . " gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '" . (int)$customer_country_id . "') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '" . (int)$customer_zone_id . "')";
     }
    
     $where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id ";
    
     if (isset($HTTP_GET_VARS['categories_id']) && tep_not_null($HTTP_GET_VARS['categories_id'])) {
    if (isset($HTTP_GET_VARS['inc_subcat']) && ($HTTP_GET_VARS['inc_subcat'] == '1')) {
      $subcategories_array = array();
      tep_get_subcategories($subcategories_array, $HTTP_GET_VARS['categories_id']);
    
      $where_str .= " and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '" . (int)$HTTP_GET_VARS['categories_id'] . "'";
    
      for ($i=0, $n=sizeof($subcategories_array); $i<$n; $i++ ) {
    	$where_str .= " or p2c.categories_id = '" . (int)$subcategories_array[$i] . "'";
      }
    
      $where_str .= ")";
    } else {
      $where_str .= " and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['categories_id'] . "'";
    }
     }
    
     if (isset($HTTP_GET_VARS['manufacturers_id']) && tep_not_null($HTTP_GET_VARS['manufacturers_id'])) {
    $where_str .= " and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
     }
    
     if (isset($search_keywords) && (sizeof($search_keywords) > 0)) {
    $where_str .= " and (";
    for ($i=0, $n=sizeof($search_keywords); $i<$n; $i++ ) {
      switch ($search_keywords[$i]) {
    	case '(':
    	case ')':
    	case 'and':
    	case 'or':
    	  $where_str .= " " . $search_keywords[$i] . " ";
    	  break;
    	default:
    	  $keyword = tep_db_prepare_input($search_keywords[$i]);// START: Extra Fields Contribution
    //		  $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'";
    	  $where_str .= "(pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%' or p2pef.products_extra_fields_value like '%" . tep_db_input($keyword) . "%'";
    // END: Extra Fields Contribution
    
    if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'";
    	  $where_str .= ')';
    	  break;
      }
    }
    $where_str .= " )";
     }
    
     if (tep_not_null($dfrom)) {
    $where_str .= " and p.products_date_added >= '" . tep_date_raw($dfrom) . "'";
     }
    
     if (tep_not_null($dto)) {
    $where_str .= " and p.products_date_added <= '" . tep_date_raw($dto) . "'";
     }
    
     if (tep_not_null($pfrom)) {
    if ($currencies->is_set($currency)) {
      $rate = $currencies->get_value($currency);
    
      $pfrom = $pfrom / $rate;
    }
     }
    
     if (tep_not_null($pto)) {
    if (isset($rate)) {
      $pto = $pto / $rate;
    }
     }
     // BOF Separate Pricing Per Customer
      if ($status_tmp_product_prices_table == true) {
     if (DISPLAY_PRICE_WITH_TAX == 'true') {
    if ($pfrom > 0) $where_str .= " and (IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) >= " . (double)$pfrom . ")";
    if ($pto > 0) $where_str .= " and (IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= " . (double)$pto . ")";
     } else {
    if ($pfrom > 0) $where_str .= " and (IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) >= " . (double)$pfrom . ")";
    if ($pto > 0) $where_str .= " and (IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) <= " . (double)$pto . ")";
     }
      } else { // $status_tmp_product_prices_table is not true: uses p.products_price instead of cg_products_price
       // because in the where clause for the case $status_tmp_special_prices is true, the table 
       // specials_retail_prices is abbreviated with "s" also we can use the same code for "true" and for "false"
    	 if (DISPLAY_PRICE_WITH_TAX == 'true') {
    if ($pfrom > 0) $where_str .= " and (IF(s.status AND s.customers_group_id = '" . $customer_group_id . "', s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) >= " . (double)$pfrom . ")";
    if ($pto > 0) $where_str .= " and (IF(s.status AND s.customers_group_id = '" . $customer_group_id . "', s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= " . (double)$pto . ")";
     } else {
    if ($pfrom > 0) $where_str .= " and (IF(s.status AND s.customers_group_id = '" . $customer_group_id . "', s.specials_new_products_price, p.products_price) >= " . (double)$pfrom . ")";
    if ($pto > 0) $where_str .= " and (IF(s.status AND s.customers_group_id = '" . $customer_group_id . "', s.specials_new_products_price, p.products_price) <= " . (double)$pto . ")";
      }
      } 
    // EOF Separate Pricing Per Customer
    
     if ( (DISPLAY_PRICE_WITH_TAX == 'true') && (tep_not_null($pfrom) || tep_not_null($pto)) ) {
    $where_str .= " group by p.products_id, tr.tax_priority";
     }
    
    
     if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {
    for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
      if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
    	$HTTP_GET_VARS['sort'] = $i+1 . 'a';
    	$order_str = ' order by pd.products_name';
    	break;
      }
    }
     } else {
    $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);
    $sort_order = substr($HTTP_GET_VARS['sort'], 1);
    $order_str = ' order by ';
    switch ($column_list[$sort_col-1]) {
      case 'PRODUCT_LIST_MODEL':
    	$order_str .= "p.products_model " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
    	break;
      case 'PRODUCT_LIST_NAME':
    	$order_str .= "pd.products_name " . ($sort_order == 'd' ? "desc" : "");
    	break;
      case 'PRODUCT_LIST_MANUFACTURER':
    	$order_str .= "m.manufacturers_name " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
    	break;
      case 'PRODUCT_LIST_QUANTITY':
    	$order_str .= "p.products_quantity " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
    	break;
      case 'PRODUCT_LIST_IMAGE':
    	$order_str .= "pd.products_name";
    	break;
      case 'PRODUCT_LIST_WEIGHT':
    	$order_str .= "p.products_weight " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
    	break;
      case 'PRODUCT_LIST_PRICE':
    	$order_str .= "final_price " . ($sort_order == 'd' ? "desc" : "") . ", pd.products_name";
    	break;
    }
     }
    
     $listing_sql = $select_str . $from_str . $where_str . $order_str;
    
     require(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING);
    ?>
    	</td>
      </tr>
      <tr>
    	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
    	<td class="main"><?php echo '<a href="' . tep_href_link(FILENAME_ADVANCED_SEARCH, tep_get_all_get_params(array('sort', 'page')), 'NONSSL', true, false) . '">' . tep_image_button('button_back.gif', IMAGE_BUTTON_BACK) . '</a>'; ?></td>
      </tr>
    </table></td>
    <!-- body_text_eof //-->
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
    <!-- right_navigation //-->
    <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
    <!-- right_navigation_eof //-->
    </table></td>
     </tr>
    </table>
    <!-- body_eof //-->
    
    <!-- footer //-->
    <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
    <!-- footer_eof //-->
    <br>
    </body>
    </html>
    <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

     

    Thanks in advance for your help.


  5. I?ve installed 2.0b on Windows 2003 with IIS 6.0 for five times and always I?m obtain

     

    CGI ERROR.

    The specified CGI application misbehaved by not returning a complete set of HTTP headers.

     

    I choose url type cNAME and SEO URL is enabled.

     

    What can I do? I think that the problem is in application_top.php but i don?t know exactly where.

     

    Please help me.

     

    Thanks.


  6. Hi Albert;

     

    I?ve installed your contribution for Sabadell Atalantico but I have write to them choose "Comercio con campo de verificaci?n" and they answer to me What is this?

     

    Vamos, que no se enteran ni del Nodo por lo que se ve? Qu? puedo hacer? Gracias?


  7. http://desarrollo.pagoseguro.com.es/catalo...?products_id=28

     

    images_big/leon_1.jpg

    thumbs/leon_1.jpg

     

    I test wiht 2 configurations

     

    1.

    T?tulo Valor Acci?n

    Big Images Directory images_big/

    Thumbnail Images Directory thumbs/

    Main Thumbnail In Thumb Directory false

    Number of Pics per Row 4

    Mo Pics Extension

    Main Big Pic Extension

    Mo Pics Thumbnail Image Type jpg

    Mo Pics Big Image Type jpg

    Mo Pics Extension

     

    2.

    T?tulo Valor Acci?n

    Big Images Directory images_big/

    Thumbnail Images Directory thumbs/

    Main Thumbnail In Thumb Directory false

    Number of Pics per Row 4

    Mo Pics Extension _

    Main Big Pic Extension _

    Mo Pics Thumbnail Image Type jpg

    Mo Pics Big Image Type jpg

    Mo Pics Extension

     

    My server is Windows 2003 and php 4.3.9

    Thanks


  8. It does not work. Anyway thnk you very very much for your answer.

     

    Now i have this configuration.

     

    Big Images Directory images_big/

    Thumbnail Images Directory thumbs/

    Main Thumbnail In Thumb Directory false

    Number of Pics per Row 3

    Mo Pics Extension _

    Main Big Pic Extension

    Mo Pics Thumbnail Image Type gif

    Mo Pics Big Image Type gif

    Big Images Directory

     

     

    The directory inside catalog/ images where your big images are stored.

     

    Fecha de Alta: 25/11/2004

    Ultima Modificaci?n: 25/11/2004


  9. Help please!!

     

    Checkout shipping;

     

    I choose this option;

     

    United Parcel Service (XML) (2 pkg(s) x 32.45 kgs total)

    UPS Standard, 2004-11-29 $28.50

     

    continue... then obtain again checkout_shippin instead oof checkout payment and change the price

     

    United Parcel Service (XML) (2 pkg(s) x 32.45 kgs total)

    UPS Standard, 2004-11-29 $45.60

     

     

    Module with Dimensions not suported


  10. Help please!!

     

    Checkout shipping;

     

    I choose this option;

     

    United Parcel Service (XML) (2 pkg(s) x 32.45 kgs total)

    UPS Standard, 2004-11-29 $28.50

     

    continue... then obtain again checkout_shippin instead oof checkout payment and change the price

     

    United Parcel Service (XML) (2 pkg(s) x 32.45 kgs total)

    UPS Standard, 2004-11-29 $45.60

     

     

    Module with Dimensions not suported

×