Reply to thread

Message: <blockquote data-quote="geeko" data-source="post: 29074065" data-attributes="member: 465247">Code eka change kale. meken trigger eka hadanna puluwan error ekak enne na. eth awashya de venne naDELIMITER $$CREATE TRIGGER update_winner_trigger AFTER UPDATE ON oc_t_item_meta FOR EACH ROW BEGIN    -- Update winner based on the specified conditions    UPDATE oc_t_auction AS a     JOIN oc_t_item AS i ON a.item_id = i.pk_i_id     SET a.winner =         CASE             WHEN (                (SELECT m1.s_value FROM oc_t_item_meta AS m1 WHERE m1.fk_i_item_id = NEW.fk_i_item_id AND m1.fk_i_field_id = 16) > UNIX_TIMESTAMP()                AND                (SELECT m2.s_value FROM oc_t_item_meta AS m2 WHERE m2.fk_i_item_id = NEW.fk_i_item_id AND m2.fk_i_field_id = 15) >= a.bidding_price            ) THEN 1             WHEN i.dt_expiration > UNIX_TIMESTAMP() AND (SELECT m2.s_value FROM oc_t_item_meta AS m2 WHERE m2.fk_i_item_id = NEW.fk_i_item_id AND m2.fk_i_field_id = 15) >= a.bidding_price THEN 1             ELSE 0         END     WHERE a.item_id = NEW.fk_i_item_id;END;$$DELIMITER ;</blockquote>

Top Bottom