Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] Description in Product Listing MS2 v.2.3


Guest

Recommended Posts

I had a few questions before I go through with installing this contrib. I've read through all the posts, looked in my DB, backed it up, and am basically ready. I'm running osCommerce 2.2-MS2.

 

Question:

In the Install.txt file the SQL lines say to add them to the `configuration` table. My DB has a config table which I assume is the same one. When I ran the first one I got this response:

 

INSERT INTO `config` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
VALUES (
'', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '', '', NULL , NULL
)

MySQL said: Documentation
#1054 - Unknown column 'configuration_id' in 'field list'

 

Is there something I'm missing and will I need to make any other changes to the code to get this to work given that the table names are different?

Link to comment
Share on other sites

  • 4 months later...
  • Replies 84
  • Created
  • Last Reply

Top Posters In This Topic

I was getting the SQL error also. I found if you are NOT installing the contribution by hand (i.e., using a tool like Beyond Compare), you'll run into a small syntax discrepancy between the install.txt instructions and the included index.php file.

Follow the install.txt instructions (below), rather then using a compare tool, to properly install the contribution's sql code into the index.php file.

Find:

? ? ? ?case 'PRODUCT_LIST_NAME':

? ? ? ? ?$select_column_list .= 'pd.products_name, ';

? ? ? ? ?break;

Below add:

// Products Description Hack begins

? ? ? ?case 'PRODUCT_LIST_DESCRIPTION':

? $select_column_list .= 'pd.products_description, ';

? ? ? ? ?break;

// Products Description Hack ends

The included index.php file omits the ',' (comma) after 'pd.products_description'.

 

 

Hi there, i did what you said above to my index.php, here is my code

 

 

	 case 'PRODUCT_LIST_MODEL':
	  $select_column_list .= 'p.products_model';
	  break;
	case 'PRODUCT_LIST_NAME':
	  $select_column_list .= 'pd.products_name';
	  break;

	  // Products Description Hack begins
   case 'PRODUCT_LIST_DESCRIPTION':
 $select_column_list .= 'pd.products_description, ';
	 break;
// Products Description Hack ends

	case 'PRODUCT_LIST_MANUFACTURER':
	  $select_column_list .= 'm.manufacturers_name';
	  break;

 

but i am still getting this error

 

1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ' , p.products_id, p.manufacturers_id, p.products_price, p.prod

 

select p.products_image, pd.products_name, pd.products_description, , , 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 products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join 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 = '1' and p2c.categories_id = '21' order by pd.products_name limit 0, 20

Link to comment
Share on other sites

Can this mod be installed with the multiple products mod?

 

they replace the product_listing with a new page called proddcut_listing_multiple, i tried to do a beyond compare but it wont work, this is the code to the page in the mod

 

