Changing Header Tags

Daddyslipdisk · August 10, 2005

I have done everything to my store. Products in place, shipping, the works. The only complaint I have now is the headers. The store home page says "TABLE_HEADING_NEW_PRODUCTS" on the top of the What's New area. Then when you go into a specific category on the left side menu, then the table has all of the headers like "TABLE_HEADING_IMAGE", "TABLE_HEADING_PRODUCTS", TABLE_HEADING_PRICE", etc.

I saw the Header Change contribution and the installation file of it is incredibly confusing to me. I also saw the newest contribution of that file that has an installer with it, but it doesn't have any included instructions with it other than the same instructions for the original file, wwhich makes even less sense because the folders and contents are different than the original.

Basically, here's what I need. Can someone, please tell me which file these headers are coming from and what line number it is? I see that some say it comes from index.php, but I can't find it to save my life. I just want to make these minor adjustments and move on with my life.

Mr. Christopher

chris@hortonwebdesign.com

www.allinoneaccess.com/catalog

Daddyslipdisk · August 10, 2005

Ok,

For anyone else that has this issue, it's located in the languages/English/index.php file. HOWEVER, the fields for those headers were gone! The lines that defined what the "TABLE_HEADING_IMAGE", "TABLE_HEADING_PRODUCTS", TABLE_HEADING_PRICE", etc. fields should say were just simply not there in the index.php file. That's why they were showing "TABLE_HEADING_IMAGE", "TABLE_HEADING_PRODUCTS", TABLE_HEADING_PRICE", etc. instead of "Product", "Price", "Buy Now!" etc. .

I found the correct lines it needed in the "espanol" folder index.php file. Then I copied and pasted the content from that index file over to the english folder and changed the content. I have never adjusted this file, so I would highly suggest you make sure that those lines are there if you have this same problem. Here's what the index.php file should look like. Copy and paste everything between the asterisks lines and save it as index.php and overwrite the one that's in your Languages/English folder. MAKE SURE YOU BACK UP YOUR ORIGINAL ONE FIRST!;

********************

<?php

/*

$Id: index.php,v 1.3 2003/07/08 16:56:04 dgw_ Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Copyright ? 2003 osCommerce

Released under the GNU General Public License

*/

define('TEXT_MAIN', 'Main text here.');

define('TABLE_HEADING_NEW_PRODUCTS', 'New Products for %s');

define('TABLE_HEADING_UPCOMING_PRODUCTS', 'Upcoming products');

define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected');

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

define('HEADING_TITLE', 'Welcome to Our E-Store');

define('TABLE_HEADING_IMAGE', 'Image');

define('TABLE_HEADING_MODEL', 'Model');

define('TABLE_HEADING_PRODUCTS', 'Products');

define('TABLE_HEADING_MANUFACTURER', 'Manufacturer');

define('TABLE_HEADING_QUANTITY', 'Quantity');

define('TABLE_HEADING_PRICE', 'Price');

define('TABLE_HEADING_WEIGHT', 'Weight');

define('TABLE_HEADING_BUY_NOW', 'Buy Now!');

define('TEXT_NO_PRODUCTS', 'No products in this category, but check back. If the category is here, then we plan on entering products here soon.');

define('TEXT_NO_PRODUCTS2', 'No products from the manufacturer for this category.');

define('TEXT_NUMBER_OF_PRODUCTS', 'Number of products: ');

define('TEXT_SHOW', 'Search:');

define('TEXT_BUY', 'Buy 1 \'');

define('TEXT_NOW', '\' time');

define('TEXT_ALL_CATEGORIES', 'All');

define('TEXT_ALL_MANUFACTURERS', 'All');

} elseif ($category_depth == 'top') {

define('HEADING_TITLE', 'Welcome to My E-Store!');

} elseif ($category_depth == 'nested') {

define('HEADING_TITLE', 'Categories');

}

?>

********************

Hope this helps someone!

Mr. Christopher

chris@hortonwebdesign.com

Diajejo · August 14, 2005

