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

osCommerce

The e-commerce.

New Demo
Our Partners

HELP!!!! pleeeeasseeee catalog_products_with_images make columns its in rows

skalcevich

By skalcevich
in General Add-Ons Support

 Share

Recommended Posts

skalcevich

skalcevich

Posted
Posted

hi there!

 

I cant figure out how to make catalog_products_with_images contribution in columns. below is my link to my site. http://philcos.com/catalog/catalog_products_with_images.php

 

 

I want 5 across and 6 down. Picture, catagory then manufacture, model then price. sorted the way it is catagory then Manufacturer within that catagory.

 

below is the code for the catalog_products_with_images.php if anyone has ideas let me know thanks!!

 

<?php
/*
 $Id: catalog_products_with_images_full.php V 3.4
 by Tom St.Croix <[email protected]> V 3.4

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License

 notes: added to the catalog/includes/languages/english.php 
 define('IMAGE_BUTTON_UPSORT', 'Sort Asending');
 define('IMAGE_BUTTON_DOWNSORT', 'Sort Desending');
*/
 require('includes/application_top.php');

 require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CATALOG_PRODUCTS_WITH_IMAGES);

 // Use $location if you have a pre breadcrumb release of OSC then comment out $breadcrumb line
 //$location = ' » <a href="' . tep_href_link(FILENAME_CATALOG_PRODUCTS_WITH_IMAGES, '', 'NONSSL') . '" class="headerNavigation">' . NAVBAR_TITLE . '</a>';

 // Use $breadcrumb if you have a breadcrumb release of OSC then comment out $location line
 $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_CATALOG_PRODUCTS_WITH_IMAGES, '', 'NONSSL'));

