  |
5 | 5 | | osCommerce, Open Source E-Commerce Solutions |
| |
6 | 6 | | http://www.oscommerce.com |
| |
7 | 7 | | |
 |
8 | | - | Copyright (c) 2005 osCommerce |
| |
| 8 | + | Copyright (c) 2006 osCommerce |
|
9 | 9 | | |
| |
10 | 10 | | Released under the GNU General Public License |
| |
11 | 11 | | */ |
| |
|
|
 |
… |
|
79 | 79 | | } |
| |
80 | 80 | | |
| |
81 | 81 | | function &execute() { |
|
82 | | - | global $osC_Database, $osC_Language; |
| |
| 82 | + | global $osC_Database, $osC_Language, $osC_Image; |
|
83 | 83 | | |
|
84 | | - | $Qlisting = $osC_Database->query('select distinct p.*, pd.*, m.*, if(s.status, s.specials_new_products_price, null) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price from :table_products p left join :table_manufacturers m using(manufacturers_id) left join :table_specials s on (p.products_id = s.products_id), :table_products_description pd, :table_categories c, :table_products_to_categories p2c where p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id'); |
| |
| 84 | + | $Qlisting = $osC_Database->query('select distinct p.*, pd.*, m.*, if(s.status, s.specials_new_products_price, null) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price, i.image from :table_products p left join :table_manufacturers m using(manufacturers_id) left join :table_specials s on (p.products_id = s.products_id) left join :table_images i on (p.products_id = i.for_id and i.images_groups_id = :images_groups_id), :table_products_description pd, :table_categories c, :table_products_to_categories p2c where p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = :language_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id'); |
|
85 | 85 | | $Qlisting->bindTable(':table_products', TABLE_PRODUCTS); |
| |
86 | 86 | | $Qlisting->bindTable(':table_manufacturers', TABLE_MANUFACTURERS); |
|
87 | | - | $Qlisting->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION); |
|
88 | 87 | | $Qlisting->bindTable(':table_specials', TABLE_SPECIALS); |
|
| 88 | + | $Qlisting->bindTable(':table_images', TABLE_IMAGES); |
| |
| 89 | + | $Qlisting->bindTable(':table_products_description', TABLE_PRODUCTS_DESCRIPTION); |
|
89 | 90 | | $Qlisting->bindTable(':table_categories', TABLE_CATEGORIES); |
| |
90 | 91 | | $Qlisting->bindTable(':table_products_to_categories', TABLE_PRODUCTS_TO_CATEGORIES); |
|
| 92 | + | $Qlisting->bindInt(':images_groups_id', $osC_Image->getID('default')); |
|
91 | 93 | | $Qlisting->bindInt(':language_id', $osC_Language->getID()); |
| |
92 | 94 | | |
| |
93 | 95 | | if ($this->hasCategory()) { |