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


***************************************************************************************
1) Upload the Database_Files/headertags_seo_update.php file to your root directory and
access it via a browser as:

http://YOUR DOMAIN NAME/headertags_seo_update.php?reset_options=true


***************************************************************************************
2) Upload all of the files in the catalog_only_new_files directory. If the Header Tags 
SEO files in your shop have been altered from the original, you will need to compare 
these to find the differences.


***************************************************************************************
3) In admin/categories.php,

FIND:

          $categories_htc_title_array = $HTTP_POST_VARS['categories_htc_title_tag'];
          $categories_htc_title_alt_array = $HTTP_POST_VARS['categories_htc_title_tag_alt'];
          $categories_htc_title_url_array = $HTTP_POST_VARS['categories_htc_title_tag_url'];
          $categories_htc_desc_array = $HTTP_POST_VARS['categories_htc_desc_tag'];

REPLACE WITH:

          $categories_htc_title_array = str_replace('"', '&quot;', $HTTP_POST_VARS['categories_htc_title_tag']);
          $categories_htc_title_alt_array = str_replace('"', '&quot;', $HTTP_POST_VARS['categories_htc_title_tag_alt']);
          $categories_htc_title_url_array = str_replace('"', '&quot;', $HTTP_POST_VARS['categories_htc_title_tag_url']);
          $categories_htc_desc_array = str_replace('"', '&quot;', $HTTP_POST_VARS['categories_htc_desc_tag']);
	           

FIND:

           /*** Begin Header Tags SEO ***/
            $sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]),
                                    'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]),
                                    'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]),
                                    'products_head_title_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag'][$language_id])) ? tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_head_title_tag'][$language_id])) : tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_name'][$language_id]))),
                                    'products_head_title_tag_alt' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag_alt'][$language_id])) ? tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_head_title_tag_alt'][$language_id])) : tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_name'][$language_id]))),
                                    'products_head_title_tag_url' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag_url'][$language_id])) ? tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_head_title_tag_url'][$language_id])) : tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_name'][$language_id]))),
                                    'products_head_desc_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_desc_tag'][$language_id])) ? tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_head_desc_tag'][$language_id])) : tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_name'][$language_id]))),
                                    
REPLACE WITH:

           /*** Begin Header Tags SEO ***/
           $products_head_title_tag = (tep_not_null($HTTP_POST_VARS['products_head_title_tag'][$language_id]) ? str_replace('"', '&quot;', $HTTP_POST_VARS['products_head_title_tag'][$language_id]) : str_replace('"', '&quot;', $HTTP_POST_VARS['products_name'][$language_id]));
           $products_head_title_tag_alt = (tep_not_null($HTTP_POST_VARS['products_head_title_tag_alt'][$language_id]) ? str_replace('"', '&quot;', $HTTP_POST_VARS['products_head_title_tag_alt'][$language_id]) : str_replace('"', '&quot;', $HTTP_POST_VARS['products_name'][$language_id]));
           $products_head_desc_tag = (tep_not_null($HTTP_POST_VARS['products_head_desc_tag'][$language_id]) ? str_replace('"', '&quot;', $HTTP_POST_VARS['products_head_desc_tag'][$language_id]) : str_replace('"', '&quot;', $HTTP_POST_VARS['products_name'][$language_id]));
            $sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]),
                                    'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]),
                                    'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]),
                                    'products_head_title_tag' => tep_db_prepare_input(strip_tags($products_head_title_tag)),
                                    'products_head_title_tag_alt' => tep_db_prepare_input(strip_tags($products_head_title_tag_alt)),
                                    'products_head_title_tag_url' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag_url'][$language_id])) ? tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_head_title_tag_url'][$language_id])) : tep_db_prepare_input(strip_tags($HTTP_POST_VARS['products_name'][$language_id]))),
                                    'products_head_desc_tag' => tep_db_prepare_input(strip_tags($products_head_desc_tag)),                                    
      

***************************************************************************************
4) In admin/mamufacturers.php,

