PDA

View Full Version : Specials page, how to show in html bts



gamefreak7
08-30-2005, 09:16 PM
We created a custom template HTML but still trying to figure out how to get the specials to show up on the mainpage. I tried {informationbox}, does anyone know the correct box or code to insert to get this to display?

Thanks.

michael_s
08-31-2005, 07:29 AM
If using BTS properly, it will automatically get included in main_page.tpl.php as it auto loads /content/index_default.tpl.php.

If not using bts properly, you will have to add code something like the following:



<?php
$default_specials_query = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' and s.customers_group_id = ". (int)$customer_group_id." order by s.specials_date_added DESC limit " . MAX_DISPLAY_SPECIAL_PRODUCTS);
$default_specials = tep_db_fetch_array($default_specials_query);

if (isset($default_specials['products_id'])) {

?>
<tr>
<td><br>
<?php include(DIR_WS_MODULES . FILENAME_DEFAULT_SPECIALS);
}
?>
</td>
</tr>