Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] Header Tags Controller for Admin MS 2.2


Farrukh

Recommended Posts

  • 2 weeks later...
  • Replies 4.6k
  • Created
  • Last Reply

Top Posters In This Topic

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.

Best regards,

 

Elmo

Link to comment
Share on other sites

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~

Do not meddle in the affairs of Dragons, for you are crunchy and good with ketchup :-)

Link to comment
Share on other sites

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~

Do not meddle in the affairs of Dragons, for you are crunchy and good with ketchup :-)

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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:

 

 

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

Link to comment
Share on other sites

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:');

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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]

Link to comment
Share on other sites

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.

Confused worm farmer looking for assistance.

Link to comment
Share on other sites

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

Confused worm farmer looking for assistance.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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;

Link to comment
Share on other sites

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.

Confused worm farmer looking for assistance.

Link to comment
Share on other sites

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?

Confused worm farmer looking for assistance.

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...