Hi, I have been struggling with this same problem for a couple of weeks now. My problem is in the sub-categories. Im getting the table_heading_image, table_heading_product, table_heading_price, and table_heading_buy_now instead of the category names. On the main category these headings are as they should be. Its the sub categories I need to find the code for. And they are not in the index.php file. I did d-load the Header Tags contribution but am at a total loss as how to install it. I also bought the Oscommerce Users manual, but it doesnt have any trouble shooting solutions. Sheesh this is frustrating! Maybe I should just buy a template and be done with it. Anyway, my question is, "In which file is the code for the 'sub-category headings'? Maybe we can figure this out together:) Thanks, Diana

Ok,
For anyone else that has this issue, it's located in the languages/English/index.php file. HOWEVER, the fields for those headers were gone! The lines that defined what the "TABLE_HEADING_IMAGE", "TABLE_HEADING_PRODUCTS", TABLE_HEADING_PRICE", etc. fields should say were just simply not there in the index.php file. That's why they were showing "TABLE_HEADING_IMAGE", "TABLE_HEADING_PRODUCTS", TABLE_HEADING_PRICE", etc. instead of "Product", "Price", "Buy Now!" etc. .

I found the correct lines it needed in the "espanol" folder index.php file. Then I copied and pasted the content from that index file over to the english folder and changed the content. I have never adjusted this file, so I would highly suggest you make sure that those lines are there if you have this same problem. Here's what the index.php file should look like. Copy and paste everything between the asterisks lines and save it as index.php and overwrite the one that's in your Languages/English folder. MAKE SURE YOU BACK UP YOUR ORIGINAL ONE FIRST!;

********************

<?php

/*

$Id: index.php,v 1.3 2003/07/08 16:56:04 dgw_ Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Copyright ? 2003 osCommerce

Released under the GNU General Public License

*/

define('TEXT_MAIN', 'Main text here.');

define('TABLE_HEADING_NEW_PRODUCTS', 'New Products for %s');

define('TABLE_HEADING_UPCOMING_PRODUCTS

', 'Upcoming products');

define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected');

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

define('HEADING_TITLE', 'Welcome to Our E-Store');

define('TABLE_HEADING_IMAGE', 'Image');

define('TABLE_HEADING_MODEL', 'Model');

define('TABLE_HEADING_PRODUCTS', 'Products');

define('TABLE_HEADING_MANUFACTURER', 'Manufacturer');

define('TABLE_HEADING_QUANTITY', 'Quantity');

define('TABLE_HEADING_PRICE', 'Price');

define('TABLE_HEADING_WEIGHT', 'Weight');

define('TABLE_HEADING_BUY_NOW', 'Buy Now!');

define('TEXT_NO_PRODUCTS', 'No products in this category, but check back. If the category is here, then we plan on entering products here soon.');

define('TEXT_NO_PRODUCTS2', 'No products from the manufacturer for this category.');

define('TEXT_NUMBER_OF_PRODUCTS', 'Number of products: ');

define('TEXT_SHOW', 'Search:');

define('TEXT_BUY', 'Buy 1 \'');

define('TEXT_NOW', '\' time');

define('TEXT_ALL_CATEGORIES', 'All');

define('TEXT_ALL_MANUFACTURERS', 'All');

} elseif ($category_depth == 'top') {

define('HEADING_TITLE', 'Welcome to My E-Store!');

} elseif ($category_depth == 'nested') {

define('HEADING_TITLE', 'Categories');

}

?>

********************

Hope this helps someone!

Mr. Christopher

chris@hortonwebdesign.com

<{POST_SNAPBACK}>

Daddyslipdisk · August 14, 2005

Same exact place as the others. They all pull from the index.php file. If the headers are not there in the code, then this is the exact thing I was referring to before in the earlier post. For some reason, there are headers that disappear from the index.php file. Make a backup of your english/index.php file first. Then take a look in the languages/espanol folder and open up that index.php file and see if you see the header listings there in the code. You won't need to know spanish, since the headers have the same name regardless of the language. If you do see the header lines in the code that you need, simply copy the lines and paste them into the english/index.php file, alter them to what you want them to say, and everything should be fine. If it gives you errors and coding makes you nervous, you may just want to just copy the espanol index.php file over to the english folder and then alter all of the fields again.

But in short, it DOES come from the index.php file and if you don't see it in the english/index.php file, it's missing when it shouldn't be. Copy the espanol/index.php over to it and then alter all of the info. But try copying the missing lines first before just copying over the entire file so you won't overwrite anything you've done up to this point.

