new_products.php short description

[real1]

Hi, i have a new_products.php that shows on frontpage, i have installed a short desc contribution, but it doesn't show in this file. I posted in that contrib forum, but no reply... :blink:

 

Can someone please tell me how can i edit this code (below) to insert a short description, just this one 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
 http://www.oscommerce.com

 Copyright (c) 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 width=437 align=center>
 <tr><td background=images/m22.gif width=437 height=29 valign=top>
	 <table cellspacing=0 cellpadding=0>
	  <tr><td height=8></td></tr>
	  <tr><td width=25></td><td class=ch6>Novos Produtos</td></tr>
	 </table>
	</td></tr>
  <tr><td valign=top class=ch7>

	   <table cellspacing=0 cellpadding=0 width=417 border=0 align=center>
		 <tr><td height=13></td></tr>
		 <tr>


   ';


 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)1 . "'");
  $product = tep_db_fetch_array($product_query);
  $new_products['products_description'] = $product['products_description'];
  echo '

		 <td width=208 valign=top align=center>
		   <table cellspacing=0 cellpadding=0 width=200 align=center>
			<tr><td width=90 align=center valign=top><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>
			<td valign=top>
			  <table cellspacing=0 cellpadding=0>
			   <tr><td><a height=35 valign=middle   class=ch9 href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a></td></tr>

			   <tr><td class=ch10 height=35 valign=middle>'.preg_replace('/\s\S*$/i', '', substr($new_products['products_description'], 0, 25)).' ...</td></tr>
			   <tr><td height=0></td></tr>
			   <tr><td><span class=ch11>pre?o:</span> <span class=ch8>'.$currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])).$new_products['short_desc']);'</span> </td></tr>
			  </table>
			 </td>
			</tr>
			<tr><td height=20></td></tr>
			<tr><td colspan=2 align=right><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>


	';

$col ++;
if ($col > 1) {
  $col = 0;
  $row ++;
  echo '

		 </tr>
		 <tr><td height=5></td></tr>
		  <tr><td colspan=3 valign=top>
		   <table cellspacing=0 cellpadding=0>
			<tr><td width=200 height=1 background=images/m29.gif></td><td width=14></td> <td width=200 height=1 background=images/m29.gif></td></tr>
		   </table>
		  </td></tr>
		  <tr><td height=5></td></tr>
		  <tr>


	   ';
} else echo '<td background=images/m09.gif width=1></td>';
 }


 echo '

					 </tr>
					</table>

	 </td></tr>
	<tr><td><img src=images/m30.gif width=438 height=7></td></tr>
   </table>

   ';


?>
<!-- new_products_eof //-->

[steve_s]

to add a short description use

$product_desc['products_description'] = substr(strip_tags($product_desc['products_description']), 0, 100);

then </? echo $product_desc; ?> where you want description to appear this will give you first 100 char of description you will have to put product_description in both sql statements

 

or you can implement a hack from digistore

[real1]

hey steve thanks for the tip, i used another module and it's now working...

thank you

[joels]

And someone know i do remove the price, if price = 0? in this?