<?php
/*
  www.oscGold.com (C) Kamelia-Net Jacek Krysiak
  modul oscGold wer 4.0
*/
$tablica_kat = explode(',',$column['dodatkowe_info']);
//
if ($tablica_kat != '') {
    $ciag = '';
    for ($indes=0;$indes<count($tablica_kat);$indes++) {
        $ciag .= "and c.categories_id != '" . $tablica_kat[$indes] . "'";
    }
}
//

if (isset($current_category_id) && ($current_category_id > 0)) {
        $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and c.categories_status = '1' and p.products_ordered > 0 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 and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) ".$ciag." order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
} else {
        $best_sellers_query = tep_db_query("select distinct p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c  where p.products_status = '1' and c.categories_status = '1' and p.products_ordered > 0 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 ".$ciag." order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
}

if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS && (int)tep_db_num_rows($best_sellers_query) > 0) {
     $boxHeading = BOX_HEADING_BESTSELLERS;
     $corner_left = 'rounded';
     $corner_right = 'rounded';

     $box_base_name = 'best_sellers';
     $boxContent_attributes = ' align="center"';
     $box_id = $box_base_name . 'Box';


     $boxContent = '<div class="box_kont">';
     while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {
        $boxContent .= '<div class="box_list"><a class="boxLink" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . osc_trunc_string($best_sellers['products_name'], 50, 1) . '</a></div>';   
        if (file_exists(DIR_WS_TEMPLATES . 'images/infobox/category_line.gif')) {
            $boxContent .= '<div class="box_line">' . tep_image(DIR_WS_TEMPLATES . 'images/infobox/category_line.gif') . '</div>';
        }            
     }
     $boxContent .= '</div>';
     $boxContent = optimize_html($boxContent);

     include (bts_select('boxes', $box_base_name)); // BTS 1.5
}
?>