butchx5

Hi Thanks for your contribution. I have uploaded it as per your instructions and after installing CKEditor it did appear in my admin (product description). However, i continued and installed KFM and it no longer appears. I think the problem may lie in step 3 of KFM installation: I am working on localhost at the moment so am not sure what I should use for: $kfm_userfiles_address = '/home/USER_NAME/catalog/images'; I've tried ='localhost/myoscommerceadministratorusername/catalog/images'; or $kfm_userfiles_output = 'http://www.DOMAIN_NAME/catalog/images/'; I've tried ='http://localhost/catalog/images/'; Can you spoon feed me what I should be using please. Helen

Hi Looking for an add on like RSS Feed but I am running V2.3 - does anyone know if one exists or how to adapt the existing one for V2.2?? Thanks Helen

Thanks kymation couldn't get that to work but after your hint and more trawling the net I used this: .goog-te-gadget-simple {font-family: Segoe UI, Helvetica, Arial, sans-serif; background-color: #333300; border: none; font-size: 6px; cursor: default; line-height: 1; width: 100%;} .goog-te-gadget-simple img{display:none;} It just about works Helen

Hi I don't know how Dali45 incorporated it but I created a new box using Generic Box for 2.3.x called it Translate Box then just copy and pasted the Google code from HERE into it. Works a treat. I am trying to work out how to create some code so the Select Language drop down blends with my site. Helen

Hi I have installed google translate into my website (localhost only at the mo) via the creation of a Generic Box. Everything works fine. However, the widget sticks out like a sore thumb as the colours/fonts don't blend in with my site theme and as the font is too large the widget spreads outside of the box. I have searched high and low for a way to edit the look of the widget and can't find anything - does anyone have any ideas?? This is the standard coding supplied by Google: <div id=\"google_translate_element\"></div><script> function googleTranslateElementInit() { new google.translate.TranslateElement({ pageLanguage: 'en', layout: google.translate.TranslateElement.InlineLayout.SIMPLE }, 'google_translate_element'); } </script><script src=\"//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit\"></script> What I'm hoping is that I can add some code to control the look of the element. Helen

Hi I am running V 2.2 Have installed One Page Checkout but get this message in admin: Warning: include() [function.include]: Unable to access /public_html/mysite.com/includes/languages/english/modules/payment/paypal_pro_dp.php in /mysite.com/admin/modules.php on line 128 There are also: [function.include]: failed to open stream: No such file or directory in /admin/modules.php on line128 [function.include]: Unable to access ................... /admin/modules.phpon line 128 [function.include]: failed to open stream: No such file or directory in admin/modules.php on line128 [function.include]: Failed opening 'english/modules/payment/paypal_pro_dp.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in/admin/modules.php on line 128 Can anyone point me in the right direction to resolve this please?? Thanks so much Helen

Hi Hoping someone can help I'm using a template monster template and want to add in Header Tags SEO but I'm struggling with how to adjust my index.php (1st code) with what Header Tags SEO is suggesting (2nd code) $p_pic_sub = '<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) . '</a>'; $p_name_sub = '<b><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . $categories['categories_name'] . '</a></b>'; FIND (Around line 78) <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> REPLACE with <?php /*** Begin Header Tags SEO ***/ ?> <td><h1><?php echo $category['categories_htc_title_tag']; ?></h1></td> <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> <?php if (tep_not_null($category['categories_htc_description'])) { ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td colspan="2"><h2><?php echo $category['categories_htc_description']; ?></h2></td> </tr> <?php } /*** End Header Tags SEO ***/ ?> Anyone have any ideas?? Thanks Helen

Yyyyyyyyyyyyaaaaaaaaaaaaayyyyyyyyyyy!!!! I winmerged my code and yours and there was only 1 difference - a dot!!!! at the end of the line WHOS_ONLINE. '</a><br>' . THANK YOU!! I can now get on with uploading the rest of the contributions I have chosen.

AAAGGGGHHHHH!!! Frustrating - I now get: Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /admin/includes/boxes/tools.php on line 33

