yurg Posted November 4, 2008 Share Posted November 4, 2008 (edited) . Edited November 4, 2008 by yurg Quote Link to comment Share on other sites More sharing options...
jasonabc Posted November 16, 2008 Share Posted November 16, 2008 Hey just wanted to say a huge thanks to everyone involved in this mod. I am working on a store where they want to create three groups (Companies, Styles and Designers) and then assign those entries to their products. This mod was absolutely perfect and works a treat. If you need an extra group or two - just take all the modifications in this contribution and duplicate them (change Manufactuers2 to Manufacturers3 and so on in each instance).  Thanks again - this contribution saved me many, many hours of extra work.  cheers  Jason Quote Jason  My Contributions: Paypal Payflow PRO | Rollover Category Images | Authorize.net Invoice Number Fix Link to comment Share on other sites More sharing options...
bibliopolis Posted January 4, 2009 Share Posted January 4, 2009 Hi vey nice contribution  look o how they use the functionality .  http://www.perizitito.gr/product.php?produ...49368&page=    they have multiple authors per book but the url per author is like that: http://www.perizitito.gr/authors.php?authorid=65797 http://www.perizitito.gr/authors.php?authorid=58442   and by clicking on an author when taken to the authors page you see all the entries even those that he is the second or third author .  Again thanks everyone involved in this contribution Quote Link to comment Share on other sites More sharing options...
bimbachetuning Posted March 25, 2009 Share Posted March 25, 2009 Hi to all! Â I need some help to adapt this module for "manufacturers" to "manufacturers2", i test to modify but not work. Â <?php $info_box_contents = array(); //$info_box_contents[] = array('text' => 'Herstellerlogos'); new infoBoxHeading($info_box_contents, true, false); $info_box_contents = array(); $fullstring = '<table width=100% border=0 cellpadding=0 cellspacing=3><tr>'; $row=0; $manufacturers_query = tep_db_query("select manufacturers_name, manufacturers_id, manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_image not like '' order by manufacturers_name" ); if (tep_db_num_rows($manufacturers_query) >= '1') { while ($manufacturers = tep_db_fetch_array($manufacturers_query)) { $row++; $fullstring .= '<td align=center valign=middle class=smallText>'; $fullstring .= '<a href=' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturers['manufacturers_id'] , 'NONSSL', false) . '>'; if ($manufacturers['manufacturers_image']) { $fullstring .= '<img src='. DIR_WS_IMAGES . $manufacturers['manufacturers_image'] . ' width=56 height=46 border=0> '; } else { $fullstring .= '<a href=' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturers['manufacturers_id'], 'NONSSL', false) . '>'. $manufacturers['manufacturers_name']; } $fullstring .= '</a>'; $fullstring .= '</td>'; if ((($row / 7) == (double)floor($row / 7))) { $fullstring .='<tr>'; } } } $fullstring .= '</td></tr></table>'; $info_box_contents = array(); $info_box_contents[] = array('text' => $fullstring); //echo $fullstring; new infoBox($info_box_contents); ?> Â This module shows the manufacturers logo ;) Â Thnks 4 your help! Â P.D.: Sorry my bad english. Quote Link to comment Share on other sites More sharing options...
Rachael w. Posted March 26, 2009 Share Posted March 26, 2009 (edited) I believe the box is manufacturers_info.php, the box that displays the manufacturers info in the right column on stock osc installs.  Create a page in includes/boxes/manufacturer2_info.php  Paste this there:  <?php /* $Id: manufacturer2_info.php,v 1.11 2003/06/09 22:12:05 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ if (isset($HTTP_GET_VARS['products_id'])) { $manufacturer2_query = tep_db_query("select m2.manufacturers2_id, m2.manufacturers2_name, m2.manufacturers2_image, mi2.manufacturers2_url from " . TABLE_MANUFACTURERS2 . " m2 left join " . TABLE_MANUFACTURERS2_INFO . " mi2 on (m2.manufacturers2_id = mi2.manufacturers2_id and mi2.languages_id = '" . (int)$languages_id . "'), " . TABLE_PRODUCTS . " p where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and p.manufacturers2_id = m2.manufacturers2_id"); if (tep_db_num_rows($manufacturer2_query)) { $manufacturer2 = tep_db_fetch_array($manufacturer2_query); ?> <!-- manufacturer2_info //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_MANUFACTURER2_INFO); new infoBoxHeading($info_box_contents, false, false); $manufacturer2_info_string = '<table border="0" width="100%" cellspacing="0" cellpadding="0">'; if (tep_not_null($manufacturer2['manufacturers2_image'])) $manufacturer2_info_string .= '<tr><td align="center" class="infoBoxContents" colspan="2">' . tep_image(DIR_WS_IMAGES . $manufacturer2['manufacturers2_image'], $manufacturer2['manufacturers2_name']) . '</td></tr>'; if (tep_not_null($manufacturer2['manufacturers2_url'])) $manufacturer2_info_string .= '<tr><td valign="top" class="infoBoxContents">- </td><td valign="top" class="infoBoxContents"><a href="' . tep_href_link(FILENAME_REDIRECT, 'action=manufacturer&manufacturers2_id=' . $manufacturer2['manufacturers2_id']) . '" target="_blank">' . sprintf(BOX_MANUFACTURER2_INFO_HOMEPAGE, $manufacturer2['manufacturers2_name']) . '</a></td></tr>'; $manufacturer2_info_string .= '<tr><td valign="top" class="infoBoxContents">- </td><td valign="top" class="infoBoxContents"><a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers2_id=' . $manufacturer2['manufacturers2_id']) . '">' . sprintf(BOX_MANUFACTURER2_INFO_OTHER_PRODUCTS, $manufacturer2['manufacturers2_name']) . '</a></td></tr>' . '</table>'; $info_box_contents = array(); $info_box_contents[] = array('text' => $manufacturer2_info_string); new infoBox($info_box_contents); ?> </td> </tr> <!-- manufacturer2_info_eof //--> <?php } } ?>  in includes/languages/yourlanguage.php (Mine would be english.php)  Paste this at the bottom of that page:  // manufacturer2 box text define('BOX_HEADING_MANUFACTURERS2', 'Change Me'); define('BOX_HEADING_MANUFACTURER2_INFO', 'Change Me Info'); define('BOX_MANUFACTURER2_INFO_HOMEPAGE', '%s Homepage'); define('BOX_MANUFACTURER2_INFO_OTHER_PRODUCTS', 'More from %s');  In includes/column_right.php add this:  if (isset($HTTP_GET_VARS['products_id'])) include(DIR_WS_BOXES . 'manufacturer2_info.php');  Be sure you have that info table in includes/database_tables.php (I think it may have been missing in the original instructions)  define('TABLE_MANUFACTURERS2_INFO', 'manufacturers2_info');   I have modified this code to work for my own store. You may need to tweak it to match your other boxes if it is different. Just copy these and change the 2 to a 3 and so on for more than one additional manufacturer.  I hope that is what you were looking for. Edited March 26, 2009 by theantiquestore Quote Link to comment Share on other sites More sharing options...
NavCopy Posted June 21, 2009 Share Posted June 21, 2009 I need the ability to add various sports (manufacturers) to each product but not have them individually listed on the website. Ideally the ability to search by sport (manufacturer) that ties in all lists created. Does anyone know if this can do it? Â Nav Quote Link to comment Share on other sites More sharing options...
AshMavrik Posted July 23, 2009 Share Posted July 23, 2009 Hello I have followed all the instruction on how to install extra manufacturers using "Manufacturer2_3_0"  However the Manufacturers 2 appears in the admin side, but not on the actual website in the left column. There still only exists the original Manufacturers. I have gone through it all again aswell, however still cannot work out the problem.  Please can anyone help  my website is www.firstnoor.co.uk/shop  Thank You Quote Link to comment Share on other sites More sharing options...
JSR Posted August 1, 2009 Share Posted August 1, 2009 Is anyone here using the contribution Quick Research? I've just finished installing it and would like to add all my manufacturers. I'm having problems including them in the $from query where its states "left join, using manufacturers_id". I know nothing about sql syntax and query commands, and after reading up on the USING command I still get a syntax error. Quote Link to comment Share on other sites More sharing options...
JSR Posted August 1, 2009 Share Posted August 1, 2009 I need the ability to add various sports (manufacturers) to each product but not have them individually listed on the website. Ideally the ability to search by sport (manufacturer) that ties in all lists created. Does anyone know if this can do it? Nav It would seem that if you don't want them to be visible on the catalog side, you don't include the boxes in left column. Or am I| not getting what you're saying? Quote Link to comment Share on other sites More sharing options...
JSR Posted August 1, 2009 Share Posted August 1, 2009 I got it: $from_str = "from ((" . TABLE_PRODUCTS . " p) left join (" . TABLE_MANUFACTURERS . " m) USING(manufacturers_id) left join (" . TABLE_MANUFACTURERS3 . " m3) USING(manufacturers3_id) left join (" . TABLE_MANUFACTURERS4 . " m4) USING(manufacturers4_id)) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id"; This way it includes all the manufacturers in a search query on quick_search.php Quote Link to comment Share on other sites More sharing options...
foundlamer Posted August 31, 2009 Share Posted August 31, 2009 He I have one problem please help me İn manufacturer2 2.0 How to add a second manufacturer to a product For example  This book have second or more authors I insert manifacture2 Contribution my osc do you know how to add for produc second or more manifacture2 Quote Link to comment Share on other sites More sharing options...
JSR Posted November 24, 2009 Share Posted November 24, 2009 (edited) I've been trying to include the manufacturers name in the manufacturers2 product listing. Does anyone know how to achieve this? Edited November 24, 2009 by JSR Quote Link to comment Share on other sites More sharing options...
JSR Posted February 16, 2010 Share Posted February 16, 2010 I've been trying to include the manufacturers name in the manufacturers2 product listing. Does anyone know how to achieve this? I have not yet found the right sql query to achieve this so any help would be immensely appreciated... Anyone? Pls? :blush: Quote Link to comment Share on other sites More sharing options...
jacven Posted February 18, 2010 Share Posted February 18, 2010 Hello, thanks for this great contribution. I have successfully installed it but I would like to know how to change the aspect. It is currently setup as drop down list, I would like to have it as the category box. Â I went to the setup in admin where you in maximum value, but when I changed that it disappeared. Â Can anyone please help me? Â Thank you. Quote Link to comment Share on other sites More sharing options...
cijumaya Posted May 20, 2010 Share Posted May 20, 2010 (edited) hello there ,   thx for the work ...  i would like to know if i can get advise about this problem i have:   in products_new.php .... the product_listing module send back all products whatever it is a manufacturer1 or 2 ....  the problem i have is : my product listing is supposed to return and write the name of manufacturer .... i get the name of manufacturer 1 but not from manufacturer2    in index.php we filter first to know if isset($HTTP_GET_VARS['manufacturers2_id']) , if so we request the database to return products that match manufacturer 2    can i get advise on how to return manufacturers name and manufacturers 2 name in the request made on products_new    thanks a lot , excuse my english skill !! Edited May 20, 2010 by cijumaya Quote Link to comment Share on other sites More sharing options...
cijumaya Posted May 29, 2010 Share Posted May 29, 2010 ok i fix my problems ..just get a little bit problem in the search area.. that do not search in table manufacturer2 Quote Link to comment Share on other sites More sharing options...
kiku90 Posted December 14, 2010 Share Posted December 14, 2010 Hello all, first I would like to say thanks for a really great contribution! I installed it without any problems and I added, on a basic of code manufacturers2, a similar table "authors" authors.php... etc and it worked. Â To the point: Â I'm just wondering how to change a pull down menu in box manufacturers2.php and in advanced_search.php to an input field so the customer could write name of a manufacturer2 (or author in my case) and it would show the results page? Is it possible? My knowledge about sql an php is limited to "copy & paste" so any advices will be welcome :) Â Thank you for any advice, very sorry for my english, I'm not sure if I described my problem correctly... :( Quote Link to comment Share on other sites More sharing options...
LudvigHoffman Posted February 10, 2011 Share Posted February 10, 2011 Was trying to install this contrib on my site, but there is'nt any /Includes/column_left.php in v2.3.1... Â How can I get the on the frontend? Search seems to work in some way. Quote Link to comment Share on other sites More sharing options...
Simpel Posted March 24, 2011 Share Posted March 24, 2011 Thank you for the reply Andes,  YES, It was a time consuming, but worth it. I will be posting the 5 manufaturers install package soon so no one else has to go through it again.  I gust have one bug and it's not with the manufacturers I installed.  It's my original manufaturers, I have it moded to work as Shop by price.  The additional box that shows with (All categories) when a price range is selected is not sorting, It's just refreshing the page.  Any idea where I can find this bug?  Thanks again, Ronnie   Hello I am very interested. Where can I find this package of 5 manufacturers? Quote Link to comment Share on other sites More sharing options...
Simpel Posted March 24, 2011 Share Posted March 24, 2011 Thanks a lot, Rachael! Your sample helped me to show manufacturer2 on my product listing.  I added a data as PRODUCT_LIST_MANUFACTURER2 on configuration table. And I duplicated PRODUCT_LIST_MANUFACTURER & renamed it as PRODUCT_LIST_MANUFACTURER2 on index.php and product_listing.php.  Thanks, Aki  It's not that easy for me. Can you show me your complete index.php file? I got manufacturer 1, 2 and 3. The code itself seems ok. But I can only show one manufacturer at the time in the product listing. Not all together. Quote Link to comment Share on other sites More sharing options...
andes1 Posted June 16, 2011 Author Share Posted June 16, 2011 It's not that easy for me. Can you show me your complete index.php file? I got manufacturer 1, 2 and 3. The code itself seems ok. But I can only show one manufacturer at the time in the product listing. Not all together.  hello  first this is for 2.2 version of oscommerce. second, do the same steps in order to create manufacturers 3,4,5 etc Quote Link to comment Share on other sites More sharing options...
steffanih Posted August 23, 2011 Share Posted August 23, 2011 (edited) Hi this is a wonderful little add-on, but I am having one problem that I have identified is somewhere in the index portion. I have three little pulldown menus in my column_left.php that operate from manufacturers.php, manufacturers2.php, and categories.php in that order. When I add the code to my index in the instructions, it does not function. I copied the code in my index that uses manufacturers and just started adding the 2 on the end of everything. The manufacturers2 works great after that, but the regular manufactures.php and categories.php no long sort...something with the filter? I've included my code below and a screenshot of the pulldown menus. Does anyone know how I might get all three functioning? (I have the manufactures2 section commented out for now so the other two pulldowns work) <?php /* $Id: index.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License 960 grid system adapted from Nathan Smith http://960.gs/ OSCommerce on CSS Grid960 v2.0 http://www.niora.com/css-oscommerce.php */ require('includes/application_top.php'); // fix manufacture reset bug if (isset($_GET['manufacturers_id']) && !tep_not_null($_GET['manufacturers_id'])) { tep_redirect(tep_href_link(FILENAME_DEFAULT));} // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { if ($cateqories_products['total'] == 1) { $query = tep_db_query("select p2c.products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where categories_id = '" . (int)$current_category_id . "'"); $prods_arr = tep_db_fetch_array($query); $prods_id = $prods_arr['products_id']; tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO,'products_id='.$prods_id)); } $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT); echo $doctype; ?> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <?php echo $stylesheet; ?> <?php // Start Banner Rotator; ?> <script type="text/javascript" src="includes/functions/jquery-1.4.2.min.js"></script> <script type="text/javascript" src="includes/functions/bannerRotator.js"></script> <script type="text/javascript"> $(document).ready(function(){ bannerRotator('#bannerRotator', 500, 5000); }); </script> <?php // End Banner Rotator; ?> <?php require(DIR_WS_INCLUDES . 'template-top.php'); ?> <?php if ($category_depth == 'nested') { $category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'"); $category = tep_db_fetch_array($category_query); ?> <link href="css/styles.css" rel="stylesheet" type="text/css"> <?php include (DIR_WS_INCLUDES . 'page-header-inc.htc'); ?> <style type="text/css"> <!-- body { margin-left: 0px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; } .dent { margin-left: 25px; } --> </style> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script> <script type="text/javascript" src="js/zoomer.jquery.js"></script> <script type="text/javascript"> $(function() { $("#wrap").anythingZoomer({ expansionSize: 30, speedMultiplier: 2.2 }); }); </script> <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-22883692-2']); _gaq.push(['_setDomainName', 'none']); _gaq.push(['_setAllowLinker', true]); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })(); </script> </head> <span class="leftfloat"><h1><?php echo HEADING_TITLE; ?></h1></span> <?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); if (isset($cPath) && strpos('_', $cPath)) { // check to see if there are deeper categories within the current category $category_links = array_reverse($cPath_array); for($i=0, $n=sizeof($category_links); $i<$n; $i++) { $categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'"); $categories = tep_db_fetch_array($categories_query); if ($categories['total'] < 1) { // do nothing, go through the loop } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); break; // we've found the deepest category the customer is in } } } else { $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name"); } while ($categories = tep_db_fetch_array($categories_query)) { $cPath_new = tep_get_path($categories['categories_id']); echo ' <div class="pl categories"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></div>' . "\n"; } // needed for the new products module shown below $new_products_category_id = $current_category_id; ?> <?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) { // create column list $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_SUBNAME' => PRODUCT_LIST_SUBNAME, 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_SUBNAME': $select_column_list .= 'pd.products_subname, '; break; case 'PRODUCT_LIST_MANUFACTURER': $select_column_list .= 'm.manufacturers_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } // show the products of a specified manufacturer // BOF qpbpp if (isset($HTTP_GET_VARS['manufacturers_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category //$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } else { // We show them all //$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; } } else { // show the products in a given categorie if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory //$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // We show them all //$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } } //EOF qpbpp if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('^[1-8][ad]$', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_SUBNAME': $listing_sql .= " order by pd.products_subname " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= " order by m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= " order by pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= " order by final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?> <h1><?php echo HEADING_TITLE; ?></h1> <?php // Get the right image for the top-right $image = DIR_WS_IMAGES . 'table_background_list.gif'; if (isset($HTTP_GET_VARS['manufacturers_id'])) { $image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); $image = tep_db_fetch_array($image); $image = $image['manufacturers_image']; } elseif ($current_category_id) { $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $image = tep_db_fetch_array($image); $image = $image['categories_image']; } ?> <?php // manufacturers image echo tep_image(DIR_WS_IMAGES . $image, HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT,'','stock-image'); ?> <div class="clear"></div> <?php // start optional Product List Filter if (PRODUCT_LIST_FILTER > 0) { if (isset($HTTP_GET_VARS['manufacturers_id'])) { $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name"; } else { $filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name"; } $filterlist_query = tep_db_query($filterlist_sql); if (tep_db_num_rows($filterlist_query) > 1) { echo ' <div class="right">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . 'Â '; if (isset($HTTP_GET_VARS['manufacturers_id'])) { echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']); $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES)); } else { echo tep_draw_hidden_field('cPath', $cPath); $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS)); } echo tep_draw_hidden_field('sort', $_GET['sort']).(isset($_GET['list']) ? tep_draw_hidden_field('list', $_GET['list']) : '') . (isset($_GET['max']) ? tep_draw_hidden_field('max', $_GET['max']) : ''); while ($filterlist = tep_db_fetch_array($filterlist_query)) { $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']); } echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"'); echo tep_hide_session_id() . '</form></div><div class="clear"></div>' . "\n"; } } /* } elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers2_id'])) { // create column list $define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL, 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME, 'PRODUCT_LIST_SUBNAME' => PRODUCT_LIST_SUBNAME, 'PRODUCT_LIST_MANUFACTURER2' => PRODUCT_LIST_MANUFACTURER2, 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE, 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY, 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT, 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE, 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW); asort($define_list); $column_list = array(); reset($define_list); while (list($key, $value) = each($define_list)) { if ($value > 0) $column_list[] = $key; } $select_column_list = ''; for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { switch ($column_list[$i]) { case 'PRODUCT_LIST_MODEL': $select_column_list .= 'p.products_model, '; break; case 'PRODUCT_LIST_NAME': $select_column_list .= 'pd.products_name, '; break; case 'PRODUCT_LIST_SUBNAME': $select_column_list .= 'pd.products_subname, '; break; case 'PRODUCT_LIST_MANUFACTURER2': $select_column_list .= 'm.manufacturers2_name, '; break; case 'PRODUCT_LIST_QUANTITY': $select_column_list .= 'p.products_quantity, '; break; case 'PRODUCT_LIST_IMAGE': $select_column_list .= 'p.products_image, '; break; case 'PRODUCT_LIST_WEIGHT': $select_column_list .= 'p.products_weight, '; break; } } // show the products of a specified manufacturer // BOF qpbpp if (isset($HTTP_GET_VARS['manufacturers2_id'])) { if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only a specific category //$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers2_id, p.products_price, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS2 . " m2, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers2_id = m2.manufacturers2_id and m2.manufacturers2_id = '" . (int)$HTTP_GET_VARS['manufacturers2_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; } else { // We show them all //$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"; $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers2_id, p.products_price, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS2 . " m2 where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers2_id = m2.manufacturers2_id and m2.manufacturers2_id = '" . (int)$HTTP_GET_VARS['manufacturers2_id'] . "'"; } } else { // show the products in a given categorie if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // We are asked to show only specific catgeory //$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers2_id, p.products_price, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS2 . " m2, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers2_id = m2.manufacturers2_id and m2.manufacturers2_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } else { // We show them all //$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers2_id, p.products_price, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS2 . " m2 on p.manufacturers2_id = m2.manufacturers2_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'"; } } //EOF qpbpp if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('^[1-8][ad]$', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) { for ($i=0, $n=sizeof($column_list); $i<$n; $i++) { if ($column_list[$i] == 'PRODUCT_LIST_NAME') { $HTTP_GET_VARS['sort'] = $i+1 . 'a'; $listing_sql .= " order by pd.products_name"; break; } } } else { $sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1); $sort_order = substr($HTTP_GET_VARS['sort'], 1); $listing_sql .= ' order by '; switch ($column_list[$sort_col-1]) { case 'PRODUCT_LIST_MODEL': $listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_SUBNAME': $listing_sql .= " order by pd.products_subname " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER2': $listing_sql .= " order by m2.manufacturers2_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= " order by pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= " order by final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?> <h1><?php echo HEADING_TITLE; ?></h1> <?php // Get the right image for the top-right $image = DIR_WS_IMAGES . 'table_background_list.gif'; if (isset($HTTP_GET_VARS['manufacturers2_id'])) { $image = tep_db_query("select manufacturers2_image from " . TABLE_MANUFACTURERS2. " where manufacturers2_id = '" . (int)$HTTP_GET_VARS['manufacturers2_id'] . "'"); $image = tep_db_fetch_array($image); $image = $image['manufacturers2_image']; } elseif ($current_category_id) { $image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $image = tep_db_fetch_array($image); $image = $image['categories_image']; } ?> <?php // manufacturers image echo tep_image(DIR_WS_IMAGES . $image, HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT,'','stock-image'); ?> <div class="clear"></div> <?php // start optional Product List Filter if (PRODUCT_LIST_FILTER > 0) { if (isset($HTTP_GET_VARS['manufacturers2_id'])) { $filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers2_id = '" . (int)$HTTP_GET_VARS['manufacturers2_id'] . "' order by cd.categories_name"; } else { $filterlist_sql= "select distinct m2.manufacturers2_id as id, m2.manufacturers2_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS2 . " m2 where p.products_status = '1' and p.manufacturers2_id = m2.manufacturers2_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m2.manufacturers2_name"; } $filterlist_query = tep_db_query($filterlist_sql); if (tep_db_num_rows($filterlist_query) > 1) { echo ' <div class="right">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . 'Â '; if (isset($HTTP_GET_VARS['manufacturers2_id'])) { echo tep_draw_hidden_field('manufacturers2_id', $HTTP_GET_VARS['manufacturers2_id']); $options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES)); } else { echo tep_draw_hidden_field('cPath', $cPath); $options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS2)); } echo tep_draw_hidden_field('sort', $_GET['sort']).(isset($_GET['list']) ? tep_draw_hidden_field('list', $_GET['list']) : '') . (isset($_GET['max']) ? tep_draw_hidden_field('max', $_GET['max']) : ''); while ($filterlist = tep_db_fetch_array($filterlist_query)) { $options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']); } echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"'); echo tep_hide_session_id() . '</form></div><div class="clear"></div>' . "\n"; } }*/ include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); } else { ?> <div class="indhide"> <div class="grid_8 alpha"> <?php require('souvenirs.php'); ?> <?php require('category_map.php'); ?> </div></div> <?php } require(DIR_WS_INCLUDES . 'template-bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> Edited August 23, 2011 by steffanih Quote Link to comment Share on other sites More sharing options...
crashtest Posted July 13, 2012 Share Posted July 13, 2012 Hello. I appreciate this contribution. It helps me a lot. But I have a problem same as lsousa04. I installed MANUFACTURER2 MODULE but when I add or update a product, I can't save manufacturer2. The data is saved except manufacturers2_id. Â I checked sql which is provided and saw my database. There is manufacturers2_id column in products table. And I checked installation of the module. I think I did as it says. I didn't get 'check the code that write on your db. consult the installation instucctions'. Â Could anyone give me some advice? Â i have the same problem with this contribution.... What's the solution to make it work ? Something else, the manufacturers_2 box doesn't appear, and there's no manufacturer in categories... Quote Link to comment Share on other sites More sharing options...
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.