View Single Post
  #6  
Old 12-19-2007, 04:02 PM
 
Jonjolt1 Jonjolt1 is offline
 

Advanced Member
  
Join Date: Nov 2006
Posts: 49
 

Default Re: Adding Extra Fields to product list page

in products.php
After:
PHP Code:
if (!empty($active_modules["Subscriptions"])) {
    include 
$xcart_dir."/modules/Subscriptions/subscription.php";

Paste this
PHP Code:
if (!empty($active_modules["Extra_Fields"]) && !empty($products)) {
foreach(
$products as $k => $v) {
$products[$k]["extra_fields"] = func_query("SELECT $sql_tbl[extra_fields].field as field, $sql_tbl[extra_field_values].value as value, $sql_tbl[extra_fields].service_name as service_name FROM $sql_tbl[extra_fields]$sql_tbl[extra_field_values] WHERE $sql_tbl[extra_field_values].fieldid = $sql_tbl[extra_fields].fieldid AND $sql_tbl[extra_fields].active='Y' AND $sql_tbl[extra_field_values].productid = '$v[productid]'");
}


This is an example of what I use in skin1/customer/main/products.tpl or products_t.tpl (Whichever you use) after the product description

PHP Code:
<ul class="ProductDescUL">
{foreach 
from=$products[product].extra_fields item="ef"}
{if 
$ef.value ne ''}
<
li class="ProductDescLI"><span class="Bold">{$ef.field}:</span> {$ef.value}</li>
{/if}
{/foreach}
 </
ul
__________________
4.1.9
Reply With Quote