function rss_feed_title($feed = false)
{
global $current_category_id;
if (!$feed) {
$feed = $_GET['feed'];
} else {
if (($i = strpos($feed, '&')) !== false) {
$feed_args = substr($feed, $i + 1);
$feed = substr($feed, 0, $i);
}
}
switch (true) {
case $feed == 'news':
$title = TEXT_RSS_NEWS;
break;
case $feed == 'categories':
$title = TEXT_RSS_CATEGORIES;
if (isset($_GET['cPath']) && $current_category_id > 0) {
$title .= RSS_TITLE_DELIMITER2 . strip_tags(zen_get_categories_name((int) $current_category_id));
}
break;
case $feed == 'specials_random':
case $feed == 'specials':
$title = TEXT_RSS_SPECIALS;
break;
case $feed == 'featured_random':
case $feed == 'featured':
$title = TEXT_RSS_FEATURED_PRODUCTS;
break;
case $feed == 'best_sellers_random':
case $feed == 'best_sellers':
$title = TEXT_RSS_BEST_SELLERS;
break;
case $feed == 'upcoming_random':
case $feed == 'upcoming':
$title = TEXT_RSS_UPCOMING_PRODUCTS;
break;
case $feed == 'new_products_random':
case $feed == 'new_products':
$title = TEXT_RSS_PRODUCTS_NEW;
break;
case $feed == 'products':
if (isset($_GET['products_id'])) {
$title = TEXT_RSS_PRODUCT . RSS_TITLE_DELIMITER2 . strip_tags(zen_get_products_name((int) $_GET['products_id']));
} elseif (isset($_GET['cPath']) && $current_category_id > 0) {
$title = TEXT_RSS_PRODUCTS . RSS_TITLE_DELIMITER2 . strip_tags(zen_get_categories_name((int) $current_category_id));
} else {
$title = TEXT_RSS_PRODUCTS_ALL;
}
break;
default:
$title = TEXT_RSS_FEED;
break;
}
return $title;
}
$num_products_count = $new_products_query == '' ? 0 : $new_products->RecordCount();
// show only when 1 or more
if ($num_products_count > 0) {
if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS == 0) {
$col_width = floor(100 / $num_products_count);
} else {
$col_width = floor(100 / SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS);
}
while (!$new_products->EOF) {
$products_price = zen_get_products_display_price($new_products->fields['products_id']);
if (!isset($productsInCategory[$new_products->fields['products_id']])) {
$productsInCategory[$new_products->fields['products_id']] = zen_get_generated_category_path_rev($new_products->fields['master_categories_id']);
}
$list_box_contents[$row][$col] = array('params' => 'class="centerBoxContentsNew centeredContent back"' . ' ' . 'style="width:' . $col_width . '%;"', 'text' => (($new_products->fields['products_image'] == '' and PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0) ? '' : '<a href="' . zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'cPath=' . $productsInCategory[$new_products->fields['products_id']] . '&products_id=' . $new_products->fields['products_id']) . '">' . zen_image(DIR_WS_IMAGES . $new_products->fields['products_image'], $new_products->fields['products_name'], IMAGE_PRODUCT_NEW_WIDTH, IMAGE_PRODUCT_NEW_HEIGHT) . '</a><br />') . '<a href="' . zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'cPath=' . $productsInCategory[$new_products->fields['products_id']] . '&products_id=' . $new_products->fields['products_id']) . '">' . $new_products->fields['products_name'] . '</a><br />' . $products_price);
$col++;
if ($col > SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS - 1) {
$col = 0;
$row++;
}
$new_products->MoveNextRandom();
}
if ($new_products->RecordCount() > 0) {
if (isset($new_products_category_id) && $new_products_category_id != 0) {
$category_title = zen_get_categories_name((int) $new_products_category_id);
$title = '<h2 class="centerBoxHeading">' . sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')) . ($category_title != '' ? ' - ' . $category_title : '') . '</h2>';
} else {
$title = '<h2 class="centerBoxHeading">' . sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')) . '</h2>';
}
$zc_show_new_products = true;
}
}
// if ((zen_get_categories_image(zen_get_products_category_id((int)$_GET['products_id']))) !='') {
switch (true) {
case $module_show_categories == '1':
$align = 'left';
break;
case $module_show_categories == '2':
$align = 'center';
break;
case $module_show_categories == '3':
$align = 'right';
break;
}
//echo 'I SEE ' . $cPath . ' vs ' . $current_category_id;
//$category_icon_display_name = zen_get_categories_name(zen_get_products_category_id((int)$_GET['products_id']), $_SESSION['languages_id']);
//$category_icon_display_image = zen_get_categories_image(zen_get_products_category_id((int)$_GET['products_id']));
$category_icon_display_name = zen_get_categories_name((int) $current_category_id);
$category_icon_display_image = zen_get_categories_image((int) $current_category_id);
switch (true) {
// name only
case PRODUCT_INFO_CATEGORIES_IMAGE_STATUS == 1:
$category_icon_display_image = '';
break;
// name and image but name only when blank
// name and image but name only when blank
case PRODUCT_INFO_CATEGORIES_IMAGE_STATUS == 2 && $category_icon_display_image == '':
$category_icon_display_image = '';
break;
default:
// name and image always display image regardless
$category_icon_display_image = zen_image(DIR_WS_IMAGES . $category_icon_display_image, $category_icon_display_name, CATEGORY_ICON_IMAGE_WIDTH, CATEGORY_ICON_IMAGE_HEIGHT) . '<br />';
break;
<?php /** * Module Template * * @package templateSystem * @copyright Copyright 2003-2005 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: tpl_modules_category_icon_display.php 2747 2005-12-31 06:05:37Z ajeh $ */ require DIR_WS_MODULES . zen_get_module_directory(FILENAME_CATEGORY_ICON_DISPLAY); ?> <div align="<?php echo $align; ?> " id="categoryIcon" class="categoryIcon"><?php echo '<a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new, 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . zen_get_categories_image(zen_get_products_category_id((int) $_GET['products_id'])), zen_get_categories_name(zen_get_products_category_id((int) $_GET['products_id']), $_SESSION['languages_id']), CATEGORY_ICON_IMAGE_WIDTH, CATEGORY_ICON_IMAGE_HEIGHT) . '<br />' . zen_get_categories_name(zen_get_products_category_id((int) $_GET['products_id']), $_SESSION['languages_id']) . '</a>'; ?> </div>
function block_xsell_products()
{
global $db;
$return = array();
$products = array();
$title = '';
$query = "\r\n select distinct\r\n p.products_id, p.products_image,\r\n pd.products_name,\r\n pt.type_handler,\r\n mf.manufacturers_name\r\n from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p\r\n LEFT JOIN " . TABLE_PRODUCT_TYPES . " pt ON p.products_type = pt.type_id\r\n LEFT JOIN " . TABLE_MANUFACTURERS . " mf ON p.manufacturers_id = mf.manufacturers_id\r\n ," . TABLE_PRODUCTS_DESCRIPTION . " pd\r\n where xp.products_id = '" . (int) $_GET['products_id'] . "'\r\n and xp.xsell_id = p.products_id\r\n and p.products_id = pd.products_id\r\n and pd.language_id = '" . $_SESSION['languages_id'] . "'\r\n and p.products_status = 1\r\n order by xp.sort_order asc limit " . (int) MODULE_CAROUSEL_UI_MAX_DISPLAY_XSELL_PRODUCTS;
$result = $db->Execute($query);
while (!$result->EOF) {
$id = $result->fields['products_id'];
$name = $result->fields['products_name'];
$image = $result->fields['products_image'];
$manufacturers = $result->fields['manufacturers_name'];
if ($result->fields['type_handler'] == '') {
$type_handler = 'product_info';
} else {
$type_handler = $result->fields['type_handler'] . '_info';
}
$link = zen_href_link($type_handler, 'products_id=' . $id);
$price = zen_get_products_display_price($id);
$products[] = array('id' => $id, 'name' => $name, 'image' => $image, 'link' => $link, 'price' => $price, 'manufacturers' => $manufacturers);
$result->MoveNext();
}
if (count($products) > 0) {
// 表示件数の倍になるようにする
$visibleCount = (int) MODULE_CAROUSEL_UI_CONF_VISIBLE_XSELL_PRODUCTS;
if ($visibleCount == 0) {
$visibleCount = 1;
}
$addCount = count($products) % $visibleCount;
if ($addCount > 0) {
$addCount = $visibleCount - $addCount;
}
for ($i = 0; $i < $addCount; $i++) {
$products[] = array('id' => 0, 'name' => '', 'image' => '', 'link' => '', 'price' => '', 'manufacturers' => '');
}
if (isset($parent_id) && $parent_id != 0) {
$category_title = zen_get_categories_name((int) $parent_id);
$title = sprintf(MODULE_CAROUSEL_UI_BLOCK_XSELL_PRODUCTS_TITLE, strftime('%B')) . ($category_title != '' ? ' - ' . $category_title : '');
} else {
$title = sprintf(MODULE_CAROUSEL_UI_BLOCK_XSELL_PRODUCTS_TITLE, strftime('%B'));
}
$return['title'] = $title;
$return['products'] = $products;
$return['ui_conf'] = array('auto' => (int) MODULE_CAROUSEL_UI_CONF_AUTO_XSELL_PRODUCTS, 'speed' => (int) MODULE_CAROUSEL_UI_CONF_SPEED_XSELL_PRODUCTS, 'vertical' => MODULE_CAROUSEL_UI_CONF_VERTICAL_XSELL_PRODUCTS == 'true' ? 'true' : 'false', 'circular' => MODULE_CAROUSEL_UI_CONF_CIRCULAR_XSELL_PRODUCTS == 'true' ? 'true' : 'false', 'visible' => (int) MODULE_CAROUSEL_UI_CONF_VISIBLE_XSELL_PRODUCTS, 'scroll' => (int) MODULE_CAROUSEL_UI_CONF_SCROLL_XSELL_PRODUCTS);
}
if ((int) MODULE_CAROUSEL_UI_CONF_VISIBLE_XSELL_PRODUCTS < count($products)) {
$return['prevbutton'] = $this->imageButton(BUTTON_IMAGE_CAROUSEL_UI_PREVIOUS, BUTTON_CAROUSEL_UI_PREVIOUS_ALT, 'class="imgover"');
$return['nextbutton'] = $this->imageButton(BUTTON_IMAGE_CAROUSEL_UI_NEXT, BUTTON_CAROUSEL_UI_NEXT_ALT, 'class="imgover"');
} else {
$return['prevbutton'] = $this->imageButton(BUTTON_IMAGE_CAROUSEL_UI_PREVIOUS_DISABLED, BUTTON_CAROUSEL_UI_DISABLED_ALT, '');
$return['nextbutton'] = $this->imageButton(BUTTON_IMAGE_CAROUSEL_UI_NEXT_DISABLED, BUTTON_CAROUSEL_UI_DISABLED_ALT, '');
}
return $return;
}
if ($num_products_count > 0) {
$title = '';
if ($num_products_count < SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS || SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS == 0) {
$col_width = floor(100 / $num_products_count);
} else {
$col_width = floor(100 / SHOW_PRODUCT_INFO_COLUMNS_NEW_PRODUCTS);
}
while (!$new_products->EOF) {
$the_categories_name_query = "select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id= '" . $new_products->fields['master_categories_id'] . "' and language_id= '" . $_SESSION['languages_id'] . "'";
$the_categories_name = $db->Execute($the_categories_name_query, null, true, CACHE_TIMELIFT);
$tpl_products['products'][$new_products->fields['products_id']] = array('id' => $new_products->fields['products_id'], 'name' => zen_get_products_name($new_products->fields['products_id']), 'href' => zen_href_link(zen_get_info_page($new_products->fields['products_id']), 'cPath=' . $productsInCategory[$new_products->fields['products_id']] . '&products_id=' . $new_products->fields['products_id']), 'display_price' => zen_get_products_display_price($new_products->fields['products_id']), 'image' => $new_products->fields['products_image'] == '' && PRODUCTS_IMAGE_NO_IMAGE_STATUS == 0 ? '' : $new_products->fields['products_image'], 'tax_class_id' => $new_products->fields['products_tax_class_id'], 'date_added' => $new_products->fields['products_date_added'], 'type' => $new_products->fields['products_type'], 'categories_id' => $new_products->fields['master_categories_id'], 'categories_name' => $the_categories_name->fields['categories_name'], 'categories_href' => zen_href_link(FILENAME_DEFAULT, 'cPath=' . $new_products->fields['master_categories_id']), 'is_call' => $new_products->fields['product_is_call'] ? true : false, 'is_free' => $new_products->fields['product_is_free'] == '1' ? true : false, 'display_normal_price' => get_normal_price($new_products->fields['products_id']), 'display_special_price' => get_special_price($new_products->fields['products_id']), 'display_sale_price' => get_sale_discount_price($new_products->fields['products_id']), 'content' => $new_products->fields['products_description']);
$new_products->MoveNext();
}
if (!empty($show_select_product_id)) {
//sort
$show_select_product_id = explode(',', $show_select_product_id);
$tpl_tmp_product = $tpl_products['products'];
$tpl_products['products'] = array();
foreach ($show_select_product_id as $tmp_id) {
$tpl_products['products'][$tmp_id] = $tpl_tmp_product[$tmp_id];
}
unset($tpl_tmp_product, $tmp_id);
}
if ($new_products->RecordCount() > 0) {
if (isset($new_products_category_id) && $new_products_category_id != 0) {
$tpl_products['title'] = zen_get_categories_name((int) $new_products_category_id);
} else {
}
$zc_show_new_products = true;
}
}
// display order dropdown
$disp_order_default = PRODUCT_NEW_LIST_SORT_DEFAULT;
require DIR_WS_MODULES . zen_get_module_directory(FILENAME_LISTING_DISPLAY_ORDER);
//var $order_by
$products_new_array = array();
// display limits
// $display_limit = zen_get_products_new_timelimit();
//#################category filter###################
$products_new_query_raw = "SELECT p.products_id, p.products_type, pd.products_name, p.products_image, p.products_price,\n\t\t\t\t\t\t\t\t\t\tp.products_tax_class_id, p.products_date_added, p.products_model,\n\t\t\t\t\t\t\t\t\t\tp.products_quantity, p.products_weight, p.product_is_call,\n\t\t\t\t\t\t\t\t\t\tp.product_is_always_free_shipping, p.products_qty_box_status,\n\t\t\t\t\t\t\t\t\t\tp.master_categories_id\n\t\t\t\t\t\t\t\t FROM " . TABLE_PRODUCTS . " p\n\t\t\t\t\t\t\t\t LEFT JOIN " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c\n\t\t\t\t\t\t\t\t ON (p.products_id = p2c.products_id ), " . TABLE_PRODUCTS_DESCRIPTION . " pd\n\t\t\t\t\t\t\t\t WHERE p.products_status = 1\n\t\t\t\t\t\t\t\t AND p.products_id = pd.products_id \n\t\t\t\t\t\t\t\t AND p.master_categories_id=p2c.categories_id \n\t\t\t\t\t\t\t\t :category_fitler_str \t\t\t\t\t\t \n\t\t\t\t\t\t\t\t AND pd.language_id = :languageID order by rand() limit 5";
$products_new_query_raw = $db->bindVars($products_new_query_raw, ':languageID', $_SESSION['languages_id'], 'integer');
$recommend_products_result = array();
$recommend_products_cat_name = array();
foreach ($recommend_new_products_listing_filtered_categories as $parent_cat_id) {
$allowed_cate_sql = 'select distinct categories_id from ' . TABLE_CATEGORIES . '
where categories_status=1
and parent_id = ' . $parent_cat_id . ' ';
$allowed_cate_db = $db->Execute($allowed_cate_sql);
$allowed_cate_id = array($parent_cat_id);
while (!$allowed_cate_db->EOF) {
$allowed_cate_id[] = $allowed_cate_db->fields['categories_id'];
$allowed_cate_db->MoveNext();
}
$category_fitler_str = ' and p.master_categories_id in(' . implode(',', $allowed_cate_id) . ') ';
$sql = str_replace(':category_fitler_str', $category_fitler_str, $products_new_query_raw);
if ($_GET['test']) {
//echo $sql.'<br><br><br>';
}
$check_products_all = $db->Execute($sql);
$recommend_products_result[] = $check_products_all;
$recommend_products_cat_name[] = array('cat_name' => zen_get_categories_name($parent_cat_id), 'link' => zen_href_link(FILENAME_DEFAULT, '&cPath=' . $parent_cat_id));
}
case $module_show_categories == '3':
$align = 'right';
break;
}
if ($module_next_previous != '3') {
?>
<tr>
<td colspan="3" align="<?php
echo $align;
?>
">
<?php
echo '<a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new, 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . zen_get_categories_image(zen_get_products_category_id((int) $_GET['products_id'])), zen_get_categories_name(zen_get_products_category_id((int) $_GET['products_id']), $_SESSION['languages_id']), HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT, ' align="middle"') . '</a>';
?>
<?php
echo '<a href="' . zen_href_link(FILENAME_DEFAULT, $cPath_new, 'NONSSL') . '">' . zen_get_categories_name(zen_get_products_category_id((int) $_GET['products_id']), $_SESSION['languages_id']) . '</a>';
?>
</td>
</tr>
<?php
}
// don't show when top and bottom
}
}
?>
<tr>
<td align="center" class="smallText" colspan="3"><?php
echo PREV_NEXT_PRODUCT;
echo $position + 1 . "/" . $counter;
?>
</td>
if (!$this_is_home_page && $categories_displayTypes == 1) {
if (zen_has_category_subcategories($current_category_id)) {
$topSelling_subcategories = array();
zen_get_subcategories($topSelling_subcategories, $current_category_id);
$topSelling_subcategories_str = implode(' or pt.categories_id = ', $topSelling_subcategories);
$suffix_sql = ' AND ( pt.categories_id =' . $topSelling_subcategories_str . ')';
} else {
$suffix_sql = ' AND pt.categories_id = \'' . $current_category_id . '\'';
}
$topSellingQuery = "SELECT p.`products_id`,p.`products_image`, pd.`products_name` \n FROM products p, products_description pd,products_to_categories pt\n WHERE pd.`language_id` = {$_SESSION['languages_id']} AND p.`products_status` = 1 AND pt.products_id=p.products_id AND pd.products_id=p.products_id " . $suffix_sql . "\n ORDER BY p.`products_ordered` DESC LIMIT 5";
$topSelling = $db->Execute($topSellingQuery);
if ($topSelling->RecordCount() > 0) {
?>
<div class="allborder pad_10px">
<h2 class="red"><?php
echo BASE_COMMON_TEXT_TOPSELLINGIN . zen_get_categories_name($current_category_id);
?>
</h2>
<ul class="top_selling">
<?php
while (!$topSelling->EOF) {
?>
<li>
<a title="<?php
echo $topSelling->fields['products_name'];
?>
" href="<?php
echo zen_href_link(zen_get_info_page($topSelling->fields['products_id']), 'products_id=' . $topSelling->fields['products_id']);
?>
"><?php
echo zen_image_OLD(DIR_WS_IMAGES . $topSelling->fields['products_image'], $topSelling->fields['products_name'], 42, 42, 'class="fl"');
