Hello,
I'm new to PHP and having a small problem in it as below.
I have running OSC successfully and just now i installed the cDynamic_Meta_Tags v1.6 from http://addons.oscommerce.com/info/2895
i am running it also successfully but the sorting of Title is like
'Product name' by: 'Manufacturer' - 'Store Name'
while i want it like this
'Store name' » 'Manufacturer' » 'Product Name'
* for » in HTML » is used
it may be here in this code somewhere
<?php
/*=======================================================================*\
|| #################### //-- SCRIPT INFO --// ########################### ||
|| # Script name: meta_tags.php # ||
|| # Contribution: cDynamic Meta Tags # ||
|| # Version: 1.3 # ||
|| # Date: April 15 2005 # ||
|| # ------------------------------------------------------------------ # ||
|| #################### //-- COPYRIGHT INFO --// ######################## ||
|| # Copyright (C) 2005 Chris LaRocque # ||
|| # # ||
|| # This script is free software; you can redistribute it and/or # ||
|| # modify it under the terms of the GNU General Public License # ||
|| # as published by the Free Software Foundation; either version 2 # ||
|| # of the License, or (at your option) any later version. # ||
|| # # ||
|| # This script is distributed in the hope that it will be useful, # ||
|| # but WITHOUT ANY WARRANTY; without even the implied warranty of # ||
|| # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # ||
|| # GNU General Public License for more details. # ||
|| # # ||
|| # Script is intended to be used with: # ||
|| # osCommerce, Open Source E-Commerce Solutions # ||
|| # http://www.oscommerce.com # ||
|| # Copyright (c) 2003 osCommerce # ||
|| ###################################################################### ||
\*========================================================================*/
#--------------------------------------------------------------------------#
############################################################################
# DO NOT ALTER OR EDIT BELOW THIS LINE UNLESS YOU KNOW WHAT YOU ARE DOING #
# Call required files
require(DIR_WS_LANGUAGES . $language . '/' . 'meta_tags.php');
require(DIR_WS_FUNCTIONS . 'meta.php');
# Take the PHP_SELF global and replace all the /'s
# This should work with ALL URL's but best for search engine safe
$meta_cache_filename = str_replace("/", "_", $_SERVER['PHP_SELF']);
# Replace all the /'s in the URL parameters. Should not be needed but just in case...
$meta_cache_param = str_replace("/", "_", $_SERVER["QUERY_STRING"]);
# Remove the osCsid from the cache parameters
$meta_cache_param = preg_replace("/([&]|)osCsid=.{32}/", "", $_SERVER["QUERY_STRING"]);
#Add the cache language and store it
$meta_cache_language = '_' . $_SESSION['language'];
# Set the cache file currency and store it
$meta_cache_currency = '_' . $_SESSION['currency'];
# Create paths and cache names
$meta_cache_file=$meta_cache_filename.'_'.$meta_cache_param.$cache_language.$cache_currency.".meta-cache";
$meta_cache_file_full = $meta_cache_files_path.$meta_cache_file;
################################################################################
#############
# Check to see what type of cache if any and run with it...
$cache_type == 1
? $meta_cache_code = $cache->get_cache($meta_cache_file)
: NULL;
if ($meta_cache_code){ echo $meta_cache_code;
}else if ($cache_type == 2 && file_exists($meta_cache_file_full)) {
echo base64_decode(gzinflate(file_get_contents($meta_cache_file_full)));
}else{
ob_start();
# Page Parameters
################################################################################
#####################
# product_info.php
# If using Categories & Products get the product info
if (strpos($_SERVER['PHP_SELF'], 'product_info.php')){
$cacherun='true';
$product_info_meta_query = tep_db_query("select pd.products_name, pd.products_description, p.products_model from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' AND p.products_status = '1' AND pd.products_id = p.products_id AND pd.language_id = '" . (int)$languages_id . "'");
$product_meta_info = tep_db_fetch_array($product_info_meta_query);
# If using Categories & Products get the Manufacturers info
$product_man__info_meta_query = tep_db_query("select m.manufacturers_name from " . TABLE_PRODUCTS . " p, " . TABLE_MANUFACTURERS . " m," . TABLE_PRODUCTS_DESCRIPTION . " pd WHERE p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' AND m.manufacturers_id = p.manufacturers_id AND pd.language_id = '" . (int)$languages_id . "'");
$product_man_meta_info = tep_db_fetch_array($product_man__info_meta_query);
# Start getting data for the meta tags
# if model number exists add it to the title
tep_not_null($product_meta_info['products_model'])&& ($show_model_in_title)
? $title.=$product_meta_info['products_name'].' - '.$product_meta_info['products_model'].' '
: $title.=$product_meta_info['products_name'];
# get data for the description
$desc.=$product_meta_info['products_name'];
$man=$product_man_meta_info['manufacturers_name'];
$descfull.=$product_meta_info['products_description'];
tep_not_null($man) && ($show_man_in_title)
? $title.=' by: '.$man.' - '
: $title.=' - ';
tep_not_null($product_meta_info['products_model'])
? $desc.=' ('.$product_meta_info['products_model'].')'
: NULL;
tep_not_null($man)
? $desc.=' by '. $man
: NULL;
tep_not_null($descfull)
? $desc.=' - '. $descfull
: NULL;
# get data for the keywords
tep_not_null($product_meta_info['products_name'])
? $key.=$product_meta_info['products_name'].', '
: NULL;
tep_not_null($product_meta_info['products_model'])
? $key.=$product_meta_info['products_model'].', '
: NULL;
# clean up a little
$strip_bread_array = array(HEADER_TITLE_TOP, HEADER_TITLE_CATALOG, $model['products_model']);
$pre_key=$breadcrumb->trail('`~`~`');
$key.=str_replace($strip_bread_array, '',$pre_key);
# add the manufacturer but strip some things like:
//$key.=str_replace($strip_man_array, '',strtolower($product_man_meta_info['manufacturers_name'].','));
# Final stage for product_info.php
# Title
$metatitle.=$title .' '.STORE_NAME;
tep_not_null(HEAD_TITLE_TAG_ALL)
? $metatitle.=' - '. STORE_DESCRIPT
: NULL;
$metatitle=meta_create_title($metatitle);
# Description
$metadescription.=$desc .' '.STORE_DESCRIPT;
tep_not_null(HEAD_DESC_TAG_ALL)
? $metadescription.=' - '. STORE_METDEX
: NULL;
$metadescription=meta_create_meta_description($metadescription);
# Keywords
tep_not_null(HEAD_KEY_TAG_ALL)
? $key.=' '.STORE_KEYWORD
: NULL;
$metakeywords=strtolower(meta_create_meta_keywords($key));
#------------------------------------------------------------------------------------------------------#
# index.php with categories
}else if (strpos($_SERVER['PHP_SELF'], 'index.php')){
# If using Categories & Products get the product info
if ($current_category_id){
$cacherun='true';
$categories_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " WHERE categories_id ='" .$current_category_id. "' and language_id = '" . (int)$languages_id . "'");
$categories = tep_db_fetch_array($categories_query);
# get sub categories to list keywords when no product
$sub_categories_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_CATEGORIES . " c WHERE c.parent_id ='" .$current_category_id. "' AND cd.categories_id = c.categories_id and cd.language_id = '" . (int)$languages_id . "' LIMIT 20");
# get top level categories to list keywords when no product or sub cats
if ($category_depth != 'products' && $category_depth != 'nested') {
$categories_all_query = tep_db_query("select cd.categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd, " . TABLE_CATEGORIES . " c WHERE c.parent_id = 0 AND cd.categories_id = c.categories_id and cd.language_id = '" . (int)$languages_id . "' ORDER BY c.sort_order ASC");
}
# Start getting data for the meta tags
$title.=$categories['categories_name'];
# Create description with part of breadcrumb
$strip_bread_array = array(HEADER_TITLE_TOP, HEADER_TITLE_CATALOG);
$pre_desc=strip_tags($breadcrumb->trail(' - '));
$pre_desc=str_replace('"', '”', $pre_desc);
$desc.=str_replace($strip_bread_array, '',$pre_desc).' from '.STORE_NAME;
tep_not_null(HEAD_DESC_TAG_ALL)
? $desc.=' - '. STORE_METDEX
: NULL;
$metadescription=meta_create_meta_description($metadescription);
$key.=$categories['categories_name'].', ';
# get sub categories to list as keywords when no product
while ($sub_categories = tep_db_fetch_array($sub_categories_query)) {
$key.=$sub_categories['categories_name'].', ';
}
# get the products in this category
if ($category_depth == 'products') {
$products_query = tep_db_query("SELECT pd.products_name FROM " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pc WHERE pc.categories_id = '".$current_category_id."' AND pc.products_id = p.products_id AND p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = '" . (int)$languages_id . "' ORDER BY rand()");
while($products = tep_db_fetch_array($products_query)) {
$key.=$products['products_name'].', ';
}
}
if ($category_depth != 'products' && $category_depth != 'nested') {
while ($categories_all = tep_db_fetch_array($categories_all_query)) {
$key.=str_replace($categories['categories_name'], '`~`~`',$categories_all['categories_name']).', ';
}
}
# if the page is showing products by manufacturers
}else if ($HTTP_GET_VARS['manufacturers_id']){
$title.=$manufacturers['manufacturers_name'];
$desc.='Products - '.$manufacturers['manufacturers_name'].' from '.STORE_OWNER;
// get products by this manufacturer
$listing_man_sql = tep_db_query("select pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' AND p.products_status = '1' AND pd.products_id = p.products_id ORDER BY rand()");
while($products = tep_db_fetch_array($listing_man_sql)) {
$key.=$products['products_name'].', ';
}
}
# index.php default
if (!isset($HTTP_GET_VARS['manufacturers_id']) && (!$current_category_id)) $default=true;
# Final stage for index.php w/o categories
# Title
tep_not_null($title)
? $metatitle.=$title.' - '
: NULL;
$metatitle.=STORE_NAME;
tep_not_null(HEAD_TITLE_TAG_INDEX) && $default==true
? $metatitle.=' - '.STORE_METDEX
: NULL;
tep_not_null(HEAD_TITLE_TAG_ALL)
? $metatitle.=' - '.STORE_DESCRIPT
: NULL;
$metatitle=meta_create_title($metatitle);
# Description
!tep_not_null($desc)
? $metadescription.=STORE_NAME.' - '
: NULL;
tep_not_null(HEAD_DESC_TAG_ALL) && $default==true
? $desc.=STORE_DESCRIPT.' - '
: NULL;
$metadescription.=$desc;
//tep_not_null($metadescription)&& $default==true
//? $metadescription.=' - '.STORE_DESCRIPT
//: NULL;
tep_not_null(HEAD_DESC_TAG_INDEX) && $default==true
? $metadescription.=' - '.STORE_DESCRIPT
: NULL;
$metadescription=meta_create_meta_description($metadescription);
# Keywords
tep_not_null(HEAD_KEY_TAG_INDEX) && $default==true
? $key.=STORE_KEYWORD.', '
: NULL;
tep_not_null(HEAD_KEY_TAG_ALL)
? $key.=' - '. STORE_KEYWORD
: NULL;
$metakeywords=strtolower(meta_create_meta_keywords($key));
#------------------------------------------------------------------------------------------------------#
# products_new.php
}else if (strpos($_SERVER['PHP_SELF'], 'products_new.php')){
$cacherun='true';
# Build a list of new product names to put in keywords
$products_new_query_raw = tep_db_query("select pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = '" . (int)$languages_id . "' ORDER by p.products_date_added DESC");
while ($products_new = tep_db_fetch_array($products_new_query_raw)) {
$key.=$products_new['products_name'] . ', ';
}
# Final stage for products_new.php
# Title
$metatitle=HEADING_TITLE.' - '.STORE_NAME;
tep_not_null(HEAD_TITLE_TAG_ALL)
? $metatitle.=' - '.STORE_DESCRIPT
: NULL;
$metatitle=meta_create_title($metatitle);
# Description
$metadescription=STORE_NAME.' - '.HEADING_TITLE;
tep_not_null(HEAD_DESC_TAG_ALL)
? $metadescription.=' - '. STORE_METDEX
: NULL;
$metadescription=meta_create_meta_description($metadescription);
# Keywords
tep_not_null(HEAD_KEY_TAG_ALL)
? $key.=' - '. STORE_KEYWORD
: NULL;
$metakeywords=strtolower(meta_create_meta_keywords($key));
#------------------------------------------------------------------------------------------------------#
# specials.php
}else if (strpos($_SERVER['PHP_SELF'], 'specials.php')){
$cacherun='true';
# Build a list of ALL specials product names to put in keywords
$specials_query = tep_db_query("select pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s WHERE s.status = '1' AND p.products_status = '1' AND s.products_id = p.products_id AND p.products_id = pd.products_id ORDER by s.specials_date_added DESC ");
while ($specials = tep_db_fetch_array($specials_query)) {
$key.=$specials['products_name'] . ', ';
}
# Final stage for specials.php
# Title
$metatitle=HEADING_TITLE.' - '.STORE_NAME;
tep_not_null(HEAD_TITLE_TAG_ALL)
? $metatitle.=' - '.STORE_DESCRIPT
: NULL;
$metatitle=meta_create_title($metatitle);
# Description
$metadescription=STORE_NAME;
tep_not_null(HEAD_DESC_TAG_ALL)
? $metadescription.=' - '. STORE_METDEX
: NULL;
$metadescription=meta_create_meta_description($metadescription);
# Keywords
tep_not_null(HEAD_KEY_TAG_ALL)
? $key.=' - '. STORE_KEYWORD
: NULL;
$metakeywords=strtolower(meta_create_meta_keywords($key));
#------------------------------------------------------------------------------------------------------#
# other pages
}else{
# Title
# pages to use HEADING_TITLE loop
foreach ($heading_pages as $index => $page){
if (strpos($_SERVER['PHP_SELF'], $page) ){
$metatitle=HEADING_TITLE.' - ';}}
#-------------------------------#
$metatitle.=STORE_NAME;
tep_not_null(HEAD_TITLE_TAG_ALL)
? $metatitle.=' - '.STORE_DESCRIPT
: NULL;
$metatitle=meta_create_title($metatitle);
# Description
$metadescription=STORE_NAME;
tep_not_null(HEAD_DESC_TAG_ALL)
? $metadescription.=' - '. STORE_METDEX
: NULL;
$metadescription=meta_create_meta_description($metadescription);
# Keywords
tep_not_null(HEAD_KEY_TAG_ALL)
? $key.=' - '. STORE_KEYWORD
: NULL;
$metakeywords=strtolower(meta_create_meta_keywords($key));
}
##################################### OUTPUT THE DATA ##########################################
echo ' <title>'.$metatitle.'</title>' . "\n";
echo ' <META NAME="Description" Content="' .$metadescription. '">' . "\n";
echo ' <META NAME="Keywords" Content="' . $metakeywords . '">' . "\n";
################################################################################
#####################
################################### BELOW IS CACHE INFO #########################################
$meta_cache_output = ob_get_contents();
ob_end_flush();
$cache_type == 1 && $cacherun=='true'
? $cache->save_cache($meta_cache_file, $meta_cache_output, 'RETURN', 1, 0, $expires)
: NULL;
if ($cache_type == 2 && $cacherun=='true'){
$meta_cache_output_code = gzdeflate(base64_encode($meta_cache_output),1);
$fp = fopen($meta_cache_file_full , 'w');
$fout = fwrite($fp , $meta_cache_output_code);
fclose($fp);
}}
?>
Please Re-arrange it for me
Thanks
New 
