Zuncan Posted June 20, 2004 Posted June 20, 2004 Hi. I`ve been struggling with this problem for some days now and I just dont get it. My question is: How can I make the new products box in the main column on the first page of osCommerce use the same style as the ordinary productlisting? As it is now it looks as all the other boxes in the left and right column.. I want new_products.php to refer to the productlisting within the stylesheet. Is there some way to fix this? Bet there are more people than me that wants the same thing. If you know the answer. Please help me out. / Zuncan So what?! Who care in a hundred years anyway?
Guest Posted June 21, 2004 Posted June 21, 2004 can you let me know how to fix that I have the same problem with the default specials also that I need to change. --Gary
Zuncan Posted June 21, 2004 Author Posted June 21, 2004 Sure thing. Just waiting for someone to give me a helping hand.. So what?! Who care in a hundred years anyway?
Zuncan Posted June 25, 2004 Author Posted June 25, 2004 Nope. Im working on it and are about to solve it. It?s a bit tricky, but I will contact you as soon as I get it to work. I will pm then. So what?! Who care in a hundred years anyway?
djs Posted June 25, 2004 Posted June 25, 2004 Can you provide a url to your site? This shouldn't be hard to fix, if I understand the problem correctly, it's just a matter of changing the class. Dan Dan Stevens
Zuncan Posted June 25, 2004 Author Posted June 25, 2004 Yes. I know it?s just a matter of changing the class, but I dont know how to do that. Here is the code for new_products.php. Can you please make the proper changes for me? ______________________________________________________ <?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 © 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 //--> ______________________________________________________ I would rather not post a link to my site because its not secured yet. Would be more than greatful if you could help me out with this problem. Sk?l! (Cheers!) / Zuncan from Sweden So what?! Who care in a hundred years anyway?
Zuncan Posted June 26, 2004 Author Posted June 26, 2004 Common! Please help me with this! Please! So what?! Who care in a hundred years anyway?
♥ecartz Posted June 26, 2004 Posted June 26, 2004 <?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') ) { $listing_sql = 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"; } else { $listing_sql = "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"; } include(DIR_WS_MODULES . 'product_listing.php'); ?> to replace the entire second PHP block. Note: this will also show additional pages through the PREV/NEXT links. It is non-trivial to do without that, as the product listing is not done through a class but via module. You would have to actually change the New Products code to be more like the Product Listing code. Hth, Matt Always back up before making changes.
Zuncan Posted June 27, 2004 Author Posted June 27, 2004 But I have the same problem with the product listing. It?s in the same backgroundcolor as my left & right column. It just dont fit into my site.. I just cant believe that it can be this hard to JUST change the background color of the new products and the productlisting. Ok. So I just replace a bit of my code with what you sent me. And that should do the trick? Ive been told that I also need to ad some code to the stylesheet as well to boxes.php. Man! Cant belive this! I would be sooo happy if someone could help me with a tutorial in how to pull this off. I know that there are more than me that have the same problem as me. This problem should be added to the wikidocumentations. Please help me. Been struggeling with this problem for more than a week now. / Zuncan So what?! Who care in a hundred years anyway?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.