}
$wats_new_query = "SELECT distinct\n p.products_id,\n pd.products_name,\n p.products_fsk18,\n p.products_image,\n p.products_tax_class_id,\n p.products_vpe,\n p.products_vpe_status,\n p.products_vpe_value,\n p.products_price,\n IFNULL(cd3.categories_name, IFNULL(cd2.categories_name, IFNULL(cd1.categories_name, cd.categories_name))) as categories_name\n FROM " . TABLE_PRODUCTS . " p\n\t\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p.products_id \n\t\t\t\t\t\t\tAND pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n\t\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id = p.products_id\n\t\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = ptc.categories_id\n\t\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id = c.categories_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c1 ON c1.categories_id = c.parent_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd1 ON cd1.categories_id = c1.categories_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c2 ON c2.categories_id = c1.parent_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd2 ON cd2.categories_id = c2.categories_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c3 ON c3.categories_id = c2.parent_id\n\t\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd3 ON cd3.categories_id = c3.categories_id \n WHERE p.products_status=1\n\t\t\t\t\tAND p.products_startpage = 1\n\t\t\t\t\t" . $group_check . "\n\t\t\t\t\t" . $fsk_lock . "\n\t\t\t\t\tand c.categories_status=1";
$news_by_date = " ORDER BY p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS;
if ($cache) {
$box_whats_new = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_tops_list.html', $cache_id);
} else {
$wats_new_query = vamDBquery($wats_new_query . $news_by_date);
// если новинок нет выбрать те что отмечены "на главной"
if (vam_db_num_rows($wats_new_query, true) == 0) {
$news_by_marked = " AND p.products_startpage = 1 limit " . MAX_DISPLAY_NEW_PRODUCTS;
$wats_new_query = vamDBquery($wats_new_query . $news_by_marked);
}
if (vam_db_num_rows($wats_new_query, true) >= 0) {
$rows = 0;
$box_content = array();
while ($wats_new = vam_db_fetch_array($wats_new_query, true)) {
$rows++;
$wats_new = array_merge($wats_new, array('ID' => vam_row_number_format($rows)));
$box_content[] = $product->buildDataArray($wats_new);
}
$box->assign('box_content', $box_content);
$box->assign('box_mark', 'news_mark');
$box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/');
$box->assign('language', $_SESSION['language']);
$box->assign('see_all_url', '/products_new.php');
}
if ($box_content != '') {
$box_whats_new = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_tops_list.html');
}
}
$vamTemplate->assign('box_WHATSNEW', $box_whats_new);
$fsk_lock = '';
if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') {
$fsk_lock = ' and p.products_fsk18!=1';
}
if (GROUP_CHECK == 'true') {
$group_check = " and p.group_permission_" . $_SESSION['customers_status']['customers_status_id'] . "=1 ";
}
$best_sellers_query = "SELECT\r\n p.products_id,\r\n pd.products_name,\r\n p.products_price,\r\n p.products_tax_class_id,\r\n p.products_image,\r\n p.products_fsk18,\r\n p.products_vpe,\r\n p.products_vpe_status,\r\n p.products_vpe_value,\r\n\t\t\t\t\t IFNULL(cd3.categories_name, IFNULL(cd2.categories_name, IFNULL(cd1.categories_name, cd.categories_name))) as categories_name\r\n FROM " . TABLE_PRODUCTS . " p \r\n\t\t\t\t\tINNER JOIN " . TABLE_FEATURED . " s ON s.products_id = p.products_id AND s.status = '1'\r\n\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p.products_id \r\n\t\t\t\t\t\t\tAND pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\r\n\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id = p.products_id\r\n\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = ptc.categories_id\r\n\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id = c.categories_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c1 ON c1.categories_id = c.parent_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd1 ON cd1.categories_id = c1.categories_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c2 ON c2.categories_id = c1.parent_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd2 ON cd2.categories_id = c2.categories_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c3 ON c3.categories_id = c2.parent_id\r\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd3 ON cd3.categories_id = c3.categories_id \r\n " . $group_check . "\r\n " . $fsk_lock . " LIMIT " . MAX_RANDOM_SELECT_FEATURED;
// set cache ID
if ($cache) {
$box_best_sellers = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_tops_list.html', $cache_id);
$vamTemplate->assign('box_BESTSELLERS', $box_best_sellers);
} else {
$best_sellers_query = vamDBquery($best_sellers_query);
//if (vam_db_num_rows($best_sellers_query, true) == 0)
//$best_sellers_query = vamDBquery($on_start_products_query);
$rows = 0;
$box_content = array();
while ($best_sellers = vam_db_fetch_array($best_sellers_query, true)) {
$rows++;
$best_sellers = array_merge($best_sellers, array('ID' => vam_row_number_format($rows)));
$box_content[] = $product->buildDataArray($best_sellers);
}
$box->assign('box_content', $box_content);
$box->assign('box_mark', 'best_sellers_mark');
$box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/');
$box->assign('language', $_SESSION['language']);
$box->assign('see_all_url', '/featured.php');
$box_best_sellers = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_tops_list.html');
$vamTemplate->assign('box_BESTSELLERS', $box_best_sellers);
}
$featured_query_1 = "SELECT\n p.products_id,\n pd.products_name,\n p.products_price,\n p.products_tax_class_id,\n p.products_image,\n p.products_fsk18,\n p.products_vpe,\n p.products_vpe_status,\n p.products_vpe_value,\n\t\t\t\t\t IFNULL(cd3.categories_name, IFNULL(cd2.categories_name, IFNULL(cd1.categories_name, cd.categories_name))) as categories_name\n FROM " . TABLE_PRODUCTS . " p \n\t\t\t\t\tINNER JOIN " . TABLE_FEATURED . " s ON s.products_id = p.products_id AND s.status = '2'\n\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p.products_id \n\t\t\t\t\t\t\tAND pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id = p.products_id\n\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = ptc.categories_id\n\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id = c.categories_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c1 ON c1.categories_id = c.parent_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd1 ON cd1.categories_id = c1.categories_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c2 ON c2.categories_id = c1.parent_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd2 ON cd2.categories_id = c2.categories_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c3 ON c3.categories_id = c2.parent_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd3 ON cd3.categories_id = c3.categories_id \n " . $group_check . "\n " . $fsk_lock . " LIMIT " . MAX_RANDOM_SELECT_FEATURED;
$featured_query_2 = "\n\t\t\t\tSELECT\n p.products_id,\n pd.products_name,\n p.products_price,\n p.products_tax_class_id,\n p.products_image,\n p.products_fsk18,\n p.products_vpe,\n p.products_vpe_status,\n p.products_vpe_value,\n\t\t\t\t\t IFNULL(cd3.categories_name, IFNULL(cd2.categories_name, IFNULL(cd1.categories_name, cd.categories_name))) as categories_name\n FROM " . TABLE_PRODUCTS . " p \n\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd ON pd.products_id = p.products_id \n\t\t\t\t\t\t\tAND pd.language_id = '" . (int) $_SESSION['languages_id'] . "'\n\t\t\t\t\tINNER JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " ptc ON ptc.products_id = p.products_id\n\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES . " c ON c.categories_id = ptc.categories_id\n\t\t\t\t\tINNER JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd ON cd.categories_id = c.categories_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c1 ON c1.categories_id = c.parent_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd1 ON cd1.categories_id = c1.categories_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c2 ON c2.categories_id = c1.parent_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd2 ON cd2.categories_id = c2.categories_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES . " c3 ON c3.categories_id = c2.parent_id\n\t\t\t\t\tLEFT JOIN " . TABLE_CATEGORIES_DESCRIPTION . " cd3 ON cd3.categories_id = c3.categories_id \n " . $group_check . "\n " . $fsk_lock . "\n WHERE p.products_startpage = 1 LIMIT " . MAX_RANDOM_SELECT_FEATURED;
// set cache ID
if (!CacheCheck()) {
$box->caching = 0;
$featured_query = vamDBquery($featured_query_1);
// если новинок нет выбрать те что отмечены "на главной"
if (vam_db_num_rows($featured_query, true) == 0) {
$featured_query = vamDBquery($featured_query_2);
}
if (vam_db_num_rows($featured_query, true) >= 0) {
$rows = 0;
$box_content = array();
while ($featured = vam_db_fetch_array($featured_query, true)) {
$rows++;
$featured = array_merge($featured, array('ID' => vam_row_number_format($rows)));
$box_content[] = $product->buildDataArray($featured);
}
$box->assign('box_content', $box_content);
$box->assign('box_mark', 'action_mark');
$box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/');
$box->assign('language', $_SESSION['language']);
$box->assign('see_all_url', '/shop_content.php?coID=12');
$box_featured = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_tops_list.html');
}
} else {
$box->caching = 1;
$box->cache_lifetime = CACHE_LIFETIME;
$box->cache_modified_check = CACHE_CHECK;
$cache_id = $_SESSION['language'] . '44' . $_SESSION['customers_status']['customers_status_name'];
$box_specials = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_tops_list.html', $cache_id);
