Specials page, how to show in html bts

[gamefreak7]

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]

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>