edtiger Posted March 10, 2006 Posted March 10, 2006 the contribution can be found here: Category & Manufacturer's name in Product_Info Page Quote
AntiqueStoreBuilder Posted March 12, 2006 Posted March 12, 2006 (edited) 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 March 12, 2006 by AntiqueStoreBuilder Quote
btunow Posted March 29, 2006 Posted March 29, 2006 The contribution works great except all the products are listed as the same catagory... is there anyway to fix this Quote
jaminunit Posted April 17, 2006 Posted April 17, 2006 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 Quote
web4luke Posted May 7, 2006 Posted May 7, 2006 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 Quote
Kjolebutikken Posted May 10, 2006 Posted May 10, 2006 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 Quote Best regards Kjolebutikken
Kjolebutikken Posted May 11, 2006 Posted May 11, 2006 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 Quote Best regards Kjolebutikken
msbee Posted June 8, 2006 Posted June 8, 2006 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? Quote
msbee Posted June 8, 2006 Posted June 8, 2006 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? Quote
Kjolebutikken Posted June 9, 2006 Posted June 9, 2006 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. Quote Best regards Kjolebutikken
msbee Posted June 9, 2006 Posted June 9, 2006 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? Quote
godino1 Posted June 11, 2006 Posted June 11, 2006 I get the same no manufacturer name shows up added kjolebutikken code fix no change still doesn't show up. Quote
godino1 Posted June 11, 2006 Posted June 11, 2006 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. Quote
godino1 Posted June 11, 2006 Posted June 11, 2006 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 Quote
carolinagirl Posted September 26, 2006 Posted September 26, 2006 Can these fields also be added to the shopping cart and the order information? Quote "There is no disgrace in not knowing, the only disgrace is not to be willing to learn." ...Benjamin Franklin
nahi_sonu Posted July 17, 2007 Posted July 17, 2007 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 Quote outside links are not allowed in signatures
Johnatan Posted January 9, 2009 Posted January 9, 2009 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.