X-Cart forums

[Gijs]

Hi,

You can easily modify XC SEO to be put out correct multi-lingual html-files for categories, manufacturers and products
by adding a $variable to contain the shop's language and using the langauage versions of the sql-tables.



Edit outputfilter.seo.php as follows:

1) Create a language variable:

Put after:

if ( !defined('XCART_START') ) { header('Location: ../'); die('Access denied'); }

the following line:

$language_shop = $GLOBALS['store_language'];

2) Edit the section: # Generate filename for a category page

Change:

function _category_filename($options) {
		global $sql_tbl;

		if (!$options['result_title'])
			$options['result_title'] = func_query_first_cell('SELECT category
											 FROM ' . $sql_tbl['categories'] . '
											 WHERE categoryid="' . $options['cat'] . '"');

To:

function _category_filename($options) {
		global $sql_tbl, $language_shop;
		if (!$options['result_title'])
			$options['result_title'] = func_query_first_cell('SELECT category
											 FROM ' . $sql_tbl['categories_lng'] . '
											 WHERE categoryid="' . $options['cat'] . '" AND code="' . $language_shop .'"');

3) Edit the section: # Generate filename for a manufacturers page

Change:

		
function _manufacturer_filename($options) {
		global $sql_tbl;

		if (!$options['result_title'])
			$options['result_title'] = func_query_first_cell('SELECT manufacturer
											 FROM ' . $sql_tbl['manufacturers'] . '
											 WHERE manufacturerid="' . $options['manufacturerid'] . '"');

To:

function _manufacturer_filename($options) {
		global $sql_tbl, $language_shop;

		if (!$options['result_title'])
			$options['result_title'] = func_query_first_cell('SELECT manufacturer
											 FROM ' . $sql_tbl['manufacturers_lng'] . '
											 WHERE manufacturerid="' . $options['manufacturerid'] . '" AND code="' . $language_shop .'"');
		

4) Edit the section: # Generate filename for a product page

Change:

function _product_filename($options) {
		global $sql_tbl;

		if (!$options['result_title'])
			$options['result_title'] = func_query_first_cell('SELECT product
											  FROM ' . $sql_tbl['products'] . '
											  WHERE productid = "' . $options['productid'] . '"');

To:

function _product_filename($options) {
		global $sql_tbl, $language_shop;

		if (!$options['result_title'])
			$options['result_title'] = func_query_first_cell('SELECT product
											  FROM ' . $sql_tbl['products_lng'] . '
											  WHERE productid = "' . $options['productid'] . '" AND code="' . $language_shop .'"');

Note:
Works fine in x-cart 4.1.11 with XC SEO Basic.
Possibly, it should work with the other version of XC SEO (Pro, ...)

My 2 cents,

Gijs

[balinor]

Moving to Third Party Add-Ons. FYI, the mod author is no longer present, or supporting their product, so anyone reading this should be advised to NOT purchase/install it if they are thinking about doing so.