Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

Product Listing Short Description Contrib Help

ChrisUCF99

By ChrisUCF99
in General Add-Ons Support

 Share

Recommended Posts

ChrisUCF99

ChrisUCF99

Posted
Posted

I've added the the Product Listing Short Description Contrib to my development osCommerce site. I followed the instructions EXACTLY.

 

This is the one i've added.

 

http://www.oscommerce.com/community/contri...ng+descriptions

 

Anyway, the code adds the column but none of the description shows up on the site, even though i see the descriptions in the proper table in the database...

 

Can someone please point me in the right direction on where I should be looking to resolve this. If you can tell me the file i should be looking in, and the correct code to display info from a table under the corresponding column i would greatly appreciate it. I've been trying to figure this out for hours now!

 

Here is my dev site and the page that should be displaying the short descriptions for the products:

 

http://geeksupport.net/esg/index.php?cPath=22_24

 

Thanks!,

 

Chris

Link to comment
Share on other sites
ChrisUCF99

ChrisUCF99

Posted
  • Author
Posted (edited)

Here is my index.php code if this will help any... products_info is where the data is stored.

 

<?php
/*
?$Id: index.php,v 1.1 2003/06/11 17:37:59 hpdl Exp $ 
?adapted for Separate Pricing Per Customer v4.1.1, Hide products from groups mod 2005/03/28
?osCommerce, Open Source E-Commerce Solutions
?http://www.oscommerce.com

?Copyright (c) 2003 osCommerce

?Released under the GNU General Public License
*/
?require('includes/application_top.php');
?global $customer_group_id;
?if(!isset($customer_group_id)) { $customer_group_id = '0'; }
// the following cPath references come from application_top.php
?$category_depth = 'top';
?if (isset($cPath) && tep_not_null($cPath)) {
? ?$categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
? ?$cateqories_products = tep_db_fetch_array($categories_products_query);
? ?if ($cateqories_products['total'] > 0) {
? ? ?$category_depth = 'products'; // display products
? ?} else {
? ? ?$category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'");
? ? ?$category_parent = tep_db_fetch_array($category_parent_query);
? ? ?if ($category_parent['total'] > 0) {
? ? ? ?$category_depth = 'nested'; // navigate through the categories
? ? ?} else {
? ? ? ?$category_depth = 'products'; // category has no products, but display the 'no products' message
? ? ?}
? ?}
?}

?require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_DEFAULT);
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
?<tr>
? ?<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
? ?</table></td>
<!-- body_text //-->
<?php
?if ($category_depth == 'nested') {
? ?$category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");
? ?$category = tep_db_fetch_array($category_query);
?>
? ?<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
? ? ?<tr>
? ? ? ?<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
? ? ? ? ?<tr>
? ? ? ? ? ?<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
? ? ? ? ? ?<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . $category['categories_image'], $category['categories_name'], HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
? ? ? ? ?</tr>
? ? ? ?</table></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
? ? ? ? ?<tr>
? ? ? ? ? ?<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
? ? ? ? ? ? ?<tr>
<?php
? ?if (isset($cPath) && strpos('_', $cPath)) {
// check to see if there are deeper categories within the current category
? ? ?$category_links = array_reverse($cPath_array);
? ? ?for($i=0, $n=sizeof($category_links); $i<$n; $i++) {
? ? ? ?$categories_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "'");
? ? ? ?$categories = tep_db_fetch_array($categories_query);
? ? ? ?if ($categories['total'] < 1) {
? ? ? ? ?// do nothing, go through the loop
? ? ? ?} else {
? ? ? ? ?$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$category_links[$i] . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
? ? ? ? ?break; // we've found the deepest category the customer is in
? ? ? ?}
? ? ?}
? ?} else {
? ? ?$categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.categories_image, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . (int)$current_category_id . "' and c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' order by sort_order, cd.categories_name");
? ?}

? ?$number_of_categories = tep_db_num_rows($categories_query);

