Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Header Tags SEO


Jack_mcs

Recommended Posts

Hi there,

 

I've been working for a week now to get Header Tags SEO working on my website. I used a template from templatemonster to build my store, and i can modify all the php files needed for HTC when going through the install instuctions except for the index.php & product_info.php.

 

It looks like my files are totally different from the ones included. I used beyond compare and still no clue. Can someone please please help me.

 

Thanks in advance for everybody who can shed some light on this.

 

Regards,

Guido

 

Below a copy of the files:

 

index.php ==============================

 

<?php

/*

$Id: index.php 1739 2007-12-20 00:52:16Z hpdl $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require_once('includes/application_top.php');

 

// the following cPath references come from application_top.php

$category_depth = 'top';

if (isset($cPath) && tep_not_null($cPath)) {

$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$cateqories_products = tep_db_fetch_array($categories_products_query);

if ($cateqories_products['total'] > 0) {

$category_depth = 'products'; // display products

} else {

$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");

$category_parent = tep_db_fetch_array($category_parent_query);

if ($category_parent['total'] > 0) {

$category_depth = 'nested'; // navigate through the categories

} else {

$category_depth = 'products'; // category has no products, but display the 'no products' message

}

}

}

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<meta name="netinsert" content="0.0.1.2.25.1">

<title><?php echo TITLE; ?></title><?php echo "<meta name=\"keywords\" content=\"".KEYWORDS."\">"; ?>

<?php echo "<meta name=\"description\" content=\"".DESCRIPTION."\">"; ?>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

 

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

 

<!-- BEGIN Live Help Code - NOT PERMITTED TO MODIFY IMAGE MAP/CODE/LINKS //-->

<script language="JavaScript" type="text/JavaScript" src="http://www.beleggerslijn.nl/livehelp/include/javascript.php"></script>

<!-- END Live Help HTML Code - NOT PERMITTED TO MODIFY IMAGE MAP/CODE/LINKS //-->

</head>

<body>

<script type="text/javascript">

var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");

document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));

</script>

<script type="text/javascript">

var pageTracker = _gat._getTracker("UA-8057545-1");

pageTracker._initData();

pageTracker._trackPageview();

</script>

<!-- header //-->

 

 

<!-- BEGIN Live Help Code - Copyright - NOT PERMITTED TO MODIFY IMAGE MAP/CODE/LINKS //-->

<div id="floatLayer" align="left" style="position:absolute; left:10px; top:10px; visibility:hidden; z-index:5000;"><map name="LiveHelpInitiateChatMap" id="LiveHelpInitiateChatMap"><area shape="rect" coords="113,183,197,206" href="#" onClick="openLiveHelp();acceptInitiateChat();return false;" alt="Accept"/><area shape="rect" coords="206,183,285,206" href="#" onClick="declineInitiateChat();return false;" alt="Decline"/>

<area shape="rect" coords="263,86,301,104" href="#" onClick="declineInitiateChat();return false;" alt="Close"/></map>

<div id="InitiateText" align="center" style="position:relative; left:30px; top:145px; width:275px; height:35px; z-index:5001; text-align:center; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold;">Do you have any questions that I can help you with?</div><img src="http://www.beleggerslijn.nl/livehelp/locale/en/images/InitateChat.gif" alt="Live Adviesdesk, koopgoud.nl" width="323" height="229" border="0" usemap="#LiveHelpInitiateChatMap"/></div>

<!-- END Live Help Messenger Code - Copyright - NOT PERMITTED TO MODIFY IMAGE MAP/CODE/LINKS //-->

 

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" class="<?php echo MAIN_TABLE; ?>" cellspacing="0" cellpadding="0">

<tr>

<!-- body_text //-->

<?php

if ($category_depth == 'nested') {

$category_query = tep_db_query("select cd.categories_name, c.categories_image 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);

?>

<td class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo panel_top(); ?>

 

<?php echo tep_draw_top();?>

 

 

 

<?php new contentBoxHeading_ProdNew($info_box_contents);?>

<?php echo tep_draw3_top();?>

 

 

 

 

<?php //echo tep_separat(); ?>

<?php //echo tep_separat(); ?>

 

<table border="0" width="100%" cellspacing="0" cellpadding="0" class="main">

<tr>

<?php

if (isset($cPath) && strpos('_', $cPath)) {

// check to see if there are deeper categories within the current category

$category_links = array_reverse($cPath_array);

for($i=0, $n=sizeof($category_links); $i<$n; $i++) {

$categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");

$categories = tep_db_fetch_array($categories_query);

if ($categories['total'] < 1) {

// do nothing, go through the loop

} else {

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

break; // we've found the deepest category the customer is in

}

}

} else {

$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");

}

 

$number_of_categories = tep_db_num_rows($categories_query);

 

$rows = 0;

while ($categories = tep_db_fetch_array($categories_query)) {

$rows++;

$cPath_new = tep_get_path($categories['categories_id']);

 

$p_pic_sub = '<a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '</a>';

 

$p_name_sub = '<a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . $categories['categories_name'] . '</a>';

 

$width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';

 

 

 

echo '

 

 

 

 

 

<td align="left" width="' . $width . '">

 

'.tep_draw_prod2_top().'

 

 

<table class="side1_top" cellpadding="0" cellspacing="0" border="0">

<tr>

<td class="side11_in">

 

<div class="cont_heading_td">'.$p_name_sub.'</div><br>

 

<table cellpadding="0" cellspacing="0" border="0">

<tr>

<td style="text-align:center;">

 

'.tep_draw_prod_pic_top().''.$p_pic_sub.''.tep_draw_prod_pic_bottom().'<br>

</td>

</tr>

</table>

</td></tr></table>

'.tep_draw_separator('spacer.gif', '1', '13').'<br>

 

'.tep_draw_prod2_bottom().'

 

 

 

</td>'."\n";

 

if ($col!=(MAX_DISPLAY_CATEGORIES_PER_ROW-1)){

echo '

<td class="padd_vv prod_line_y">'.tep_draw_separator('spacer.gif', '1', '1').'</td>

';

}else{

 

if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {

echo '

</tr><tr><td class="prod_line_x" colspan="'.(MAX_DISPLAY_CATEGORIES_PER_ROW + MAX_DISPLAY_CATEGORIES_PER_ROW -1).'">'.tep_draw_separator('spacer.gif', '1', '10').'</td></tr>' . "\n";

echo '<tr>' . "\n";

}

}

if ($col==MAX_DISPLAY_CATEGORIES_PER_ROW-1){

$col=0;

}else{

$col++;

}

}

 

// needed for the new products module shown below

$new_products_category_id = $current_category_id;

?>

</tr>

</table>

 

<?php echo tep_draw_separator('spacer.gif', '1', '12'); ?><br>

 

 

 

 

<?php echo tep_draw3_bottom();?>

 

<?php echo tep_draw_bottom();?>

 

<?php echo tep_separat2(); ?>

 

<?php echo tep_draw_top77();?>

 

 

 

<?php new contentBoxHeading_WHATS_NEW($info_box_contents, true, false);?>

 

 

 

 

 

<?php echo tep_draw3_top();?>

<?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?>

 

<?php echo tep_draw3_bottom();?>

 

<?php echo tep_draw_bottom77();?>

 

</td>

<td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

 

 

<?php

} elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {

// create column list

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

 

asort($define_list);

 

$column_list = array();

reset($define_list);

while (list($key, $value) = each($define_list)) {

if ($value > 0) $column_list[] = $key;

}

 

$select_column_list = '';

 

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

switch ($column_list[$i]) {

case 'PRODUCT_LIST_MODEL':

$select_column_list .= 'p.products_model, ';

break;

case 'PRODUCT_LIST_NAME':

$select_column_list .= 'pd.products_name, ';

break;

case 'PRODUCT_LIST_MANUFACTURER':

$select_column_list .= 'm.manufacturers_name, ';

break;

case 'PRODUCT_LIST_QUANTITY':

$select_column_list .= 'p.products_quantity, ';

break;

case 'PRODUCT_LIST_IMAGE':

$select_column_list .= 'p.products_image, ';

break;

case 'PRODUCT_LIST_WEIGHT':

$select_column_list .= 'p.products_weight, ';

break;

}

}

 

// show the products of a specified manufacturer

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only a specific category

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";

}

} else {

// show the products in a given categorie

if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {

// We are asked to show only specific catgeory

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

} else {

// We show them all

$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";

}

}

 

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('^[1-8][ad]$', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {

for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {

if ($column_list[$i] == 'PRODUCT_LIST_NAME') {

$HTTP_GET_VARS['sort'] = $i+1 . 'a';

$listing_sql .= " order by pd.products_name";

break;

}

}

} else {

$sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);

$sort_order = substr($HTTP_GET_VARS['sort'], 1);

 

switch ($column_list[$sort_col-1]) {

case 'PRODUCT_LIST_MODEL':

$listing_sql .= " order by p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_NAME':

$listing_sql .= " order by pd.products_name " . ($sort_order == 'd' ? 'desc' : '');

break;

case 'PRODUCT_LIST_MANUFACTURER':

$listing_sql .= " order by m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_QUANTITY':

$listing_sql .= " order by p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_IMAGE':

$listing_sql .= " order by pd.products_name";

break;

case 'PRODUCT_LIST_WEIGHT':

$listing_sql .= " order by p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

case 'PRODUCT_LIST_PRICE':

$listing_sql .= " order by final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";

break;

}

}

?>

<td class="<?php echo CONTENT_WIDTH_TD; ?>">

 

<?php echo panel_top(); ?>

 

<?php echo tep_draw_top77();?>

 

 

<?php

// optional Product List Filter

if (PRODUCT_LIST_FILTER > 0) {

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";

} else {

$filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";

}

$filterlist_query = tep_db_query($filterlist_sql);

if (tep_db_num_rows($filterlist_query) > 1) {

echo tep_draw_side_top();

echo '<table border="0" cellpadding="0" cellspacing="0" style="width:auto; float:right;"><tr><td style="padding-top:17px;">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . '   </td><td>';

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);

$options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));

} else {

echo tep_draw_hidden_field('cPath', $cPath);

$options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));

}

echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);

while ($filterlist = tep_db_fetch_array($filterlist_query)) {

$options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);

}

echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()" class="select2"');

echo tep_hide_session_id() . '</form></td></tr></table>' . "\n";

echo tep_draw_side_bottom();

}

}

 

// Get the right image for the top-right

$image = DIR_WS_IMAGES . 'table_background_list.gif';

if (isset($HTTP_GET_VARS['manufacturers_id'])) {

$image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");

$image = tep_db_fetch_array($image);

$image = $image['manufacturers_image'];

} elseif ($current_category_id) {

$image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");

$image = tep_db_fetch_array($image);

$image = $image['categories_image'];

}

?>

 

<?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?>

 

<?php echo tep_draw3_bottom();?>

 

<?php echo tep_draw_bottom77();?>

 

</td>

<?php

} else { // default page

?>

<td class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo panel_top(); ?>

 

<?php echo tep_draw_top77();?>

<?php //echo tep_image(DIR_WS_IMAGES.'welcome.jpg');?>

<!-- Welcome_box_start -->

<?php /* tep_draw_heading_top(); */?>

