Hallo WayneTsun,
ich habe alles durchsucht aber keine Lösung gefunden.
Was muss im PHP-Code source/boxes/specials.php geändert werden damit die letzten drei Sonderangebote (nach Datum aber ohne Random) in der Box_Specials.html angezeigt werden?
source/boxex/specials.php
<?php
/* -----------------------------------------------------------------------------------------
$Id: specials.php 1292 2005-10-07 16:10:55Z mz $
XT-Commerce - community made shopping
http://www.(( Wir dulden keine kommerziellen Werbelinks - Bitte Forenregeln beachten! ))
Copyright (c) 2003 XT-Commerce
-----------------------------------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(specials.php,v 1.30 2003/02/10); www.oscommerce.com
(c) 2003 nextcommerce (specials.php,v 1.10 2003/08/17); www.nextcommerce.org
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
$box_smarty = new smarty;
$box_smarty->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');
$box_content = '';
// include needed functions
require_once (DIR_FS_INC.'xtc_random_select.inc.php');
//fsk18 lock
$fsk_lock = '';
if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') {
$fsk_lock = ' and p.products_fsk18!=1';
}
if (GROUP_CHECK == 'true') {
$group_check = " and p.group_permission_".$_SESSION['customers_status']['customers_status_id']."=1 ";
}
if ($random_product = xtc_random_select("select
p.products_id,
pd.products_name,
pd.products_short_description,
p.products_price,
p.products_tax_class_id,
p.products_image,
s.expires_date,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
s.specials_new_products_price
from ".TABLE_PRODUCTS." p,
".TABLE_PRODUCTS_DESCRIPTION." pd,
".TABLE_SPECIALS." s where p.products_status = '1'
and p.products_id = s.products_id
and pd.products_id = s.products_id
and pd.language_id = '".$_SESSION['languages_id']."'
and s.status = '1'
".$group_check."
".$fsk_lock."
order by s.specials_date_added
desc limit ".MAX_RANDOM_SELECT_SPECIALS)) {
$box_smarty->assign('box_content',$product->buildDataArray($random_product));
$box_smarty->assign('SPECIALS_LINK', xtc_href_link(FILENAME_SPECIALS));
$box_smarty->assign('language', $_SESSION['language']);
if ($random_product["products_id"] != '') {
// set cache ID
if (!CacheCheck()) {
$box_smarty->caching = 0;
$box_specials = $box_smarty->fetch(CURRENT_TEMPLATE.'/boxes/box_specials.html');
} else {
$box_smarty->caching = 1;
$box_smarty->cache_lifetime = CACHE_LIFETIME;
$box_smarty->cache_modified_check = CACHE_CHECK;
$cache_id = $_SESSION['language'].$random_product["products_id"].$_SESSION['customers_status']['customers_status_name'];
$box_specials = $box_smarty->fetch(CURRENT_TEMPLATE.'/boxes/box_specials.html', $cache_id);
}
$smarty->assign('box_SPECIALS', $box_specials);
}
}
?>
Ich würde mich sehr freuen wenn mir jemand dabei helfen könnte. Bin am verzweifeln.
Danke und Gruß