? ?$rows = 0;
? ?while ($categories = tep_db_fetch_array($categories_query)) {
? ? ?$rows++;
? ? ?$cPath_new = tep_get_path($categories['categories_id']);
? ? ?$width = (int)(100 / MAX_DISPLAY_CATEGORIES_PER_ROW) . '%';
? ? ?echo ' ? ? ? ? ? ? ? ?<td align="center" class="smallText" width="' . $width . '" valign="top"><a href="' . tep_href_link(FILENAME_DEFAULT, $cPath_new) . '">' . tep_image(DIR_WS_IMAGES . $categories['categories_image'], $categories['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br>' . $categories['categories_name'] . '</a></td>' . "\n";
? ? ?if ((($rows / MAX_DISPLAY_CATEGORIES_PER_ROW) == floor($rows / MAX_DISPLAY_CATEGORIES_PER_ROW)) && ($rows != $number_of_categories)) {
? ? ? ?echo ' ? ? ? ? ? ? ?</tr>' . "\n";
? ? ? ?echo ' ? ? ? ? ? ? ?<tr>' . "\n";
? ? ?}
? ?}

// needed for the new products module shown below
? ?$new_products_category_id = $current_category_id;
?>
? ? ? ? ? ? ?</tr>
? ? ? ? ? ?</table></td>
? ? ? ? ?</tr>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ?</tr>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>
? ? ? ? ?</tr>
? ? ? ?</table></td>
? ? ?</tr>
? ?</table></td>
<?php
?} elseif ($category_depth == 'products' || isset($HTTP_GET_VARS['manufacturers_id'])) {
// create column list
? ?$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
? ? ? ? ? ? ? ? ? ? ? ? 'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
? ? ? ? ? ? ? ? ? ? ? ? 'PRODUCT_LIST_INFO' => PRODUCT_LIST_INFO,
? ? ? ? ? ? ? ? ? ? ? ? 'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,
? ? ? ? ? ? ? ? ? ? ? ? 'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
? ? ? ? ? ? ? ? ? ? ? ? 'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,
? ? ? ? ? ? ? ? ? ? ? ? 'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,
? ? ? ? ? ? ? ? ? ? ? ? 'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,
? ? ? ? ? ? ? ? ? ? ? ? 'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

? ?asort($define_list);

? ?$column_list = array();
? ?reset($define_list);
? ?while (list($key, $value) = each($define_list)) {
? ? ?if ($value > 0) $column_list[] = $key;
? ?}

// BOF Separate Pricing Per Customer
? if(!tep_session_is_registered('sppc_customer_group_id')) { 
? ? $customer_group_id = '0';
? ? } else {
? ? ?$customer_group_id = $sppc_customer_group_id;
? }
? // this will build the table with specials prices for the retail group or update it if needed
? // this function should have been added to includes/functions/database.php
? if ($customer_group_id == '0') {
? tep_db_check_age_specials_retail_table(); 
? }
? $status_product_prices_table = false;
? $status_need_to_get_prices = false;

? // find out if sorting by price has been requested
? if ( (isset($HTTP_GET_VARS['sort'])) && (ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) && (substr($HTTP_GET_VARS['sort'], 0, 1) <= sizeof($column_list)) && $customer_group_id != '0' ){
? ?$_sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);
? ?if ($column_list[$_sort_col-1] == 'PRODUCT_LIST_PRICE') {
? ? ?$status_need_to_get_prices = true;
? ? ?}
? }
? 
? if ($status_need_to_get_prices == true && $customer_group_id != '0') { 
? $product_prices_table = TABLE_PRODUCTS_GROUP_PRICES.$customer_group_id;
? // the table with product prices for a particular customer group is re-built only a number of times per hour
? // (setting in /includes/database_tables.php called MAXIMUM_DELAY_UPDATE_PG_PRICES_TABLE, in minutes)
? // to trigger the update the next function is called (new function that should have been
? // added to includes/functions/database.php)
? tep_db_check_age_products_group_prices_cg_table($customer_group_id);
? $status_product_prices_table = true; ? 

? } // end if ($status_need_to_get_prices == true && $customer_group_id != '0')
// EOF Separate Pricing Per Customer

? ?$select_column_list = '';

? ?for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
? ? ?switch ($column_list[$i]) {
? ? ? ?case 'PRODUCT_LIST_MODEL':
? ? ? ? ?$select_column_list .= 'p.products_model, ';
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_NAME':
? ? ? ? ?$select_column_list .= 'pd.products_name, ';
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_INFO':
? ? $select_column_list .= 'pd.products_info, ';
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_MANUFACTURER':
? ? ? ? ?$select_column_list .= 'm.manufacturers_name, ';
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_QUANTITY':
? ? ? ? ?$select_column_list .= 'p.products_quantity, ';
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_IMAGE':
? ? ? ? ?$select_column_list .= 'p.products_image, ';
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_WEIGHT':
? ? ? ? ?$select_column_list .= 'p.products_weight, ';
? ? ? ? ?break;
? ? ?}
? ?}

