Jump to content

crapu

Members
  • Content count

    14
  • Joined

  • Last visited

  1. crapu

    Header Tags SEO

    I also noticed that this time there are some aspects that don't work: If in page control -> product_info.php I introduce custom title, description, keywords, when I press 'view result' they don't display: And with these settings in all the pages product_info (products, categories and manufacturers) I only get the default title. You can check the site at www.nevertebrate.ro. P.S.: the index file settings from the page control panel works fine. It has something to do with the damn Ultimate SEO urls contribution. Thanks in advance for your help
  2. crapu

    Header Tags SEO

    Jack, you were right here. At that point, when I had the oscommerce freshly reinstalled, header tags SEO automatically installed, your contribution worked great. Therefore I continued editing my shop and installing contributions. Among these were the Ultimate SEO urls. Right after I installed that one, I have the problem again. The headertags it is screwed again. I read SpankyAndy's post and I looked through the /header_tags.php file and it seems that, as you said, I have that code inserted. I will paste the entire file at the end of the post. Please tell me what can I do next in order to get both contributions working together. Thanks <?php /* $Id: header_tags_seo.php,v 3.0 2008/01/10 by Jack_mcs osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Portions Copyright 2009 oscommerce-solution.com Released under the GNU General Public License */ require_once(DIR_WS_FUNCTIONS . 'header_tags.php'); require_once(DIR_WS_FUNCTIONS . 'clean_html_comments.php'); // Clean out HTML comments from ALT tags etc. $header_tags_array = array(); $sortOrder = array(); $tmpTags = array(); $defaultTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS_DEFAULT . " where language_id = '" . (int)$languages_id . "'"); $defaultTags = tep_db_fetch_array($defaultTags_query); $tmpTags['def_title'] = (tep_not_null($defaultTags['default_title'])) ? $defaultTags['default_title'] : ''; $tmpTags['def_desc'] = (tep_not_null($defaultTags['default_description'])) ? $defaultTags['default_description'] : ''; $tmpTags['def_keywords'] = (tep_not_null($defaultTags['default_keywords'])) ? $defaultTags['default_keywords'] : ''; $tmpTags['def_logo_text'] = (tep_not_null($defaultTags['default_logo_text'])) ? $defaultTags['default_logo_text'] : ''; // Define specific settings per page: switch (true) { // INDEX.PHP case (basename($_SERVER['PHP_SELF']) === FILENAME_DEFAULT): $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . FILENAME_DEFAULT . "' and language_id = '" . (int)$languages_id . "'"); $pageTags = tep_db_fetch_array($pageTags_query); $catStr = "select categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "' and language_id = '" . (int)$languages_id . "'"; $manStr = "select mi.manufacturers_htc_title_tag as htc_title_tag, mi.manufacturers_htc_desc_tag as htc_desc_tag, mi.manufacturers_htc_keywords_tag as htc_keywords_tag from " . TABLE_MANUFACTURERS . " m LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "'"; if ($pageTags['append_root'] || $category_depth == 'top' && ! isset($_GET['manufacturers_id']) ) { $sortOrder['title'][$pageTags['sortorder_root']] = $pageTags['page_title']; $sortOrder['description'][$pageTags['sortorder_root']] = $pageTags['page_description']; $sortOrder['keywords'][$pageTags['sortorder_root']] = $pageTags['page_keywords']; $sortOrder['logo'][$pageTags['sortorder_root']] = $pageTags['page_logo']; $sortOrder['logo_1'][$pageTags['sortorder_root_1']] = $pageTags['page_logo_1']; $sortOrder['logo_2'][$pageTags['sortorder_root_2']] = $pageTags['page_logo_2']; $sortOrder['logo_3'][$pageTags['sortorder_root_3']] = $pageTags['page_logo_3']; $sortOrder['logo_4'][$pageTags['sortorder_root_4']] = $pageTags['page_logo_4']; } $sortOrder = GetCategoryAndManufacturer($sortOrder, $pageTags, $defaultTags, $catStr, $manStr); if ($pageTags['append_default_title'] && tep_not_null($tmpTags['def_title'])) $sortOrder['title'][$pageTags['sortorder_title']] = $tmpTags['def_title']; if ($pageTags['append_default_description'] && tep_not_null($tmpTags['def_desc'])) $sortOrder['description'][$pageTags['sortorder_description']] = $tmpTags['def_desc']; if ($pageTags['append_default_keywords'] && tep_not_null($tmpTags['def_keywords'])) $sortOrder['keywords'][$pageTags['sortorder_keywords']] = $tmpTags['def_keywords']; if ($pageTags['append_default_logo'] && tep_not_null($tmpTags['def_logo_text'])) $sortOrder['logo'][$pageTags['sortorder_logo']] = $tmpTags['def_logo_text']; FillHeaderTagsArray($header_tags_array, $sortOrder); // Canonical URL add-on if (tep_not_null($cPath)) $canonical_url = tep_href_link(FILENAME_DEFAULT, 'cPath='.$cPath); break; // PRODUCT_INFO.PHP // PRODUCT_REVIEWS.PHP // PRODUCT_REVIEWS_INFO.PHP // PRODUCT_REVIEWS_WRITE.PHP case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_INFO): case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS): case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_INFO): case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_WRITE): switch (true) { case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_INFO): $filename = FILENAME_PRODUCT_INFO; break; case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS): $filename = FILENAME_PRODUCT_REVIEWS; break; case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_INFO): $filename = FILENAME_PRODUCT_REVIEWS_INFO; break; case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_WRITE): $filename = FILENAME_PRODUCT_REVIEWS_WRITE; break; default: $filename = FILENAME_PRODUCT_INFO; } $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . $filename . "' and language_id = '" . (int)$languages_id . "'"); $pageTags = tep_db_fetch_array($pageTags_query); $the_product_info_query = tep_db_query("select p.products_id, pd.products_head_title_tag, pd.products_head_keywords_tag, pd.products_head_desc_tag, p.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_id = '" . (int)$_GET['products_id'] . "' and pd.language_id ='" . $languages_id . "'"); $the_product_info = tep_db_fetch_array($the_product_info_query); $header_tags_array['product'] = $the_product_info['products_head_title_tag']; //save for use on the logo $tmpTags['prod_title'] = (tep_not_null($the_product_info['products_head_title_tag'])) ? $the_product_info['products_head_title_tag'] : ''; $tmpTags['prod_desc'] = (tep_not_null($the_product_info['products_head_desc_tag'])) ? $the_product_info['products_head_desc_tag'] : ''; $tmpTags['prod_keywords'] = (tep_not_null($the_product_info['products_head_keywords_tag'])) ? $the_product_info['products_head_keywords_tag'] : ''; $catStr = "select c.categories_htc_title_tag as htc_title_tag, c.categories_htc_desc_tag as htc_desc_tag, c.categories_htc_keywords_tag as htc_keywords_tag from " . TABLE_CATEGORIES_DESCRIPTION . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where c.categories_id = p2c.categories_id and p2c.products_id = '" . (int)$the_product_info['products_id'] . "' and language_id = '" . (int)$languages_id . "'"; $manStr = "select mi.manufacturers_htc_title_tag as htc_title_tag, mi.manufacturers_htc_desc_tag as htc_desc_tag, mi.manufacturers_htc_keywords_tag as htc_keywords_tag from " . TABLE_MANUFACTURERS . " m LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$the_product_info['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "' LIMIT 1"; if ($pageTags['append_root']) { $sortOrder['title'][$pageTags['sortorder_root']] = $pageTags['page_title']; $sortOrder['description'][$pageTags['sortorder_root']] = $pageTags['page_description']; $sortOrder['keywords'][$pageTags['sortorder_root']] = $pageTags['page_keywords']; $sortOrder['logo'][$pageTags['sortorder_root']] = $pageTags['page_logo']; $sortOrder['logo_1'][$pageTags['sortorder_root_1']] = $pageTags['page_logo_1']; $sortOrder['logo_2'][$pageTags['sortorder_root_2']] = $pageTags['page_logo_2']; $sortOrder['logo_3'][$pageTags['sortorder_root_3']] = $pageTags['page_logo_3']; $sortOrder['logo_4'][$pageTags['sortorder_root_4']] = $pageTags['page_logo_4']; } if ($pageTags['append_product']) { $sortOrder['title'][$pageTags['sortorder_product']] = $tmpTags['prod_title']; //places the product title at the end of the list $sortOrder['description'][$pageTags['sortorder_product']] = $tmpTags['prod_desc']; $sortOrder['keywords'][$pageTags['sortorder_product']] = $tmpTags['prod_keywords']; $sortOrder['logo'][$pageTags['sortorder_product']] = $tmpTags['prod_title']; } $sortOrder = GetCategoryAndManufacturer($sortOrder, $pageTags, $defaultTags, $catStr, $manStr, true); if ($pageTags['append_default_title'] && tep_not_null($tmpTags['def_title'])) $sortOrder['title'][$pageTags['sortorder_title']] = $tmpTags['def_title']; if ($pageTags['append_default_description'] && tep_not_null($tmpTags['def_desc'])) $sortOrder['description'][$pageTags['sortorder_description']] = $tmpTags['def_desc']; if ($pageTags['append_default_keywords'] && tep_not_null($tmpTags['def_keywords'])) $sortOrder['keywords'][$pageTags['sortorder_keywords']] = $tmpTags['def_keywords']; if ($pageTags['append_default_logo'] && tep_not_null($tmpTags['def_logo_text'])) $sortOrder['logo'][$pageTags['sortorder_logo']] = $tmpTags['def_logo_text']; FillHeaderTagsArray($header_tags_array, $sortOrder); // Canonical URL add-on if ($_GET['products_id'] != '') { $canonical_url = tep_href_link(basename($_SERVER['PHP_SELF']), 'products_id='.(int)$_GET['products_id']); } break; // SPECIALS.PHP case (basename($_SERVER['PHP_SELF']) === FILENAME_SPECIALS): $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . FILENAME_SPECIALS . "' and language_id = '" . (int)$languages_id . "'"); $pageTags = tep_db_fetch_array($pageTags_query); // Build a list of ALL specials product names to put in keywords $new = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC "); $row = 0; $the_specials=''; while ($new_values = tep_db_fetch_array($new)) { $the_specials .= clean_html_comments($new_values['products_name']) . ', '; } if (strlen($the_specials) > 30000) //arbitrary number - may vary with server setting $the_specials = substr($the_specials, 0, 30000); //adjust as needed if ($pageTags['append_root']) { $sortOrder['title'][$pageTags['sortorder_root']] = $pageTags['page_title']; $sortOrder['description'][$pageTags['sortorder_root']] = $pageTags['page_description']; $sortOrder['keywords'][$pageTags['sortorder_root']] = $pageTags['page_keywords']; $sortOrder['logo'][$pageTags['sortorder_root']] = $pageTags['page_logo']; $sortOrder['logo_1'][$pageTags['sortorder_root']] = $pageTags['page_logo_1']; $sortOrder['logo_2'][$pageTags['sortorder_root']] = $pageTags['page_logo_2']; $sortOrder['logo_3'][$pageTags['sortorder_root']] = $pageTags['page_logo_3']; $sortOrder['logo_4'][$pageTags['sortorder_root']] = $pageTags['page_logo_4']; } $sortOrder['keywords'][10] = $the_specials;; if ($pageTags['append_default_title'] && tep_not_null($tmpTags['def_title'])) $sortOrder['title'][$pageTags['sortorder_title']] = $tmpTags['def_title']; if ($pageTags['append_default_description'] && tep_not_null($tmpTags['def_desc'])) $sortOrder['description'][$pageTags['sortorder_description']] = $tmpTags['def_desc']; if ($pageTags['append_default_keywords'] && tep_not_null($tmpTags['def_keywords'])) $sortOrder['keywords'][$pageTags['sortorder_keywords']] = $tmpTags['def_keywords']; if ($pageTags['append_default_logo'] && tep_not_null($tmpTags['def_logo_text'])) $sortOrder['logo'][$pageTags['sortorder_logo']] = $tmpTags['def_logo_text']; FillHeaderTagsArray($header_tags_array, $sortOrder); break; // ALL OTHER PAGES NOT DEFINED ABOVE default: $header_tags_array['title'] = tep_db_prepare_input($defaultTags['default_title']); $header_tags_array['desc'] = tep_db_prepare_input($defaultTags['default_description']); $header_tags_array['keywords'] = tep_db_prepare_input($defaultTags['default_keywords']); break; } echo ' <title>' . $header_tags_array['title'] . '</title>' . "\n"; echo ' <meta name="Description" content="' . $header_tags_array['desc'] . '" />' . "\n"; echo ' <meta name="Keywords" content="' . $header_tags_array['keywords'] . '" />' . "\n"; if ($defaultTags['meta_google']) echo ' <meta name="googlebot" content="all" />' . "\n"; if ($defaultTags['meta_language']) echo ' <meta http-equiv="Content-Language" content="en-US" />'."\n"; if ($defaultTags['meta_noodp']) echo ' <meta name="robots" content="noodp" />' . "\n"; if ($defaultTags['meta_noydir']) echo ' <meta name="slurp" content="noydir" />' . "\n"; if ($defaultTags['meta_revisit']) echo ' <meta name="revisit-after" content="1 days" />' . "\n"; if ($defaultTags['meta_robots']) echo ' <meta name="robots" content="index, follow" />' . "\n"; if ($defaultTags['meta_unspam']) echo ' <meta name="no-email-collection" value="' . HTTP_SERVER . '" />' . "\n"; if ($defaultTags['meta_replyto']) echo ' <meta name="Reply-to" content="' . STORE_OWNER_EMAIL_ADDRESS . '"/>' . "\n"; if (tep_not_null($canonical_url)) echo ' <link rel="canonical" href="'.$canonical_url.'" />'. "\n"; echo ' <meta http-equiv="Content-Type" content="text/html; charset=' . CHARSET . '" />'."\n"; echo '<!-- EOF: Header Tags SEO Generated Meta Tags -->' . "\n"; ?>
  3. crapu

    Header Tags SEO

    Yes they are: Page control ->product_info.php Catalog -> page description edit
  4. crapu

    Header Tags SEO

    Thank you very much for all your help. I reinstalled a clean Oscommerce RC2.2 and then I did an automatic install. I installed the romanian language by copying and renaming the english language files to romanian both in the catalog/includes/languages and in admin/includes/languages. I set the romanian language to default. It seems that all the files in english work well: Example product in english , but the romanian don't even if it has the EXACT same files as the english: Example product in romanian . What other changes do I need to to get the romanian to work? Here are the test results: Thanks a lot!
  5. crapu

    Header Tags SEO

    Which included files? Do you mean the ones in the catalog_for_new_shop_only? I always did a manual install because I am using a website with 2 languages: english and romanian.
  6. crapu

    Header Tags SEO

    Hi Jack, Thanks for your reply. I reinstalled the store the 4th time to reinstall the Headertags fresh. Everything seems working except for the same product_info. I did what you asked me: - I filled tags, went to admin/product editing panel and all the tags have been filled (therefore as to your statements the problem is not on the admin side). When I go to the site, it shows only the default title - I went to page control -> product_info and I put some test title, description and keywords in the index.php and product_info.php files. I checked with the "View Result" checkbox and they were all introduced as I wanted. For the index.php they appear on the site so there is nothing wrong there. When I clink on categories and products the title displayed is the default title. What can I do now? Here is what the "Test" gives me (nothing wrong detected) Please help me get this to work. I have spent a couple of days now trying to get it working... Thank. P.S: The header_tags.php file is the one supplied in the contribution. I haven't made any changes there. I will display the code here: <?php /* $Id: header_tags_seo.php,v 3.0 2008/01/10 by Jack_mcs osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Portions Copyright 2009 oscommerce-solution.com Released under the GNU General Public License */ require_once(DIR_WS_FUNCTIONS . 'header_tags.php'); require_once(DIR_WS_FUNCTIONS . 'clean_html_comments.php'); // Clean out HTML comments from ALT tags etc. $header_tags_array = array(); $sortOrder = array(); $tmpTags = array(); $defaultTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS_DEFAULT . " where language_id = '" . (int)$languages_id . "'"); $defaultTags = tep_db_fetch_array($defaultTags_query); $tmpTags['def_title'] = (tep_not_null($defaultTags['default_title'])) ? $defaultTags['default_title'] : ''; $tmpTags['def_desc'] = (tep_not_null($defaultTags['default_description'])) ? $defaultTags['default_description'] : ''; $tmpTags['def_keywords'] = (tep_not_null($defaultTags['default_keywords'])) ? $defaultTags['default_keywords'] : ''; $tmpTags['def_logo_text'] = (tep_not_null($defaultTags['default_logo_text'])) ? $defaultTags['default_logo_text'] : ''; // Define specific settings per page: switch (true) { // INDEX.PHP case (basename($_SERVER['PHP_SELF']) === FILENAME_DEFAULT): $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . FILENAME_DEFAULT . "' and language_id = '" . (int)$languages_id . "'"); $pageTags = tep_db_fetch_array($pageTags_query); $catStr = "select categories_htc_title_tag as htc_title_tag, categories_htc_desc_tag as htc_desc_tag, categories_htc_keywords_tag as htc_keywords_tag from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "' and language_id = '" . (int)$languages_id . "'"; $manStr = "select mi.manufacturers_htc_title_tag as htc_title_tag, mi.manufacturers_htc_desc_tag as htc_desc_tag, mi.manufacturers_htc_keywords_tag as htc_keywords_tag from " . TABLE_MANUFACTURERS . " m LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "'"; if ($pageTags['append_root'] || $category_depth == 'top' && ! isset($_GET['manufacturers_id']) ) { $sortOrder['title'][$pageTags['sortorder_root']] = $pageTags['page_title']; $sortOrder['description'][$pageTags['sortorder_root']] = $pageTags['page_description']; $sortOrder['keywords'][$pageTags['sortorder_root']] = $pageTags['page_keywords']; $sortOrder['logo'][$pageTags['sortorder_root']] = $pageTags['page_logo']; $sortOrder['logo_1'][$pageTags['sortorder_root_1']] = $pageTags['page_logo_1']; $sortOrder['logo_2'][$pageTags['sortorder_root_2']] = $pageTags['page_logo_2']; $sortOrder['logo_3'][$pageTags['sortorder_root_3']] = $pageTags['page_logo_3']; $sortOrder['logo_4'][$pageTags['sortorder_root_4']] = $pageTags['page_logo_4']; } $sortOrder = GetCategoryAndManufacturer($sortOrder, $pageTags, $defaultTags, $catStr, $manStr); if ($pageTags['append_default_title'] && tep_not_null($tmpTags['def_title'])) $sortOrder['title'][$pageTags['sortorder_title']] = $tmpTags['def_title']; if ($pageTags['append_default_description'] && tep_not_null($tmpTags['def_desc'])) $sortOrder['description'][$pageTags['sortorder_description']] = $tmpTags['def_desc']; if ($pageTags['append_default_keywords'] && tep_not_null($tmpTags['def_keywords'])) $sortOrder['keywords'][$pageTags['sortorder_keywords']] = $tmpTags['def_keywords']; if ($pageTags['append_default_logo'] && tep_not_null($tmpTags['def_logo_text'])) $sortOrder['logo'][$pageTags['sortorder_logo']] = $tmpTags['def_logo_text']; FillHeaderTagsArray($header_tags_array, $sortOrder); // Canonical URL add-on if (tep_not_null($cPath)) $canonical_url = tep_href_link(FILENAME_DEFAULT, 'cPath='.$cPath); break; // PRODUCT_INFO.PHP // PRODUCT_REVIEWS.PHP // PRODUCT_REVIEWS_INFO.PHP // PRODUCT_REVIEWS_WRITE.PHP case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_INFO): case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS): case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_INFO): case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_WRITE): switch (true) { case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_INFO): $filename = FILENAME_PRODUCT_INFO; break; case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS): $filename = FILENAME_PRODUCT_REVIEWS; break; case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_INFO): $filename = FILENAME_PRODUCT_REVIEWS_INFO; break; case (basename($_SERVER['PHP_SELF']) === FILENAME_PRODUCT_REVIEWS_WRITE): $filename = FILENAME_PRODUCT_REVIEWS_WRITE; break; default: $filename = FILENAME_PRODUCT_INFO; } $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . $filename . "' and language_id = '" . (int)$languages_id . "'"); $pageTags = tep_db_fetch_array($pageTags_query); $the_product_info_query = tep_db_query("select p.products_id, pd.products_head_title_tag, pd.products_head_keywords_tag, pd.products_head_desc_tag, p.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_id = '" . (int)$_GET['products_id'] . "' and pd.language_id ='" . $languages_id . "'"); $the_product_info = tep_db_fetch_array($the_product_info_query); $header_tags_array['product'] = $the_product_info['products_head_title_tag']; //save for use on the logo $tmpTags['prod_title'] = (tep_not_null($the_product_info['products_head_title_tag'])) ? $the_product_info['products_head_title_tag'] : ''; $tmpTags['prod_desc'] = (tep_not_null($the_product_info['products_head_desc_tag'])) ? $the_product_info['products_head_desc_tag'] : ''; $tmpTags['prod_keywords'] = (tep_not_null($the_product_info['products_head_keywords_tag'])) ? $the_product_info['products_head_keywords_tag'] : ''; $catStr = "select c.categories_htc_title_tag as htc_title_tag, c.categories_htc_desc_tag as htc_desc_tag, c.categories_htc_keywords_tag as htc_keywords_tag from " . TABLE_CATEGORIES_DESCRIPTION . " c, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where c.categories_id = p2c.categories_id and p2c.products_id = '" . (int)$the_product_info['products_id'] . "' and language_id = '" . (int)$languages_id . "'"; $manStr = "select mi.manufacturers_htc_title_tag as htc_title_tag, mi.manufacturers_htc_desc_tag as htc_desc_tag, mi.manufacturers_htc_keywords_tag as htc_keywords_tag from " . TABLE_MANUFACTURERS . " m LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id where m.manufacturers_id = '" . (int)$the_product_info['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "' LIMIT 1"; if ($pageTags['append_root']) { $sortOrder['title'][$pageTags['sortorder_root']] = $pageTags['page_title']; $sortOrder['description'][$pageTags['sortorder_root']] = $pageTags['page_description']; $sortOrder['keywords'][$pageTags['sortorder_root']] = $pageTags['page_keywords']; $sortOrder['logo'][$pageTags['sortorder_root']] = $pageTags['page_logo']; $sortOrder['logo_1'][$pageTags['sortorder_root_1']] = $pageTags['page_logo_1']; $sortOrder['logo_2'][$pageTags['sortorder_root_2']] = $pageTags['page_logo_2']; $sortOrder['logo_3'][$pageTags['sortorder_root_3']] = $pageTags['page_logo_3']; $sortOrder['logo_4'][$pageTags['sortorder_root_4']] = $pageTags['page_logo_4']; } if ($pageTags['append_product']) { $sortOrder['title'][$pageTags['sortorder_product']] = $tmpTags['prod_title']; //places the product title at the end of the list $sortOrder['description'][$pageTags['sortorder_product']] = $tmpTags['prod_desc']; $sortOrder['keywords'][$pageTags['sortorder_product']] = $tmpTags['prod_keywords']; $sortOrder['logo'][$pageTags['sortorder_product']] = $tmpTags['prod_title']; } $sortOrder = GetCategoryAndManufacturer($sortOrder, $pageTags, $defaultTags, $catStr, $manStr, true); if ($pageTags['append_default_title'] && tep_not_null($tmpTags['def_title'])) $sortOrder['title'][$pageTags['sortorder_title']] = $tmpTags['def_title']; if ($pageTags['append_default_description'] && tep_not_null($tmpTags['def_desc'])) $sortOrder['description'][$pageTags['sortorder_description']] = $tmpTags['def_desc']; if ($pageTags['append_default_keywords'] && tep_not_null($tmpTags['def_keywords'])) $sortOrder['keywords'][$pageTags['sortorder_keywords']] = $tmpTags['def_keywords']; if ($pageTags['append_default_logo'] && tep_not_null($tmpTags['def_logo_text'])) $sortOrder['logo'][$pageTags['sortorder_logo']] = $tmpTags['def_logo_text']; FillHeaderTagsArray($header_tags_array, $sortOrder); // Canonical URL add-on if ($_GET['products_id'] != '') { $canonical_url = tep_href_link(basename($_SERVER['PHP_SELF']), 'products_id='.(int)$_GET['products_id']); } break; // SPECIALS.PHP case (basename($_SERVER['PHP_SELF']) === FILENAME_SPECIALS): $pageTags_query = tep_db_query("select * from " . TABLE_HEADERTAGS . " where page_name like '" . FILENAME_SPECIALS . "' and language_id = '" . (int)$languages_id . "'"); $pageTags = tep_db_fetch_array($pageTags_query); // Build a list of ALL specials product names to put in keywords $new = tep_db_query("select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added DESC "); $row = 0; $the_specials=''; while ($new_values = tep_db_fetch_array($new)) { $the_specials .= clean_html_comments($new_values['products_name']) . ', '; } if (strlen($the_specials) > 30000) //arbitrary number - may vary with server setting $the_specials = substr($the_specials, 0, 30000); //adjust as needed if ($pageTags['append_root']) { $sortOrder['title'][$pageTags['sortorder_root']] = $pageTags['page_title']; $sortOrder['description'][$pageTags['sortorder_root']] = $pageTags['page_description']; $sortOrder['keywords'][$pageTags['sortorder_root']] = $pageTags['page_keywords']; $sortOrder['logo'][$pageTags['sortorder_root']] = $pageTags['page_logo']; $sortOrder['logo_1'][$pageTags['sortorder_root']] = $pageTags['page_logo_1']; $sortOrder['logo_2'][$pageTags['sortorder_root']] = $pageTags['page_logo_2']; $sortOrder['logo_3'][$pageTags['sortorder_root']] = $pageTags['page_logo_3']; $sortOrder['logo_4'][$pageTags['sortorder_root']] = $pageTags['page_logo_4']; } $sortOrder['keywords'][10] = $the_specials;; if ($pageTags['append_default_title'] && tep_not_null($tmpTags['def_title'])) $sortOrder['title'][$pageTags['sortorder_title']] = $tmpTags['def_title']; if ($pageTags['append_default_description'] && tep_not_null($tmpTags['def_desc'])) $sortOrder['description'][$pageTags['sortorder_description']] = $tmpTags['def_desc']; if ($pageTags['append_default_keywords'] && tep_not_null($tmpTags['def_keywords'])) $sortOrder['keywords'][$pageTags['sortorder_keywords']] = $tmpTags['def_keywords']; if ($pageTags['append_default_logo'] && tep_not_null($tmpTags['def_logo_text'])) $sortOrder['logo'][$pageTags['sortorder_logo']] = $tmpTags['def_logo_text']; FillHeaderTagsArray($header_tags_array, $sortOrder); break; // ALL OTHER PAGES NOT DEFINED ABOVE default: $header_tags_array['title'] = tep_db_prepare_input($defaultTags['default_title']); $header_tags_array['desc'] = tep_db_prepare_input($defaultTags['default_description']); $header_tags_array['keywords'] = tep_db_prepare_input($defaultTags['default_keywords']); break; } echo ' <title>' . $header_tags_array['title'] . '</title>' . "\n"; echo ' <meta name="Description" content="' . $header_tags_array['desc'] . '" />' . "\n"; echo ' <meta name="Keywords" content="' . $header_tags_array['keywords'] . '" />' . "\n"; if ($defaultTags['meta_google']) echo ' <meta name="googlebot" content="all" />' . "\n"; if ($defaultTags['meta_language']) echo ' <meta http-equiv="Content-Language" content="en-US" />'."\n"; if ($defaultTags['meta_noodp']) echo ' <meta name="robots" content="noodp" />' . "\n"; if ($defaultTags['meta_noydir']) echo ' <meta name="slurp" content="noydir" />' . "\n"; if ($defaultTags['meta_revisit']) echo ' <meta name="revisit-after" content="1 days" />' . "\n"; if ($defaultTags['meta_robots']) echo ' <meta name="robots" content="index, follow" />' . "\n"; if ($defaultTags['meta_unspam']) echo ' <meta name="no-email-collection" value="' . HTTP_SERVER . '" />' . "\n"; if ($defaultTags['meta_replyto']) echo ' <meta name="Reply-to" content="' . STORE_OWNER_EMAIL_ADDRESS . '"/>' . "\n"; if (tep_not_null($canonical_url)) echo ' <link rel="canonical" href="'.$canonical_url.'" />'. "\n"; echo ' <meta http-equiv="Content-Type" content="text/html; charset=' . CHARSET . '" />'."\n"; echo '<!-- EOF: Header Tags SEO Generated Meta Tags -->' . "\n"; ?>
  7. crapu

    Header Tags SEO

    Dear Jack, Please help me with this problem I am facing: I installed the Headertags SEO contribution on my website www.nevertebrate.ro. I followed all the instructions exactly, in fact I went back on them 3 times already. Eveything seems to be in order: everything is working, except for the product_info.php which is not showing in the header the title of the product itself, but the default title. I tryed everything but it is still not working. I even reinstalled everything 3 times, but still I can't get it to work. The categories header doesn't show the title also. Please tell me what can I do. If you need me to paste some code from the store please feel free to ask. This is the result of the 'test' Thanks in advance for your response. Crapu
  8. Hello everybody! I am looking for a contribution that would allow me to create a special products that would be a combination of 2 or 3 products already listed in the store, at a special price. I could list them as a new products, but I want the store to list them automaticly in separate positions on the invoice. Therefore I am looking for something that would allow me to combine these products and set a separate price. I looked for it in the Contributions section but I couldn't find it. Is there such a thing? Thanks.
  9. crapu

    Links Manager II

    Hello Jack! I returned with another problem I am facing. Installed a few contributions (links manager II and addblog) and I get the following message when I try to access those specific pages Catchable fatal error: Object of class infoBox could not be converted to string in /home/medicals/public_html/includes/boxes/information.php on line 29 You can see that specific error accessing this page My information.php file contains this: <?php /* $Id: information.php,v 1.6 2003/02/10 22:31:00 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ ?> <!-- information //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('text' => BOX_HEADING_INFORMATION); new infoBoxHeading($info_box_contents, false, false); $info_box_contents = array(); $info_box_contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_SHIPPING) . '">' . BOX_INFORMATION_SHIPPING . '</a><br>' . '<a href="' . tep_href_link(FILENAME_PRIVACY) . '">' . BOX_INFORMATION_PRIVACY . '</a><br>' . '<a href="' . tep_href_link(FILENAME_CONDITIONS) . '">' . BOX_INFORMATION_CONDITIONS . '</a><br>' . '<a href="' . tep_href_link(FILENAME_MY_POINTS_HELP) . '">' . BOX_INFORMATION_MY_POINTS_HELP . '</a><br>' . // Points/Rewards Module V2.1rc2a '<a href="' . tep_href_link(FILENAME_CONTACT_US) . '">' . BOX_INFORMATION_CONTACT . '</a>'); '<a href="' . tep_href_link(FILENAME_LINKS) . '">' . BOX_INFORMATION_LINKS . '</a><br>' . // Links Manager II v1.00 added new infoBox($info_box_contents); ?> </td> </tr> <!-- information_eof //--> Can you, or somebody else help with the solution for this problem, please? Thank you in advance.
  10. crapu

    Links Manager II

    I didn't notice those instructions. It fixed it. Thank you very much.
  11. crapu

    Customers extra fields

    Hello! Please tell me for what version of Oscommerce is this contribution? I am using Oscommerce 2.2 MS2. Will I have any problems if I install it? Thank you very much. Manu
×