<?php
/*
 $Id: product_listing_multi.php,v 2.0 2005/24/03 01:50:59 hpdl Exp $

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

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');
 if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr>
<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
 </tr>
</table>
<form name="cart_multi" method="post" action="<?php echo tep_href_link(FILENAME_SHOPPING_CART, tep_get_all_get_params(array('action')) . 'action=add_multi', 'NONSSL'); ?>">
<?php
 }
 $list_box_contents = array();
 for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
switch ($column_list[$col]) {
  case 'PRODUCT_LIST_MODEL':
	$lc_text = TABLE_HEADING_MODEL;
	$lc_align = '';
	break;
  case 'PRODUCT_LIST_NAME':
	$lc_text = TABLE_HEADING_PRODUCTS;
	$lc_align = '';
	break;
	case 'PRODUCT_LIST_MANUFACTURER':
		$lc_text = TABLE_HEADING_MANUFACTURER;
		$lc_align = '';
	break;
	case 'PRODUCT_LIST_RETAIL_PRICE':
		$lc_text = TABLE_HEADING_RETAIL_PRICE;
		$lc_align = 'right';
	break;
	case 'PRODUCT_LIST_PRICE':
		$lc_text = TABLE_HEADING_PRICE;
		$lc_align = 'right';
	break;
	case 'PRODUCT_LIST_SAVE':
		$lc_text = TABLE_HEADING_SAVE;
		$lc_align = 'right';
	break;
	case 'PRODUCT_LIST_QUANTITY':
		$lc_text = TABLE_HEADING_QUANTITY;
		$lc_align = 'right';
	break;
  case 'PRODUCT_LIST_WEIGHT':
	$lc_text = TABLE_HEADING_WEIGHT;
	$lc_align = 'right';
	break;
  case 'PRODUCT_LIST_IMAGE':
	$lc_text = TABLE_HEADING_IMAGE;
	$lc_align = 'center';
	break;
  case 'PRODUCT_LIST_BUY_NOW':
	$lc_text = TABLE_HEADING_BUY_NOW;
	$lc_align = 'center';
	break;
}
if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') && ($column_list[$col] != 'PRODUCT_LIST_SAVE') ) {
  $lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text);
}
$list_box_contents[0][] = array('align' => $lc_align,
								'params' => 'class="productListing-heading"',
								'text' => ' ' . $lc_text . ' ');
 }
 if ($listing_split->number_of_rows > 0) {
$rows = 0;
$listing_query = tep_db_query($listing_split->sql_query);
while ($listing = tep_db_fetch_array($listing_query)) {
  $rows++;
  if (($rows/2) == floor($rows/2)) {
	$list_box_contents[] = array('params' => 'class="productListing-even"');
  } else {
	$list_box_contents[] = array('params' => 'class="productListing-odd"');
  }
  $cur_row = sizeof($list_box_contents) - 1;
  for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
	$lc_align = '';
	switch ($column_list[$col]) {
	  case 'PRODUCT_LIST_MODEL':
		$lc_align = '';
		$lc_text = ' ' . $listing['products_model'] . ' ';
		break;
	  case 'PRODUCT_LIST_NAME':
		$lc_align = '';
		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['products_id']) . '">' . $listing['products_name'] . '</a>';
		} else {
		  $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> ';
		}
		break;
	  case 'PRODUCT_LIST_MANUFACTURER':
			$lc_align = '';
			$lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a> ';
			break;
		case 'PRODUCT_LIST_RETAIL_PRICE':
			$lc_align = 'right';
			if ((tep_not_null($listing['products_retail_price'])) && ($listing['products_retail_price']) > 0) {
			$lc_text = '<font color="#55508a">' . $currencies->display_price($listing['products_retail_price'], tep_get_tax_rate($listing['products_tax_class_id']));
			} else {
			$lc_text = ' ';
			}
			break;
		case 'PRODUCT_LIST_PRICE':
			$lc_align = 'right';
			if (tep_not_null($listing['specials_new_products_price'])) {
			$lc_text = ' ' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '  <span class="productSpecialPrice">' . $currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span> </nobr>';
			} else {
			$lc_text = ' ' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . ' </nobr>';
			}
			break;
		case 'PRODUCT_LIST_SAVE':
			$lc_align = 'right';
			if ((tep_not_null($listing['products_retail_price'])) && ($listing['products_retail_price']) > 0) {
			$lc_save = round(100 - (( $listing['products_price'] / $listing['products_retail_price'] ) * 100 ));
			$lc_text = '<font color="red"> ' . $lc_save . '% </font>';
			} else {
			$lc_text = ' ';
			}
			break;
		case 'PRODUCT_LIST_QUANTITY':
			$lc_align = 'right';
			$lc_text = ' ' . $listing['products_quantity'] . ' ';
			break;
	  case 'PRODUCT_LIST_WEIGHT':
		$lc_align = 'right';
		$lc_text = ' ' . $listing['products_weight'] . ' ';
		break;
		case 'PRODUCT_LIST_IMAGE':
		$lc_align = 'center';
		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['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';
		} else {
		  $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a> ';
		}
		break;
		case 'PRODUCT_LIST_BUY_NOW':
			$lc_align = 'center';
			$lc_text = '<input type="checkbox" name="add_id['.sizeof($list_box_contents).']" value="1">';
			break;
	}
	$list_box_contents[$cur_row][] = array('align' => $lc_align,
										   'params' => 'class="productListing-data"',
										   'text'  => $lc_text );
  }
	?> <input type="hidden" name="products_id[<?=sizeof($list_box_contents)?>]" value="<?php echo $listing['products_id']; ?>"> <?php
		echo "\n";
}
new productListingBox($list_box_contents);
 } else {
$list_box_contents = array();
$list_box_contents[0] = array('params' => 'class="productListing-odd"');
$list_box_contents[0][] = array('params' => 'class="productListing-data"',
							   'text' => TEXT_NO_PRODUCTS);
new productListingBox($list_box_contents);
}
 ?>
<?php // hide if empty by willross
if ($cateqories_products['total'] > 0) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
 <tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
 </tr>
</table>
<table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
 <tr class="infoBoxContents">
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
	  <tr>
		<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		<td align="left" class="main"><a href="<?php echo tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL'); ?>"><?php echo tep_image_button('button_checkout.gif', IMAGE_BUTTON_CHECKOUT); ?></a></td>
		<td align="right" class="main"><?php echo tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>
		<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
	  </tr>
	</table></td>
 </tr>
</table>
<?php
}
?></form>
<?php
 if ( ($listing_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')) ) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr>
<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
 </tr>
</table>
<?php
 }
?>

Link to comment
Share on other sites

  • 3 weeks later...

has anyone had the trouble of this mod just creating a 2nd buy now button? nothing else happened and it has just as good of functionality as the original buy now buttons any advice would be appreciated. TIA Bill

Can this mod be installed with the multiple products mod?

 

they replace the product_listing with a new page called proddcut_listing_multiple, i tried to do a beyond compare but it wont work, this is the code to the page in the mod

 

<?php
/*
 $Id: product_listing_multi.php,v 2.0 2005/24/03 01:50:59 hpdl Exp $

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

 Copyright (c) 2003 osCommerce

 Released under the GNU General Public License
*/

 $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_SEARCH_RESULTS, 'p.products_id');
 if ( ($listing_split->number_of_rows > 0) && ( (PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3') ) ) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr>
<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
 </tr>
</table>
<form name="cart_multi" method="post" action="<?php echo tep_href_link(FILENAME_SHOPPING_CART, tep_get_all_get_params(array('action')) . 'action=add_multi', 'NONSSL'); ?>">
<?php
 }
 $list_box_contents = array();
 for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
switch ($column_list[$col]) {
  case 'PRODUCT_LIST_MODEL':
	$lc_text = TABLE_HEADING_MODEL;
	$lc_align = '';
	break;
  case 'PRODUCT_LIST_NAME':
	$lc_text = TABLE_HEADING_PRODUCTS;
	$lc_align = '';
	break;
	case 'PRODUCT_LIST_MANUFACTURER':
		$lc_text = TABLE_HEADING_MANUFACTURER;
		$lc_align = '';
	break;
	case 'PRODUCT_LIST_RETAIL_PRICE':
		$lc_text = TABLE_HEADING_RETAIL_PRICE;
		$lc_align = 'right';
	break;
	case 'PRODUCT_LIST_PRICE':
		$lc_text = TABLE_HEADING_PRICE;
		$lc_align = 'right';
	break;
	case 'PRODUCT_LIST_SAVE':
		$lc_text = TABLE_HEADING_SAVE;
		$lc_align = 'right';
	break;
	case 'PRODUCT_LIST_QUANTITY':
		$lc_text = TABLE_HEADING_QUANTITY;
		$lc_align = 'right';
	break;
  case 'PRODUCT_LIST_WEIGHT':
	$lc_text = TABLE_HEADING_WEIGHT;
	$lc_align = 'right';
	break;
  case 'PRODUCT_LIST_IMAGE':
	$lc_text = TABLE_HEADING_IMAGE;
	$lc_align = 'center';
	break;
  case 'PRODUCT_LIST_BUY_NOW':
	$lc_text = TABLE_HEADING_BUY_NOW;
	$lc_align = 'center';
	break;
}
if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') && ($column_list[$col] != 'PRODUCT_LIST_SAVE') ) {
  $lc_text = tep_create_sort_heading($HTTP_GET_VARS['sort'], $col+1, $lc_text);
}
$list_box_contents[0][] = array('align' => $lc_align,
								'params' => 'class="productListing-heading"',
								'text' => ' ' . $lc_text . ' ');
 }
 if ($listing_split->number_of_rows > 0) {
$rows = 0;
$listing_query = tep_db_query($listing_split->sql_query);
while ($listing = tep_db_fetch_array($listing_query)) {
  $rows++;
  if (($rows/2) == floor($rows/2)) {
	$list_box_contents[] = array('params' => 'class="productListing-even"');
  } else {
	$list_box_contents[] = array('params' => 'class="productListing-odd"');
  }
  $cur_row = sizeof($list_box_contents) - 1;
  for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
	$lc_align = '';
	switch ($column_list[$col]) {
	  case 'PRODUCT_LIST_MODEL':
		$lc_align = '';
		$lc_text = ' ' . $listing['products_model'] . ' ';
		break;
	  case 'PRODUCT_LIST_NAME':
		$lc_align = '';
		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['products_id']) . '">' . $listing['products_name'] . '</a>';
		} else {
		  $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . $listing['products_name'] . '</a> ';
		}
		break;
	  case 'PRODUCT_LIST_MANUFACTURER':
			$lc_align = '';
			$lc_text = ' <a href="' . tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $listing['manufacturers_id']) . '">' . $listing['manufacturers_name'] . '</a> ';
			break;
		case 'PRODUCT_LIST_RETAIL_PRICE':
			$lc_align = 'right';
			if ((tep_not_null($listing['products_retail_price'])) && ($listing['products_retail_price']) > 0) {
			$lc_text = '<font color="#55508a">' . $currencies->display_price($listing['products_retail_price'], tep_get_tax_rate($listing['products_tax_class_id']));
			} else {
			$lc_text = ' ';
			}
			break;
		case 'PRODUCT_LIST_PRICE':
			$lc_align = 'right';
			if (tep_not_null($listing['specials_new_products_price'])) {
			$lc_text = ' ' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '  <span class="productSpecialPrice">' . $currencies->display_price($listing['specials_new_products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</span> </nobr>';
			} else {
			$lc_text = ' ' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . ' </nobr>';
			}
			break;
		case 'PRODUCT_LIST_SAVE':
			$lc_align = 'right';
			if ((tep_not_null($listing['products_retail_price'])) && ($listing['products_retail_price']) > 0) {
			$lc_save = round(100 - (( $listing['products_price'] / $listing['products_retail_price'] ) * 100 ));
			$lc_text = '<font color="red"> ' . $lc_save . '% </font>';
			} else {
			$lc_text = ' ';
			}
			break;
		case 'PRODUCT_LIST_QUANTITY':
			$lc_align = 'right';
			$lc_text = ' ' . $listing['products_quantity'] . ' ';
			break;
	  case 'PRODUCT_LIST_WEIGHT':
		$lc_align = 'right';
		$lc_text = ' ' . $listing['products_weight'] . ' ';
		break;
		case 'PRODUCT_LIST_IMAGE':
		$lc_align = 'center';
		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['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a>';
		} else {
		  $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $listing['products_image'], $listing['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a> ';
		}
		break;
		case 'PRODUCT_LIST_BUY_NOW':
			$lc_align = 'center';
			$lc_text = '<input type="checkbox" name="add_id['.sizeof($list_box_contents).']" value="1">';
			break;
	}
	$list_box_contents[$cur_row][] = array('align' => $lc_align,
										   'params' => 'class="productListing-data"',
										   'text'  => $lc_text );
  }
	?> <input type="hidden" name="products_id[<?=sizeof($list_box_contents)?>]" value="<?php echo $listing['products_id']; ?>"> <?php
		echo "\n";
}
new productListingBox($list_box_contents);
 } else {
$list_box_contents = array();
$list_box_contents[0] = array('params' => 'class="productListing-odd"');
$list_box_contents[0][] = array('params' => 'class="productListing-data"',
							   'text' => TEXT_NO_PRODUCTS);
new productListingBox($list_box_contents);
}
 ?>