Hi Here's the code: <?php /* $Id: tools.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ ?> <!-- tools //--> <tr> <td> <?php $heading = array(); $contents = array(); $heading[] = array('text' => BOX_HEADING_TOOLS, 'link' => tep_href_link(FILENAME_BACKUP, 'selected_box=tools')); if ($selected_box == 'tools') { $contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_BACKUP) . '" class="menuBoxContentLink">' . BOX_TOOLS_BACKUP . '</a><br>' . '<a href="' . tep_href_link(FILENAME_STORE_BACKUP) . '" class="menuBoxContentLink" >' . BOX_TOOLS_STORE_BACKUP . '</a><br>' . '<a href="' . tep_href_link(FILENAME_BANNER_MANAGER) . '" class="menuBoxContentLink">' . BOX_TOOLS_BANNER_MANAGER . '</a><br>' . '<a href="' . tep_href_link(FILENAME_CACHE) . '" class="menuBoxContentLink">' . BOX_TOOLS_CACHE . '</a><br>' . '<a href="' . tep_href_link(FILENAME_DEFINE_LANGUAGE) . '" class="menuBoxContentLink">' . BOX_TOOLS_DEFINE_LANGUAGE . '</a><br>' . '<a href="' . tep_href_link(FILENAME_MAIL) . '" class="menuBoxContentLink">' . BOX_TOOLS_MAIL . '</a><br>' . '<a href="' . tep_href_link(FILENAME_NEWSLETTERS) . '" class="menuBoxContentLink">' . BOX_TOOLS_NEWSLETTER_MANAGER . '</a><br>' . '<a href="' . tep_href_link(FILENAME_SERVER_INFO) . '" class="menuBoxContentLink">' . BOX_TOOLS_SERVER_INFO . '</a><br>' . '<a href="' . tep_href_link(FILENAME_WHOS_ONLINE) . '" class="menuBoxContentLink">' . BOX_TOOLS_WHOS_ONLINE . '</a><br>' '<a href="' . tep_href_link(FILENAME_MAILBEEZ, '', 'NONSSL') . '">MailBeez</a><br>'); ) $box = new box; echo $box->menuBox($heading, $contents); ?> </td> </tr> <!-- tools_eof //--> Thanks, again. Helen

Hi Dan Thank you for sparing the time to try and help. Made that change and now I get this message: Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /admin/includes/boxes/tools.php on line 33 Any further ideas? Helen

