* @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: