Jump to content
Latest News: (loading..)

Search the Community

Showing results for tags 'php'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • News and Announcements
    • News and Announcements
    • Partner Announcements
    • Ambassadors
  • Commercial Support
    • Developer Feedback
  • osCommerce Online Merchant v2.x
    • General Support
    • Installation and Configuration
    • Upgrading from Earlier Versions (v2.x to v2.x)
    • Add-Ons
    • Tips and Tricks
    • Security
  • Development
    • osCommerce Online Merchant v2.4
    • osCommerce Online Merchant Community Bootstrap Edition
    • osCommerce Online Merchant v3.x
    • Development Proposals
  • General
    • Next Steps / Optimizations / Marketing
    • Live Shop Reviews
    • E-Commerce Laws
    • General Discussions
    • PHP / SQL / Web Design
  • oscBooks and oscTemplates's Announcements
  • PayPal's Announcements
  • Sage Pay's Announcements
  • Solomono - new level osCommerce templates's Announcements
  • German Community's OSCOM v2.x
  • German Community's Allgemein
  • German Community's OSCOM v3.x

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Real Name





Found 16 results

  1. Please help me #1812 - Tablespace is missing for table '(null)' mysql osCommerce `usu_cache` problem
  2. zetap

    Developer guide

    I am a programmer and I have to do a development on an existing oscommerce site, as it is the first time I work on this platform, I am looking for, if it exists, some kind of developer guide on oscommerce, on the official site, I have not been able to find any. If anyone has information about it, I thank you from now on Regards !
  3. Hello, I have installed osCommerce many times on a local Ubuntu 16.04 LTS server. After a default installation - admin folder not renamed - I cannot login to the admin portal. Also, the layout of the catalog is not right. I have attached a print screen of the catalog. I have checked the settings in both configure.php files. There are no references to unknows folders and the DB settings are correct. Any suggestions are appreciated. With kind regards, Willem-Jan
  4. Hi guys and girls, enthusiasts, I'd like to know how to insert data from a tep_input_field into the mysql database I'm currently using the AJAX Attribute Manager Addon and added another input field to it for EAN/GTIN input. How can I submit the entered ean to my database ? See the Code and attached screenshot below I've already added a column for ean and tried to add ean as input value. The Field is being shown, but inserting doesn't work. Thanks for any help in advance. Have a nice day. <?php echo tep_draw_input_field("ean_$optionValueId",$optionValueInfo['ean'],' style="margin:3px 0px 3px 0px;" id="ean_'.$optionValueId.'" size="7" onfocus="amF(this)" onblur="amB(this)" onChange="return amUpdate(\''.$optionId.'\',\''.$optionValueId.'\',\'ean\');"'); ?>
  5. Hello all, I'm using All Manufacturers for BS by @reflex-ocasion https://apps.oscommerce.com/clER0&all-manufacturers-bs. It's a great module to have for search engine crawling and user experience. A step further (for large stores with hundreds or thousands of brands) would be to arrange on the All Manufacturers page alphabetically like: A Animal Apple B Bakery Box It has been done by @amseek here: https://apps.oscommerce.com/00fKs&all-manufacturers but not adapted to BS version nor the Community Edition by @burt. I have the instructions and code for the All Manufacturers from 6 years ago OSC version 2.3.1: All Manufacturers Contribution v.1 for osCommerce 2.2 - Alpha-Split Layout Option (March 2012) -------------------------------- Created by Art Main OSC:amseek www.goldcoastdesign.org http://addons.oscommerce.com/profile/253123 Overview -------- This contribution adds an alphabetized list layout option to the all-manufacturers contribution. You can choose to control the number of columns to show (or let the program choose), the width of each column and the alignment (CSS text-align values) for each column. Please note: There are still a couple CSS quirks with regards to the borders and overall layout. I don't have the time to track these down, but just so you are aware. The Alpa-Split php and html are sound though. Thanks ------ Alex Kaiser (alex@pooliestudios.com) - original mod Installation ------------ 1. Install the All Manufacturers Contribution v.1 for osCommerce 2.2 (contrib page: http://addons.oscommerce.com/info/1685/v,22) if you don't already have it installed. 2. Apply the following changes below. 3. To enable, change the COLUMN_LISTING value to 'alpha-list'. ==================================== allmanufacturers.php: ------------------- find (app line 30): define('COLUMN_LISTING', 'false'); // added by azer change to false for columns listing ------------------- add after: //+CSS/Alpha-Split Layout Option $num_cols = 'auto'; //number of columns (int) or 'auto' (default is 'auto') $list_align = 'left'; //CSS 'text-align' values (default is 'left' for Alpha-Split layout, otherwise default is 'center') $col_width = 'auto'; //CSS 'width' values (if just a number, 'px' will be assumed). Default is '150px' //set to 'auto' for no set CSS width (Alpha-Split layout only) //-CSS/Alpha-Split Layout Option ------------------- find (app line 97 [line 186 if you have CSS Layout Option installed]): } else { // column ------------------- before add: //+Alpha-Split Layout Option } else if (COLUMN_LISTING=='alpha-split') { $manufacturer_name_query_start = "select manufacturers_id, manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_name"; $manufacturer_name_query_end = " order by manufacturers_name"; $manufacturers_query = tep_db_query('select count(*) as count from ' . TABLE_MANUFACTURERS . ' order by manufacturers_name'); $item = tep_db_fetch_array($manufacturers_query); $num_manufacturers = $item["count"]; if (!(tep_not_null($num_cols) && is_int($num_cols))) { $num_cols = 5; } if ($num_manufacturers > 0) { $num_headings = 0; foreach (range('A', 'Z') as $letter) { $manufacturer_name_query = $manufacturer_name_query_start . " like '" . $letter . "%'" . $manufacturer_name_query_end; $manufacturer_name = tep_db_query($manufacturer_name_query); if (tep_db_num_rows($manufacturer_name) > 0) { $num_headings++; //adjust for letter headings while ($manufacturer = tep_db_fetch_array($manufacturer_name)) { $manufacturers_result[$letter][] = $manufacturer; } } } } if (tep_not_null($manufacturers_result)) { $column_itor = 0; $itor = 0; $num_per = ceil(($num_manufacturers + $num_headings) / $num_cols); foreach ($manufacturers_result as $letter => $manulist) { $itor++; foreach ($manulist as $index => $manuitem) { if ($letter == $curr_letter) { $itor++; $curr_letter = null; } if ($itor >= $num_per) { $curr_letter = $letter; $column_itor++; $itor = 0; } $manufacturers_list[$column_itor][$letter][] = $manuitem; $itor++; } } //set up user chosen params $pattern = '/^(\d+)(in|cm|mm|px|em|ex|pt|pc|px)?$/'; if (preg_match($pattern,$col_width,$matches)) { if (empty($matches[2])) { $col_width_text = 'width:' . $matches[1] . 'px;'; } } else if ($col_width != 'auto') { $col_width_text = 'width:150px;'; } if ($list_align != "center" && $list_align != "right") { $list_align = "left"; } ?> <style type="text/css"> <!-- div.alpha_list_container ul { text-align:<?php echo $list_align; ?>; } div.alpha_list_container ul li { <?php echo $col_width_text; ?> overflow:hidden; } --> </style> <div id="manufacturers_list_container" class="alpha_list_container"> <?php foreach ($manufacturers_list as $column) { ?> <div class="multicolumn_list"> <?php foreach ($column as $letter => $manu_list) { ?> <ul class="alpha_list"> <li class="manufacturer_letter"><?php echo $letter; ?></li> <?php foreach ($manu_list as $manufacturers) { echo '<li>' . "\n" . '<a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $manufacturers['manufacturers_id'] . '=' . $manufacturers['manufacturers_name']) . '">'. $manufacturers['manufacturers_name'] . "<br />\n"; echo "</a>\n </li>\n"; } ?> </ul> <?php } ?> </div> <?php } ?> <div style="clear:left;"></div> </div> <?php } //-Alpha-Split Layout Option ==================================== stylesheet.css: ------------------- if you do not have the CSS Layout Option installed add: /* multicolumn_list */ div#manufacturers_list_container { float:left; } div#manufacturers_list_container ul { margin:0; padding:0; list-style:none; } div.multicolumn_list { float:left; } ------------------- find (within the CSS Layout Option css shown above): div.multicolumn_list { float:left; } ------------------- change to: div.multicolumn_list { border: 0px solid #d9d9da; float:left; } ------------------- add: div.alpha_list_container { border: 0px solid #d9d9da; border-right-width: 1px; border-bottom-width: 1px; } ul.alpha_list { font-size: .7em; border: 0px solid #d9d9da; border-left-width: 1px; } ul.alpha_list li a { display:block; border: 0px solid #ffffff; border-top-width: 1px; border-bottom-width: 1px; } ul.alpha_list li a:hover { border-color:#d9d9da; text-decoration:none; } li.manufacturer_letter { font-weight:bold; background:#D7E9F7; border: 0px solid #d9d9da; border-top-width: 1px; border-bottom-width: 1px; } I know page splitting is probably done much differently in BS. So I've included the code for reflex-ocasion's All Manufacturer's page: <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2017 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require('includes/languages/' . $language . '/allmanufacturers.php'); $breadcrumb->add(NAVBAR_TITLE, tep_href_link('allmanufacturers.php')); require('includes/template_top.php'); ?> <div class="page-header"> <h1><?php echo HEADING_TITLE; ?></h1> </div> <div class="contentContainer"> <div class="contentText"> <?php $manufacturers_query = tep_db_query("select manufacturers_name, manufacturers_id, manufacturers_image from manufacturers order by manufacturers_name" ); $manufacturers = tep_db_num_rows($manufacturers_query); while ($manufacturers = tep_db_fetch_array($manufacturers_query)) { ?> <div class="col-sm-6 col-md-4" itemprop="itemListElement" itemscope="" itemtype="http://schema.org/Product"> <div class="thumbnail equal-height"> <?php echo ' <p class="text-center"><a href="' . tep_href_link('index.php', 'manufacturers_id=' . $manufacturers['manufacturers_id'] . '=' . $manufacturers['manufacturers_name']) . '">'. $manufacturers['manufacturers_name']; echo ' <br /> '; echo tep_image('images/' . $manufacturers['manufacturers_image'], $manufacturers['manufacturers_name']) . '</a></p>'; ?> </div> </div> <?php } ?> </div> <p>&nbsp;</p> <div class="buttonSet"> <div class="text-right"><?php echo tep_draw_button(IMAGE_BUTTON_CONTINUE, 'fa fa-angle-right', tep_href_link('index.php')); ?></div> </div> </div> <?php require('includes/template_bottom.php'); require('includes/application_bottom.php'); ?> I'm not a coder so I have no clue where to begin. Any input/advice @MrPhil @kymation @frankl @wHiTeHaT will be appreciated. Do you think this would be ideal for core code?
  6. I understand that older versions of PHP will soon be deprecated. How hard will it be to upgrade to a newer PHP? I'm currently running an OSC v2.3.4 (bootstrap) with PHP Version 5.3.29. Heavily modified cart. In early 2015 we upgraded to where we are now from OSC v2.2 (and and older version of PHP) and had tonnes of PHP issues (mysqli for example). Not really looking to do that again. How broken will my cart get if I upgrade the PHP on my server? Is there a "safe" version of PHP I could upgrade too (even if not the latest)? To save time/resources, I intend to leave the OSC cart as 2.3.4 (BS) unless everyone tells me it is imperative I upgrade to something else. Keep in mind I have a lot of mods, and some of them I built (hacked together) myself. My skill level: Not a programmer, but I'm pretty good for a non-programmer. Using OSC since 2005 and have implemented a lot of mods myself. Thanks
  7. I am new to the board, so please let me know if I posted in the wrong area. My friend has the following- running the following- PHP 5.2,oscom version 2.2 ms2 He had been told that if he does not upgrade his code or PHP by this week they are going to shutdown his site. Is there a simple process to upgrade? Do we just upgrade PHP to 5.6 or 7? Do we just update our oscom version? Is there a lot of issues with upgrading? Should I just toss the site and move all the products over to something new?
  8. Raj Bhardwaj

    PHP errors

    Hi all I am new with oscommerce and using oscommerce 2.3.4 the everthing is fixed now . Just two little problem occuring 1. please check screenshot https://prnt.sc/h76myo when i am trying to edit customers information from admin end its showing this error. 2. https://prnt.sc/h76n9q I have installed klarna payment module its showing into back end but into payment options front end its not showing please help!
  9. How can I use the function tep_get_prid in some pages specific admin/orders and account_history_info.php after the order is complete? I've been trying but a need a little help please.
  10. Hi, I got a oscommerce 2.3.4 website and I'm installing this addon: Imprint Text Options -> https://apps.oscommerce.com/wLYWg&imprint-text-options This is a old addon I found but is exactly what I need. It works fine but there's a problem if I choice two products it gets the same attributes for both. Also ... session_id = '" . $osCsid . "'"); As not working had to change it to: tep_session_id() so it could insert the session_id into database. Then I tried instead of normally product_id using the products_id with the variables like this -> 270{10}86{1}15{8}64{7}70{5}49{2}26{6}57{4}42{9}85 so even if the product if the same at least if any attributes changes it would show a different one. But this to work correctly I need to change in the database the column products_id which is int(11) and primary key. In the database others products_id are tinytext. But always I try to change I get something about blob so I can't change it to allow those special characters. Here is the sql of the installation: DROP TABLE IF EXISTS customers_basket_text_attributes; CREATE TABLE customers_basket_text_attributes ( session_id varchar(255) NOT NULL default '', products_id int(11) NOT NULL default '0', products_text_attributes_id int(11) NOT NULL default '0', products_text_attributes_text text NOT NULL, PRIMARY KEY (session_id,products_id,products_text_attributes_id) ) ENGINE=MyISAM; DROP TABLE IF EXISTS orders_text_attributes; CREATE TABLE orders_text_attributes ( orders_id int(11) NOT NULL default '0', products_id int(11) NOT NULL default '0', products_text_attributes_id int(11) NOT NULL default '0', products_text_attributes_text text NOT NULL, PRIMARY KEY (orders_id,products_id,products_text_attributes_id) ) ENGINE=MyISAM; DROP TABLE IF EXISTS products_text_attributes; CREATE TABLE products_text_attributes ( products_text_attributes_id int(11) NOT NULL auto_increment, products_text_attributes_name varchar(255) NOT NULL default '', PRIMARY KEY (products_text_attributes_id) ) ENGINE=MyISAM; INSERT INTO products_text_attributes (products_text_attributes_id, products_text_attributes_name) VALUES (1, 'Mes'); INSERT INTO products_text_attributes (products_text_attributes_id, products_text_attributes_name) VALUES (2, 'Ano'); INSERT INTO products_text_attributes (products_text_attributes_id, products_text_attributes_name) VALUES (3, 'Geracao'); DROP TABLE IF EXISTS products_text_attributes_enabled; CREATE TABLE products_text_attributes_enabled ( products_id int(11) NOT NULL default '0', products_text_attributes_id int(11) NOT NULL default '0', PRIMARY KEY (products_id,products_text_attributes_id) ) ENGINE=MyISAM; Any suggestion or help would be really great, would appreciate it a lot. Best regards.
  11. Hi all, I am working on modifying a discount coupon add-on to allow two coupons for one order. The class discount_coupon looks like this: <?php /* * discount_coupon.php * August 4, 2006 * author: Kristen G. Thorson * ot_discount_coupon_codes version 3.0 * * * Released under the GNU General Public License * */ class discount_coupon { var $messages, $coupon, $applied_discount, $cart_info; function discount_coupon( $code, $delivery ) { $this->messages = array(); $this->coupon = array(); $this->applied_discount = array(); $this->cart_info = array( 'valid_products' => array( 'count' => 0, 'line_items' => 0, 'total' => 0 ), 'total_products' => array( 'count' => 0, 'line_items' => 0, 'total' => 0 ), 'exclusions' => array() ); $this->get_coupon( $code, $delivery ); I have already made some modifications to this file to bypass the exclusions if necessary. Does anyone have any ideas on a method to allow multiple codes? Thanks
  12. Good day, I have installed and configured Simple Photo Gallery by Raju Rajpurohit - Codoffer Infotech I believe that I have done everything according to the instructions but being a bit 'very new' to php I don'y know where to place the line: <a href="<?php echo tep_href_link(FILENAME_PHOTO_GALLERY);?>">Photo Gallery</a> that I assume will execute the gallery add on. Would appreciate some help rgs
  13. carpesitus

    Need PHP help, please

    I'm trying to add an additional condition to a per item shipping module. It is processing the zone properly but I can't get it to calculate the shipping correctly. It returns a $0.00 shipping total. Here is the code: if ($dest_zone == 0) { $groups_cost = constant('MODULE_SHIPPING_PIPC_COST_DEFAULT'); $handle_cost = constant('MODULE_SHIPPING_PIPC_HANDLING_DEFAULT'); } elseif ($dest_zone == 1 && $total_count > 2) { $shipping_cost = $groups_cost + $groups_cost; } else { $groups_cost = constant('MODULE_SHIPPING_PIPC_COST_' . $dest_zone); $handle_cost = constant('MODULE_SHIPPING_PIPC_HANDLING_' . $dest_zone); } $shipping_method = MODULE_SHIPPING_PIPC_TEXT_WAY . ' ' . $dest_country . ' : ' . $shipping_weight . ' ' . MODULE_SHIPPING_PIPC_TEXT_UNITS; $shipping_cost = $groups_cost * $total_count + $handle_cost; $this->quotes = array('id' => $this->code, 'module' => MODULE_SHIPPING_PIPC_TEXT_TITLE, 'methods' => array(array('id' => $this->code, 'title' => $shipping_method, 'cost' => $shipping_cost)));
  14. FantasyArt

    Creating Return in PHP

    I am trying to create a return at the end of a line in the Flat.php I start off with this below and want to put a return after the Local to SHEPPARTON, VICTORIA REGION ONLY!! <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ define('MODULE_SHIPPING_FLAT_TEXT_TITLE', 'Local to SHEPPARTON, VICTORIA REGION ONLY!!'); define('MODULE_SHIPPING_FLAT_TEXT_DESCRIPTION', 'Local to SHEPPARTON, VICTORIA REGION ONLY!!'); define('MODULE_SHIPPING_FLAT_TEXT_WAY', 'LOCAL PICKUP OPTION'); ?> Below is the code I enter but keep on getting it wrong. New to editing PHP files so need some help as to know what I am doing wrong. <?php /* $Id$ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ define('MODULE_SHIPPING_FLAT_TEXT_TITLE', 'Local to SHEPPARTON, VICTORIA REGION ONLY!!'); define('MODULE_SHIPPING_FLAT_TEXT_DESCRIPTION', 'Local to SHEPPARTON, VICTORIA REGION ONLY!!'\rWe reserve the right to cancel any orders outside the PICKUP AREA stated above that don't include shipping.); define('MODULE_SHIPPING_FLAT_TEXT_WAY', 'LOCAL PICKUP OPTION'); ?> Keep on getting an error for this so I know I am doing something wrong but don't know what. PLEASE HELP I am also trying to get help on another post I have in the forum as to which module is the best and easiest to install for Guest Checkout. Would like some help on both these matters please.
  15. I am looking to create a google feed for my instance of osCommerce. However, I have the ultimate SEO URL's 5 installed on my 2.3.1 instance. How do I get the product URL's for each product at they are not stored in the database in the products table? Any help would be appreciated.
  16. I know there have been a few posts on this topic before, but without prevail. It seems that there has not been an answer to this question. Header Tags SEO and Enable/Disable Categories have a conflict in includes/application_top.php. I am an intermediate at PHP, yet I can't seem to figure this one out. I have tried multipe variations, the closest results, stretched the products, distorting the index page, and also showing top category images. I know that there has to be a way to merge the two conflicting queries, either with one MySQL query or a PHP array that merges the two querys. To make it a little easier to read, basically I need to merge the red with the green. Thank you, Brandon ************************************************************************************************************************ // add category names or the manufacturer name to the breadcrumb trail if (isset($cPath_array)) { for ($i=0, $n=sizeof($cPath_array); $i<$n; $i++) { // BOF Enable & Disable Categories $categories_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " cd left join " . TABLE_CATEGORIES . " c on cd.categories_id = c.categories_id where c.categories_status = '1' and cd.categories_id = '" . (int)$cPath_array[$i] . "' and cd.language_id = '" . (int)$languages_id . "'"); // EOF Enable & Disable Categories if (tep_db_num_rows($categories_query) > 0) { $categories = tep_db_fetch_array($categories_query); $breadcrumb->add($categories['categories_name'], tep_href_link(FILENAME_DEFAULT, 'cPath=' . implode('_', array_slice($cPath_array, 0, ($i+1))))); } else { break; } } *************** /*** Begin Header Tags SEO ***/ // add category names or the manufacturer name to the breadcrumb trail if (isset($cPath_array)) { for ($i=0, $n=sizeof($cPath_array); $i<$n; $i++) { $categories_query = tep_db_query("select categories_htc_title_tag from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$cPath_array[$i] . "' and language_id = '" . (int)$languages_id . "' LIMIT 1"); if (tep_db_num_rows($categories_query) > 0) { $categories = tep_db_fetch_array($categories_query); $breadcrumb->add($categories['categories_htc_title_tag'], tep_href_link(FILENAME_DEFAULT, 'cPath=' . implode('_', array_slice($cPath_array, 0, ($i+1))))); } else { break; } } ************************************************************************************************************************** } elseif (isset($HTTP_GET_VARS['manufacturers_id'])) { $manufacturers_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); if (tep_db_num_rows($manufacturers_query)) { $manufacturers = tep_db_fetch_array($manufacturers_query); $breadcrumb->add($manufacturers['manufacturers_name'], tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'])); } } *************** } elseif (isset($_GET['manufacturers_id'])) { $manufacturers_query = tep_db_query("select manufacturers_htc_title_tag from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' AND languages_id = '" . (int)$languages_id . "' LIMIT 1"); if (tep_db_num_rows($manufacturers_query)) { $manufacturers = tep_db_fetch_array($manufacturers_query); $breadcrumb->add($manufacturers['manufacturers_htc_title_tag'], tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $_GET['manufacturers_id'])); } } *************************************************************************************************************************** // add the products model to the breadcrumb trail if (isset($HTTP_GET_VARS['products_id'])) { // BOF Enable & Disable Categories $model_query = tep_db_query("select p.products_model from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where c.categories_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and p.products_id = pd.products_id"); // EOF Enable & Disable Categories if (tep_db_num_rows($model_query)) { $model = tep_db_fetch_array($model_query); $breadcrumb->add($model['products_model'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id'])); } } **************** // add the products name to the breadcrumb trail if (isset($_GET['products_id'])) { $products_query = tep_db_query("select pd.products_head_title_tag from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_id = '" . (int)$_GET['products_id'] . "' and pd.language_id ='" . (int)$languages_id . "' LIMIT 1"); if (tep_db_num_rows($products_query)) { $products = tep_db_fetch_array($products_query); $breadcrumb->add($products['products_head_title_tag'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $_GET['products_id'])); } } /*** End Header Tags SEO ***/