[Contribution] Header Tags Controller for Admin MS 2.2

Farrukh · July 21, 2003

Hi all

I have just updated Richard Fielder Admin mod to be compatible with Milestone 2.2. Its a simple update

let me know if anyone finds any problems.

Get it here:

http://www.oscommerce.com/community/contributions,207

rmyles · July 21, 2003

Thanks!

I was trying to install it last night and ran into some problems. I'll give it another shot

Ron

Farrukh · July 22, 2003

post it here , if it works for you

July 28, 2003

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

Farrukh · July 28, 2003

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]

solardirect · August 3, 2003

Farrukh,

I have the same problem. I don't understand your answer in the above post. Could you please post the exact code to look for and the exact code to replace it with. Plus, see below, there are two sections that are not in MS2 code.

In the readme file are the following two instructions:

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

AND

Find the following (approx line 573)

$pInfo = new objectInfo($product);

} elseif ($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'];

} else {

$pInfo = new objectInfo(array());

}

I have a clean install of 2.2 MS2 and can not find this code in the categories.php file.

Has this changed and the readme is not updated? What code am I really looking for, and do I replace it with the code in the readme file?

Any help is appreciated as the readme file does not seem to be correct.

solardirect · August 3, 2003

Another fix (syntax error):

readme says:

Find the following (approx line 279)

$sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]),

'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]),

'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]),

Add the following to the end

'products_head_title_tag' => tep_db_prepare_input($HTTP_POST_VARS['products_head_title_tag'][$language_id]),

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

Well the last ";" in the original code does need to be changed to a "," but the last line of the new code needs to end with "));"

Here is the complete code:

$sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]), 

                                   'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]), 

                                   'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]), 

                                   'products_head_title_tag' => tep_db_prepare_input($HTTP_POST_VARS['products_head_title_tag'][$language_id]));

Farrukh · August 3, 2003

HI

Jsut updated the Install file and i have also included the files which are needed to be edited.

You can compare them with your own. Also, I have other mods installed as well. So dont miss them up.

Download from here:

http://www.oscommerce.com/community/contributions,207

networkdad · August 3, 2003

I get the following error while looking at the reviews of a product, and then clicking on a the link. Ex, http://www.healthyharvest.com/product_revi...31&reviews_id=1

Error:

Fatal error: Call to undefined function: tep_get_header_tag_products_desc() in /home/healthyh/public_html/includes/header_tags.php on line 169

Code from line 169:

        $the_desc= tep_get_header_tag_products_desc((int)$HTTP_GET_VARS['reviews_id']) . ' ' . HEAD_DESC_TAG_ALL;

Suggestions ??

networkdad · August 3, 2003

Same error in /product_reviews.php

Farrukh · August 4, 2003

YOu can check my site, everything i working fine. I have checked out the reviews also, it doesnt give any problems.

Did you follow the installation rules properly.

Impudent1 · August 20, 2003

Just curious about this one. How does one go about making the Admin page for creating a new products show the label text for meta tags fields in a second language?

I have tried adding the following to the admin/includes/languages/french/categories.php :

define('TEXT_PRODUCTS_PAGE_TITLE', 'Products Page Title:');

define('TEXT_PRODUCTS_HEADER_DESCRIPTION', 'French Product Descriptions:');

define('TEXT_PRODUCTS_KEYWORDS', 'French Product Keywords:');

but I still just get the field boxes with the flags and no text for the french description and meta tag boxes.

I have seen on webmakerscorner site on the demo admin of the shopcontroller mod that it is possible , I just seem to be missing something

tia

Dangeo1 · August 25, 2003

I have attempted to install the admin portion of the header tag controller, and get 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

There was no mention of adding fields for the admin portion. I have added all required by Linda's part.

Any help would be great.

Dangeo1 · August 25, 2003

That error is from admincategories.php

Dangeo1 · August 25, 2003

Ok, here's what I did.

I used the readme.txt to manually update the admincategories.php. It appears to be working fine.

But, I did notice one of the changes asks to change code that has already been replaced.

"Header Tag Controller Admin MS 2.2.TXT"

Find the following (approx line 603) 



     $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);

     

     

Replace with the following      





     $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);

The only place that code exists in the categories.php is already replaced with the following instruction from "Header Tag Controller Admin MS 2.2.TXT"

Find the following (approx line 743)





<?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'];

  } 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 = '" . $HTTP_GET_VARS['pID'] . "'");

     $product = tep_db_fetch_array($product_query);

   }



    

Replace with the following     

    



<?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 = '" . $HTTP_GET_VARS['pID'] . "'");

     $product = tep_db_fetch_array($product_query);

I dunno, maybe I hacked it and turned it into a timebomb.

sgflowers · August 25, 2003

I have attempted to install the admin portion of the header tag controller, and get 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

There was no mention of adding fields for the admin portion. I have added all required by Linda's part.

Any help would be great.

category status was removed some time ago from oscommerce this error is because it is not present in the database remove all references to category status ie: 'c.categories_status'

August 29, 2003

Does any one can put a working contrib for download? I'm little confused couse I tried to edit these files with no results :( As I seen on forum there are some fixes and I tried to put them but right now it's complete disaster :( I had to go back to old categories.php couse it was really broken. PLEASE update this instal :/

Thanks A LOT in advance

Piotr

August 30, 2003

Fatal error: Cannot 'redeclare tep_get_products_head_title_tag() (previously declared in /home/www/web10/html/admin/includes/functions/general.php:515) in /home/www/web10/html/admin/includes/functions/general.php on line 539

This is the error I currently have :( I've checked categories.php from admin section several times and there is something like 'redeclare tep_get_products_head_title_tag' Any ideas?

Dangeo1 · August 30, 2003

Also, I recommed a program like Editplus to use for editing your php files.

It does a good job of color-coding the text to tell what things are comments, functions, HTML, etc...

http://www.editplus.com/

southmodel · September 2, 2003

I'm sorry, but i can't find Tag control in admin section after installation..... where is?

showman · September 4, 2003

I have the same problem as previous poster - I've installed the Header Tags controller and the admin part, but cannot find this function in admin.

maybe I've done somthing wrong in the installation?

If somebody could tell me what to expect in the admin, this would be a great help.

thanks

Farrukh · September 4, 2003

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

showman · September 4, 2003

:D

Many thanks,

the penny dropped (how silly of me not to notice) about 5 mins after I made that post, I was just about to post again then I saw your reply.

thanks again

it works great.

cheers

showman

wace · September 5, 2003

I'm getting the following error:

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



select pd.products_name, pd.products_description, 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 products p, products_description pd where p.products_id = '30' and p.products_id = pd.products_id and pd.language_id = '4'

what can I do about it?

Farrukh · September 6, 2003

I'm getting the following error:

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



select pd.products_name, pd.products_description, 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 products p, products_description pd where p.products_id = '30' and p.products_id = pd.products_id and pd.language_id = '4'

what can I do about it?

It seems for the above SQK Query that 'products_head_title_tag' is missing 'pd.' in front of it.

Run this SQL Command.

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;

[Contribution] Header Tags Controller for Admin MS 2.2

Recommended Posts

Farrukh

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

rmyles

Farrukh

Guest

Farrukh

solardirect

solardirect

Farrukh

networkdad

networkdad

Farrukh

Impudent1

Dangeo1

Dangeo1

Dangeo1

sgflowers

Guest

Guest

Dangeo1

southmodel

showman

Farrukh

showman

wace

Farrukh

Join the conversation

Browse

Activity