[Sommaire] [Imprimer]

   1  <?php
   2  /**

   3   * reviews header_php.php 

   4   *

   5   * @package page

   6   * @copyright Copyright 2003-2006 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: header_php.php 3000 2006-02-09 21:11:37Z wilt $

  10   */
  11  
  12  require(DIR_WS_MODULES . zen_get_module_directory('require_languages.php'));
  13  
  14  
  15  // if review must be approved or is disabled, do not show review

  16  $review_status = " AND r.status = 1";
  17  $reviews_query_raw = "SELECT r.reviews_id, left(rd.reviews_text, 100) AS reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name 
  18                        FROM " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd 
  19                        WHERE p.products_status = '1' 
  20                        AND p.products_id = r.products_id 
  21                        AND r.reviews_id = rd.reviews_id 
  22                        AND p.products_id = pd.products_id 
  23                        AND pd.language_id = :languageID 
  24                        AND rd.languages_id = :languageID" . $review_status . " 
  25                        ORDER BY r.reviews_id DESC";
  26  
  27  $reviews_query_raw = $db->bindVars($reviews_query_raw, ':languageID', $_SESSION['languages_id'], 'integer');
  28  $reviews_query_raw = $db->bindVars($reviews_query_raw, ':languageID', $_SESSION['languages_id'], 'integer');
  29  $reviews_split = new splitPageResults($reviews_query_raw, MAX_DISPLAY_NEW_REVIEWS);
  30  
  31  $breadcrumb->add(NAVBAR_TITLE);
  32  ?>