tuppergirl Posted August 11, 2005 Posted August 11, 2005 Hi all, How do I change the number of products featured on the front page? After a while of searching and editing the codes with my limited php knowledge, I can't get it done correctly. I need two columns instead of three. Is it from new_products.php or else where? What are the lines of codes that I need to change? Thanks
♥Monika in Germany Posted August 11, 2005 Posted August 11, 2005 Hi all, How do I change the number of products featured on the front page? After a while of searching and editing the codes with my limited php knowledge, I can't get it done correctly. I need two columns instead of three. Is it from new_products.php or else where? What are the lines of codes that I need to change? Thanks <{POST_SNAPBACK}> the number of products can be changed in admin ... the columns are hardcoded into new_products.php <?php /* $Id: new_products.php,v 1.34 2003/06/09 22:49:58 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <!-- new_products //--> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B'))); new contentBoxHeading($info_box_contents); 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; $info_box_contents = array(); while ($new_products = tep_db_fetch_array($new_products_query)) { $new_products['products_name'] = tep_get_products_name($new_products['products_id']); $info_box_contents[$row][$col] = array('align' => 'center', 'params' => 'class="smallText" width="33%" valign="top"', 'text' => '<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) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id']))); $col ++; if ($col > 2) { $col = 0; $row ++; } } new contentBox($info_box_contents); ?> <!-- new_products_eof //--> to have 2 columns instead of 3, change width="33%" to width="50%" and if ($col > 2) { to if ($col > 1) { :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
tuppergirl Posted August 11, 2005 Author Posted August 11, 2005 Great thanks! I've another question.. How do I control the number of rows from this? Thanks again!
♥Monika in Germany Posted August 11, 2005 Posted August 11, 2005 Great thanks! I've another question.. How do I control the number of rows from this? Thanks again! <{POST_SNAPBACK}> admin -> max values -> New Products Module how many items you want. 4 rows is 8 items :-) :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
tuppergirl Posted August 12, 2005 Author Posted August 12, 2005 THANKS for your help, Monika! You've saved some of my brain cells. I've been trying to achieve this effect which can be seen on this link.. http://demo.yourwebstore.net/oscommerce/OS06E00089/index.php where there are lines in the New products main box, I can't figure out how it is done. I managed to add the tep_draw_separator in the products listing to have line separating the products. The price and the buy now is aligned horizontally too. Do I use tep_draw separator for those lines too? The main page has codes that I don't understand how to fit that in. Do you know how it can be done too?
♥Monika in Germany Posted August 12, 2005 Posted August 12, 2005 THANKS for your help, Monika! You've saved some of my brain cells. I've been trying to achieve this effect which can be seen on this link.. http://demo.yourwebstore.net/oscommerce/OS06E00089/index.php where there are lines in the New products main box, I can't figure out how it is done. I managed to add the tep_draw_separator in the products listing to have line separating the products. The price and the buy now is aligned horizontally too. Do I use tep_draw separator for those lines too? The main page has codes that I don't understand how to fit that in. Do you know how it can be done too? <{POST_SNAPBACK}> show me how close you got to that image, and I'll try to guide you through setting it up. The upper and lower tep_draw_separator are added before and after your regular code in the "text" piece. Best would be to make the whole text piece a table with 3 cells, used full width for the upper line and in 3 parts for the price/divider (same sep but vertically) and the buy now button. :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.