  |
1 | 1 | | <?php |
| |
2 | 2 | | /* |
 |
3 | | - | $Id: reviews.php 377 2006-01-09 14:47:49Z hpdl $ |
| |
| 3 | + | $Id: reviews.php 555 2006-04-30 22:28:59Z hpdl $ |
|
4 | 4 | | |
| |
5 | 5 | | osCommerce, Open Source E-Commerce Solutions |
| |
6 | 6 | | http://www.oscommerce.com |
| |
7 | 7 | | |
|
8 | | - | Copyright (c) 2004 osCommerce |
| |
| 8 | + | Copyright (c) 2006 osCommerce |
|
9 | 9 | | |
| |
10 | 10 | | Released under the GNU General Public License |
| |
11 | 11 | | */ |
| |
|
|
 |
… |
|
140 | 140 | | } |
| |
141 | 141 | | |
| |
142 | 142 | | function &getListing($id = null) { |
|
143 | | - | global $osC_Database, $osC_Language; |
| |
| 143 | + | global $osC_Database, $osC_Language, $osC_Image; |
|
144 | 144 | | |
| |
145 | 145 | | if (is_numeric($id)) { |
| |
146 | 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 | 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_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'); |
| |
| 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_images i on (p.products_id = i.for_id and i.images_groups_id = :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'); |
|
151 | 151 | | $Qreviews->bindTable(':table_products', TABLE_PRODUCTS); |
|
| 152 | + | $Qreviews->bindTable(':table_images', TABLE_IMAGES); |
|
152 | 153 | | $Qreviews->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION); |
|
| 154 | + | $Qreviews->bindTable(':images_groups_id', $osC_Image->getID('default')); |
|
153 | 155 | | $Qreviews->bindInt(':languages_id', $osC_Language->getID()); |
| |
154 | 156 | | $Qreviews->bindInt(':language_id', $osC_Language->getID()); |
| |
155 | 157 | | } |