Jack,
I wonder if you could give me a quick thumbs up. I've come across a problem on how to install HeaderTags SEO 3.1.2:
I followed the Install_ReadMe_First instructions (part 1) in the download and executed successfully the file headertags_seo_install.php.
Following the instructions of Install_Catalog, though, I've noticed that the code I am supposed to alter is incorrect.
Here is what the instructions are:
======================================
3) In index.php
...
FIND (Around line 247)
?>
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
REPLACE with
/*** Begin Header Tags SEO ***/
if (isset($HTTP_GET_VARS['manufacturers_id']))
$db_query = tep_db_query("select manufacturers_htc_title_tag as htc_title, manufacturers_htc_description as htc_description from " . TABLE_MANUFACTURERS_INFO . " where languages_id = '" . (int)$languages_id . "' and manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
else
$db_query = tep_db_query("select categories_htc_title_tag as htc_title, categories_htc_description as htc_description from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "' and language_id = '" . (int)$languages_id . "'");
$htc = tep_db_fetch_array($db_query);
?>
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><h1><?php echo $htc['htc_title']; ?></h1></td>
<?php /*** End Header Tags SEO ***/ ?>
==============================================
Here is what my original code is:
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td class="pageHeading">
<!--<?php echo HEADING_TITLE; ?>-->
<?php
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
$category_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
$category = tep_db_fetch_array($category_query);
if ($category['manufacturers_name'] != "") {
echo $category['manufacturers_name'];
} else {
echo HEADING_TITLE;
}
} else {
$category_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");
$category = tep_db_fetch_array($category_query);
if ($category['categories_name'] != "") {
echo $category['categories_name'];
} else {
echo HEADING_TITLE;
}
}
?>
</td>
==============================================
For some reason, similar code already exists. The only thing I've done is install/activate STS 4.5.8 in a fresh osCommerce 2.2-MS2 DB (Netfirms).
Can you tell me how I should proceed? Am I to replace all of it? Please note that the variables are quite different in the two code samples.
Many thanks...
Chris