Снимаем товары с публикации при нулевой цене определенного рода - [VM2&3] Модификации и хаки

DELIMITER ;
USE имя_вашей_БД;
DROP TRIGGER IF EXISTS имя_вашей_БД.`after_update_price`;
DELIMITER $$
CREATE
DEFINER = CURRENT_USER
TRIGGER имя_вашей_БД.after_update_price
AFTER UPDATE
ON antilopa.ytgb1_virtuemart_product_prices
FOR EACH ROW
BEGIN
  SET @total_retail_price = 0;
  SET @id = NEW.virtuemart_product_id;
  SET @total_retail_price = IFNULL((SELECT
    SUM(IFNULL(product_price, 0))
  FROM `ytgb1_virtuemart_product_prices`
  WHERE virtuemart_product_id = @id AND virtuemart_shoppergroup_id = 0),0);
  IF @total_retail_price <= 0 THEN
    UPDATE ytgb1_virtuemart_products
    SET published = 0
    WHERE virtuemart_product_id = NEW.virtuemart_product_id;
  ELSEIF @total_retail_price > 0 THEN
    UPDATE ytgb1_virtuemart_products
    SET published = 1
    WHERE virtuemart_product_id = NEW.virtuemart_product_id;
  END IF;
END
$$

DROP TRIGGER IF EXISTS имя_вашей_БД.`after_insert_price` 
$$
CREATE
DEFINER = CURRENT_USER
TRIGGER имя_вашей_БД.after_insert_price
AFTER INSERT
ON имя_вашей_БД.ytgb1_virtuemart_product_prices
FOR EACH ROW
BEGIN
  SET @total_retail_price = 0;
  SET @id = NEW.virtuemart_product_id;
  SET @total_retail_price = IFNULL((SELECT
    SUM(IFNULL(product_price, 0))
  FROM `ytgb1_virtuemart_product_prices`
  WHERE virtuemart_product_id = @id AND virtuemart_shoppergroup_id = 0),0);
  IF @total_retail_price <= 0 THEN
    UPDATE ytgb1_virtuemart_products
    SET published = 0
    WHERE virtuemart_product_id = NEW.virtuemart_product_id;
  ELSEIF @total_retail_price > 0 THEN
    UPDATE ytgb1_virtuemart_products
    SET published = 1
    WHERE virtuemart_product_id = NEW.virtuemart_product_id;
  END IF;
END
$$


DROP TRIGGER IF EXISTS имя_вашей_БД.`after_delete_price` 
$$
CREATE
DEFINER = CURRENT_USER
TRIGGER имя_вашей_БД.after_delete_price
AFTER DELETE
ON antilopa.ytgb1_virtuemart_product_prices
FOR EACH ROW
BEGIN
  SET @total_retail_price = 0;
  SET @id = OLD.virtuemart_product_id;
  SET @total_retail_price = IFNULL((SELECT
    SUM(IFNULL(product_price, 0))
  FROM `ytgb1_virtuemart_product_prices`
  WHERE virtuemart_product_id = @id AND virtuemart_shoppergroup_id = 0),0);
  IF @total_retail_price <= 0 THEN
    UPDATE ytgb1_virtuemart_products
    SET published = 0
    WHERE virtuemart_product_id = OLD.virtuemart_product_id;
  ELSEIF @total_retail_price > 0 THEN
    UPDATE ytgb1_virtuemart_products
    SET published = 1
    WHERE virtuemart_product_id = OLD.virtuemart_product_id;
  END IF;
END
$$
DELIMITER ;

// Start the Output
foreach ($this->products as $product) {

if($product->prices['salesPrice'] > 0) {