FIND:

          $manufacturers_htc_title_array = $HTTP_POST_VARS['manufacturers_htc_title_tag'];
          $manufacturers_htc_title_alt_array = $HTTP_POST_VARS['manufacturers_htc_title_tag_alt'];
          $manufacturers_htc_title_url_array = $HTTP_POST_VARS['manufacturers_htc_title_tag_url'];
          $manufacturers_htc_desc_array = $HTTP_POST_VARS['manufacturers_htc_desc_tag'];

          
REPLACE WITH:

          $manufacturers_htc_title_array = str_replace('"', '&quot;',$HTTP_POST_VARS['manufacturers_htc_title_tag']);
          $manufacturers_htc_title_alt_array = str_replace('"', '&quot;',$HTTP_POST_VARS['manufacturers_htc_title_tag_alt']);
          $manufacturers_htc_title_url_array = $HTTP_POST_VARS['manufacturers_htc_title_tag_url'];
          $manufacturers_htc_desc_array = str_replace('"', '&quot;',$HTTP_POST_VARS['manufacturers_htc_desc_tag']);
  

***************************************************************************************
5) In includes/application_top.php,

FIND:

 // add the products name to the breadcrumb trail
 if (isset($_GET['products_id'])) {
     $addModel = false;
     $db_query = tep_db_query("select 1 from " . TABLE_HEADERTAGS . " where page_name = '" . tep_db_input(basename($_SERVER['SCRIPT_FILENAME'])) . "' and append_model=1");
     if (tep_db_num_rows($db_query)) {
         $addModel = true;
     }
     
     $products_query = tep_db_query("select IF(pd.products_head_breadcrumb_text !='', pd.products_head_breadcrumb_text,pd.products_name) as title, p.products_model as model 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 =" .  (int)$languages_id);
     if (tep_db_num_rows($products_query)) {
         $products = tep_db_fetch_array($products_query);          
         $title = ($addModel && tep_not_null($products['model']) ? $products['model'] . ' - ' . $products['title'] : $products['title']);
         $args = isset($_GET['reviews_id']) ? tep_get_all_get_params() : 'cPath=' . $cPath . '&products_id=' . $_GET['products_id'] ;
         $breadcrumb->add($title, tep_href_link(basename($_SERVER['SCRIPT_FILENAME']), $args));
     }
  }
/*** End Header Tags SEO ***/

REPLACE WITH:

 // add the products name to the breadcrumb trail
 if (isset($_GET['products_id'])) {
     if (HEADER_TAGS_BREADCRUMB_MODEL_OVERRIDE == 'true') {
         $products_query = tep_db_query("select p.products_model as model 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 =" .  (int)$languages_id);
         if (tep_db_num_rows($products_query)) {
             $products = tep_db_fetch_array($products_query);          
             $title = $products['model'];
             $args = isset($_GET['reviews_id']) ? tep_get_all_get_params() : 'cPath=' . $cPath . '&products_id=' . $_GET['products_id'] ;
             $breadcrumb->add($title, tep_href_link(basename($_SERVER['SCRIPT_FILENAME']), $args));
         }      
     } else { 
         $addModel = false;
         $db_query = tep_db_query("select 1 from " . TABLE_HEADERTAGS . " where page_name = '" . tep_db_input(basename($_SERVER['SCRIPT_FILENAME'])) . "' and append_model=1");
         if (tep_db_num_rows($db_query)) {
             $addModel = true;
         }
         
         $products_query = tep_db_query("select IF(pd.products_head_breadcrumb_text !='', pd.products_head_breadcrumb_text,pd.products_name) as title, p.products_model as model 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 =" .  (int)$languages_id);
         if (tep_db_num_rows($products_query)) {
             $products = tep_db_fetch_array($products_query);          
             $title = ($addModel && tep_not_null($products['model']) ? $products['model'] . ' - ' . $products['title'] : $products['title']);
             $args = isset($_GET['reviews_id']) ? tep_get_all_get_params() : 'cPath=' . $cPath . '&products_id=' . $_GET['products_id'] ;
             $breadcrumb->add($title, tep_href_link(basename($_SERVER['SCRIPT_FILENAME']), $args));
         }
     }    
  }
/*** End Header Tags SEO ***/
***************************************************************************************
