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


***************************************************************************************

1) NOT REQUIRED: If you would like to reduce the size of your database size, run the 
following statements. 

ALTER table headertags CHANGE page_keywords page_keywords TEXT;

ALTER table categories_description CHANGE categories_htc_desc_tag categories_htc_desc_tag VARCHAR( 160 );
ALTER table categories_description CHANGE categories_htc_keywords_tag categories_htc_keywords_tag TEXT;
ALTER table categories_description CHANGE categories_htc_description categories_htc_description TEXT;

ALTER table manufacturers_info CHANGE manufacturers_htc_desc_tag manufacturers_htc_desc_tag VARCHAR( 160 );
ALTER table manufacturers_info CHANGE manufacturers_htc_keywords_tag manufacturers_htc_keywords_tag TEXT;
ALTER table manufacturers_info CHANGE manufacturers_htc_description manufacturers_htc_description TEXT;

ALTER table products_description CHANGE products_head_desc_tag products_head_desc_tag VARCHAR( 160 );
ALTER table products_description CHANGE products_head_keywords_tag products_head_keywords_tag TEXT;
ALTER table products_description CHANGE products_head_listing_text products_head_listing_text TEXT;
ALTER table products_description CHANGE products_head_sub_text products_head_sub_text TEXT;


2) Upload the following files:

admin/header_tags_seo.php
admin/includes/functions/header_tags.php
includes/headertags_seo_tagcloud_footer.php 
includes/modules/header_tags_social_bookmarks.php 

includes/header_tags.php - NOTE: if you use pseudo pages, you will need to compare this file instead of replacing it.

3) In admin/categories.php, 

FIND: (be careful, there are multiple sections that look similar but only one that matches)

                  if (HEADER_TAGS_ENABLE_HTML_EDITOR == 'No Editor' || HEADER_TAGS_ENABLE_EDITOR_PRODUCTS == 'false')
                    echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? $products_description[$languages[$i]['id']] : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); 
                  else 
                  {
                    if (HEADER_TAGS_ENABLE_HTML_EDITOR == 'FCKEditor') { 
                      echo tep_draw_fckeditor('products_description[' . $languages[$i]['id'] . ']', '600', '300', (isset($products_description[$languages[$i]['id']]) ? $products_description[$languages[$i]['id']] : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); 
                    } else if (HEADER_TAGS_ENABLE_HTML_EDITOR == 'CKEditor') { 
                      echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '110', '15', (isset($products_description[$languages[$i]['id']]) ? $products_description[$languages[$i]['id']] : tep_get_products_description($pInfo->products_id, $languages[$i]['id'])), 'id = "products_description[' . $languages[$i]['id'] . ']" class="ckeditor"'); 
                    } else { 
                      echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? $products_description[$languages[$i]['id']] : tep_get_products_description($pInfo->products_id, $languages[$i]['id']))); 
                    }
                  } 

REPLACE WITH:

                  if (HEADER_TAGS_ENABLE_HTML_EDITOR == 'No Editor' || HEADER_TAGS_ENABLE_EDITOR_PRODUCTS == 'false')
                    echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? stripslashes($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id'])));
                  else 
                  {
                    if (HEADER_TAGS_ENABLE_HTML_EDITOR == 'FCKEditor') { 
                      echo tep_draw_fckeditor('products_description[' . $languages[$i]['id'] . ']', '600', '300', (isset($products_description[$languages[$i]['id']]) ? stripslashes($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id'])));
                    } else if (HEADER_TAGS_ENABLE_HTML_EDITOR == 'CKEditor') { 
                      echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '110', '15', (isset($products_description[$languages[$i]['id']]) ? stripslashes($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id'])), 'id = "products_description[' . $languages[$i]['id'] . ']" class="ckeditor"');
                    } else { 
                      echo tep_draw_textarea_field('products_description[' . $languages[$i]['id'] . ']', 'soft', '70', '15', (isset($products_description[$languages[$i]['id']]) ? stripslashes($products_description[$languages[$i]['id']]) : tep_get_products_description($pInfo->products_id, $languages[$i]['id'])));
                    }
                  } 


