* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version GIT: $Id: Author: DrByte Tue Jan 22 03:36:04 2013 -0500 Modified in v1.5.2 $ */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } ///// // BOF PREVIOUS NEXT if (!isset($current_category_id)) { $current_category_id = 0; } if (!isset($prev_next_list) || $prev_next_list == '') { // calculate the previous and next $result = $db->Execute("select products_type from " . TABLE_PRODUCTS . " where products_id='" . (int) $products_filter . "'"); $check_type = $result->EOF ? 0 : $result->fields['products_type']; define('PRODUCT_INFO_PREVIOUS_NEXT_SORT', zen_get_configuration_key_value_layout('PRODUCT_INFO_PREVIOUS_NEXT_SORT', $check_type)); // sort order switch (PRODUCT_INFO_PREVIOUS_NEXT_SORT) { case 0: $prev_next_order = ' order by LPAD(p.products_id,11,"0")'; break; case 1: $prev_next_order = " order by pd.products_name"; break; case 2: $prev_next_order = " order by p.products_model"; break; case 3: $prev_next_order = " order by p.products_price, pd.products_name"; break; case 4:
/** * @package admin * @copyright Copyright 2003-2011 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0 * @version $Id: products_previous_next.php 18695 2011-05-04 05:24:19Z drbyte $ */ if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } // /// // BOF PREVIOUS NEXT if ($prev_next_list == '') { // calculate the previous and next $check_type = $db->Execute("select products_type from " . TABLE_PRODUCTS . " where products_id='" . (int) $products_filter . "'"); define('PRODUCT_INFO_PREVIOUS_NEXT_SORT', zen_get_configuration_key_value_layout('PRODUCT_INFO_PREVIOUS_NEXT_SORT', $check_type->fields['products_type'])); // sort order switch (PRODUCT_INFO_PREVIOUS_NEXT_SORT) { case 0: $prev_next_order = ' order by LPAD(p.products_id,11,"0")'; break; case 1: $prev_next_order = " order by pd.products_name"; break; case 2: $prev_next_order = " order by p.products_model"; break; case 3: $prev_next_order = " order by p.products_price, pd.products_name"; break; case 4: