Hi,

this is not one of the built-in functions, but is not too hard to do with a little PHP. Try the following:

$vm = JomGenius("virtuemart");
$cat = $vm->info("category_id");
if ($cat) {
  $db->setQuery("select count(*) from #_" . "_virtuemart_products p"
    . ", #_" . "_virtuemart_product_categories pc "
    . " where pc.virtuemart_category_id = " . (int)$cat
    . " and pc.virtuemart_product_id = p.virtuemart_product_id "
    . " and p.published = 1";
  $num = $db->loadResult();
  if ($num > 0) return XXX;
}

// replace XXX with the module id of the module to display if category has no items.


Cheers,
Stephen

Ooops, just realised there was a missing ")":

$vm = JomGenius("virtuemart");
$cat = $vm->info("category_id");
if ($cat) {
  $db->setQuery("select count(*) from #_" . "_virtuemart_products p"
    . ", #_" . "_virtuemart_product_categories pc "
    . " where pc.virtuemart_category_id = " . (int)$cat
    . " and pc.virtuemart_product_id = p.virtuemart_product_id "
    . " and p.published = 1");
  $num = $db->loadResult();
  if ($num > 0) return XXX;
}


Also, please note that this will display on product pages as well as category pages. If you ONLY want it on category pages, do the following instead:

$vm = JomGenius("virtuemart");
$cat = $vm->info("category_id");
if ($cat and $vm->check("pagetype = category")) {
  $db->setQuery("select count(*) from #_" . "_virtuemart_products p"
    . ", #_" . "_virtuemart_product_categories pc "
    . " where pc.virtuemart_category_id = " . (int)$cat
    . " and pc.virtuemart_product_id = p.virtuemart_product_id "
    . " and p.published = 1");
  $num = $db->loadResult();
  if ($num > 0) return XXX;
}