<?php /* tep_draw_heading_top_3(); */?>

<?php /* echo tep_draw_prod_top(); */ ?>

<!-- <table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr><td class="main"><?php /* echo tep_customer_greeting(); */ ?></td></tr>

<tr><td><?php /* echo tep_draw_separator('pixel_trans.gif', '100%', '10'); */ ?></td></tr>

<tr><td class="main"><?php /* echo TEXT_MAIN; */ ?></td></tr>

</table> -->

 

<?php /* echo tep_draw_prod_bottom(); */ ?>

<?php /* tep_draw_heading_bottom_3(); */?>

<?php /* echo tep_draw_separate(); */ ?>

 

<!-- Welcome_box_end -->

 

<?php //echo panel_top2(); ?>

<?php new contentBoxHeading_ProdNew($info_box_contents); ?>

 

<?php echo tep_draw4_top();?>

 

 

<?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?>

 

<?php echo tep_draw4_bottom();?>

 

<?php echo tep_draw_bottom77();?>

 

<?php include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS); ?>

 

 

 

</td>

<td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

 

<?php

}

?>

<!-- body_text_eof //-->

<td class="<?php echo BOX_WIDTH_TD_RIGHT; ?>"><table border="0" class="<?php echo BOX_WIDTH_RIGHT; ?>" cellspacing="0" cellpadding="0">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

 

 

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