<?php // hide if empty by willross
if ($cateqories_products['total'] > 0) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
 <tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
 </tr>
</table>
<table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
 <tr class="infoBoxContents">
<td><table border="0" width="100%" cellspacing="0" cellpadding="2">
	  <tr>
		<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
		<td align="left" class="main"><a href="<?php echo tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL'); ?>"><?php echo tep_image_button('button_checkout.gif', IMAGE_BUTTON_CHECKOUT); ?></a></td>
		<td align="right" class="main"><?php echo tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?></td>
		<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
	  </tr>
	</table></td>
 </tr>
</table>
<?php
}
?></form>
<?php
 if ( ($listing_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3')) ) {
?>
<table border="0" width="100%" cellspacing="0" cellpadding="2">
 <tr>
<td class="smallText"><?php echo $listing_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
<td class="smallText" align="right"><?php echo TEXT_RESULT_PAGE . ' ' . $listing_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
 </tr>
</table>
<?php
 }
?>

Link to comment
Share on other sites

has anyone had the trouble of this mod just creating a 2nd buy now button? nothing else happened and it has just as good of functionality as the original buy now buttons any advice would be appreciated. TIA Bill

 

 

Yes I did, what I did was I went to my configuration settings > product listing, and set them all to off ( 0 )

I then went and turned things back on one by one, first set your Image to 1, then product name to 2, then see what it looks like. If all fine, continue to turn the options on as desired.

 

Worked for me!

Link to comment
Share on other sites

Yes I did, what I did was I went to my configuration settings > product listing, and set them all to off ( 0 )

I then went and turned things back on one by one, first set your Image to 1, then product name to 2, then see what it looks like. If all fine, continue to turn the options on as desired.

 

Worked for me!

Thank You for the advice. It did not however work for me. The product description column keeps showing the last column that was added remove buy now it shows price a 2nd time. Remove price it shows product name a 2nd time. I am not sure what I have done wrong i followed the directions 3 time now after restoring from the original files. If you or anyone else has any other ideas please let me know. TIA Bill

Link to comment
Share on other sites

  • 6 months later...

Hi from France ;)

 

