Best Sellers

[phaser-001]

Hallo zusammen.

Ich habe XT 304SP2 und dies ist meine best_sellers.php

sie wird nicht immer angezeigt und dies stört mich.

meine frage ist, was muss ich ändern, wenn die best seller box immer angezeigt wird.

danke schon mal und frohe ostern.

// reset var

$box_smarty = new smarty;

$box_content='';

$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_ids LIKE '%c_".$_SESSION['customers_status']['customers_status_id']."_group%'";

}

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,

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 ".$fsk_lock."

".$group_check."

and p2c.categories_id = c.categories_id and '" . $current_category_id . "'

in (c.categories_id, c.parent_id)

order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS;

} else {

$best_sellers_query = "select distinct

p.products_id,

p.products_image,

p.products_price,

p.products_tax_class_id,

pd.products_name from " .

TABLE_PRODUCTS . " p, " .

TABLE_PRODUCTS_DESCRIPTION . " pd, " .

TABLE_CATEGORIES . " c

where p.products_status = '1'

and c.categories_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,

pd.products_name limit " . MAX_DISPLAY_BESTSELLERS;

}

$best_sellers_query = xtDBquery($best_sellers_query);

if (xtc_db_num_rows(&$best_sellers_query,true) >= MIN_DISPLAY_BESTSELLERS) {

$rows = 0;

$box_content=array();

while ($best_sellers = xtc_db_fetch_array(&$best_sellers_query,true)) {

$rows++;

$image='';

if ($best_sellers['products_image']) $image=DIR_WS_INFO_IMAGES . $best_sellers['products_image'];

$box_content[]=array(

'ID'=> xtc_row_number_format($rows),

'NAME'=> $best_sellers['products_name'],

'IMAGE' => $image,

'PRICE'=>$xtPrice->xtcGetPrice($best_sellers['products_id'],$format=true,1,$best_sellers['products_tax_class_id'],$best_sellers['products_price']),

'LINK'=> xtc_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']));

}

$box_smarty->assign('box_content', $box_content);

$box_smarty->assign('language', $_SESSION['language']);

// set cache ID

if (USE_CACHE=='false') {

$box_smarty->caching = 0;

$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;

$cache_id = $_SESSION['language'];

$box_best_sellers= $box_smarty->fetch(CURRENT_TEMPLATE.'/boxes/box_best_sellers.html',$cache_id);

}

$smarty->assign('box_BESTSELLERS',$box_best_sellers);

}

?>

[justus]

Hi,

die Bestsellerbox erscheint nur, wenn Artikel gekauft wurden.

mach ein paar Testkäufe in den einzelnen Kategorien und dann wird diese auch erscheinen

schöne Feiertage

[phaser-001]

Hi

habe ich schon gemacht.

mir ist aufgefallen, das bei den unterkategorien geht es nur wenn ich eine Hauptkategorie an wähle, werden best seller nicht angezeigt.

mfg