Let me know if this helps. I'll make sure that the coding folks know that the next version of osCommerce needs to fix this issue.

Chris

Jack_mcs · August 14, 2005

This isn't an oscommerce issue, or a Header Tags issue for that matter. The problem is in the Auto Install contribution. That is not part of the Header Tags contribution and should not have been uploaded to that section. If you are having problems with it, you should ask in the support thread for that contribution since the author is more likely to see your problem then.

Jack

Diajejo · August 15, 2005

Well here is a copy of my index.php file. Do you see where the problem is? Thanks, Diana

Released under the GNU General Public License

*/

define('TEXT_MAIN', 'Welcome to California Wine Sellers online shopping store! ');

define('TABLE_HEADING_NEW_PRODUCTS', 'New Products For %s');

define('TABLE_HEADING_UPCOMING_PRODUCTS', 'Upcoming Products');

define('TABLE_HEADING_DATE_EXPECTED', 'Date Expected');

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

define('HEADING_TITLE', 'You Have Now Entered Zin Country!');

define('TABLE_HEADING_IMAGE', 'Image');

define('TABLE_HEADING_MODEL', 'Model');

define('TABLE_HEADING_PRODUCTS', 'Products');

define('TABLE_HEADING_MANUFACTURERS', 'Winery');

define('TABLE_HEADING_QUANTITY', 'Quantity');

define('TABLE_HEADING_PRICE', 'Price');

define('TABLE_HEADING_WEIGHT', 'Weight');

define('TABLE_HEADING_BUY_NOW', 'Buy Now!');

define('TEXT_NO_PRODUCTS', 'There are no products to list in this category.');

define('TEXT_NO_PRODUCTS2', 'There is no product available from this manufacturer.');

define('TEXT_NUMBER_OF_PRODUCTS', 'Number of Products: ');

define('TEXT_SHOW', 'Show:');

define('TEXT_BUY', 'Buy 1 \'');

define('TEXT_NOW', '\'Now');

define('TEXT_ALL_CATEGORIES', 'Main Menu');

define('TEXT_ALL_MANUFACTURERS', 'Winery');

} elseif ($category_depth == 'top') {

define('HEADING_TITLE', 'You Have Now Entered Zin Country!');

} elseif ($category_depth == 'nested') {

define('HEADING_TITLE', 'Categories');

}

?>

Same exact place as the others. They all pull from the index.php file. If the headers are not there in the code, then this is the exact thing I was referring to before in the earlier post. For some reason, there are headers that disappear from the index.php file. Make a backup of your english/index.php file first. Then take a look in the languages/espanol folder and open up that index.php file and see if you see the header listings there in the code. You won't need to know spanish, since the headers have the same name regardless of the language. If you do see the header lines in the code that you need, simply copy the lines and paste them into the english/index.php file, alter them to what you want them to say, and everything should be fine. If it gives you errors and coding makes you nervous, you may just want to just copy the espanol index.php file over to the english folder and then alter all of the fields again.

But in short, it DOES come from the index.php file and if you don't see it in the english/index.php file, it's missing when it shouldn't be. Copy the espanol/index.php over to it and then alter all of the info. But try copying the missing lines first before just copying over the entire file so you won't overwrite anything you've done up to this point.

Let me know if this helps. I'll make sure that the coding folks know that the next version of osCommerce needs to fix this issue.

Chris

<{POST_SNAPBACK}>

Diajejo · August 15, 2005

Hi, Well I did download the Header Tag conrib but thats as far as it went since I have no idea on how to put it where it needs to go. Im guessing that the auto install came with the oscommerce when I got it from my internet provider. I do appreciate the help. Thanks, Diana

This isn't an oscommerce issue, or a Header Tags issue for that matter. The problem is in the Auto Install contribution. That is not part of the Header Tags contribution and should not have been uploaded to that section. If you are having problems with it, you should ask in the support thread for that contribution since the author is more likely to see your problem then.

Jack

<{POST_SNAPBACK}>

mi_jaiten · August 15, 2005

Hi, Well I did download the Header Tag conrib but thats as far as it went since I have no idea on how to put it where it needs to go. Im guessing that the auto install came with the oscommerce when I got it from my internet provider. I do appreciate the help. Thanks, Diana

<{POST_SNAPBACK}>

Hi Diana,

