PS 1.7 Modify "price-drop" page to show only "on sale" products

[PassionX]

Hi

There is no information to find how to modify the prices drop page (specials) to show only the "on sale" products.

This Solution does not work:

Can someone advise?

 

The code for the getdropprice function is on Line 2912:

WHERE product_shop.'active'= 1

AND p.quantity > 0

AND p-on_sale = 1

AND product_shop.'show_price' = 1

But this is not working in PS 1.7

Thank You

Simon

Edited April 3, 2020 by PassionX (see edit history)

[Tomascap]

Hi, 

for 1.7 to show "On sale" products in specials you need to add OR p.on_sale = 1  in the end of two lines in classes/Product.php. So you will get:

Line 2846

'.((!$beginning && !$ending) ? ' AND p.`id_product` IN ('.((is_array($tab_id_product) && count($tab_id_product)) ? implode(', ', $tab_id_product) : 0).')' : '').' OR p.on_sale = 1

Line 2808

'.((!$beginning && !$ending) ? 'AND p.`id_product` IN('.((is_array($tab_id_product) && count($tab_id_product)) ? implode(', ', $tab_id_product) : 0).')' : '').' OR p.on_sale = 1