[SOLVED] Adv Search don't filter Categ unpublished

Hello gavick-usres!

In the Advanced Search (eshop.com)you can select "Search All Categories" or you can selcet any categorie. The Bugg: You can select categories, that not active in virtuemart/categories. Where is the problem? Hoppe you can help me and sorry for my SUPERENGLISH.

Servus, Holger

Hi

Yes you are right.
This will be address to our programmer and an update will be release as soon as possible.
Also, this update may reflect the eshoptrixII template as well.

Thank you for the warning.

Cheers

Please change in index.php file line:

Code: Select all

$query = "SELECT `c`.`category_name` AS `name` , `c`.`category_id` AS `id` FROM `#__vm_category` AS `c` ORDER BY `c`.`category_id`;";

for:

Code: Select all

$query = "SELECT `c`.`category_name` AS `name` , `c`.`category_id` AS `id` FROM `#__vm_category` AS `c` WHERE `c`.`category_publish` = 'Y' ORDER BY `c`.`category_id`;";

Cool!!

Thank you!!

Holger