Update instructions for updating Header Tags SEO version 3.3.6 to Header Tags SEO V 3.3.6 by Jack_mcs - oscommerce-solution.com

===================================================================
1 - In admin/categories.php, 

FIND:

           /*** Begin Header Tags SEO ***/
	   $hts_fields = GetHTSFieldList();
           $description_query = tep_db_query("select language_id, products_name, products_description, products_url, products_seo_title, products_seo_description, products_seo_keywords, " . $hts_fields['fields'] . " from products_description where products_id = '" . (int)$products_id . "'");
           while ($description = tep_db_fetch_array($description_query)) {
             tep_db_query("insert into products_description (products_id, language_id, products_name, products_description, products_url, products_viewed, products_seo_title, products_seo_description, products_seo_keywords) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_url']) . "', '0', '" . tep_db_input($description['products_seo_title']) . "', '" . tep_db_input($description['products_seo_description']) . "', '" . tep_db_input($description['products_seo_keywords']) . "', " . $hts_fields['input'] . ")");
           }
           /*** End Header Tags SEO ***/
           
REPLACE WITH:

           /*** Begin Header Tags SEO ***/
           require_once('includes/functions/header_tags_general.php');
           $hts_fields = GetHTSFieldList();
           $description_query = tep_db_query("select language_id, products_name, products_description, products_url, products_seo_title, products_seo_description, products_seo_keywords, " . $hts_fields['fields'] . " from products_description where products_id = '" . (int)$products_id . "'");
           while ($description = tep_db_fetch_array($description_query)) {
               tep_db_query("insert into products_description (products_id, language_id, products_name, products_description, products_url, products_viewed, products_seo_title, products_seo_description, products_seo_keywords, " . GetHTSFieldListWithIDs(true) . ") values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_url']) . "', '0', '" . tep_db_input($description['products_seo_title']) . "', '" . tep_db_input($description['products_seo_description']) . "', '" . tep_db_input($description['products_seo_keywords']) . "', " . $hts_fields['input'] . ")");
           }
           /*** End Header Tags SEO ***/           

===================================================================
 
2 - Copy these files from the NewFiles directory for your shop to the
correct location on the server:

catalog_only_new_files/includes/header_tags.php
catalog_only_new_files/includes/functions/header_tags.php
catalog_only_new_files/admin/includes/functions/header_tags.php
catalog_only_new_files/admin/includes/functions/header_tags_general.php
catalog_only_new_files/admin/header_tags_seo.php
