Jump to content
Sign in to follow this  
edtiger

[contribution] Category & Manufacturers name in Product_Info Page

Recommended Posts

the contribution can be found here:

Category & Manufacturer's name in Product_Info Page

 

Is there any easy way for me to create a link to the category in product_info? (Similar to how it's done in the header). I'm trying to leverage the "no buy button if quantity = 0" contrib (contrib 3703) so that if the product quantity = 0, rather than just hide the buy button (which is what the original contrib does), it says something like "Product Sold Out, but you can browse more items in the [CategoryName] category."

 

Using this contrib I've gotten the category name to display correctly, but am beat down to a pulp when I try to figure out how to generate the associated tep_href_link.

 

Any help would be appreciated - realize this is somewhat unreleated to this contrib itself but hope it's within the realm of requesting assistance.

Edited by AntiqueStoreBuilder

Share this post


Link to post
Share on other sites

The contribution works great except all the products are listed as the same catagory... is there anyway to fix this

Share this post


Link to post
Share on other sites
The contribution works great except all the products are listed as the same catagory... is there anyway to fix this

 

Yeah I get the same,

 

Any bright spark know whats going on?

 

J

Share this post


Link to post
Share on other sites
Yeah I get the same,

 

Any bright spark know whats going on?

 

J

 

Hi,

the query is listing all the categories. I changed the query in product_info.php

 

from

 

$categories_name_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

 

to

 

$categories_name_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd inner join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p2c.categories_id = cd.categories_id where p2c.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and cd.language_id = '" . (int)$languages_id . "'");

 

I hope it fits for you

w4l

Share this post


Link to post
Share on other sites

Hi,

I just installed this contribution, but only the category shows below the modelnr (varenr). The manufacturer does not show.

 

What is wrong? Cannot figure it out. Hope somebody can help me out here.

Here is my product_info.php file for you to see:

 

<?php
/*
 $Id: product_info.php,v 1.97 2003/07/01 14:34:54 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 require('includes/application_top.php');

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);


 $product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
 $product_check = tep_db_fetch_array($product_check_query);

// MOD 2389 oscStudio.com ic 20050803 - Category & Manufactureres Name in Product_info
 $categories_name_query  = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id, " . TABLE_PRODUCTS_DESCRIPTION . "  pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

 $category = tep_db_fetch_array($categories_name_query);	
 // END 2389

?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<script language="javascript"><!--
function popupWindow(url) {
 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res
izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le
ft=150')
}
//--></script>
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<? include(DIR_WS_MODULES . 'thumb_bar.php'); ?>
<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<!-- body_text //-->


<td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">


<?php
 if ($product_check['total'] < 1) {
?> 
  <tr>
	<td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr> 
  <tr>
	<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
	  <tr class="infoBoxContents">
		<td><table border="0" width="100%" cellspacing="0" cellpadding="2"> 
		  <tr>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
			<td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
			<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
<?php
 } else {
$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_pop, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
$product_info = tep_db_fetch_array($product_info_query);
$manufacturer_info_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m where m.manufacturers_id = '" . (int)$product_info['manufacturers_id'] . "'"); //qty discount GoddardHewett.com
$manufacturer_info = tep_db_fetch_array($manufacturer_info_query);
tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
  $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s><span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
} else {
  $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));
}



// MOD 2389 oscStudio.com ic 20050803 - Category & Manufactureres Name in Product_info
if (tep_not_null($product_info['products_model'])) {
  $products_name = $product_info['products_name'] . '<span class="smallText"><br><br>Varenr.: </span><span class="smallText">' . $product_info['products_model'] . '  </span>' . ' <span class="smallText"><br>Kategori: </span><span class="smallText">' . $category['categories_name'] . '</span>';
  if (tep_not_null($$manufacturer_info_info['manufacturers_name'])) {
	  $products_name = $products_name . ' <span class="smallText">[Mfg:' . $manufacturer_info['manufacturers_name'] . ']</span>';
  }
} else {
  $products_name = $product_info['products_name'] . '<br><span class="smallText">' . ' <span class="smallText"> ' . $category['categories_name'] . '</span>';
  if (tep_not_null($product_info['manufacturers_name'])) {
	  $products_name = $products_name . ' <span class="smallText">[Mfg:' . $manufacturer_info['manufacturers_name'] . ']</span>';
  }
}
// END 2389

?>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="pageHeading" valign="top"><?php echo $products_name; ?></td>
		<td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
	<td class="main">
<?php
if (tep_not_null($product_info['products_image'])) {
?>
	  <table border="0" cellspacing="0" cellpadding="2" align="right">
		<tr>
		  <td align="center" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), DISPLAY_IMAGE_WIDTH, DISPLAY_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');
//--></script>
<noscript>
<<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image_pop']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image_pop'], $product_info['products_name'], DISPLAY_IMAGE_WIDTH, DISPLAY_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>
</noscript>
<tr>
	<td>
	  <?php require(DIR_WS_MODULES . FILENAME_ADDITIONAL_IMAGES); ?>   
	</td>
  </tr>
		  </td>
		</tr>
	  </table>
<?php
}
?>
	 <?php
$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");
$products_attributes = tep_db_fetch_array($products_attributes_query);
if ($products_attributes['total'] > 0) {
?>
	  <table border="0" cellspacing="0" cellpadding="2">
		<tr>
		  <br><td class="main" colspan="2"><?php echo TEXT_PRODUCT_OPTIONS; ?></td>
		</tr>
<?php
  $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");
  while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
	$products_options_array = array();
	$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");
	while ($products_options = tep_db_fetch_array($products_options_query)) {
	  $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);
	  if ($products_options['options_values_price'] != '0') {
		$products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';
	  }
	}

	if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {
	  $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];
	} else {
	  $selected_attribute = false;
	}
?> 
	   <tr>
		  <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>
		  <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>
		</tr>


<?php
  }
?>

	  </table>
<p><?php echo stripslashes($product_info['products_description']); ?></p>

<?php
}
?>
	 </td>
  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
<?php

if (tep_not_null($product_info['products_url'])) {
?>
  <tr>
	<td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>

  </tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '20'); ?></td>
  </tr>

<tr>
<td class="main">
<?php 
 $search_string_array = explode(" ",$product_info['products_name']);
 foreach($search_string_array AS $search_entry) {
if(strlen($search_entry) > 3) {
  $search_entry = ereg_replace("[^a-z0-9]", "", strtolower($search_entry));
  $search_string .= '<a href="'.tep_href_link(FILENAME_ADVANCED_SEARCH_RESULT,'keywords='.$search_entry).'">'.$search_entry.'</a> ';
}
 }
 echo 'S?k etter andre tilsvarende varer.<br>Klikk p? s?keordene som f?lger her: '.$search_string;
?>
</td>
</tr>

<tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0" class="infoBox">
	  <tr class="infoBoxContents">			 
		<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
<//td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
<td class="main" align="left"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_PRINT, tep_get_all_get_params()) . '" target="_blank">Utskriftsvennlig side HER.</a>' ?></td>	   
		  </tr>
		</table></td>
	  </tr>
	</table><br></td>



<?php
}

if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {
?>
  <tr>
	<td align="left" class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>
  </tr>
<?php
} else {
?> 
  <?php
}
?>
		<tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
  </tr>
  <tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0" class="infoBox">
	  <tr class="infoBoxContents">			 
		<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
<td align="left" class="smallText"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td>
<td class="main" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>
<td width="1"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>		
		  </tr>
		</table></td>
	  </tr>
	</table><br></td>

</tr>
  <tr>
	<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '30'); ?></td>
  </tr>


<?php include(DIR_WS_BOXES . 'manufacturer_info.php'); ?>
  </tr>
  <tr>
		 <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>	
  </tr>
  <tr>
	<td>
<br><?php include(DIR_WS_MODULES . 'thumb_bar_join.php'); ?>
</td> 
 </td>
  </tr>
</table></form>



<?php
if ((USE_CACHE == 'true') && empty($SID)) {
  echo tep_cache_also_purchased(3600);
} else {
//include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
 }
?>


<!-- body_text_eof //-->
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
</table></td>
 </tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

Thanks:-)

Kjolebutikken


Best regards

Kjolebutikken

Share this post


Link to post
Share on other sites
Hi,

I just installed this contribution, but only the category shows below the modelnr (varenr). The manufacturer does not show.

 

What is wrong? Cannot figure it out. Hope somebody can help me out here.

Here is my product_info.php file for you to see:

 

Thanks:-)

Kjolebutikken

 

Hi, I solved my problem with changing a little the some of code in the product_info.php to:

 

// MOD 2389 oscStudio.com ic 20050803 - Category & Manufactureres Name in Product_info
if (tep_not_null($product_info['products_model'])) {
  $products_name = $product_info['products_name'] . '<span class="smallText"><br><br>Varenr.: </span><span class="smallText">' . $product_info['products_model'] . ' </span>' . ' <span class="smallText"><br>Kategori: </span><span class="smallText">' . $category['categories_name'] . '</span>' . ' <span class="smallText"><br>Designer: </span><span class="smallText">' . $manufacturer_info['manufacturers_name'] . '</span>';
  if (tep_not_null($$manufacturer_info_info['manufacturers_name'])) {
	  $products_name = $products_name . ' <span class="smallText">' . $manufacturer_info['manufacturers_name'] . '</span>';
  }
} else {
  $products_name = $product_info['products_name'] . '<span class="smallText">' . ' <span class="smallText">' . $category['categories_name'] . '</span>';
  if (tep_not_null($product_info['manufacturers_name'])) {
	  $products_name = $products_name . '<span class="smallText">' . $manufacturer_info['manufacturers_name'] . '</span>';
  }
}
// END 2389

 

Not a proper change I think, don't know much about it, but it works.

 

I have a little cosmetic problem however. I want the space between the modelnb (varenr in my case) and the category to be the same as between the category and the manufacturer (Designer in my case). Now there are more room between the fisrt two. Not much, but if it is possible to change, I would like to do that:-)

 

Here you can see on my page:

 

http://www.kjolebutikken.com/oscdemo1/prod...?products_id=29

 

Thanks

Kjolebutikken


Best regards

Kjolebutikken

Share this post


Link to post
Share on other sites

hi, don't know what i do wrong... 've got the same problem as kjolebutikken so checked code again .. and again and find nothing.. still no manufacturer in my product_info >_< any ideas?

Share this post


Link to post
Share on other sites

hi, don't know what is wrong... 've got the same problem as kjolebutikken so checked code again .. and again and find nothing everything looks fine but .. still no manufacturer in my product_info >_< any ideas?

Share this post


Link to post
Share on other sites
hi, don't know what is wrong... 've got the same problem as kjolebutikken so checked code again .. and again and find nothing everything looks fine but .. still no manufacturer in my product_info >_< any ideas?

 

 

Have you tried to change the code like I did? Worked for me:-)

Look at my post above for the changes.

 

Kjolebutikken.


Best regards

Kjolebutikken

Share this post


Link to post
Share on other sites
Have you tried to change the code like I did? Worked for me:-)

Look at my post above for the changes.

 

Kjolebutikken.

 

yes i've tried, still nothing. should i paste my code?

Share this post


Link to post
Share on other sites

I get the same no manufacturer name shows up added kjolebutikken code fix no change still doesn't show up.

Share this post


Link to post
Share on other sites

Here you go a fix

 

use the following

 

Find these lines:

 

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_price1,p.products_price2,p.products_price3,p.products_price4,p.produc

ts_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_price4_qty,p

.products_qty_blocks, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); //qty discount GoddardHewett.com

$product_info = tep_db_fetch_array($product_info_query);

 

Add below:

 

$manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image from " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p where p.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and p.manufacturers_id = m.manufacturers_id");

$manufacturer = tep_db_fetch_array($manufacturer_query);

 

Find these lines:

 

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';

} else {

$products_name = $product_info['products_name'];

}

 

 

Replace with these lines:

 

// MOD - Category & Manufactureres Name in Product_info

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . '<br><span class="smallText">' . $product_info['products_model'] . ' </span>' . ' <span class="smallText"> ' . $category['categories_name'] . '</span>';

if (tep_not_null($manufacturer ['manufacturers_name'])) {

$products_name = $products_name . ' <span class="smallText">[' . $manufacturer['manufacturers_name'] . ']</span>';

}

} else {

$products_name = $product_info['products_name'] . '<br><span class="smallText">' . ' <span class="smallText"> ' . $category['categories_name'] . '</span>';

if (tep_not_null($product_info['manufacturers_name'])) {

$products_name = $products_name . ' <span class="smallText">[' . $manufacturer_info['manufacturers_name'] . ']</span>';

}

}

// END

 

 

and that it

 

all other parts of original contribution are fine.

 

 

the above works for me.

 

tell me how it goes please.

Share this post


Link to post
Share on other sites

Sorry the above only works when model is in use but if not in use it doesn't so here is a fix so it now works on both

 

 

 

Find these lines:

 

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_price1,p.products_price2,p.products_price3,p.products_price4,p.produc

ts_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_price4_qty,p

.products_qty_blocks, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); //qty discount GoddardHewett.com

$product_info = tep_db_fetch_array($product_info_query);

 

Add below:

 

$manufacturer_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image from " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p where p.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and p.manufacturers_id = m.manufacturers_id");

$manufacturer = tep_db_fetch_array($manufacturer_query);

 

Find these lines:

 

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';

} else {

$products_name = $product_info['products_name'];

}

 

 

Replace with these lines:

 

// MOD - Category & Manufactureres Name in Product_info

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . '<br><span class="smallText">' . $product_info['products_model'] . ' </span>' . ' <span class="smallText"> ' . $category['categories_name'] . '</span>';

if (tep_not_null($manufacturer ['manufacturers_name'])) {

$products_name = $products_name . ' <span class="smallText">[' . $manufacturer['manufacturers_name'] . ']</span>';

}

} else {

$products_name = $product_info['products_name'] . '<br><span class="smallText">' . ' <span class="smallText"> ' . $category['categories_name'] . '</span>';

if (tep_not_null($manufacturer['manufacturers_name'])) {

$products_name = $products_name . ' <span class="smallText">[' . $manufacturer['manufacturers_name'] . ']</span>';

}

}

// END

Share this post


Link to post
Share on other sites

Can these fields also be added to the shopping cart and the order information?


"There is no disgrace in not knowing, the only disgrace is not to be willing to learn." ...Benjamin Franklin

Share this post


Link to post
Share on other sites

hi,

i just want to add manufacturer name on the product_info! i dont want sub category or model name!! just a manufacturer name!

how can i do that? plz i need help as soon as possible!

thanx in advance


outside links are not allowed in signatures

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×