?>
<!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 (getenv('HTTPS') == 'on' ? 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 //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
 <tr>
<!-- body_text //-->
<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; ?>
<?PHP
 if (PRODUCT_LIST_CATALOG_CURRENCY == 'show') { 
require(DIR_WS_BOXES . 'currencies.php');
}
?>
</td>
	  </tr>
	</table></td>
  </tr>
  <tr>
	<td><table border="0" width="100%" cellspacing="0" cellpadding="0">
	  <tr>
		<td colspan="<?php echo $count_rows; ?>"><?php echo tep_draw_separator(); ?></td>
	  </tr>
	  <input type=button value="Print Page" onClick="print()">
	  <tr>
		<td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
	  <?php
	  switch ($listing) {
		  case "image":
		  $order = "p.products_image,";
		  break;
		  case "image-desc":
		  $order = "p.products_image DESC";
		  break;
		  case "name":
		  $order = "pd.products_name, cd.categories_name";
		  break;
		  case "name-desc":
		  $order = "pd.products_name DESC, cd.categories_name";
		  break;
		  case "categories":
		  $order = "cd.categories_name, pd.products_name";
		  break;
		  case "categories-desc":
		  $order = "cd.categories_name DESC, pd.products_name";
		  break;
		  case "products_description":
		  $order = "pd.products_name, pd.products_description";
		  break;
		  case "products_description-desc":
		  $order = "pd.products_name DESC, pd.products_description";
		  break;
		  case "model":
		  $order = "p.products_model";
		  break;
		  case "model-desc":
		  $order = "p.products_model DESC";
		  break;
		  case "upc":
		  $order = "p.products_upc";
		  break;
		  case "upc-desc":
		  $order = "p.products_upc DESC";
		  break;
		  case "quantity":
		  $order = "p.products_quantity, pd.products_name";
		  break;
		  case "quantity-desc":
		  $order = "p.products_quantity DESC, pd.products_name";
		  break;
		  case "weight":
		  $order = "p.products_weight, pd.products_name";
		  break;
		  case "weight-desc":
		  $order = "p.products_weight DESC, pd.products_name";
		  break;
		  case "price":
		  $order = "p.products_price, pd.products_name";
		  break;
		  case "price-desc":
		  $order = "p.products_price DESC, pd.products_name";
		  break;
		  case "manufacturers":
		  $order = "m.manufacturers_name, pd.products_name";
		  break;
		  case "manufacturers-desc":
		  $order = "m.manufacturers_name DESC, pd.products_name";
		  break;
		  case "date":
		  $order = "p.products_date_added, pd.products_name";
		  break;
		  case "date-desc":
		  $order = "p.products_date_added DESC, pd.products_name";
		  break;
	  default:
		  $order = "cd.categories_name, m.manufacturers_name";
	  }
	  ?>
		 <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr class="dataTableHeadingRow">
<?PHP
  $count_rows=0;
  if (PRODUCT_LIST_CATALOG_IMAGE == 'show') {
	  $count_rows++;
?>
			<td class="TableHeading" align="center">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="15%" rowspan="1"  align="right" valign="bottom">
		 <br> 
		</td>
		<td width="85%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_IMAGES; ?>
		</td>
		</tr>
		</table>
						  </td>
<?PHP } 
 if (PRODUCT_LIST_CATALOG_OPTIONS == 'show') { 
	  $count_rows++;
?>
			<td class="TableHeading" align="left">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="15%" rowspan="1"  align="right" valign="bottom">
		 <br> 
		</td>
		<td width="70%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_OPTIONS; ?>
		</td>
		</tr>
		</table>
						  </td>
<?PHP }
 if (PRODUCT_LIST_CATALOG_DATE == 'show') {
	  $count_rows++;
?>
			<td class="TableHeading" align="left">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="17%" align="right" valign="bottom">
		<a href="<?php echo "$PHP_SELF?listing=date-asc"; ?>"><?php echo tep_image_button('printable_catalog_up.gif', IMAGE_BUTTON_UPSORT); ?></a><br><a href="<?php echo "$PHP_SELF?listing=date-desc"; ?>"><?php echo tep_image_button('printable_catalog_down.gif', IMAGE_BUTTON_DOWNSORT); ?></a></td>
		<td width="83%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_DATE; ?>
		</td>
		</tr>
		</table>
						  </td>
<?PHP }
 if (PRODUCT_LIST_CATALOG_MANUFACTURERS == 'show') {
	  $count_rows++;
?>
			<td class="TableHeading" align="left">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="30%" align="right" valign="bottom">
		<a href="<?php echo "$PHP_SELF?listing=manufacturers"; ?>"><?php echo tep_image_button('printable_catalog_up.gif', IMAGE_BUTTON_UPSORT); ?></a><br><a href="<?php echo "$PHP_SELF?listing=manufacturers-desc"; ?>"><?php echo tep_image_button('printable_catalog_down.gif', IMAGE_BUTTON_DOWNSORT); ?></a></td>
		<td width="70%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_MANUFACTURERS; ?>
		</td>
		</tr>
		</table>
						  </td>

<?PHP }  
 if (PRODUCT_LIST_CATALOG_NAME == 'show') {
	  $count_rows++;
?>
			<td class="TableHeading" align="left">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="30%" align="right" valign="bottom">
		<a href="<?php echo "$PHP_SELF?listing=name"; ?>"><?php echo tep_image_button('printable_catalog_up.gif', IMAGE_BUTTON_UPSORT); ?></a><br><a href="<?php echo "$PHP_SELF?listing=name-desc"; ?>"><?php echo tep_image_button('printable_catalog_down.gif', IMAGE_BUTTON_DOWNSORT); ?></a></td>
		<td width="70%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_PRODUCTS; ?>
		</td>
		</tr>
		</table>
						  </td>
<?PHP }  
 if (PRODUCT_LIST_CATALOG_DESCRIPTION == 'show') {
	  $count_rows++;
?>
			<td class="TableHeading" align="center">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="30%" align="right" valign="bottom">
		<a href="<?php echo "$PHP_SELF?listing=products_description"; ?>"><?php echo tep_image_button('printable_catalog_up.gif', IMAGE_BUTTON_UPSORT); ?></a><br><a href="<?php echo "$PHP_SELF?listing=products_description-desc"; ?>"><?php echo tep_image_button('printable_catalog_down.gif', IMAGE_BUTTON_DOWNSORT); ?></a></td>
		<td width="70%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_DESCRIPTION; ?>
		</td>
		</tr>
		</table>
						  </td>

<?PHP } 
 if (PRODUCT_LIST_CATALOG_CATEGORIES == 'show') {
	  $count_rows++;
?>
			<td class="TableHeading" align="left">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="17%" align="right" valign="bottom">
		<a href="<?php echo "$PHP_SELF?listing=categories"; ?>"><?php echo tep_image_button('printable_catalog_up.gif', IMAGE_BUTTON_UPSORT); ?></a><br><a href="<?php echo "$PHP_SELF?listing=categories-desc"; ?>"><?php echo tep_image_button('printable_catalog_down.gif', IMAGE_BUTTON_DOWNSORT); ?></a></td>
		<td width="83%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_CATEGORIES; ?>
		</td>
		</tr>
		</table>
						  </td>
<?PHP } 
  if (PRODUCT_LIST_CATALOG_MODEL == 'show') { 
	  $count_rows++;
?>
		<td class="TableHeading" align="left">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="25%" align="right" valign="bottom">
		<a href="<?php echo "$PHP_SELF?listing=model"; ?>"><?php echo tep_image_button('printable_catalog_up.gif', IMAGE_BUTTON_UPSORT); ?></a><br><a href="<?php echo "$PHP_SELF?listing=model-desc"; ?>"><?php echo tep_image_button('printable_catalog_down.gif', IMAGE_BUTTON_DOWNSORT); ?></a></td>
		</td>
		<td width="75%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_MODEL; ?>
		</td>
		</tr>
		</table>
						  </td>
<?PHP } 
  if (PRODUCT_LIST_CATALOG_UPC == 'show') { 
	  $count_rows++;
?>
		<td class="TableHeading" align="left">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="25%" align="right" valign="bottom">
		<a href="<?php echo "$PHP_SELF?listing=upc"; ?>"><?php echo tep_image_button('printable_catalog_up.gif', IMAGE_BUTTON_UPSORT); ?></a><br><a href="<?php echo "$PHP_SELF?listing=upc-desc"; ?>"><?php echo tep_image_button('printable_catalog_down.gif', IMAGE_BUTTON_DOWNSORT); ?></a></td>
		</td>
		<td width="75%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_UPC; ?>
		</td>
		</tr>
		</table>
						  </td>
<?PHP } 
  if (PRODUCT_LIST_CATALOG_QUANTITY == 'show') {
	  $count_rows++;
?>
		<td class="TableHeading" align="left">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="25%" align="right" valign="bottom">
		<a href="<?php echo "$PHP_SELF?listing=quantity"; ?>"><?php echo tep_image_button('printable_catalog_up.gif', IMAGE_BUTTON_UPSORT); ?></a><br><a href="<?php echo "$PHP_SELF?listing=quantity-desc"; ?>"><?php echo tep_image_button('printable_catalog_down.gif', IMAGE_BUTTON_DOWNSORT); ?></a></td>
		</td>
		<td width="75%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_QUANTITY; ?>
		</td>
		</tr>
		</table>
						  </td>
<?PHP }
  if (PRODUCT_LIST_CATALOG_WEIGHT == 'show') { 
	  $count_rows++;
?>
		<td class="TableHeading" align="left">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="25%" align="right" valign="bottom">
		<a href="<?php echo "$PHP_SELF?listing=weight"; ?>"><?php echo tep_image_button('printable_catalog_up.gif', IMAGE_BUTTON_UPSORT); ?></a><br><a href="<?php echo "$PHP_SELF?listing=weight-desc"; ?>"><?php echo tep_image_button('printable_catalog_down.gif', IMAGE_BUTTON_DOWNSORT); ?></a></td>
		</td>
		<td width="75%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_WEIGHT; ?>
		</td>
		</tr>
		</table>
						  </td>
<?PHP } 
  if (PRODUCT_LIST_CATALOG_PRICE == 'show') { 
	  $count_rows++;
?>
		<td class="TableHeading" align="left">
		<table border="0" cellspacing="0" cellpadding="2">
		<tr>
		<td width="30%" align="right" valign="bottom">
		<a href="<?php echo "$PHP_SELF?listing=price"; ?>"><?php echo tep_image_button('printable_catalog_up.gif', IMAGE_BUTTON_UPSORT); ?></a><br><a href="<?php echo "$PHP_SELF?listing=price-desc"; ?>"><?php echo tep_image_button('printable_catalog_down.gif', IMAGE_BUTTON_DOWNSORT); ?></a></td>
		</td>
		<td width="70%" rowspan="2" align="left" class="TableHeading">
		<?php echo TABLE_HEADING_PRICE; ?>
		</td>
		</tr>
		</table>
						  </td>
<?php
 }
?>
			</tr>
		  <tr>
			<td colspan="<?php echo $count_rows; ?>"><?php echo tep_draw_separator(); ?></td>
		  </tr>
			<tr>


<?php
 if (strlen($listing)>0) { $sort = $listing; } else { $sort = ""; }
 if ($HTTP_GET_VARS['page'] > 1) $rows = $HTTP_GET_VARS['page'] * 20 - 20;
// This query can be used if you use the UPC Mod and want to have the catalog display UPC numbers as well
  //$products_query_raw = "select distinct p.products_id, p.products_image, p.products_model, p.products_upc, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id 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_CATEGORIES_DESCRIPTION . " cd on p2c.categories_id = cd.categories_id left join " . TABLE_SPECIALS . " 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 = '" . $languages_id . "' and cd.language_id = '" . $languages_id . "' order by $order";
 $products_query_raw = "select distinct p.products_id, p.products_image, p.products_model, p.products_quantity, p.products_weight, pd.products_name, p.manufacturers_id, p.products_price, p.products_date_added, 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, m.manufacturers_name, pd.products_description, cd.categories_name, p.products_tax_class_id, p2c.categories_id 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_CATEGORIES_DESCRIPTION . " cd on p2c.categories_id = cd.categories_id left join " . TABLE_SPECIALS . " 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 = '" . $languages_id . "' and cd.language_id = '" . $languages_id . "' order by $order";
 $products_query = tep_db_query($products_query_raw);
//Discount used for Customer Discount Mod

// Number of products to display per page 
 $limit = mysql_result(mysql_query("SELECT configuration_value from  " . TABLE_CONFIGURATION . " WHERE configuration_key = 'PRODUCT_LIST_CATALOG_PERPAGE'"), 0 , 0);
//Number of text in the products description - not working yet
 $description_length = mysql_result(mysql_query("SELECT configuration_value from  " . TABLE_CONFIGURATION . " WHERE configuration_key = 'PRODUCT_LIST_DESCRIPTION_LENGTH'"), 0 , 0);  
 $totalrows = mysql_num_rows($products_query);
 if (empty($page)) { $page = 1; }
 $limitvalue = $page * $limit - ($limit);
 $query = $products_query_raw . " LIMIT $limitvalue, $limit";
 $result = tep_db_query($query);
 if(mysql_num_rows($result) == 0) 
	echo("Nothing to Display!");

 while($products = tep_db_fetch_array($result)) {
$rows++;

if (strlen($rows) < 2) {
  $rows = '0' . $rows;
}
?>

		  <tr class="tableRow">
<?PHP if (PRODUCT_LIST_CATALOG_IMAGE == 'show') { ?> 
<?PHP if (SEARCH_ENGINE_FRIENDLY_URLS == 'true') { ?> 
		   <td class="tableData" align="center"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?> </td>
<?PHP } else { ?>
		   <td class="tableData" align="center"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $products['categories_id'] . '&products_id=' . $products['products_id'], 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . $products['products_image'], $products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>'; ?> </td>
<?PHP } ?>
<?PHP } ?>
<?PHP if (PRODUCT_LIST_CATALOG_OPTIONS == 'show') { ?>
			<td class="tableData" align="left">

<?php
// Get the options:
$products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . $products['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . $languages_id . "'");
$products_attributes = tep_db_fetch_array($products_attributes_query);
if ($products_attributes['total'] > 0) {
	  $opt_x = 0;
  $opt_y = 0;
		$max_y = 0;
  unset($products_options_array); 
  $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . $products['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . $languages_id . "'");
  while ($products_options_name = tep_db_fetch_array($products_options_name_query)) {
	$opt_y = 0;
	$products_options_array[$opt_x][0]= $products_options_name['products_options_name']; 
	$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . $products['products_id'] . "' and pa.options_id = '" . $products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'");
	while ($products_options = tep_db_fetch_array($products_options_query)) {
	  $opt_y++;	
				if ($opt_y > $max_y) $max_y = $opt_y;
				  $products_option_name=$products_options['products_options_values_name'];
	  if ($products_options['options_values_price'] != '0') {
		$produkt_option_name.= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($products['products_tax_class_id'])) .') ';
	  }
	  $products_options_array[$opt_x][$opt_y] = $products_option_name;
	}
	  $opt_x++;	
	  }
?>
			   <table border="1" cellspacing="0" cellpadding="0">
							   <tr>
<?php
  // Start Output:
  $out_x = 0;
  $out_y = 0;

		for ($out_y = 0; $out_y <= $max_y; $out_y++) {
			  echo "<tr>";
				for ($out_x = 0; $out_x < $opt_x; $out_x++) {
				  echo '<td class="smallText" align="center">' .  $products_options_array[$out_x][$out_y] . ' </td>';
			  }
			echo "</tr>";
		}
?>		
							 </table>
<?php		

	}
?>
	 </td>
<?PHP if (PRODUCT_LIST_CATALOG_DATE == 'show') { ?>
			<td class="tableData" align="center"><div align=left><?php 
								if (PRODUCT_LIST_CATALOG_DATE_SHOW == 'show') echo tep_date_short($products['products_date_added']); ?> </div></td>
<?PHP } ?>
<?PHP } ?>
<?PHP if (PRODUCT_LIST_CATALOG_MANUFACTURERS == 'show') { ?>
			<td class="tableData" align="center"><div align=left><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $products['cPath'] . '&products_id=' . $products['products_id'], 'NONSSL') . '">' . $products['manufacturers_name'] . '</a>'; ?> </div></td>
<?PHP } ?>
<?PHP if (PRODUCT_LIST_CATALOG_NAME == 'show') { ?>
<?PHP if (SEARCH_ENGINE_FRIENDLY_URLS == 'true') { ?> 
			<td class="tableData" align="center"><div align=left><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id'], 'NONSSL') . '">' . $products['products_name'] . '</a>'; ?> </div></td>
<?PHP } else { ?>
			<td class="tableData" align="center"><div align=left><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $products['categories_id'] . '&products_id=' . $products['products_id'], 'NONSSL') . '">' . $products['products_name'] . '</a>'; ?> </div></td>
<?PHP } ?>
<?PHP } ?>
<?PHP if (PRODUCT_LIST_CATALOG_DESCRIPTION == 'show') { ?>
		   <td class="tableData" align="center"><?php echo substr(nl2br($products['products_description']), 0, $description_length); ?>... <?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $products['cPath'] . '&products_id=' . $products['products_id'], 'NONSSL') . '"><i>More Info</i>...</a>'; ?></td>
<?PHP } ?>
<?PHP if (PRODUCT_LIST_CATALOG_CATEGORIES == 'show') { ?>
			<td class="tableData" align="center"><div align=left><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'cPath=' . $products['categories_id'], 'NONSSL') . '">' . $products['categories_name'] . '</a>'; ?> </div></td>