// show the products of a specified manufacturer
? ?if (isset($HTTP_GET_VARS['manufacturers_id'])) {
? ? ?if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only a specific category
// BOF Separate Pricing Per Customer
if ($status_product_prices_table == true) {
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'"; ?
} else { // either retail or no need to get correct special prices
$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "'";
} // end else { // either retail...
// EOF Separate Pricing Per Customer
? ? ?} else {
// We show them all
// BOF Separate Pricing Per Customer
? ? ? ?if ($status_product_prices_table == true) {
? ? ? ?$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";	
} else { // either retail or no need to get correct special prices
? ? ? ?$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m ?left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
} // end else { // either retail...
// EOF Separate Pricing Per Customer
? ? ?}
? ?} else {
// show the products in a given categorie
? ? ?if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only specific catgeory; ?
// BOF Separate Pricing Per Customer
? ? ? ?if ($status_product_prices_table == true) {
? ? ? ?$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS . " p left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";	
? ? ? ?} else { // either retail or no need to get correct special prices
? ? ? ?$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS_RETAIL_PRICES . " s using(products_id) where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
? ? ? ?} // end else { // either retail...
// EOF Separate Pricing Per Customer
? ? ?} else {
// We show them all
// BOF Separate Pricing Per Customer
? ? ? ?if ($status_product_prices_table == true) {
? ? ? ?$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, tmp_pp.products_price, p.products_tax_class_id, IF(tmp_pp.status, tmp_pp.specials_new_products_price, NULL) as specials_new_products_price, IF(tmp_pp.status, tmp_pp.specials_new_products_price, tmp_pp.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . $product_prices_table . " as tmp_pp using(products_id), " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
? ? ? ?} else { // either retail or no need to get correct special prices
? ? ? ?$listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS_RETAIL_PRICES . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$current_category_id . "'";
? ? ?} // end else { // either retail...
// EOF Separate Pricing per Customer
? ? ?}
? ?}
// BOF Hide products from groups
$listing_sql .= " and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 ";
// EOF hide products from group

