peter888 Posted November 24, 2006 Share Posted November 24, 2006 hi, First of all, I like to say "Happy Thanksgiving to everyone". How to remove "New Products For November"? I like to move the "center(New Products For November)" of first page. any one knows how to remove it? Happy thanksgiving!!! Link to comment Share on other sites More sharing options...
usernamenone Posted November 24, 2006 Share Posted November 24, 2006 Hummmmmmmmm do you mean remove the wording or as you say remove the products? I will guess you mean remove the wording. You will find most of the wording in your language file. either includes/languages/english.php or includes/languages/english/index.php. There is a great knowledge base for reading. http://www.oscommerce.info/ So if you open your includes/languages/english/index.php. you will see how to change the text to something else on line 15. If you want to remove the products all together open our includes/modules and open new_products.php with a text editor. Then by adding the HIDE code which is /* ..... */ to the beginning and end of this entire file, I REMOVED this BOX from my design. hi, First of all, I like to say "Happy Thanksgiving to everyone". How to remove "New Products For November"? I like to move the "center(New Products For November)" of first page. any one knows how to remove it? Happy thanksgiving!!! Link to comment Share on other sites More sharing options...
bpmcclure Posted December 10, 2007 Share Posted December 10, 2007 Hummmmmmmmm do you mean remove the wording or as you say remove the products? I will guess you mean remove the wording. You will find most of the wording in your language file. either includes/languages/english.php or includes/languages/english/index.php. There is a great knowledge base for reading. http://www.oscommerce.info/ So if you open your includes/languages/english/index.php. you will see how to change the text to something else on line 15. If you want to remove the products all together open our includes/modules and open new_products.php with a text editor. Then by adding the HIDE code which is /* ..... */ to the beginning and end of this entire file, I REMOVED this BOX from my design. I tried putting this code at the beginning and end of the file as recommended, and I got... the code at the beginning and end of the New for December box below my Subcategory listings. Tried some other commenting out on this page, but nothing worked. Anyone know the secret here? Thanks, Bruce Link to comment Share on other sites More sharing options...
germ Posted December 10, 2007 Share Posted December 10, 2007 In your main index.php file, can you find this code: <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> :unsure: Change it to: <td><?php //include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
bpmcclure Posted December 10, 2007 Share Posted December 10, 2007 In your main index.php file, can you find this code: <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> :unsure: Change it to: <td><?php //include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td> Already did that and New Products box not on main page, but still shows up in middle of Subcategories page. That's my dilemma. Thanks, Bruce Link to comment Share on other sites More sharing options...
germ Posted December 10, 2007 Share Posted December 10, 2007 I'm as dense as tik wood, Bruce... Can you post a link (or PM it to me) so I can see what you're talking about? :unsure: If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
bpmcclure Posted December 10, 2007 Share Posted December 10, 2007 I'm as dense as tik wood, Bruce... Can you post a link (or PM it to me) so I can see what you're talking about? :unsure: Heres the offending page: http://suppertimexpress.com/oscommerce/index.php?cPath=37 Want to eliminate the New Products for... box if it can be done. Thanks for all the help! Bruce Link to comment Share on other sites More sharing options...
germ Posted December 10, 2007 Share Posted December 10, 2007 In my unadulterated copy of index.php, the line I said to change actually appears in the file twice. Does it in yours as well? :unsure: If so, you'll need to change both instances. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
bpmcclure Posted December 10, 2007 Share Posted December 10, 2007 Now who's dense! That was easy enough to be embarrassing. Who knew it was in there twice? :D Thanks a lot, glad you pros are around to help us dolts. Bruce Link to comment Share on other sites More sharing options...
germ Posted December 10, 2007 Share Posted December 10, 2007 (w00t) I'm the dolt... I should have checked! :lol: Glad we got it sorted out. :thumbsup: If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
mcpisik Posted July 6, 2008 Share Posted July 6, 2008 I'm as dense as tik wood, Bruce... Can you post a link (or PM it to me) so I can see what you're talking about? :unsure: Hi Jim, Was hoping you could tell me how to open my home page with a category, instead of New products. (ive asked elsewhere, but no replies) Would be very grateful for a point in the right direction... Thanks! Link to comment Share on other sites More sharing options...
germ Posted July 6, 2008 Share Posted July 6, 2008 I fiddled with the code and got it to open with a specified category, but the only way I know to get rid of the "New Products for..." is to "comment out" the code that makes it appear. Anyway, this may not be "according to Hoyle" but it worked for me and it's real simple to try. MAKE A BACKUP OF THIS FILE BEFORE MAKING ANY EDITS. At the top of your /catalog/index.php find this code: // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && tep_not_null($cPath)) { Change it to something like this: // the following cPath references come from application_top.php $category_depth = 'top'; // // beginning of added code: // if ( ! isset($cPath) || ($cPath=='') ) { $cPath_array[0] = 21; $cPath = 21; $current_category_id = 21; } // // end of added code // if (isset($cPath) && tep_not_null($cPath)) { I used the number 21 as an example. You'd need to replace that number with the number of the category it is that you wish to open. BE SURE TO USE THE SAME NUMBER ON ALL THREE LINES! Like I said, it isn't "according to Hoyle" but it worked for me. :blush: If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
mcpisik Posted July 8, 2008 Share Posted July 8, 2008 Absolutely superb! Has worked perfectly. I've been searching for so many hours to find someone else with that request but with no luck, so I'm very happy to have your suggestion. Thank you muchly... Link to comment Share on other sites More sharing options...
monicapepe Posted August 30, 2008 Share Posted August 30, 2008 That worked great! Took a few minutes to figure out the correct category id... For any newbies reading this post... the category ID for your products is contained in the table called Products_to_categories in your database. You'll need to access your db via SQL, and display the contents of this table (select the table then select browse). I guess this step depends on the application you use to view the database. Anywho... thank you for this quick edit. Its super easy and no need to install any contributions. Link to comment Share on other sites More sharing options...
hwkd Posted August 31, 2008 Share Posted August 31, 2008 That worked great! Took a few minutes to figure out the correct category id... For any newbies reading this post... the category ID for your products is contained in the table called Products_to_categories in your database. You'll need to access your db via SQL, and display the contents of this table (select the table then select browse). I guess this step depends on the application you use to view the database. Anywho... thank you for this quick edit. Its super easy and no need to install any contributions. Gentlemen, Well, I have now learned how to get rid of the what is new from my page, which I wanted to do. Thanks. My general problem is that my products will not list for on the category page after the cateogry is selected from the category listing in the left column. They will appear if you select from the manufacturer listing. Web site: http://superparrots.com/ Have I goofed something in the db? Cordially, hwkd Link to comment Share on other sites More sharing options...
germ Posted August 31, 2008 Share Posted August 31, 2008 In your Admin set "Use Search-Engine Safe URLs (still in development)" to false Save it. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
day2 Posted September 6, 2008 Share Posted September 6, 2008 Awesome!! Fantastic!! Link to comment Share on other sites More sharing options...
day2 Posted September 8, 2008 Share Posted September 8, 2008 Awesome!! Fantastic!! Hey Buddy, one problem, the Manufacturer others product and search by manufacturer no longer works with this option!! http://you domain.com/store/index.php?manufacturers_id=1 will be redirected to this catalog page. :blink: Link to comment Share on other sites More sharing options...
germ Posted September 8, 2008 Share Posted September 8, 2008 You might find something useful here: Click Me My site doesn't use manufacturers much so I haven't delved into that side of things. If you can't get it resolved I'll look into it a bit later. I'm working on a bit of code for a friend at the present. If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you. "Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice." - Me - "Headers already sent" - The definitive help "Cannot redeclare ..." - How to find/fix it SSL Implementation Help Like this post? "Like" it again over there > Link to comment Share on other sites More sharing options...
day2 Posted September 12, 2008 Share Posted September 12, 2008 You might find something useful here: Click Me My site doesn't use manufacturers much so I haven't delved into that side of things. If you can't get it resolved I'll look into it a bit later. I'm working on a bit of code for a friend at the present. Thanks. U are a nice guy :lol: Link to comment Share on other sites More sharing options...
macmizer Posted September 16, 2008 Share Posted September 16, 2008 I have made the change listed in this forum and it did seem to work. On the following url I need to show just the category called Negus Gold Jewelry on the mainpage. http://demos.onlineacc.com/negus/ What was happening before this change is the mainpage would read Welcome Guest and then right below that it shows the New Products for September. I was showing Gold and Silver products. The heading of the page read "Welcome to Negus Jewelry The place for all your Ethiopian Orthodox and Roots Culture Jewelry Stores Welcome Guest! Would you like to log yourself in? Or would you prefer to create an account? " Once I added the suggested change it removed all the text I just pasted above and shows the heading Negus Gold Jewlery only which is the category name I want to show on the page but I still wanted it to show the above text with the Welcome text as well. Anyway I can show all of this simultaneously? Link to comment Share on other sites More sharing options...
PJ2006 Posted October 29, 2008 Share Posted October 29, 2008 Already did that and New Products box not on main page, but still shows up in middle of Subcategories page. That's my dilemma. Thanks, Bruce I dont' have these lines in my main index file. I want to remove New products for.... from the home page and also for the categories. <?php /* $Id: index.php,v 1.1 2003/06/11 17:37:59 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'); // 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) { $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); ?> <!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"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- 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 //--> <?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); ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <?php if (isset($cPath) && strpos('_', $cPath)) { ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <?php // 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 } } ?> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } 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"); } $number_of_categories = tep_db_num_rows($categories_query); $rows = 0; while ($categories = tep_db_fetch_array($categories_query)) { $rows++;exit $cPath_new = tep_get_path($categories['categories_id']); $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%'; echo ' <td align="center" class="smallText" width="' . $width . '" valign="top"><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></td>' . "\n"; if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) { echo ' </tr>' . "\n"; echo ' <tr>' . "\n"; } */ } // needed for the new products module shown below $new_products_category_id = $current_category_id; ?> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?></td> </tr> </table></td> </tr> </table></td> <?php } 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_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_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 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'] . "'"; } 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'] . "'"; } } 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 . "'"; } 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 . "'"; } } 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 .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_NAME': $listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : ''); break; case 'PRODUCT_LIST_MANUFACTURER': $listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_QUANTITY': $listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_IMAGE': $listing_sql .= "pd.products_name"; break; case 'PRODUCT_LIST_WEIGHT': $listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; case 'PRODUCT_LIST_PRICE': $listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name"; break; } } ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"></td> <?php // 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 ' <td align="center" class="main">' . 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', $HTTP_GET_VARS['sort']); 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 '</form></td>' . "\n"; } } // 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']; } ?> </tr> </table></td> </tr> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td> </tr> </table></td> <?php } else { // default page ?> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"></td> <td class="pageHeading"></td> </tr> </table></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"> <tr> <td class="main"><?php echo tep_customer_greeting(); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> <tr> <td class="main"><?php include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFINE_MAINPAGE); ?></td> </tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><?php include(DIR_WS_MODULES . FILENAME_FEATURED); ?></td> </tr> <?php include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS); ?> </table></td> </tr> </table></td> <?php } ?> <!-- 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'); ?> Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.