[Sommaire] [Imprimer]

   1  <?php
   2  /**

   3   * specials sidebox - displays a random product "on special"

   4   *

   5   * @package templateSystem

   6   * @copyright Copyright 2003-2005 Zen Cart Development Team

   7   * @copyright Portions Copyright 2003 osCommerce

   8   * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

   9   * @version $Id: specials.php 2718 2005-12-28 06:42:39Z drbyte $

  10   */
  11  
  12  // test if box should display

  13    $show_specials= false;
  14  
  15    if (isset($_GET['products_id'])) {
  16      $show_specials= false;
  17    } else {
  18      $show_specials= true;
  19    }
  20  
  21    if ($show_specials == true) {
  22      $random_specials_sidebox_product_query = "select p.products_id, pd.products_name, p.products_price,
  23                                      p.products_tax_class_id, p.products_image,
  24                                      s.specials_new_products_price
  25                               from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
  26                                      . TABLE_SPECIALS . " s
  27                               where p.products_status = 1
  28                               and p.products_id = s.products_id
  29                               and pd.products_id = s.products_id
  30                               and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
  31                               and s.status = 1
  32                               limit " . MAX_RANDOM_SELECT_SPECIALS;
  33  
  34      $random_specials_sidebox_product = zen_random_select($random_specials_sidebox_product_query);
  35  
  36      if ($random_specials_sidebox_product->RecordCount() > 0)  {
  37        $specials_box_price = zen_get_products_display_price($random_specials_sidebox_product->fields['products_id']);
  38  
  39        require($template->get_template_dir('tpl_specials.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_specials.php');
  40        $title =  BOX_HEADING_SPECIALS;
  41        $title_link = FILENAME_SPECIALS;
  42        require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
  43      }
  44    }
  45  ?>