Quick Search:

Mode

Context

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

Other Diffs

Ignore

Blank Lines Whitespace:

Diff

212
  
213
  
213
  
reviews.php
_> 11 <?php
  22 /*
<> 3 -  $Id: reviews.php 212 2005-10-04 07:55:32Z hpdl $
   3+  $Id: reviews.php 213 2005-10-05 10:37:33Z hpdl $
44 
  55   osCommerce, Open Source E-Commerce Solutions
  66   http://www.oscommerce.com
      
 !
 
…
101101       return $Qcheck->valueInt('total');
  102102     }
  103103 
<> 104 -    function exists($id = null) {
   104+    function exists($id = null, $groupped = false) {
105105       global $osC_Database;
  106106 
  107107       $Qcheck = $osC_Database->query('select reviews_id from :table_reviews where');
  108108 
  109109       if (is_numeric($id)) {
<> 110 -        $Qcheck->appendQuery('products_id = :products_id and');
  111 -        $Qcheck->bindInt(':products_id', $id);
   110+        if ($groupped === false) {
   111+          $Qcheck->appendQuery('reviews_id = :reviews_id and');
   112+          $Qcheck->bindInt(':reviews_id', $id);
   113+        } else {
   114+          $Qcheck->appendQuery('products_id = :products_id and');
   115+          $Qcheck->bindInt(':products_id', $id);
   116+        }
112117       }
  113118 
  114119       $Qcheck->appendQuery('languages_id = :languages_id and reviews_status = 1 limit 1');
      
 !
 
…
123128       return false;
  124129     }
  125130 
<>  131+    function getProductID($id) {
   132+      global $osC_Database;
   133+
   134+      $Qreview = $osC_Database->query('select products_id from :table_reviews where reviews_id = :reviews_id');
   135+      $Qreview->bindTable(':table_reviews', TABLE_REVIEWS);
   136+      $Qreview->bindInt(':reviews_id', $id);
   137+      $Qreview->execute();
   138+
   139+      return $Qreview->valueInt('products_id');
   140+    }
   141+
126142     function &getListing($id = null) {
  127143       global $osC_Database;
  128144 
<> 129 -      $Qreviews = $osC_Database->query('select r.reviews_id, left(r.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, p.products_id, pd.products_name, p.products_image, r.customers_name from :table_reviews r, :table_products p, :table_products_description pd where r.reviews_status = 1 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 and r.languages_id = :languages_id order by r.reviews_id desc');
   145+      if (is_numeric($id)) {
   146+        $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');
   147+        $Qreviews->bindInt(':products_id', $id);
   148+        $Qreviews->bindInt(':languages_id', $_SESSION['languages_id']);
   149+      } else {
   150+        $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_model, p.products_image, p.products_price, p.products_tax_class_id, pd.products_name 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');
   151+        $Qreviews->bindTable(':table_products', TABLE_PRODUCTS);
   152+        $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
   153+        $Qreviews->bindInt(':languages_id', $_SESSION['languages_id']);
   154+        $Qreviews->bindInt(':language_id', $_SESSION['languages_id']);
   155+      }
130156       $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
<> 131 -      $Qreviews->bindTable(':table_products', TABLE_PRODUCTS);
  132 -      $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION);
  133 -      $Qreviews->bindInt(':language_id', $_SESSION['languages_id']);
  134 -      $Qreviews->bindInt(':languages_id', $_SESSION['languages_id']);
135157       $Qreviews->setBatchLimit((isset($_GET['page']) && is_numeric($_GET['page']) ? $_GET['page'] : 1), MAX_DISPLAY_NEW_REVIEWS);
  136158       $Qreviews->execute();
  137159 
  138160       return $Qreviews;
  139161     }
<>  162+
   163+    function &getEntry($id) {
   164+      global $osC_Database;
   165+
   166+      $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');
   167+      $Qreviews->bindTable(':table_reviews', TABLE_REVIEWS);
   168+      $Qreviews->bindInt(':reviews_id', $id);
   169+      $Qreviews->bindInt(':languages_id', $_SESSION['languages_id']);
   170+      $Qreviews->execute();
   171+
   172+      return $Qreviews;
   173+    }
140174   }   
<_ 141 -?>
   175+?>