Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[contribution] Category & Manufacturers name in Product_Info Page


edtiger

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
Link to comment
Share on other sites

  • 3 weeks later...
  • 3 weeks later...
  • 3 weeks later...
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

Link to comment
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

Link to comment
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

Link to comment
Share on other sites

  • 4 weeks later...

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?

Link to comment
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?

Link to comment
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

Link to comment
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.

Link to comment
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

Link to comment
Share on other sites

  • 3 months later...
  • 9 months later...

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

Link to comment
Share on other sites

  • 1 year later...
the contribution can be found here:

Category & Manufacturer's name in Product_Info Page

 

Please if someone can help me with some changes. This contrib shows my second subcategory, model and manufacturer, but I also whant to show primary categorie (i mean first category)

 

Can someone can help me?

 

BR

Johnatan

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...