Der Code sieht so aus (/templates/gambio/source/boxes/best_sellers.php):
Code:
<?php
/* --------------------------------------------------------------
best_sellers.php 2008-08-10 gambio
Gambio OHG
http://www.gambio.de
Copyright (c) 2008 Gambio OHG
Released under the GNU General Public License
--------------------------------------------------------------
*/
?><?php
/* -----------------------------------------------------------------------------------------
$Id: best_sellers.php 1292 2005-10-07 16:10:55Z mz $
XT-Commerce - community made shopping
http://www.xt-commerce.com
Copyright (c) 2003 XT-Commerce
-----------------------------------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(best_sellers.php,v 1.20 2003/02/10); www.oscommerce.com
(c) 2003 nextcommerce (best_sellers.php,v 1.10 2003/08/17); www.nextcommerce.org
Released under the GNU General Public License
-----------------------------------------------------------------------------------------
Third Party contributions:
Enable_Disable_Categories 1.3 Autor: Mikel Williams | mikel@ladykatcostumes.com
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
// reset var
$box_smarty = new smarty;
$box_content = '';
$box_smarty->assign('language', $_SESSION['language']);
// set cache ID
if (!CacheCheck()) {
$cache=false;
$box_smarty->caching = 0;
} else {
$cache=true;
$box_smarty->caching = 1;
$box_smarty->cache_lifetime = CACHE_LIFETIME;
$box_smarty->cache_modified_check = CACHE_CHECK;
$cache_id = $_SESSION['language'].$current_category_id;
}
//if (!$box_smarty->is_cached(CURRENT_TEMPLATE.'/boxes/box_best_sellers.html', $cache_id) || !$cache) {
$box_smarty->assign('tpl_path', 'templates/'.CURRENT_TEMPLATE.'/');
// include needed functions
require_once (DIR_FS_INC.'xtc_row_number_format.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 (isset ($current_category_id) && ($current_category_id > 0)) {
$best_sellers_query = "select distinct
p.products_id,
p.products_price,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
pd.products_name from ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd, ".TABLE_PRODUCTS_TO_CATEGORIES." p2c, ".TABLE_CATEGORIES." c
where p.products_status = '1'
and c.categories_status = '1'
and p.products_ordered > 0
and p.products_id = pd.products_id
and pd.language_id = '".(int) $_SESSION['languages_id']."'
and p.products_id = p2c.products_id
".$group_check."
".$fsk_lock."
and p2c.categories_id = c.categories_id and '".$current_category_id."'
in (c.categories_id, c.parent_id)
order by p.products_ordered desc limit ".MAX_DISPLAY_BESTSELLERS;
} else {
$best_sellers_query = "select distinct
p.products_id,
p.products_image,
p.products_price,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_tax_class_id,
pd.products_name from ".TABLE_PRODUCTS." p, ".TABLE_PRODUCTS_DESCRIPTION." pd
where p.products_status = '1'
".$group_check."
and p.products_ordered > 0
and p.products_id = pd.products_id ".$fsk_lock."
and pd.language_id = '".(int) $_SESSION['languages_id']."'
order by p.products_ordered desc limit ".MAX_DISPLAY_BESTSELLERS;
}
$best_sellers_query = xtDBquery($best_sellers_query);
if (xtc_db_num_rows($best_sellers_query, true) >= MIN_DISPLAY_BESTSELLERS || $_SESSION['style_edit_mode'] == 'edit') {
$rows = 0;
$box_content = array ();
while ($best_sellers = xtc_db_fetch_array($best_sellers_query, false)) {
$rows ++;
$image = '';
$best_sellers = array_merge($best_sellers, array ('ID' => xtc_row_number_format((double)$rows)));
$box_content[] = $product->buildDataArray($best_sellers);
}
$box_smarty->assign('box_content', $box_content);
}
// set cache ID
if (!CacheCheck()) {
$box_smarty->caching = 0;
if ($box_content!='') {
$box_best_sellers = $box_smarty->fetch(CURRENT_TEMPLATE.'/boxes/box_best_sellers.html');
}
} else {
$box_smarty->caching = 1;
$box_smarty->cache_lifetime=CACHE_LIFETIME;
$box_smarty->cache_modified_check=CACHE_CHECK;
$box_best_sellers = $box_smarty->fetch(CURRENT_TEMPLATE.'/boxes/box_best_sellers.html', $cache_id);
}
//GM_MOD:
if(is_dir(DIR_FS_CATALOG.'StyleEdit/') === false)
$gm_box_pos = 'gm_box_pos_114';
else
$gm_box_pos = $gmBoxesMaster->get_position('bestsellers');
$smarty->assign($gm_box_pos, $box_best_sellers);
?>
Alle Änderungen habe ich auch in meinen Shop getestet. Unter link ist das Resultat (Bestseller, rechte Sidebar, unten).
Grüße
yellotux