Community Add-Ons

I had a need to hide my FREE products from the infobox, thus only displaying the bestsellers that actually cost more than 0. Here is the query with the needed changes to hide free stuff if anyone needs it :)

if (isset($current_category_id) && ($current_category_id > 0)) {
$best_sellers_query = tep_db_query("select distinct p.products_id, p.products_price, 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_price > 0 and p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' 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);
} else {
$best_sellers_query = tep_db_query("select distinct p.products_id, p.products_price, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_price > 0 and p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
}

all i added was a check for products price above 0 like this "where p.products_price > 0 and "

njoy!

...just changed:

o double html tag - href deleted
o title and alt added to the href
o little space added between the pictures

thx

I didn't like that the foto was placed before the product's name, so I changed that. It made me a little bit confused, I didn't know witch foto belongs to what product.

Now the product number and name are before the foto.

Nothing else is changed.

Added link to contribution page.

Changed instructions as they mentioned uploading a incorrect filename to your server.

Changed "FTP the file specials_scroll.php"
TO
"FTP the file best_sellers_scroll.php"

Works with Internet Explorer and the latest versions of FireFox and Netscrape, not sure about Opera, Konquerer and the other "browsers"

:) Enjoy!

Same thing only now the product images on the scroller are clickable and also I moved the number of the product on the list to before the product title, not the picture. (its better aligned this way)

Simple to use scrolling best sellers box with product images.