[Contribution] Header Tags Controller for Admin MS 2.2

[wace]

Problem... On the index.php, no metatags are shown after installing this contribution, it works on all the other pages, but not on the index.php and thereby the most important page. How to fix this?

[Elmo]

I can't seem to find this code anywhere, and I am using ms2. ?Maybe I am blind, if it is there could someone post the line # on a default install. ?Thanks

 

Find the following (approx line 377)



? } elseif ($HTTP_GET_VARS['action'] == 'new_product') {

? ?if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {

? ? ?$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

? ? ?$product = tep_db_fetch_array($product_query);

 

This line is not present in MS2

 

} elseif ($HTTP_GET_VARS['action'] == 'new_product') {

 

 

Instead find this below code:

 

Its around 434 line:

 

<?php

?if ($action == 'new_product') {

? ?$parameters = array('products_name' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_description' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_url' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_id' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_quantity' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_model' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_image' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_mediumimage' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_largeimage' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_price' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_weight' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_date_added' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_last_modified' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_date_available' => '',

? ? ? ? ? ? ? ? ? ? ? 'products_status' => '',

? ? ? ? ? ? ? ? ? ? ? ? ? 'products_tax_class_id' => '',

? ? ? ? ? ? ? ? ? ? ? 'manufacturers_id' => '');



? ?$pInfo = new objectInfo($parameters);



? ?if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {

$product_query = tep_db_query("select pd.products_name, pd.products_description, ?pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

? ? ?$product = tep_db_fetch_array($product_query);

 

[/code]

May I kindly ask what code we should replace this with if we are using oscommerce 2.2 MS 2?

 

I cannot find the answer in this thread, thanks very much for your help.

[inetchoices]

I am getting the following error:

 

1054 - Unknown column 'c.categories_status' in 'field list'

 

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name

 

[TEP STOP]

 

 

I've read all of the posts in this thread and I can't find any reference to c.categories_status in the php files or in the db files. How do I remove a reference to something I can't find?

 

Help?

 

Khim~

[inetchoices]

About an hour after I posted my plea for help, I grew a new brain cell and used Find/Replace in GoLive to search for any entries including categories_status and was able to delete all references to c.categories_status in admin/categories.php

 

Works like a charm :-)

 

Thanks!

 

Khim~

[vice]

I'm very confused with somethings that should be done, however I can't see where to make it.

Instructions said:

 

Find the following (approx line 457)

 

 

 

if (isset($HTTP_GET_VARS['pID']) && empty($HTTP_POST_VARS)) {

$product_query = tep_db_query("select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product = tep_db_fetch_array($product_query);

 

 

Replace with the following

 

 

if (isset ($HTTP_GET_VARS['pID']) && (!$HTTP_POST_VARS) ) {

$product_query = tep_db_query("select 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_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'");

$product = tep_db_fetch_array($product_query);

 

I understand that, but, where are this instructions?! My admin/categories.php don't have it!! What should I do?

 

Another question that I must do is: I've installed Header Tags from Linda (I suppose they work... don't really know), is this the only thing I need to do to have my site well in ranking? or should I install also the Admin contribution?

 

If someone could help I appreciate that.

[Veronica]

Header Tag Controller Admin MS 2.2i

dont work, this the problem:

 

1054 - Unknown column 'c.categories_status' in 'field list'

 

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '3' order by c.sort_order, cd.categories_name

 

[TEP STOP]

 

Somebody can help me?

[vice]

Veronica, you must see the 2nd page of this topic.

[rhizome]

When you add a Products, you will see Three (3) Blank Boxes.

 

First one will be " Products Page Title: "

 

Second will be " Page Header Description: "

 

Third will be " Product Keywords: "

 

These are the places where you have to enter the details

Hi Farrukh,

 

do you maybe have a fix for that. The tree english boxes show the description in german and the tree german boxes are empty. Also the 'product description box' is concerned. What do I have to change?

 

My version: Header Tag Controller Admin MS2.2i (09/25/2003)

 

Thanks a lot,

 

Michael

[Farrukh]

I really did not make the changes for German and Spanish lanugages, though I did correct the prob with c.categories_status.

 

Download the latest version

[DMaster]

I installed Header Tags Controller and the Admin. I have two major issues.

I've gone through all the posts in this thread and many others. I've tried the suggested solutions and still having challenges getting them fixed.

 

When ever I click on any individual product or category I get the following:

 

1064 - You have an error in your SQL syntax near 'and c.parent_id = '21' and c.categories_id = cd.categories_id and cd.language_id' at line 1

 

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where and c.parent_id = '21' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

 

TEP STOP

 

Here is an example of the address it goes to when I click a product:

 

http://www.procamnetworks.com/catalog/prod...39f7f915eaba830

 

Second when I am in Admin and go to edit a product, the Meta Tags forms look correct but after previewing upon clicking to update product info I go the the following screan:

 

1054 - Unknown column 'products_head_title_tag' in 'field list'

 

update products set products_quantity = '49', products_model = '', products_price = '1.0000', products_date_available = null, products_weight = '0.00', products_status = '1', products_tax_class_id = '1', manufacturers_id = '', products_head_title_tag = '', products_head_desc_tag = '', products_head_keywords_tag = '', products_image = 'j0178039_small.jpg', products_last_modified = now() where products_id = '41'

 

TEP STOP

 

I've got the entries in my database under products_descriptions as required. They do not show on the main list of fields but they do show under products_descriptions. I've played with the null values, turning on and off, droped and re-added to DB with no success.

 

Possible relevant Code:

Catolog\Admin\Catagories.php

<?php
   $categories_count = 0;
   $rows = 0;
   if (isset($HTTP_GET_VARS['search'])) {
     $search = tep_db_prepare_input($HTTP_GET_VARS['search']);

     $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and cd.categories_name like '%" . tep_db_input($search) . "%' order by c.sort_order, cd.categories_name");
   } else {
     $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified 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 c.sort_order, cd.categories_name");
   }
   while ($categories = tep_db_fetch_array($categories_query)) {
     $categories_count++;
     $rows++;

// Get parent_id for subcategories if search
     if (isset($HTTP_GET_VARS['search'])) $cPath= $categories['parent_id'];

     if ((!isset($HTTP_GET_VARS['cID']) && !isset($HTTP_GET_VARS['pID']) || (isset($HTTP_GET_VARS['cID']) && ($HTTP_GET_VARS['cID'] == $categories['categories_id']))) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) {
       $category_childs = array('childs_count' => tep_childs_in_category_count($categories['categories_id']));
       $category_products = array('products_count' => tep_products_in_category_count($categories['categories_id']));

       $cInfo_array = array_merge($categories, $category_childs, $category_products);
       $cInfo = new objectInfo($cInfo_array);
     }

     if (isset($cInfo) && is_object($cInfo) && ($categories['categories_id'] == $cInfo->categories_id) ) {
       echo '              <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CATEGORIES, tep_get_path($categories['categories_id'])) . '\'">' . "\n";
     } else {
       echo '              <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories['categories_id']) . '\'">' . "\n";
     }
?>

 

<?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'];
  //BOF Header Tag Controler
  //Added the following 3 lines
  $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'];
  //EOF Header Tag Controler
   } else {
     //BOF Header Tag Controler
  $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);
  //EOF Header Tag Controler
     //$product = tep_db_fetch_array($product_query);
  
     $pInfo = new objectInfo($product);
     $products_image_name = $pInfo->products_image;
   }

   $form_action = (isset($HTTP_GET_VARS['pID'])) ? 'update_product' : 'insert_product';

   echo tep_draw_form($form_action, FILENAME_CATEGORIES, 'cPath=' . $cPath . (isset($HTTP_GET_VARS['pID']) ? '&pID=' . $HTTP_GET_VARS['pID'] : '') . '&action=' . $form_action, 'post', 'enctype="multipart/form-data"');

 

I've been working for 48 Hours on these two problems. Hopefully I didn't miss the answer somewhere. I will post the results of any suggestions given so others will know if they worked for this and will post a final recap when issues are solved to help others.

 

Thanks,

Adam

[Guest]

if you like the desciptions next to all the boxes instead of the english language use the code below

 

Line 556

<td class="main" valign="top"><?php if (%i == 0) echo TEXT_PRODUCTS_DESCRIPTION; ?></td>

 

replace with

<td class="main" valign="top"><?php echo TEXT_PRODUCTS_DESCRIPTION; ?></td>

 

Line 570

<td class="main" valign="top"><?php (%i == 0) echo TEXT_PRODUCTS_PAGE_TITLE; ?></td>

 

replace with

<td class="main" valign="top"><?php echo TEXT_PRODUCTS_PAGE_TITLE; ?></td>

 

Line 583

<td class="main" valign="top"><?php (%i == 0) echo TEXT_PRODUCTS_HEADER_DESCRIPTION; ?></td>

 

repace with

<td class="main" valign="top"><?php echo TEXT_PRODUCTS_HEADER_DESCRIPTION; ?></td>

 

Line 596

<td class="main" valign="top"><?php (%i == 0) echo TEXT_PRODUCTS_KEYWORDS; ?></td>

 

<td class="main" valign="top"><?php echo TEXT_PRODUCTS_KEYWORDS; ?></td>

 

Translation for espanol and german

 

/admin/includes/espanol/catagories.php

add the following

//header tags

define('TEXT_PRODUCTS_PAGE_TITLE', 'T?tulo de P?gina de Productos:');

define('TEXT_PRODUCTS_HEADER_DESCRIPTION', 'Descripci?n de Jefe de P?gina:');

define('TEXT_PRODUCTS_KEYWORDS', 'Palabras clave de Producto:');

 

/admin/includes/german/catagories.php

//header tags

define('TEXT_PRODUCTS_PAGE_TITLE', ' Produktseitentitel:');

define('TEXT_PRODUCTS_HEADER_DESCRIPTION', 'Seitenkopfball-Beschreibung:');

define('TEXT_PRODUCTS_KEYWORDS', 'Produktschl?sselw?rter:');

[vice]

Someone who please looks at my post and answer me?

Thanks in advance.

 

www.neuronios.com

[Guest]

Someone who please looks at my post and answer me?

Thanks in advance.

 

www.neuronios.com

i looked at you site it seems you have the catalog setup right for the meta tags

 

for the admin side the catagoeries should be /catalog/admin/catagories.php

 

if you don't have it you will to upload the file again

[strickliesl]

Like others in this thread I can't find the Tag control in admin section after installation, but unlike the others I cant even find it when adding a new product, whats wrong?

Also I get an error message when I hit the read-product-review button

 

Fatal error:

Call to undefined function: tep_get_header_tag_products_desc() in /homepages/33/d83839338/htdocs/catalog/includes/header_tags.php on line 169

 

Somebody can tell me in which file the function should be defined, I know about nothing of php only work strictly after the instructions, .... which was okay up to this point... Please help!

[jakegaisser]

I have tried installing this contribution a few times i always backup first then restore original files i did everything step by step. I get errors in the product description page when installing this mod. All the files that you edit for this are stock I have only installed infobox image headers, centershop, and Allprods and none of the files edited for this procedure have anything related to those mods.

 

Does anyone have this working with a very recent install of Oscommerce

 

osCommerce 2.2 Milestone 2 (07/12/2003) - this is the one i have from the download section. If anyone has got this working could they please zip the three files that are edited for this to work and post it here or email it to me at: [email protected]

[mariusz]

Please, sent me step by step instruction how can I install this mod, with all necessary files. (Oryginal OsC 2.2 MS2) email: [email protected]

[clia]

I have worked on this mod for a while, everything seems correct. However, the 3 new fields in New Product page are not showing up.

 

Any advice? Thanks in advance.

[spilotes]

Just one question and I'm sure I'll fell foolish when I get the answer. The read me file states

 

NEW FILES TO ADD:

Added Files:

/catalog/includes/header_tags.php

/catalog/includes/languages/english/header_tags.php

/catalog/includes/functions/clean_html_comments.php

/catalog/includes/functions/header_tags.php

 

Where is this table located...................I've looked high and low.

[spilotes]

Oops wrong qoute.

 

This is what I'm looking for.

 

TABLE CHANGES:

Add the following new fields to products_description table. NOTE: The lengths can be anything you perfer to use.

products_head_title_tag varchar 80

products_head_desc_tag longtext 300

products_head_keywords_tag longtext 300

[Guest]

strickliesl it appears that you don't have the databse update installed

 

 

jakegaisser you must have missed some thing in the install if you check again you should find what you missed

 

 

I wish i could post my cataegories.php but i have mine heavly modified so it would not be help you should have no problem installing the mod by following the instructions

 

for the admin section use this 09/25/2003 - Header Tags Admin MS 2.2

 

for the catalog section use this 09/05/2003 - Header Tags Controller v2.1

[Guest]

Oops wrong qoute.

 

This is what I'm looking for.

 

TABLE CHANGES:

Add the following new fields to products_description table. NOTE: The lengths can be anything you perfer to use.

products_head_title_tag varchar 80

products_head_desc_tag longtext 300

products_head_keywords_tag longtext 300

use this for the database

 

ALTER TABLE products_description ADD products_head_title_tag VARCHAR(80) NULL;
ALTER TABLE products_description ADD products_head_desc_tag LONGTEXT NULL;
ALTER TABLE products_description ADD products_head_keywords_tag LONGTEXT NULL;

[spilotes]

use this for the database

 

 

CODE

ALTER TABLE products_description ADD products_head_title_tag VARCHAR(80) NULL;

ALTER TABLE products_description ADD products_head_desc_tag LONGTEXT NULL;

ALTER TABLE products_description ADD products_head_keywords_tag LONGTEXT NULL;

 

 

 

Database............how do I get there? Totally lost.

[Guest]

depending on your web site control panel there should be a link to the database if you have more than one database make sure you select the right one

[spilotes]

Ok I'm getting the swing of things now.

 

I've installed I've installed the 9/5/03 update, but now I get the following warning.

 

Warning: Cannot modify header information - headers already sent by (output started at /home/jenkinsc/public_html/catalog/includes/languages/english.php:332) in /home/jenkinsc/public_html/catalog/includes/functions/general.php on line 29

 

Any thoughts?

[Guest]

check what you have on line 332 in english.php and what you have on line 29 in general.php and post the contets you problably have typo