=========================================

 

product_info.php==============================

 

<?php

/*

$Id: product_info.php 1739 2007-12-20 00:52:16Z hpdl $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2003 osCommerce

 

Released under the GNU General Public License

*/

 

require('includes/application_top.php');

 

require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO);

 

$product_check_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product_check = tep_db_fetch_array($product_check_query);

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title><?php echo "<meta name=\"keywords\" content=\"".KEYWORDS."\">"; ?>

<?php echo "<meta name=\"description\" content=\"".DESCRIPTION."\">"; ?>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<script language="javascript"><!--

function popupWindow(url) {

window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res

izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le

ft=150')

}

//--></script>

<?php require('customer_call_back_header.php') ; ?>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<?php require('customer_call_back.php') ; ?>

<!-- header_eof //-->

 

 

<!-- BEGIN Live Help Code - Copyright - NOT PERMITTED TO MODIFY IMAGE MAP/CODE/LINKS //-->

<div id="floatLayer" align="left" style="position:absolute; left:10px; top:10px; visibility:hidden; z-index:5000;"><map name="LiveHelpInitiateChatMap" id="LiveHelpInitiateChatMap"><area shape="rect" coords="113,183,197,206" href="#" onClick="openLiveHelp();acceptInitiateChat();return false;" alt="Accept"/><area shape="rect" coords="206,183,285,206" href="#" onClick="declineInitiateChat();return false;" alt="Decline"/>

<area shape="rect" coords="263,86,301,104" href="#" onClick="declineInitiateChat();return false;" alt="Close"/></map>

<div id="InitiateText" align="center" style="position:relative; left:30px; top:145px; width:275px; height:35px; z-index:5001; text-align:center; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold;">Do you have any questions that I can help you with?</div><img src="http://www.beleggerslijn.nl/livehelp/locale/en/images/InitateChat.gif" alt="Live Adviesdesk, koopgoud.nl" width="323" height="229" border="0" usemap="#LiveHelpInitiateChatMap"/></div>

<!-- END Live Help Messenger Code - Copyright - NOT PERMITTED TO MODIFY IMAGE MAP/CODE/LINKS //-->

 

