Вывод категории с столбик с количеством товара - [VM2&3] Модификации и хаки

function products_in_category( $category_id ) {
  if( PSHOP_SHOW_PRODUCTS_IN_CATEGORY == '1' ) {
   $num = ps_product_category::product_count($category_id);
   if( empty($num) && ps_product_category::has_childs( $category_id )) {
    $db = new ps_DB;
    $q = "SELECT category_child_id FROM #__{vm}_category_xref ";
    $q .= "WHERE category_parent_id='$category_id' ";
    $db->query($q);
    while( $db->next_record() ) {
     $num += ps_product_category::product_count($db->f("category_child_id"));
    }
   }
 
   return " ($num) ";
  }
  else
  return ( "" );
 }

function prod_in_cat_recursive( $category_id ) {
 $num=0;
 if (ps_product_category::has_childs( $category_id )) {
  $db = new ps_DB;
  $q = "SELECT category_child_id FROM #__{vm}_category_xref ";
  $q .= "WHERE category_parent_id='$category_id' ";
  $db->query($q);
  while( $db->next_record() ) {
   $num += ps_product_category::prod_in_cat_recursive($db->f("category_child_id"));
    }
   }
    $num += ps_product_category::product_count($category_id);
   return $num;
   }
 function products_in_category( $category_id ) {
  if( PSHOP_SHOW_PRODUCTS_IN_CATEGORY == '1' ) {
  $num = ps_product_category::prod_in_cat_recursive( $category_id );
  return " ($num) ";
  }
  else
  return "";
  }