<?PHP } ?>
<?PHP if (PRODUCT_LIST_CATALOG_MODEL == 'show') { ?>
			<td class="tableData" align="center"><div align=left><?php echo $products['products_model']; ?> </div></td>
<?PHP } ?>
<?PHP if (PRODUCT_LIST_CATALOG_UPC == 'show') { ?>
			<td class="tableData" align="center"><div align=left><?php echo $products['products_upc']; ?> </div></td>
<?PHP } ?>
<?PHP if (PRODUCT_LIST_CATALOG_QUANTITY == 'show') { ?>
			<td class="tableData" align="center"><div align=left><?php echo $products['products_quantity']; ?> </div></td>
<?PHP } ?>
<?PHP if (PRODUCT_LIST_CATALOG_WEIGHT == 'show') { ?>
			<td class="tableData" align="center"><div align=left><?php echo $products['products_weight']; ?> </div></td>
<?PHP } ?>
<?PHP if (PRODUCT_LIST_CATALOG_PRICE == 'show') { ?> 
		<td class="tableData" align="center"><div align=left><B>
<?php 
 if (PRODUCT_LIST_CUSTOMER_DISCOUNT == 'show') {
//echo $currencies->format($products['final_price']-($products['final_price']*$discount/100)); 
echo $currencies->display_price($products['final_price']-($products['final_price']*$discount/100), tep_get_tax_rate($products['products_tax_class_id']));
} else {
echo $currencies->display_price($products['final_price'], tep_get_tax_rate($products['products_tax_class_id']));
}
?></B> </div></td>
<?PHP } ?>
		  </tr>