<!-- body //-->

<table border="0" class="<?php echo MAIN_TABLE; ?>" cellspacing="0" cellpadding="0">

<tr>

<!-- body_text //-->

<td class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo panel_top(); ?><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?>

 

 

 

<?php

if ($product_check['total'] < 1) {

?>

<?php echo tep_draw_top();?>

<?php echo tep_draw_title_top();?>

 

<?php echo TEXT_PRODUCT_NOT_FOUND; ?>

 

<?php echo tep_draw_title_bottom();?>

 

 

<?php echo tep_draw11_top();?>

 

 

 

<?php echo tep_draw_infoBox2_top();?>

 

<table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr><td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td></tr>

</table>

 

<?php echo tep_draw_infoBox2_bottom();?>

 

<?php echo tep_draw11_bottom();?>

 

<?php

} else {

$product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product_info = tep_db_fetch_array($product_info_query);

 

tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

 

if ($new_price = tep_get_products_special_price($product_info['products_id'])) {

$products_price2 = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s><br><span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';

} else {

$products_price2 = '<span class="productSpecialPrice">'.$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])).'</span>';

}

 

if ($new_price = tep_get_products_special_price($product_info['products_id'])) {

$products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s>   <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';

} else {

$products_price = '<span class="productSpecialPrice">'.$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])).'</span>';

}

 

if (tep_not_null($product_info['products_model'])) {

$products_name = $product_info['products_name'] . '<br> <span class="smallText">[' . $product_info['products_model'] . ']</span>';

} else {

$products_name = $product_info['products_name'];

}

?>

 

<?php echo tep_draw_top();?>

<?php echo tep_draw_title_top();?>

 

<div class="in_prod_info"><?php echo $breadcrumb->trail(' » ')?> » <?php echo $products_name; ?></div>

 

<?php echo tep_draw_title_bottom();?>

 

 

<?php echo tep_draw11_top();?>

 

 

 

<?php /* echo tep_draw2_top(); */ ?>

 

<?php /* echo tep_pixel_trans(); */?>

 

<?php

if (tep_not_null($product_info['products_image'])) {

?>

 

 

 

<div class="inmain" style="float:left;padding:1px 1px 1px 1px;margin:0px 20px 0px 0px; text-align:center; width:<?php echo (SMALL_IMAGE_WIDTH +14);?>px;">

<table><tr><td>

 

<?php echo tep_draw_prod_pic_top();?>

 

 

 

<script language="javascript"><!--

document.write('<?php echo '<a href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, '') . '</a>'; ?>');

//--></script>

<div style="clear:both;"></div>

 

 

<noscript>

<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, '') . '</a>'; ?>

</noscript>

 

<?php echo tep_draw_prod_pic_bottom();?>

</td></tr>

<tr>

<td style="text-align:center">

<script language="javascript"><!--

document.write('<?php echo '<a class="enlarge" href="java script:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');

//--></script>

<noscript>

<?php echo '<a class="enlarge" href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>

</noscript>

</td></tr></table>

</div>

 

 

<div class="inmain"><div class=""><?php echo stripslashes($product_info['products_description']); ?></div><br><?php echo $products_price?></div>

<div style="clear:both;"></div>

<?php

}

?>

 

<?php echo tep_pixel_trans();?>

 

<?php /* echo tep_draw2_bottom(); */ ?>

<div class="cart_line_x padd_gg"><?php echo tep_draw_separator('spacer.gif', '1', '1'); ?></div>

 

<?php echo tep_draw2_top();?>

 

<?php

$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'");

$products_attributes = tep_db_fetch_array($products_attributes_query);

if ($products_attributes['total'] > 0) {

?>

 

<?php echo tep_pixel_trans();?>

 

<table border="0" cellspacing="4" cellpadding="2">

<tr>

<td class="inmain" colspan="2"><strong class="strong"><?php echo TEXT_PRODUCT_OPTIONS; ?></strong></td>

</tr>

<?php

$products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");

while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {

$products_options_array = array();

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'");

while ($products_options = tep_db_fetch_array($products_options_query)) {

$products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']);

if ($products_options['options_values_price'] != '0') {

$products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') ';

}

}

 

if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) {

$selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']];

} else {

$selected_attribute = false;

}

?>

<tr>

<td class="inmain"><?php echo $products_options_name['products_options_name'] . ':'; ?></td>

<td class="inmain"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute); ?></td>

</tr>

<?php

}

?>

</table>

<?php

}

?>

 

 

<?php

$reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");

$reviews = tep_db_fetch_array($reviews_query);

if ($reviews['count'] > 0) {

?>

<table cellpadding="0" cellspacing="4" border="0">

<tr>

<td class="inmain"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

</table>

<?php

}

 

if (tep_not_null($product_info['products_url'])) {

?>

<table cellpadding="0" cellspacing="4" border="0">

<tr>

<td class="inmain"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td>

</tr>

</table>

 

<?php echo tep_pixel_trans();?>

 

<?php

}

 

