Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product Listing Product Name Layout


gaspower

Recommended Posts

Hello,

 

Currently I have the following code under PRODUCT_LIST_NAME in products_listings.php,

 

case 'PRODUCT_LIST_NAME':
		$lc_align = '';
		if(isset($HTTP_GET_VARS['language']))
		{
		  $env_language = $HTTP_GET_VARS['language'];
		  $language_query = tep_db_query("select languages_id from ". TABLE_LANGUAGES . " where code ='" . $env_language . "'");
		  $language_arr = tep_db_fetch_array($language_query);
		  $language_id = $language_arr['languages_id'];
		}
		else
		{
		  $language_id = (int)$languages_id;
		}
		  $products_to_catagories_query = tep_db_query("SELECT categories_name FROM ". TABLE_PRODUCTS_TO_CATEGORIES ." p2c, ". TABLE_CATEGORIES_DESCRIPTION ." cd WHERE p2c.products_id = " . (int)$listing[$x]['products_id'] . " and p2c.categories_id = cd.categories_id and language_id ='".(int)$language_id."'");
		$category_list = " ";
		do
		  {
			if($category_list != " ")
				$category_list .=" , ";
			else
			   $products_to_categories_array = tep_db_fetch_array($products_to_catagories_query);
			$category_list .= $products_to_categories_array['categories_name'];
		   }
		while($products_to_categories_array = tep_db_fetch_array($products_to_catagories_query));
		$category_list .="<br>";
		if (isset($HTTP_GET_VARS['manufacturers_id'])) {
		  $lc_text = $category_list . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a>';
		} else {
		  $lc_text = $category_list . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a> ';
		}
		break;

 

And the output is,

 

category name, category name, ect

Product name and description.

 

I would like it reversed to read,

 

Product name and description.

category name, category name, ect

 

But I keep breaking the site, any help would be greatly appreciated.

 

Thanks JR

Link to comment
Share on other sites

Hello,

 

It is not the default code, can the configuration file will not set this adjustment. I attached a image to show a better look. I need to be able to swap the Accessories, Wire line with the 12V Car Battery line.

 

Thanks JR

 

cable.jpg

Link to comment
Share on other sites

Hi - I don't have customer groups installed so cant test the result, but you can Backup and Try this.

 

Find

 $products_to_catagories_query = tep_db_query("SELECT categories_name FROM ". TABLE_PRODUCTS_TO_CATEGORIES ." p2c, ". TABLE_CATEGORIES_DESCRIPTION ." cd WHERE p2c.products_id = " . (int)$listing[$x]['products_id'] . " and p2c.categories_id = cd.categories_id and language_id ='".(int)$language_id."'");
		$category_list = " ";
		do
		  {
			if($category_list != " ")
				$category_list .=" , ";
			else
			   $products_to_categories_array = tep_db_fetch_array($products_to_catagories_query);
			$category_list .= $products_to_categories_array['categories_name'];
		   }
		while($products_to_categories_array = tep_db_fetch_array($products_to_catagories_query));
		$category_list .="<br>";
		if (isset($HTTP_GET_VARS['manufacturers_id'])) {
		  $lc_text = $category_list . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a>';
		} else {
		  $lc_text = $category_list . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a> ';
		}
		break;

 

Replace with

 

 

 $products_to_catagories_query = tep_db_query("SELECT categories_name FROM ". TABLE_PRODUCTS_TO_CATEGORIES ." p2c, ". TABLE_CATEGORIES_DESCRIPTION ." cd WHERE p2c.products_id = " . (int)$listing[$x]['products_id'] . " and p2c.categories_id = cd.categories_id and language_id ='".(int)$language_id."'");
		$category_list = " ";
		do
		  {
			if($category_list != " ")
				$category_list .=" , ";
			else
			   $products_to_categories_array = tep_db_fetch_array($products_to_catagories_query);
			$category_list .= $products_to_categories_array['categories_name'].'';
		   }
		while($products_to_categories_array = tep_db_fetch_array($products_to_catagories_query));
		$category_list .="";
		if (isset($HTTP_GET_VARS['manufacturers_id'])) {
		  $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a>'.'<br>
		  '.$category_list;
		} else {
		  $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing[$x]['products_id']) . '">' . $listing[$x]['products_name'] . '</a>'.'<br>
		  '.$category_list;
		}
		break;

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...