Zen Cart 源代码 featured.php

下载文件

文件名: featured.php
文件类型: PHP文件
文件大小: 1.88 KiB
MD5: 496ce52a735b3052c13a09514197f006

featured.php - 打开高亮: <?php /** * featured sidebox - displays a random Featured Product * * @package templateSystem * @copyright Copyright 2003-2007 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: featured.php 6475 2007-06-08 21:10:33Z ajeh $ */ // test if box should display $show_featured= true; if ($show_featured == true) { $random_featured_products_query = "select p.products_id, p.products_image, pd.products_name, p.master_categories_id from (" . TABLE_PRODUCTS . " p left join " . TABLE_FEATURED . " f on p.products_id = f.products_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id ) where p.products_id = f.products_id and p.products_id = pd.products_id and p.products_status = 1 and f.status = 1 and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'"; // randomly select ONE featured product from the list retrieved: //$random_featured_product = zen_random_select($random_featured_products_query); $random_featured_product = $db->ExecuteRandomMulti($random_featured_products_query, MAX_RANDOM_SELECT_FEATURED_PRODUCTS); if ($random_featured_product->RecordCount() > 0) { require($template->get_template_dir('tpl_featured.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_featured.php'); $title = BOX_HEADING_FEATURED_PRODUCTS; $title_link = FILENAME_FEATURED_PRODUCTS; require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default); } } ?>