There is another index.php file in catalog/index.php the one you've shown is in catalog/includes/languages/english/index.php it looks Ok.

below is an unedited catalog/index.php check to see if yours looks the same or just copy and paste over yours.

Kind Regards,

Michelle

P.S. I added Header Tags Controller it's pretty easy just follow the guide in the Read Me file it's well worth persevering as it makes life a breeze.

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

php Empty Spaces Rule

Tip: Make sure that there are no empty spaces before the first <?php at the top of the page and after the last ?> at the bottom. php don?t like empty spaces at the beginning or end of a page. Blank spaces can cause Error Warnings.

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

This is osC knowledge Base index

http://www.oscommerce.info/

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

<?php

/*
 
$Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $



 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com



Copyright (c) 2003 osCommerce



Released under the GNU General Public License

*/

 


require('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; ?>"> 

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

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

</head>

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

<!-- header //-->

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

<!-- header_eof //-->



<!-- body //-->

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

    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

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

<!-- left_navigation_eof //-->
        </table></td>

<!-- 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 width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

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

        <tr>

          <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

           <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
         </tr>

       </table></td>

     </tr>

     <tr>

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

     </tr>

     <tr>

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

         <tr>

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

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

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

     echo '                <td align="center" class="smallText" width="' . $width . '" valign="top"><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) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";

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

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

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

     }

   }



// needed for the new products module shown below

   $new_products_category_id = $current_category_id;

?>

             </tr>

           </table></td>

         </tr>

         <tr>

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

         </tr>

         <tr>

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

         </tr>

       </table></td>

     </tr>

   </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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id 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);

     $listing_sql .= ' order by ';

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

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

         break;

       case 'PRODUCT_LIST_NAME':

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

         break;

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

         break;

       case'PRODUCT_LIST_QUANTITY':

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

         break;

       case 'PRODUCT_LIST_IMAGE':

         $listing_sql .= "pd.products_name";

         break;

       case 'PRODUCT_LIST_WEIGHT':

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

         break;

       case 'PRODUCT_LIST_PRICE':

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

         break;

     }

   }

?>

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

     <tr>

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

         <tr>

           <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<?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 '            <td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';

       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()"');

       echo '</form></td>' . "\n";

     }

   }



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

   }
?>

           <td align="right"><?php echo tep_image(DIR_WS_IMAGES . $image, HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

         </tr>

       </table></td>

     </tr>

     <tr>

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

     </tr>

     <tr>

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

     </tr>

   </table></td>

<?php

 } else { // default page

?>

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

     <tr>

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

         <tr>

           <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

           <td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_default.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

         </tr>

       </table></td>

     </tr>

     <tr>

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

     </tr>

     <tr>

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

         <tr>

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

         </tr>

         <tr>

           <td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>
         </tr>

<?php

   include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);

?>

       </table></td>

     </tr>

   </table></td>

<?php
 }

?>

<!-- body_text_eof //-->

   <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- 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 //-->

<br>

</body>

</html>

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

Jack_mcs · August 15, 2005

Hi, Well I did download the Header Tag conrib but thats as far as it went since I have no idea on how to put it where it needs to go. Im guessing that the auto install came with the oscommerce when I got it from my internet provider. I do appreciate the help. Thanks, Diana

<{POST_SNAPBACK}>

No, these are all contributions, which are code changes someone wrote to enhance the basic oscommerce code. When you say "auto install," are you referring the auto install that is part of header tags or the contribution installer?

Jack

Diajejo · August 15, 2005

I want to thank you all for your help. I fixed the problem. I deleted the whole dang thing and bought a template. Hopefully that will make it easier. It sucks being such a newbie and not having the time to do it from the basic template. Again, thanks to all!

Changing Header Tags

Recommended Posts

Daddyslipdisk

Link to comment

Share on other sites

Daddyslipdisk

Link to comment

Share on other sites

Diajejo

Link to comment

Share on other sites

Daddyslipdisk

Link to comment

Share on other sites

Jack_mcs

Link to comment

Share on other sites

Diajejo

Link to comment

Share on other sites

Diajejo

Link to comment

Share on other sites

mi_jaiten

Link to comment

Share on other sites

Jack_mcs

Link to comment

Share on other sites

Diajejo

Link to comment

Share on other sites

Archived

Browse

Activity