24 May 2006, 5:57 PM
New Zenner
- Join Date:
- Apr 2006
- Posts:
- 56
- Plugin Contributions:
- 0
Best seller sidebox problem!!
I've changed the bestseller.php sidebox by the one showing images for every page refresh, but I dont want that the sidebox shows the products with 0,00 price *(freebies).
*
I tried to change the code of the new php as shown below, but it has no effect at all.
What I am doing bad?
Thanks!!:D
In red the lines I added.
if ($show_best_sellers == true) {
if (isset($current_category_id) && ($current_category_id > 0)) {
$best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
. TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c
where p.products_status = '1'
and p.products_ordered > 0
and p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
[B]and p2c.categories_id > 3 [/B] //I don't wanna show categories 1,2,3
[B]and p.product_is_free = '0'[/B]
and p.products_id = p2c.products_id
and p2c.categories_id = c.categories_id
and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id)
order by p.products_ordered desc, pd.products_name
limit " . MAX_DISPLAY_BESTSELLERS;
$best_sellers = $db->Execute($best_sellers_query);
} else {
$best_sellers_query = "select distinct p.products_id, pd.products_name, p.products_ordered
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
where p.products_status = '1'
and p.products_ordered > 0
[B]and p.product_is_free = '0'[/B]
and p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
order by p.products_ordered desc, pd.products_name
limit " . MAX_DISPLAY_BESTSELLERS;
$best_sellers = $db->Execute($best_sellers_query);
}