if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) {

?>

 

<?php echo tep_pixel_trans();?>

 

<table cellpadding="0" cellspacing="4" border="0">

<tr>

<td class="smallText"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td>

</tr>

</table>

<?php

} else {

?>

 

 

<?php

}

?>

 

<?php echo tep_draw2_bottom();?>

 

<?php echo tep_pixel_trans();?>

 

 

<?php echo tep_draw2_top();?>

 

<?php echo tep_pixel_trans();?>

 

<?php /* echo tep_draw_infoBox2_top(); */ ?>

 

<table border="0" width="auto" cellspacing="0" cellpadding="2"><tr>

<td class="inmain button_marg"></td>

<td class="inmain button_marg" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart1.gif', IMAGE_BUTTON_IN_CART); ?></td>

</tr>

</table>

 

<?php /* echo tep_draw_infoBox2_bottom(); */ ?>

 

<?php echo tep_draw2_bottom();?>

 

 

<?php echo tep_draw11_bottom();?>

 

<?php echo tep_draw_bottom();?>

 

 

<?php

if ((USE_CACHE == 'true') && empty($SID)) {

echo tep_cache_also_purchased(3600);

} else {

include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);

}

}

?>

 

 

 

</form></td>

<td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text_eof //-->

<td class="<?php echo BOX_WIDTH_TD_RIGHT; ?>"><table border="0" class="<?php echo BOX_WIDTH_RIGHT; ?>" cellspacing="0" cellpadding="0"><td class="callback" <a href="java script:void(document.getElementById('customer_call_back_window').style.visibility = 'visible');"><?php echo BOX_INFORMATION_CALLBACK?></a><br><br>

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //--> </td>

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

=============================

Link to comment
Share on other sites

Hi Jack i´m giving this a new try.. ;)

 

how do i replace this code correct from your install text:

 

