Bug in VM Search plugin

[man.of.earth]

Hello everyone,

The VM Search plugin had a bug, i.e. it also displayed the unpublished products.
The bug was in the query; simply put a pair of parentheses on lines 192 and respectively 194:
before:

Code Select Expand

" WHERE {$where} " .
" {$shopper_group_condition} " .
" {$uncategorized_products_condition} " .
" AND p.published = 1" .
after:

Code Select Expand

" WHERE ({$where} " .
" {$shopper_group_condition} " .
" {$uncategorized_products_condition}) " .
" AND p.published = 1" .

Regards,
George
www.proxima-mundi.ro

[Ventsi Genchev]

https://forum.virtuemart.net/index.php?topic=141807.0