crapu

July 6, 2009

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

July 6, 2009

Do you see a difference in the default section for the difference languages?

Jack

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";
?>

July 4, 2009

Are the check boxes in page control for the index and products_info pages set the same for both languages? If you go into a products edit page, are the meta tags filled in for both languages?

Jack

Yes they are:

Page control ->product_info.php

Catalog -> page description edit

July 4, 2009

That doesn't matter on a clean shop. You would still have to make the additional language changes but the other included files will work.

Jack

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:

Test Results

Default Text Present: explain

The default root text, New Home Page Title, should be removed or changed for index.php with language ID of 4.

The default root text, products new home, should be removed or changed for product_info.php with language ID of 1.

Missing Code in File explain

The Header Tags head code for the product_reviews.php file cannot be found.

The Header Tags head code for the product_reviews_info.php file cannot be found.

The Header Tags head code for the product_reviews_write.php file cannot be found.

The Header Tags head code for the specials.php file cannot be found.

Thanks a lot!

July 3, 2009

What happens when you use the included files?

Jack

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.

July 3, 2009

- Run Fill Tags
- Check a product in the prodicts edit page to make sure the title is filled in. If not, something is wrong on the admin side.

- Use the included product_info.php file. If it still fails, it's probably the includes/heder_tags.php file.

Jack

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)

Test Results

Missing Code in File explain

The Header Tags head code for the product_reviews.php file cannot be found.

The Header Tags head code for the product_reviews_info.php file cannot be found.

The Header Tags head code for the product_reviews_write.php file cannot be found.

The Header Tags head code for the specials.php file cannot be found.

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";
?>

July 2, 2009

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'

Test Results

Default Text Present: explain

The default root text, New Home Page Title, should be removed or changed for index.php with language ID of 6.

The default root text, products new home, should be removed or changed for product_info.php with language ID of 6.

Thanks in advance for your response.

Crapu

May 14, 2009

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.

May 6, 2009

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.

May 5, 2009

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

May 5, 2009

I just upgraded from Links Manager 1.18 to 1.20 & get the following errors.

Fatal error: Call to undefined function tep_hide_session_id() in C:\htdocs\mystorename\myadminfoldername\links.php on line 722
[/color]
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr><?php echo tep_draw_form('search', FILENAME_LINKS, '', 'get') . tep_hide_session_id(); ?> [color=#0000FF]// line 722[/color]
<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

Links Status = Fatal error: Call to undefined function tep_hide_session_id() in C:\htdocs\mystorename\myadminfoldername\links_status.php on line 111
[color=#FF0000][code][/color]
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr><?php echo tep_draw_form('search', FILENAME_LINKS_STATUS, '', 'get') . tep_hide_session_id(); ?> [color=#0000FF]// line 111[/color]
<td class="pageHeading"><?php echo HEADING_TITLE_LINKS_STATUS; ?></td>

Link Categories = ok
Links Contact = ok
Links Exchange = ok
Links Featured =ok

Ideas as to what went wrong?
Thanks

I am having the exact same problem with my site. I installed this contribution and I am getting the same errors as nextime.
Please help me on finding where the problem is and fixing it. Thanks you in advance.

Crapu

January 6, 2009

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

crapu

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by crapu

Header Tags SEO

Header Tags SEO

Header Tags SEO

Header Tags SEO

Header Tags SEO

Header Tags SEO

Header Tags SEO

Multiple products at a special price

Links Manager II

Links Manager II

Links Manager II

Customers extra fields

Browse

Activity