<!-- /*** Begin Header Tags SEO ***/ //-->	 
<?php
 } elseif ($action == 'new_product_preview') {
if (tep_not_null($HTTP_POST_VARS)) {
  $pInfo = new objectInfo($HTTP_POST_VARS);
  $products_name = $HTTP_POST_VARS['products_name'];
  $products_description = $HTTP_POST_VARS['products_description'];
  $products_head_title_tag = $HTTP_POST_VARS['products_head_title_tag'];
  $products_head_desc_tag = $HTTP_POST_VARS['products_head_desc_tag'];
  $products_head_keywords_tag = $HTTP_POST_VARS['products_head_keywords_tag'];
  $products_url = $HTTP_POST_VARS['products_url'];
} else {
  $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id  from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");
  $product = tep_db_fetch_array($product_query); 
/*** End Header Tags SEO ***/

 

With my code(i have the bcdev contrib):

 

<?php
 } elseif ($action == 'new_product_preview') {
if (tep_not_null($HTTP_POST_VARS)) {
  $pInfo = new objectInfo($HTTP_POST_VARS);
  $products_name = $HTTP_POST_VARS['products_name'];
  $products_description = $HTTP_POST_VARS['products_description'];
  $products_url = $HTTP_POST_VARS['products_url'];
  $products_description = $HTTP_POST_VARS['products_description'];
  // bcdev contrib - Add Attributes to categories.php
  $products_options = $HTTP_POST_VARS['option'];
  $products_options_price = $HTTP_POST_VARS['value_price'];
  $products_options_price_prefix = $HTTP_POST_VARS['price_prefix'];
  if (DOWNLOAD_ENABLED == 'true') {
	$products_attributes_filename = $HTTP_POST_VARS['products_attributes_filename'];
	$products_attributes_maxdays = $HTTP_POST_VARS['products_attributes_maxdays'];
	$products_attributes_maxcount =  $HTTP_POST_VARS['products_attributes_maxcount'];
  }
  // end bcdev contrib
} else {
  $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name, 

pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, 

p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, 

p.products_status, p.manufacturers_id  from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where 

p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");
  $product = tep_db_fetch_array($product_query);

 

Thanks

Edited by Solan
Link to comment
Share on other sites

Hello,

 

I see that only

	  $products_head_title_tag = $HTTP_POST_VARS['products_head_title_tag'];
  $products_head_desc_tag = $HTTP_POST_VARS['products_head_desc_tag'];
  $products_head_keywords_tag = $HTTP_POST_VARS['products_head_keywords_tag'];

 

and

pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag,

 

should be added for the header tags

So you can try this:

 

<?php
 } elseif ($action == 'new_product_preview') {
if (tep_not_null($HTTP_POST_VARS)) {
  $pInfo = new objectInfo($HTTP_POST_VARS);
  $products_name = $HTTP_POST_VARS['products_name'];
  $products_description = $HTTP_POST_VARS['products_description'];
  $products_head_title_tag = $HTTP_POST_VARS['products_head_title_tag'];
  $products_head_desc_tag = $HTTP_POST_VARS['products_head_desc_tag'];
  $products_head_keywords_tag = $HTTP_POST_VARS['products_head_keywords_tag'];  
  $products_url = $HTTP_POST_VARS['products_url'];
  $products_description = $HTTP_POST_VARS['products_description'];
  // bcdev contrib - Add Attributes to categories.php
  $products_options = $HTTP_POST_VARS['option'];
  $products_options_price = $HTTP_POST_VARS['value_price'];
  $products_options_price_prefix = $HTTP_POST_VARS['price_prefix'];
  if (DOWNLOAD_ENABLED == 'true') {
	$products_attributes_filename = $HTTP_POST_VARS['products_attributes_filename'];
	$products_attributes_maxdays = $HTTP_POST_VARS['products_attributes_maxdays'];
	$products_attributes_maxcount =  $HTTP_POST_VARS['products_attributes_maxcount'];
  }
  // end bcdev contrib
} else {
  $product_query = tep_db_query("select p.products_id, pd.language_id, pd.products_name,

pd.products_head_title_tag, pd.products_head_desc_tag, pd.products_head_keywords_tag,

pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image,

p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available,

p.products_status, p.manufacturers_id  from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where

p.products_id = pd.products_id and p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "'");
  $product = tep_db_fetch_array($product_query);

 

 

Stanislav

Link to comment
Share on other sites

Sorry Jack but I need your assistance again. :blush:

 

After all the previous updating and editing from version 3.0.1 to 3.1.4 plus the extra little glitches, I can't fix this problem myself.

 

In Admin Panel I added all the meta tag info for such pages as - categories, manufacturers, and products.

 

In version 3.0.1 I had them all properly displaying on the catalog side.

 

Now no matter how I set things up in Admin Panel > Header Tags SEO I can't get the Description content to showup.

 

Any thoughts or ideas?

 

Also, this may be really stupid and too late...

But exactly what was wrong with version 3.0.1 which required me to make so many updates?

If you go to admin->Catalog and edit a product and the Header Tags desciption is there, then it means it the database has it and the problem is on the shop side. If the problem on the shop side is on all pages (categories, manufacturers and products) then the problem is in the includes/header_tags.php and/or includes/functions/header_tags.php file. You can replace those with the ones from the contribution to see if that fixes it.

 

You would have to look at the history file to see the changes made since 3.0.1. Some were optins that were added that may not have affected your site but some, like Canonical tags, will help the site. Plus, keeping your version updated will make future updates easier. If I change something tomorrow that because a must have in your case but you are ten versions behind, you will have to go through what you have gone through to get to that point. So it is better, in my opinion, to do it in small steps.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

If I go to Page Control and select the Add Missing Pages option, it don't fix anything and during the test I see the same error.

In admin/includes/functions/header_tags.php I can exclude a file from list or add files on $baseFiles array, in this array there are index.php product_info.php product_reviews.php product_reviews_info.php product_reviews_write.php specials.php. If I try in $baseFiles to add for example info_shopping_cart.php, in test the error remains.

Any ideas?

Bye

Remove the Header Tags code (that goes in the <head> section) from files that shouldn't have it and Page Control won't see the files. You will have to remove them from the includes/header_tags.php file, or just replace it, to clear those already in there.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

If the problem on the shop side is on all pages (categories, manufacturers and products) then the problem is in the includes/functions/header_tags.php file.

 

... keeping your version updated will make future updates easier.

 

Thank you Jack for pointing me in the right direction!!! :)

 

I found an editing problem in the includes/functions/header_tags.php file. Awhile back when we where editing that file due to error messages, I had changed line 64. :unsure:

 

From this:

  $header_tags_array['desc'] = ltrim(tep_db_prepare_input(implode(' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION . ' ', $sortOrder['description'])), ' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION);

To this:

if (isset($sortOrder['desc'])) $header_tags_array['description'] = ltrim(tep_db_prepare_input(implode(' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION . ' ', $sortOrder['desc'])), ' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION);

 

:blush:

 

I just wasn't sure if something was wrong with v3.0.1.

You know the old saying - "If it ain't broke don't fix it." LOL :P

 

I appreciate your help again, big THANK YOU!!!

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Link to comment
Share on other sites

Hi Jack,

 

Quick Question. I tried intalling Ultimate SEO 2.7 it has a few bugs to be worked out, But I saw this question posed in that thread which is.

 

Is there any compatability issue using both of these contributions together? (that you know of)

 

i.e. Should I only run one or the other or can both work together

 

Thanks

I like that fact that your code has not had other people making mince meat of it.

The Site can be viewed at www.performanceautopartsonline.com

 

The site is live (despite these minor glitches) please respect that and do not sign up etc...

 

maybe a contribution one day when I get this site the way I want it.

 

I don't make spelling mistakes! I have dyslecsic fingers.

Link to comment
Share on other sites

Hi Jack,

 

Quick Question. I tried intalling Ultimate SEO 2.7 it has a few bugs to be worked out, But I saw this question posed in that thread which is.

 

Is there any compatability issue using both of these contributions together? (that you know of)

 

i.e. Should I only run one or the other or can both work together

 

Thanks

I like that fact that your code has not had other people making mince meat of it.

I can't keep up with all of the versions of Ultimate SEO but they all should work. However, some vresions have a bug in the code that will erase the settings for Header Tags. The only one I know that works for sure is the one I uploaded (v 2.1d).

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Hi guys...im a newby at all this oscommerce thing and i am finding it quite hard as i have a real basic knowledge. I have just begun my install and i have fallen at the first hurdle. I have uploaded the dadabase install file into the same directory as my index.php and i get this error message does anyone know what this means.

 

1060 - Duplicate column name 'categories_htc_title_tag'

 

ALTER TABLE categories_description ADD categories_htc_title_tag VARCHAR(80) NULL;

 

[TEP STOP]

 

please answer in very easy terms

 

Thanks in advance

 

 

Regards

 

Donna

Link to comment
Share on other sites

Hi guys...im a newby at all this oscommerce thing and i am finding it quite hard as i have a real basic knowledge. I have just begun my install and i have fallen at the first hurdle. I have uploaded the dadabase install file into the same directory as my index.php and i get this error message does anyone know what this means.

 

1060 - Duplicate column name 'categories_htc_title_tag'

It means the database changes, or at least one of them, has already been made to your database. Upload the headertags_seo_uninstall.php file and run that before running the install one and it should work.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

oh no scrap that heres the code it came up with this time

 

1136 - Column count doesn't match value count at row 1

 

INSERT INTO headertags VALUES ('index.php', 'New Home Page Title', 'new description', 'new keywords1,keywords2', 'new logo text', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '10', '1', '1')

 

[TEP STOP]

Link to comment
Share on other sites

Hi I'm having a problem with broken tables in my template. I narrowed it down and I think Header Tags is causing it by creating extra tables and not closing them. I'm using sts and simply created a table with the $content placeholder in there to bring up any content for a page. This page is a category page with no products. Any ideas on how to fix this would be nice. Yes I know quick fix but I'm more concerned that bad code will screw up more pages depending on what the content is that's pulled. I guess I could turn off Header Tags and see if it changed anything. Well I already typed this out, so I figure someone bright will probably know exactly what the problem is. Anyhoo, Here is the code:

 

===========================================================

 

<html>

<body>

 

<!-- beginning of my table -->

<table width="900" border="4" align="center" cellpadding="0" cellspacing="0" bgcolor="#990000">

<tr>

<td>

<!-- BEGIN CONTENT-->

 

<!-- start Index content //-->

TABLE 1

<table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td>

 

 

TABLE 2

<table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><h1>EMPTY H1 BECAUSE I DELETED ALL FILL TAGS</h1></td>

<td width="100%" valign="top">

 

TABLE 3

<table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td>

 

TABLE 4

<table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><h1>EMPTY H1 BECAUSE I DELETED ALL FILL TAGS</h1></td>

**missing </tr> **

</table>

END TABLE 4

 

</td>

</tr>

<tr>

<td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="10"></td>

</tr>

<tr>

<td>

 

 

TABLE 4B

<table border="0" width="100%" cellspacing="0" cellpadding="2" class="productListing">

<tr class="productListing-odd">

<td class="productListing-data">There are no products to list in this category.</td>

</tr>

</table>

END TABLE 4B

 

 

</td>

</tr>

<!--- BEGIN Header Tags SEO Social Bookmarks -->

<!--- END Header Tags SEO Social Bookmarks -->

</table>

END TABLE 3 (or 2 or 1 depending on what's messed up)

 

**missing end of tables 1 and 2 **

<!-- end Index content //-->

 

 

<!-- END OF CONTENT-->

</td>

</tr>

</table>

<!-- end of my table-->

 

</body>

</html>

☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆ ☆

Link to comment
Share on other sites

hiya...thanks but i found that somewhere and did it but it still comes up with the same...i uninstalled it and a page came up saying sucessfull....so i went to installation url and same thing came up......im so bad at this...any other ideas???

What are the exact steps you are taking from the beginning with regards to getting the database changes uploaded? Not what steps you are doing now. Assume this is a new install - what would you do?

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

firstly i uploaded the database install file into the same directory...so i think as my index php...then i copy the url to my clipboard and paste it into my browser and then the error comes up on a page

 

1136 - Column count doesn't match value count at row 1

 

INSERT INTO headertags VALUES ('index.php', 'New Home Page Title', 'new description', 'new keywords1,keywords2', 'new logo text', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '10', '1', '1')

 

[TEP STOP]

 

i have looked thru complications and it says something about default language file not having an id of 1 then it says to install admin and add missing files.....anyone know what i should do???

Link to comment
Share on other sites

firstly i uploaded the database install file into the same directory...so i think as my index php...then i copy the url to my clipboard and paste it into my browser and then the error comes up on a page

 

1136 - Column count doesn't match value count at row 1

 

INSERT INTO headertags VALUES ('index.php', 'New Home Page Title', 'new description', 'new keywords1,keywords2', 'new logo text', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '10', '1', '1')

 

[TEP STOP]

 

i have looked thru complications and it says something about default language file not having an id of 1 then it says to install admin and add missing files.....anyone know what i should do???

This is a known problem and the fix is in the thread. But I've uploaded a new version for those that can't find it. Please use the sql files from it once it becomes available.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

A new version has been uploaded with these changes:

 

-> Corrected mistakes in the sql install files.

-> Corrected mistake in includes/functions/header_tags.php.

-> Added code to allow the logo text to work in STS shops.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Nasty bugger bit me in the butt again Jack! :angry:

 

In the includes/functions/header_tags.php file. Awhile back we where editing that file due to error messages, I had changed line 64.

 

From this:

  $header_tags_array['desc'] = ltrim(tep_db_prepare_input(implode(' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION . ' ', $sortOrder['description'])), ' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION);

To this:

if (isset($sortOrder['desc'])) $header_tags_array['description'] = ltrim(tep_db_prepare_input(implode(' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION . ' ', $sortOrder['desc'])), ' ' . HEADER_TAGS_SEPARATOR_DESCRIPTION);

 

Just found out why I edited line 64 -

Warning: implode() [[url="http://handeshobbies.com/function.implode"]function.implode[/url]]: Bad arguments. in /home3/handesho/public_html/includes/functions/header_tags.php on line 64

 

I had reverted back to the original code for line 64, which solved my problems of the META tag DESCRIPTION content not showing up.

 

I was playing around with setting up the sitemap in admin panel (Sitemap SEO v1.2).

Then I noticed on the catalog side, the pageHeading was not showing up and the title was missing "Sitemap" (see here).

So I went to Admin > Header Tags SEO > Page Control > Select A File > sitemap.php (yes I installed the header tags edits first) and then tried setting the Title, Description, Keyword(s).

 

I go back to the catalog and load the Sitemap page and that's when I noticed the warning message and still no pageHeading. :o

 

I really need help with this because I have no clue what's going on, why or how to fix it.

I'm super close to scrapping the whole ecommerce thing and just go fishing (bass are starting to bite and we can keep them come June 15th ;) ).

 

Even a super stripped down simple version would be fine at this point. :(

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Link to comment
Share on other sites

No, it's V 3.1.5. Due to its size, it doesn't get posted until it has been checked.

 

Jack

 

Ok, thank you Jack.

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Link to comment
Share on other sites

Nasty bugger bit me in the butt again Jack! :angry:

 

 

 

Just found out why I edited line 64 -

Warning: implode() [[url="http://handeshobbies.com/function.implode"]function.implode[/url]]: Bad arguments. in /home3/handesho/public_html/includes/functions/header_tags.php on line 64

 

I had reverted back to the original code for line 64, which solved my problems of the META tag DESCRIPTION content not showing up.

 

I was playing around with setting up the sitemap in admin panel (Sitemap SEO v1.2).

Then I noticed on the catalog side, the pageHeading was not showing up and the title was missing "Sitemap" (see here).

So I went to Admin > Header Tags SEO > Page Control > Select A File > sitemap.php (yes I installed the header tags edits first) and then tried setting the Title, Description, Keyword(s).

 

I go back to the catalog and load the Sitemap page and that's when I noticed the warning message and still no pageHeading. :o

 

I really need help with this because I have no clue what's going on, why or how to fix it.

I'm super close to scrapping the whole ecommerce thing and just go fishing (bass are starting to bite and we can keep them come June 15th ;) ).

 

Even a super stripped down simple version would be fine at this point. :(

Since it is only happening on the sitemap page, the problem is most likely in page control. Go there, select the sitemap page and uncheck all boxes for it ecept for root. Make sure there is a sort order number for the root box. Enter text into the boxes for that page and update. Does it still fail?

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Since it is only happening on the sitemap page, the problem is most likely in page control. Go there, select the sitemap page and uncheck all boxes for it ecept for root. Make sure there is a sort order number for the root box. Enter text into the boxes for that page and update. Does it still fail?

 

Jack

 

:blink: :blush:

 

Thanks Jack, no more warning message and the tags are filled in with the text I entered.

 

Just one problem remaining, might not be related, still no pageHeading on the page.

 

td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td class="pageHeading"></td>
		<td class="pageHeading" align="right"><img src="images/table_background_specials.gif" border="0" alt="Sitemap" title=" Sitemap " width="125" height="65"></td>
	  </tr>
	</table></td>

 

I'll assume that will be the process for any other pages I add in the future?

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Link to comment
Share on other sites

Just one problem remaining, might not be related, still no pageHeading on the page.

 

I tried changing this (line 192):

<?php echo $settings['heading_title']; ?>

 

To this:

<?php echo HEADING_TITLE; ?>

 

Now the pageHeading displays.

Did I just make another mess of things or is that alright? :huh:

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...