Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Look of new products box in main column


Zuncan

Recommended Posts

Posted

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?

Posted

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

Posted

Sure thing. Just waiting for someone to give me a helping hand..

So what?! Who care in a hundred years anyway?

Posted

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?

Posted

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

Posted

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?

Posted

<?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.

Posted

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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...