Diff
556
583
583
reviews.php
  |
1 | 1 | | <?php |
| |
2 | 2 | | /* |
 |
3 | | - | $Id: reviews.php 556 2006-04-30 23:57:23Z hpdl $ |
| |
| 3 | + | $Id: reviews.php 583 2006-06-29 13:12:20Z hpdl $ |
|
4 | 4 | | |
| |
5 | 5 | | osCommerce, Open Source E-Commerce Solutions |
| |
6 | 6 | | http://www.oscommerce.com |
| |
|
|
 |
… |
|
147 | 147 | | $Qreviews->bindInt(':products_id', $id); |
| |
148 | 148 | | $Qreviews->bindInt(':languages_id', $osC_Language->getID()); |
| |
149 | 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_price, p.products_tax_class_id, pd.products_name, pd.products_keyword, i.image from :table_reviews r, :table_products p left join :table_products_images i on (p.products_id = i.products_id and i.products_images_groups_id = :products_images_groups_id), :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'); |
| |
| 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_price, p.products_tax_class_id, pd.products_name, pd.products_keyword, i.image from :table_reviews r, :table_products p left join :table_products_images i on (p.products_id = i.products_id and i.products_images_groups_id = :products_images_groups_id and i.default_flag = :default_flag), :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 | 151 | | $Qreviews->bindTable(':table_products', TABLE_PRODUCTS); |
| |
152 | 152 | | $Qreviews->bindTable(':table_products_images', TABLE_PRODUCTS_IMAGES); |
| |
153 | 153 | | $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION); |
|
154 | | - | $Qreviews->bindTable(':products_images_groups_id', $osC_Image->getID('default')); |
| |
| 154 | + | $Qreviews->bindInt(':products_images_groups_id', $osC_Image->getID('default')); |
| |
| 155 | + | $Qreviews->bindInt(':default_flag', 1); |
|
155 | 156 | | $Qreviews->bindInt(':languages_id', $osC_Language->getID()); |
| |
156 | 157 | | $Qreviews->bindInt(':language_id', $osC_Language->getID()); |
| |
157 | 158 | | } |
|