Multiple currencies and product filter/sorter

[simon1066]

V1.50 on a local server

"product_filter_by_attribute_and_price_range" sorts products by price range using:

if($enable_price_filter){
$where_str .= " AND p.products_price >= ".$pfrom;
$where_str .= " AND p.products_price <= ".$pto;
} 

the problem is that when changing currencies the sorter still gets the database's price, instead of the displayed price.

Is there a way to substitute the 'p.products_price' with a field that uses the displayed price?

[simon1066]

Looking at this further.

The above command calls data from the database, as the 'displayed price' (in an alternative currency) is not stored in the database I think that a more significant change, than I had hoped, is required.