Hi Am just trying to install Mailbeez to my Oscommerce site v 2.2 RC2a. When I goto admin I get the following error: Parse error: syntax error, unexpected T_VARIABLE in /home/xpertdr1/public_html/stik-r.com/admin/includes/boxes/tools.php on line 36 This is my code - can anyone help out and advise me how to adjust things so I can do the install. Thanks Helen <?php /* $Id: tools.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ ?> <!-- tools //--> <tr> <td> <?php $heading = array(); $contents = array(); $heading[] = array('text' => BOX_HEADING_TOOLS, 'link' => tep_href_link(FILENAME_BACKUP, 'selected_box=tools')); if ($selected_box == 'tools') { $contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_BACKUP) . '" class="menuBoxContentLink">' . BOX_TOOLS_BACKUP . '</a><br>' . '<a href="' . tep_href_link(FILENAME_STORE_BACKUP) . '" class="menuBoxContentLink" >' . BOX_TOOLS_STORE_BACKUP . '</a><br>' . '<a href="' . tep_href_link(FILENAME_BANNER_MANAGER) . '" class="menuBoxContentLink">' . BOX_TOOLS_BANNER_MANAGER . '</a><br>' . '<a href="' . tep_href_link(FILENAME_CACHE) . '" class="menuBoxContentLink">' . BOX_TOOLS_CACHE . '</a><br>' . '<a href="' . tep_href_link(FILENAME_DEFINE_LANGUAGE) . '" class="menuBoxContentLink">' . BOX_TOOLS_DEFINE_LANGUAGE . '</a><br>' . '<a href="' . tep_href_link(FILENAME_MAIL) . '" class="menuBoxContentLink">' . BOX_TOOLS_MAIL . '</a><br>' . '<a href="' . tep_href_link(FILENAME_NEWSLETTERS) . '" class="menuBoxContentLink">' . BOX_TOOLS_NEWSLETTER_MANAGER . '</a><br>' . '<a href="' . tep_href_link(FILENAME_SERVER_INFO) . '" class="menuBoxContentLink">' . BOX_TOOLS_SERVER_INFO . '</a><br>' . '<a href="' . tep_href_link(FILENAME_WHOS_ONLINE) . '" class="menuBoxContentLink">' . BOX_TOOLS_WHOS_ONLINE . '</a><br>' . '<br><a href="' . tep_href_link(FILENAME_MAILBEEZ, '', 'NONSSL') . '">MailBeez</a><br>' ) $box = new box; echo $box->menuBox($heading, $contents); ?> </td> </tr> <!-- tools_eof //-->

Hi I am creating a site using a template monster template and have just tried to install Header Tags SEO only to discover that my index.php or product_info.php files do not have the following code: <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> Where could it be? This is the full coding for my index.php. <?php error_reporting(E_ALL); ini_set('display_errors', '1');/* $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 */ 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> <?php require(DIR_WS_INCLUDES . 'header_includes.php'); ?> </head> <body> <?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); ?> <!-- header //--> <?php $tab_sel = 2; ?> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <?php $sum2 = 0; ?> <!-- body //--> <table border="0" class="<?php echo MAIN_TABLE; ?>" cellspacing="0" cellpadding="0" align="center"> <tr> <td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td class="<?php echo CONTENT_WIDTH_TD; ?>"> <?php echo tep_draw_top();?><?php include(DIR_WS_BOXES . 'panel_top.php');?> <?php new contentBoxHeading_ProdNew($info_box_contents);?><?php echo tep_draw3_top();?> <table border="0" width="100%" cellspacing="0" cellpadding="0" class="main sub_category"> <tr> <?php 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"); } $number_of_categories = tep_db_num_rows($categories_query); $rows = 0; while ($categories = tep_db_fetch_array($categories_query)) { $rows++; $cPath_new = tep_get_path($categories['categories_id']); $p_pic_sub = '<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) . '</a>';$p_name_sub = '<b><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . $categories['categories_name'] . '</a></b>'; $width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%'; echo '<td align="center" width="' . $width . '">'.tep_draw_prod2_top().' <table cellpadding="0" cellspacing="0" border="0" class="wrapper_box"> <tr><td class="pic2_padd">'.tep_draw_prod_pic_top().''.$p_pic_sub.''.tep_draw_prod_pic_bottom().'</td></tr> <tr><td class="name name4_padd">'.$p_name_sub.'</td></tr> </table>'.tep_draw_prod2_bottom().' </td>'."\n"; if ($col!=(MAX_DISPLAY_CATEGORIES_PER_ROW-1)){ echo ' <td class="prod_line_y padd_vv">'.tep_draw_separator('spacer.gif', '1', '1').'</td> '; }else{ if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) { echo ' </tr><tr><td class="prod_line_x padd_gg" colspan="'.(MAX_DISPLAY_CATEGORIES_PER_ROW + MAX_DISPLAY_CATEGORIES_PER_ROW -1).'">'.tep_draw_separator('spacer.gif', '1', '1').'</td></tr>' . "\n"; echo '<tr>' . "\n"; } } if ($col==MAX_DISPLAY_CATEGORIES_PER_ROW-1){ $col=0; }else{ $col++; } } // needed for the new products module shown below $new_products_category_id = $current_category_id; ?> </tr> </table> <?php echo tep_draw3_bottom();?><?php /*echo tep_draw_bottom();*/?> <?php /*echo tep_draw_top();*/?> <?php new contentBoxHeading_WHATS_NEW($info_box_contents, true, false);?> <br> <?php echo tep_draw3_top();?> <?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?> <?php echo tep_draw3_bottom();?> <?php echo tep_draw_bottom();?><?php include(DIR_WS_BOXES . 'panel_bottom.php');?></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); 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_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; } } ?> <!-- header //--> <?php $tab_sel = 2; ?> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <?php $sum2 = 0; ?> <!-- body //--> <table border="0" class="<?php echo MAIN_TABLE; ?>" cellspacing="0" cellpadding="0" align="center"> <tr> <td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td class="<?php echo CONTENT_WIDTH_TD; ?>"> <?php echo tep_draw_top();?><?php include(DIR_WS_BOXES . 'panel_top.php');?> <?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 tep_draw_side_top(); echo ' <table cellpadding="0" cellspacing="0" border="0" class="select2"> <tr><td align="right" class="main">' . tep_draw_form('filter', tep_href_link( FILENAME_DEFAULT ), 'get') . '<b>'.TEXT_SHOW . '</b>'; 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 tep_hide_session_id() . '</form></td></tr> </table>' . "\n"; echo tep_draw_side_bottom(); } } // 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 include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?> <!--- BEGIN Header Tags SEO Social Bookmarks --> <?php if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php'); ?> <!--- END Header Tags SEO Social Bookmarks --> <?php echo tep_draw_bottom();?><?php include(DIR_WS_BOXES . 'panel_bottom.php');?> </td> <?php } else { // default page ?> <!-- header //--> <?php $tab_sel = 222; ?> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <?php $sum2 = 0; ?> <!-- body //--> <table border="0" class="<?php echo MAIN_TABLE; ?>" cellspacing="0" cellpadding="0" align="center"> <tr> <td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo tep_draw_top();?><?php include(DIR_WS_BOXES . 'panel_top.php');?> <!-- Welcome_box_start --> <?php /* tep_draw_heading_top(); */?> <?php /* tep_draw_heading_top_3(); */?> <?php /* echo tep_draw_prod_top(); */ ?> <!-- <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> <tr><td class="main"><?php /* echo TEXT_MAIN; */ ?></td></tr> </table> --> <?php /* echo tep_draw_prod_bottom(); */ ?> <?php /* tep_draw_heading_bottom_3(); */?> <?php /* echo tep_draw_separate(); */ ?><!-- Welcome_box_end --> <?php new contentBoxHeading_ProdNew($info_box_contents);?><?php echo tep_draw3_top(); $sum2 = 1; ?> <?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?> <!--- BEGIN Header Tags SEO Social Bookmarks --> <?php if (HEADER_TAGS_DISPLAY_SOCIAL_BOOKMARKS == 'true') include(DIR_WS_MODULES . 'header_tags_social_bookmarks.php'); ?> <!--- END Header Tags SEO Social Bookmarks --> <?php echo tep_draw3_bottom();?> <?php include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS); ?> <?php echo tep_draw_bottom();?><?php include(DIR_WS_BOXES . 'panel_bottom.php');?></td> <?php } ?> <!-- body_text_eof //--> <td class="<?php echo BOX_WIDTH_TD_RIGHT; ?>"><table border="0" class="<?php echo BOX_WIDTH_RIGHT; ?>" cellspacing="0" cellpadding="0"> <!-- 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 //--> </body> <?php require(DIR_WS_INCLUDES . 'footer_includes.php'); ?> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> I'm guessing several things: Template monster have: have used alternative coding for the same outcome - in which case how/what do I change? included that section of coding in an alternative file - in which case how do I find it? for whaterever reason this code or an alternative is not part of the template - which I assume means I cannot use Header Tags SEO I welcome your thoughts and hopefully tips on how to proceed. Helen

Hi Have installed Security Pro latest version into my site v2.2 rc2a but when I run the suggested test by keying [w](o)%3Cr%3Ek|i*n^g in the site search box. After hitting return nothing appears in the search box and the site just returns There is no product that matches the search criteria. It is such a simple install would could I have done wrong??? Helen