Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Naveeddil

Members
  • Content count

    10
  • Joined

  • Last visited

Posts posted by Naveeddil


  1. Hello All,

    I have download and used v2.6_1 and v2.4 2nd edition

     

    Both are giving problems

    for some problems i have search this Thread and Got them fix but on return had problems in Cattegories and attributes Menus

     

    BOTTOM LINE

     

    can i have the full latest version in shape of one pack please ?

     

    Can you upload all the updated files and Bugs in one PACKAGE


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

×