<?php
 }
?>
		  <tr>
			 <td colspan="<?php echo $count_rows; ?>"><?php echo tep_draw_separator(); ?></td>
		  </tr>
	</table></td>
  <tr>
	<td colspan="3">

	<center>
<?php
if($page != 1)

{
$pageprev = $page - 1; 
echo("<a href=\"$PHP_SELF?listing=" . $sort . "&page=$pageprev\">".BOX_CATALOG_PREV."</a> ");  
} else {
	echo(BOX_CATALOG_PREV." ");
}
//PRODUCT_LIST_PAGEBREAK_NUMBERS_PERPAGE
$displaycount_number = (mysql_result(mysql_query("SELECT configuration_value from  " . TABLE_CONFIGURATION . " WHERE configuration_key = 'PRODUCT_LIST_PAGEBREAK_NUMBERS_PERPAGE'"), 0 , 0)) - 2;
$numofpages = $totalrows / $limit;
// setting both 10s will limit the list to ten page links 20s would set it to display 20 page breaks max.
$displaycount = $numofpages < $displaycount_number ? $numofpages : $displaycount_number; 

$startpage = $page > $displaycount / 2 ? floor($page - $displaycount / 2) : 1;


for($i = $startpage; $i <= $startpage + $displaycount; $i++)  
{  
if($i > $numofpages) 
{ 
	break; 
}else 
if($i == $page)   
{  
	if($i>0) echo("[<b>".$i."</b>] ");  
} else { 
	if($i>0) echo("<a href=\"$PHP_SELF?listing=" . $sort . "&page=$i\">[$i</a>] ");  
}
}

if(($totalrows % $limit) != 0) 
{ 

if($i == $page)

{
	if($i>0) echo("[<b>".$i."</b>] ");
} else {
	if($i>0) echo("<a href=\"$PHP_SELF?listing=" . $sort . "&page=$i\">[$i]</a> ");
}
}

if(($totalrows - ($limit * $page)) > 0)
{ 
$pagenext = $page + 1;
echo("<a href=\"$PHP_SELF?listing=" . $sort . "&page=$pagenext\">".BOX_CATALOG_NEXT."</a>");  
} else {
echo("  ".BOX_CATALOG_NEXT);  
}
mysql_free_result($result); 
?>
	  <left>
		</td>
  </tr>
		  <tr>
			<td colspan="<?php echo $count_rows; ?>"><?php echo tep_draw_separator(); ?></td>
		  </tr>
	  <tr>
		<td colspan="<?php echo $count_rows; ?>"><table border="0" width="100%" cellspacing="0" cellpadding="2">
		  <tr>
			<td class="smallText"> </td>
			<td align="right" class="smallText"> </td>
		  </tr>
		</table></td>
	  </tr>
	</table></td>
  </tr>
</table></td>
<!-- body_text_eof //-->
 </tr>
</table>
<!-- body_eof //-->

</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

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