Cannot manage to work out this "read more" ;(

Was wondering if there is a problem with the contrib featured_products_v1.5.5

And I didn't update it to 1.5.6 yet.

 

Have you got any help, please ;)

sub-total (tax free), Bookmark, Browse by Categories 2.5, Category box enhancement, Contact us choice 1.0.1, Featured products 1.5.5.1, MultiGeoZone MultiTable Shipping 1.101, Os Active Desktop 2.3, Paymenttypes 1.2, Phpmyvisites 2.1, Session counter, Skype Contact 1.0, Stats products per month 1, Store Pick Up Version 1.4, Updated spiders.txt, Who's Online Enhancement 2.00, BackButtons, Google Analytics, stats_sales_csv_1.2, google_position_1.3, Customers List Improved 1.4, boxe defilante

Link to comment
Share on other sites

This is because I have to install the Optional Special to have short description in new products for the current month (includes/modules/new_products.php)

But I use featured products instead!!

sub-total (tax free), Bookmark, Browse by Categories 2.5, Category box enhancement, Contact us choice 1.0.1, Featured products 1.5.5.1, MultiGeoZone MultiTable Shipping 1.101, Os Active Desktop 2.3, Paymenttypes 1.2, Phpmyvisites 2.1, Session counter, Skype Contact 1.0, Stats products per month 1, Store Pick Up Version 1.4, Updated spiders.txt, Who's Online Enhancement 2.00, BackButtons, Google Analytics, stats_sales_csv_1.2, google_position_1.3, Customers List Improved 1.4, boxe defilante

