Guest Posted June 13, 2007 Posted June 13, 2007 (edited) I'v managed to install the Featured Products 4.3 Mod and it worked like a charm . But i'd like to display them the same as my new products do with a template i'v bought in boxes, with add to cart and a short description. Can someone please point out which code i need to change to achieve this? My New Products File <?php /* edited - 2005/07/01 13:50 ----------------------------------------- $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2003 osCommerce Released under the GNU General Public License */ ?> <!-- new_products //--> <?php if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) { $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } else { $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS); } $row = 0; $col = 0; echo ' <table cellspacing=0 cellpadding=0> <tr><td class=br1 width=533> <table border=0 cellspacing=0 cellpadding=0> <tr><td colspan=5 height=3></td></tr> <tr><td width=3></td> '; while ($new_products = tep_db_fetch_array($new_products_query)) { $new_products['products_name'] = tep_get_products_name($new_products['products_id']); $product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$new_products['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); $product = tep_db_fetch_array($product_query); $new_products['products_description'] = $product['products_description']; echo ' <td width=259 class=br2> <table cellspacing=0 cellpadding=0> <tr><td width=110> <table cellspacing=0 cellpadding=0> <tr><td><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'vspace=0') . '</a></td></tr> <tr><td height=1 bgcolor=#EBEBEB></td></tr> <tr><td height=49 bgcolor=#F4F4F4 class=ch3 align=center>'.$currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])).'</td></tr> </table> </td> <td width=1 bgcolor=#EBEBEB></td> <td width=149 valign=top> <table border=0 cellspacing=0 cellpadding=0 width=129 align=center> <tr><td height=12></td></tr> <tr><td align=center height=32 ><a class=ml2 href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a></td></tr> <tr><td height=13></td></tr> <tr><td><img src=images/m26.gif width=128 height=1></td></tr> <tr><td height=5></td></tr> <tr><td class=tx style="padding-left:10px; padding-right:10px">'.preg_replace('/\s\S*$/i', '', substr($new_products['products_description'], 0, 85)).' ...</td></tr> <tr><td height=2></td></tr> <tr><td><img src=images/m26.gif width=128 height=1></td></tr> <tr><td height=15></td></tr> <tr><td valign=middle align=center><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image_button('small_view.gif') . '</a> <a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']) . '">' . tep_image_button('button_in_cart.gif') . '</a></td></tr> </table> </td></tr> </table> </td> '; $col ++; if ($col > 1) { $col = 0; $row ++; echo ' <td width=3></td></tr> <tr><td colspan=5 height=5></td></tr> <tr><td width=3></td> '; } else echo '<td width=3></td>'; } echo ' <td width=3></td></tr> <tr><td colspan=5 height=3></td></tr> </table> </td></tr> <tr><td height=3></td></tr> <tr><td><a href='.tep_href_link('index.php','manufacturers_id=18').'><img src=images/m22.gif width=135 height=73 border=0></a><a href='.tep_href_link('index.php','manufacturers_id=13').'><img src=images/m23.gif width=131 height=73 border=0></a><a href='.tep_href_link('index.php','manufacturers_id=20').'><img src=images/m24.gif width=134 height=73 border=0></a><a href='.tep_href_link('index.php','manufacturers_id=12').'><img src=images/m25.gif width=133 height=73 border=0></a></td></tr> </table> '; ?> <!-- new_products_eof //--> My Featured Products File <?php /* osCommerce, Open Source E-Commerce Solutions [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url] Copyright © 2002 osCommerce Released under the GNU General Public License Featured Products Listing Module */ ?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if (sizeof($featured_products_array) == '0') { ?> <tr> <td class="main"><?php echo TEXT_NO_FEATURED_PRODUCTS; ?></td> </tr> <?php } else { for($i=0; $i<sizeof($featured_products_array); $i++) { if ($featured_products_array[$i]['specials_price']) { $products_price = '<s>' . $currencies->display_price($featured_products_array[$i]['price'], tep_get_tax_rate($featured_products_array[$i]['tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($featured_products_array[$i]['specials_price'], tep_get_tax_rate($featured_products_array[$i]['tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($featured_products_array[$i]['price'], tep_get_tax_rate($featured_products_array[$i]['tax_class_id'])); } ?> <tr> <td width="<?php echo SMALL_IMAGE_WIDTH + 10; ?>" valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products_array[$i]['id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . $featured_products_array[$i]['image'], $featured_products_array[$i]['name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?></td> <td valign="top" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $featured_products_array[$i]['id'], 'NONSSL') . '"><b><u>' . $featured_products_array[$i]['name'] . '</u></b></a><br>' . TEXT_DATE_ADDED . ' ' . $featured_products_array[$i]['date_added'] . '<br>' . TEXT_MANUFACTURER . ' ' . $featured_products_array[$i]['manufacturer'] . '<br><br>' . TEXT_PRICE . ' ' . $products_price; ?></td> <td align="right" valign="middle" class="main"><?php echo '<a href="' . tep_href_link(FILENAME_FEATURED_PRODUCTS, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $featured_products_array[$i]['id'], 'NONSSL') . '">' . tep_image_button('button_in_cart.gif', IMAGE_BUTTON_IN_CART) . '</a>'; ?></td> </tr> <?php if (($i+1) != sizeof($featured_products_array)) { ?> <tr> <td colspan="3" class="main"> </td> </tr> <?php } } } ?> </table> Thanks Ken Edited June 13, 2007 by kenboon Quote
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.