? ?if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('[1-8][ad]', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {
? ? ?for ($i=0, $n=sizeof($column_list); $i<$n; $i++) {
? ? ? ?if ($column_list[$i] == 'PRODUCT_LIST_NAME') {
? ? ? ? ?$HTTP_GET_VARS['sort'] = $i+1 . 'a';
? ? ? ? ?$listing_sql .= " order by pd.products_name";
? ? ? ? ?break;
? ? ? ?}
? ? ?}
? ?} else {
? ? ?$sort_col = substr($HTTP_GET_VARS['sort'], 0 , 1);
? ? ?$sort_order = substr($HTTP_GET_VARS['sort'], 1);
? ? ?$listing_sql .= ' order by ';
? ? ?switch ($column_list[$sort_col-1]) {
? ? ? ?case 'PRODUCT_LIST_MODEL':
? ? ? ? ?$listing_sql .= "p.products_model " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_NAME':
? ? ? ? ?$listing_sql .= "pd.products_name " . ($sort_order == 'd' ? 'desc' : '');
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_INFO':
? ? ? ? ?$listing_sql .= "pd.products_info " . ($sort_order == 'd' ? 'desc' : '');
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_MANUFACTURER':
? ? ? ? ?$listing_sql .= "m.manufacturers_name " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_QUANTITY':
? ? ? ? ?$listing_sql .= "p.products_quantity " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_IMAGE':
? ? ? ? ?$listing_sql .= "pd.products_name";
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_WEIGHT':
? ? ? ? ?$listing_sql .= "p.products_weight " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
? ? ? ? ?break;
? ? ? ?case 'PRODUCT_LIST_PRICE':
? ? ? ? ?$listing_sql .= "final_price " . ($sort_order == 'd' ? 'desc' : '') . ", pd.products_name";
? ? ? ? ?break;
? ? ?}
? ?}
?>
? ?<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
? ? ?<tr>
? ? ? ?<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
? ? ? ? ?<tr>
? ? ? ? ? ?<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
<?php
// optional Product List Filter
? ?if (PRODUCT_LIST_FILTER > 0) {
? ? ?if (isset($HTTP_GET_VARS['manufacturers_id'])) {
? ? ? ?$filterlist_sql = "select distinct c.categories_id as id, cd.categories_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.categories_id = cd.categories_id and cd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";
? ? ?} else {
? ? ? ?$filterlist_sql= "select distinct m.manufacturers_id as id, m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by m.manufacturers_name";
? ? ?}
? ? ?$filterlist_query = tep_db_query($filterlist_sql);
? ? ?if (tep_db_num_rows($filterlist_query) > 1) {
? ? ? ?echo ' ? ? ? ? ? ?<td align="center" class="main">' . tep_draw_form('filter', FILENAME_DEFAULT, 'get') . TEXT_SHOW . ' ';
? ? ? ?if (isset($HTTP_GET_VARS['manufacturers_id'])) {
? ? ? ? ?echo tep_draw_hidden_field('manufacturers_id', $HTTP_GET_VARS['manufacturers_id']);
? ? ? ? ?$options = array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES));
? ? ? ?} else {
? ? ? ? ?echo tep_draw_hidden_field('cPath', $cPath);
? ? ? ? ?$options = array(array('id' => '', 'text' => TEXT_ALL_MANUFACTURERS));
? ? ? ?}
? ? ? ?echo tep_draw_hidden_field('sort', $HTTP_GET_VARS['sort']);
? ? ? ?while ($filterlist = tep_db_fetch_array($filterlist_query)) {
? ? ? ? ?$options[] = array('id' => $filterlist['id'], 'text' => $filterlist['name']);
? ? ? ?}
? ? ? ?echo tep_draw_pull_down_menu('filter_id', $options, (isset($HTTP_GET_VARS['filter_id']) ? $HTTP_GET_VARS['filter_id'] : ''), 'onchange="this.form.submit()"');
? ? ? ?echo '</form></td>' . "\n";
? ? ?}
? ?}

// Get the right image for the top-right
? ?$image = DIR_WS_IMAGES . 'table_background_list.gif';
? ?if (isset($HTTP_GET_VARS['manufacturers_id'])) {
? ? ?$image = tep_db_query("select manufacturers_image from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'");
? ? ?$image = tep_db_fetch_array($image);
? ? ?$image = $image['manufacturers_image'];
? ?} elseif ($current_category_id) {
? ? ?$image = tep_db_query("select categories_image from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'");
? ? ?$image = tep_db_fetch_array($image);
? ? ?$image = $image['categories_image'];
? ?}
?>
? ? ? ? ? ?<td align="right"><?php echo tep_image(DIR_WS_IMAGES . $image, HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
? ? ? ? ?</tr>
? ? ? ?</table></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><?php include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING); ?></td>
? ? ?</tr>
? ?</table></td>
<?php
?} else { // default page
?>
? ?<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">
? ? ?<tr>
? ? ? ?<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
? ? ? ? ?<tr>
? ? ? ? ? ?<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
? ? ? ? ? ?<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_default.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
? ? ? ? ?</tr>
? ? ? ?</table></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
? ? ? ? ?<tr>
? ? ? ? ? ?<td class="main"><?php echo tep_customer_greeting(); ?></td>
? ? ? ? ?</tr>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ?</tr>
? ? ? ? ?<tr>
? ? ? ? ? ?<td class="main"><?php echo TEXT_MAIN; ?></td>
? ? ? ? ?</tr>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ?</tr>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php include(DIR_WS_MODULES . FILENAME_NEW_PRODUCTS); ?></td>
? ? ? ? ?</tr>
<?php
? ?include(DIR_WS_MODULES . FILENAME_UPCOMING_PRODUCTS);
?>
? ? ? ?</table></td>
? ? ?</tr>
? ?</table></td>
<?php
}
?>
<!-- body_text_eof //-->
? ?<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- right_navigation //-->
<?php ?require(DIR_WS_INCLUDES . 'column_right.php'); ?>
<!-- right_navigation_eof //-->
? ?</table></td>
?</tr>
</table>
<!-- body_eof //-->

<!-- footer //-->
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Edited by ChrisUCF99
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...