Antwort #4 am: 13. November 2014, 19:31:18
Hallo Ado
Vorschlag:
Suche in ‘specials.php’ folgenden Code
//BOF - DokuMan - 2010-01-26 - use Join on TABLE_PRODUCTS_DESCRIPTION & TABLE_SPECIALS
$specials_query_raw = "select p.products_id,
pd.products_name,
p.products_price,
p.products_tax_class_id,
p.products_shippingtime,
p.products_image,
p.products_vpe_status,
p.products_vpe_value,
p.products_vpe,
p.products_fsk18,
s.expires_date,
s.specials_new_products_price
from
".TABLE_PRODUCTS." p
left join ".TABLE_PRODUCTS_DESCRIPTION." pd
on p.products_id = pd.products_id
left join ".TABLE_SPECIALS." s
on p.products_id = s.products_id
where p.products_status = '1'
and s.products_id = p.products_id
and p.products_id = pd.products_id
".$group_check."
".$fsk_lock."
and pd.language_id = '".(int)$_SESSION['languages_id']."'
and s.status = '1'
order by s.specials_date_added DESC";
//EOF - DokuMan - 2010-01-26 - use Join on TABLE_PRODUCTS_DESCRIPTION & TABLE_SPECIALS
und ersetze ihn mit folgendem Code
//BOF - DokuMan - 2010-01-26 - use Join on TABLE_PRODUCTS_DESCRIPTION & TABLE_SPECIALS
$specials_query_raw = "select p.products_id,
pd.products_name,
p.products_price,
p.products_model,
p.products_tax_class_id,
p.products_shippingtime,
p.products_image,
p.products_vpe_status,
p.products_vpe_value,
p.products_vpe,
p.products_fsk18,
s.expires_date,
s.specials_new_products_price
from
".TABLE_PRODUCTS." p
left join ".TABLE_PRODUCTS_DESCRIPTION." pd
on p.products_id = pd.products_id
left join ".TABLE_SPECIALS." s
on p.products_id = s.products_id
where p.products_status = '1'
and s.products_id = p.products_id
and p.products_id = pd.products_id
".$group_check."
".$fsk_lock."
and pd.language_id = '".(int)$_SESSION['languages_id']."'
and s.status = '1'
order by s.specials_date_added DESC";
//EOF - DokuMan - 2010-01-26 - use Join on TABLE_PRODUCTS_DESCRIPTION & TABLE_SPECIALS
Danach seht dir in ‘templates/dein_template/module/specials.html’ folgende Smarty-Variable
$module_data.PRODUCTS_MODEL
innerhalb folgender Schleife zur Verfügung
{foreach name=aussen item=module_data from=$module_content}
{/foreach}
Gruss
Hanspeter