Quick Search:

Mode

Context

Displaying 3 lines of context. None | Less | More | Full

Other Diffs

Ignore

Blank Lines Whitespace:

Diff

368
  
383
  
383
  
reviews.php
_> 11 <?php
  22 /*
<> 3 -  $Id: reviews.php 368 2005-12-22 16:27:23Z hpdl $
   3+  $Id: reviews.php 383 2006-01-09 16:35:46Z hpdl $
44 
  55   osCommerce, Open Source E-Commerce Solutions
  66   http://www.oscommerce.com
      
 !
 
…
9090     }
  9191 
  9292     function getTotal($id) {
<> 93 -      global $osC_Database;
   93+      global $osC_Database, $osC_Language;
9494 
  9595       $Qcheck = $osC_Database->query('select count(*) as total from :table_reviews where products_id = :products_id and languages_id = :languages_id and reviews_status = 1 limit 1');
  9696       $Qcheck->bindTable(':table_reviews', TABLE_REVIEWS);
  9797       $Qcheck->bindInt(':products_id', $id);
<> 98 -      $Qcheck->bindInt(':languages_id', $_SESSION['languages_id']);
   98+      $Qcheck->bindInt(':languages_id', $osC_Language->getID());
9999       $Qcheck->execute();
  100100 
  101101       return $Qcheck->valueInt('total');
  102102     }
  103103 
  104104     function exists($id = null, $groupped = false) {
<> 105 -      global $osC_Database;
   105+      global $osC_Database, $osC_Language;
106106 
  107107       $Qcheck = $osC_Database->query('select reviews_id from :table_reviews where');
  108108 
      
 !
 
…
118118 
  119119       $Qcheck->appendQuery('languages_id = :languages_id and reviews_status = 1 limit 1');
  120120       $Qcheck->bindTable(':table_reviews', TABLE_REVIEWS);
<> 121 -      $Qcheck->bindInt(':languages_id', $_SESSION['languages_id']);
   121+      $Qcheck->bindInt(':languages_id', $osC_Language->getID());
122122       $Qcheck->execute();
  123123 
  124124       if ($Qcheck->numberOfRows() === 1) {
      
 !
 
…
140140     }
  141141 
  142142     function &getListing($id = null) {
<> 143 -      global $osC_Database;
   143+      global $osC_Database, $osC_Language;
144144 
  145145       if (is_numeric($id)) {
  146146         $Qreviews = $osC_Database->query('select reviews_id, reviews_text, reviews_rating, date_added, customers_name from :table_reviews where products_id = :products_id and languages_id = :languages_id and reviews_status = 1 order by reviews_id desc');
  147147         $Qreviews->bindInt(':products_id', $id);
<> 148 -        $Qreviews->bindInt(':languages_id', $_SESSION['languages_id']);
   148+        $Qreviews->bindInt(':languages_id', $osC_Language->getID());
149149       } else {
  150150         $Qreviews = $osC_Database->query('select r.reviews_id, left(r.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, r.customers_name, p.products_id, p.products_image, p.products_price, p.products_tax_class_id, pd.products_name, pd.products_keyword from :table_reviews r, :table_products p, :table_products_description pd where r.reviews_status = 1 and r.languages_id = :languages_id and r.products_id = p.products_id and p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id order by r.reviews_id desc');
  151151         $Qreviews->bindTable(':table_products', TABLE_PRODUCTS);
  152152         $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
<> 153 -        $Qreviews->bindInt(':languages_id', $_SESSION['languages_id']);
  154 -        $Qreviews->bindInt(':language_id', $_SESSION['languages_id']);
   153+        $Qreviews->bindInt(':languages_id', $osC_Language->getID());
   154+        $Qreviews->bindInt(':language_id', $osC_Language->getID());
155155       }
  156156       $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
  157157       $Qreviews->setBatchLimit((isset($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1), MAX_DISPLAY_NEW_REVIEWS);
      
 !
 
…
161161     }
  162162 
  163163     function &getEntry($id) {
<> 164 -      global $osC_Database;
   164+      global $osC_Database, $osC_Language;
165165 
  166166       $Qreviews = $osC_Database->query('select reviews_id, reviews_text, reviews_rating, date_added, customers_name from :table_reviews where reviews_id = :reviews_id and languages_id = :languages_id and reviews_status = 1');
  167167       $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
  168168       $Qreviews->bindInt(':reviews_id', $id);
<> 169 -      $Qreviews->bindInt(':languages_id', $_SESSION['languages_id']);
   169+      $Qreviews->bindInt(':languages_id', $osC_Language->getID());
170170       $Qreviews->execute();
  171171 
  172172       return $Qreviews;
  173173     }
  174174 
  175175     function saveEntry($data) {
<> 176 -      global $osC_Database;
   176+      global $osC_Database, $osC_Language;
177177 
  178178       $Qreview = $osC_Database->query('insert into :table_reviews (products_id, customers_id, customers_name, reviews_rating, languages_id, reviews_text, reviews_status, date_added) values (:products_id, :customers_id, :customers_name, :reviews_rating, :languages_id, :reviews_text, :reviews_status, now())');
  179179       $Qreview->bindTable(':table_reviews', TABLE_REVIEWS);
  180180       $Qreview->bindInt(':products_id', $data['products_id']);
  181181       $Qreview->bindInt(':customers_id', $data['customer_id']);
  182182       $Qreview->bindValue(':customers_name', $data['customer_name']);
  183183       $Qreview->bindValue(':reviews_rating', $data['rating']);
<> 184 -      $Qreview->bindInt(':languages_id', $_SESSION['languages_id']);
   184+      $Qreview->bindInt(':languages_id', $osC_Language->getID());
<_ 185185       $Qreview->bindValue(':reviews_text', $data['review']);
  186186       $Qreview->bindInt(':reviews_status', $data['status']);
  187187       $Qreview->execute();