Link to comment
Share on other sites

  • 10 months later...
does anyone know how to differentiate the styles of the description from the title??? That way we could have a bold product title and a smaller description. Right now it looks to be tied to the productListing-data class, how do you make it separate and what do you have to change?

 

ideas would be great! thanks!

 

I have solved this problem at my store. I have added the 'add read more...' hack to this contrib. as well and my code is so heavily modified that all I can do is show you how I got it to work using the code I have.

 

Inside 'product_listing.php' I have some code that now looks like this:

 

// Products Description Hack begins

//Add a read more link to the products description

case 'PRODUCT_LIST_DESCRIPTION':

$lc_text = '<div align="justify"><span class="mod">' . osc_trunc_string(strip_tags($listing['products_description'], ''), PRODUCT_LIST_DESCRIPTION_LENGTH) . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing['products_id']) . '"><b>' . osc_suite_more(strip_tags($listing['products_description'], ''), PRODUCT_LIST_DESCRIPTION_LENGTH) . '</b></a></span></div>';

$col_to_span = sizeof($column_list)-1;

if (PRODUCT_LIST_IMAGE > 0) {

$col_to_span -= 1;

}

$lc_params = 'colspan="' . $col_to_span . '" ';

break;

// Products Description Hack ends

 

I got this code from a post inside this very forum I believe. It was missing from the 'read more' contribution. The only difference between how it was posted and what is above is that I added the <span class="mod"> tag and, later in the same block of code, </span>. I then added a class called '.mod' to my general stylesheet.css file. The '.mod' class shapes up the product description snippet text to appear as I like. Here it is just for the sake of it (within stylesheet.css):

 

/* mod is a hack to reposition/format product description in product listing */

.mod {

display:block;

position:relative;

top:-40px;

color: black;

font-weight:normal;

padding-right:180px;

padding-left:10px;

}

 

I am using MS2.2 and STS 4.4 and seems to work fine. You can see here: http://www.choicepetproducts.com/index.php?cPath=68

 

If anyone sees any probs with this hack, please let me and others know. I'm simply posting to try and be of assistance as I have been 'assisted' many, many times by the kind folks participating in this forum/project.

 

gaus

Link to comment
Share on other sites

  • 5 months later...
Thank You for the advice. It did not however work for me. The product description column keeps showing the last column that was added remove buy now it shows price a 2nd time. Remove price it shows product name a 2nd time. I am not sure what I have done wrong i followed the directions 3 time now after restoring from the original files. If you or anyone else has any other ideas please let me know. TIA Bill

 

Hi bubaku0,

did you find asolution for the problem?

I have the same issue, tryed all these without a result.

I'll appreciate if you share your solution if any

 

Thanks a lot!!

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.

×
×
  • Create New...