Reply to thread

Message: <blockquote data-quote="geeko" data-source="post: 29074169" data-attributes="member: 465247">code eka venas kala. dan trigger karaddi error ekak enne na. eth one karana  function eke venne naDELIMITER $$CREATE TRIGGER update_winner_trigger AFTER UPDATE ON oc_t_item_meta FOR EACH ROW BEGIN    -- Check if m1_value is greater than current timestamp    IF (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() THEN        -- Update winner based on m2_value and bidding price        IF (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            UPDATE oc_t_auction AS a             JOIN oc_t_item AS i ON a.item_id = i.pk_i_id             SET a.winner = 1            WHERE a.item_id = NEW.fk_i_item_id;        END IF;    -- If m1_value is not greater than current timestamp, check i.dt_expiration    ELSEIF (SELECT i.dt_expiration FROM oc_t_item AS i WHERE i.pk_i_id = NEW.fk_i_item_id) > UNIX_TIMESTAMP() THEN        -- Update winner based on m2_value and bidding price        IF (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            UPDATE oc_t_auction AS a             JOIN oc_t_item AS i ON a.item_id = i.pk_i_id             SET a.winner = 1            WHERE a.item_id = NEW.fk_i_item_id;        END IF;    ELSE        -- If neither condition is met, set the winner column to 0        UPDATE oc_t_auction AS a         JOIN oc_t_item AS i ON a.item_id = i.pk_i_id         SET a.winner = 0        WHERE a.item_id = NEW.fk_i_item_id;    END IF;END;$$DELIMITER ;<hr />DELIMITER $$CREATE TRIGGER update_winner_trigger AFTER UPDATE ON oc_t_item_meta FOR EACH ROW BEGIN    -- Check if m1_value is greater than current timestamp    IF (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() THEN        -- Update winner based on m2_value and bidding price        IF (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            UPDATE oc_t_auction AS a             JOIN oc_t_item AS i ON a.item_id = i.pk_i_id             SET a.winner = 1            WHERE a.item_id = NEW.fk_i_item_id;        END IF;    -- If m1_value is not greater than current timestamp, check i.dt_expiration    ELSEIF (SELECT i.dt_expiration FROM oc_t_item AS i WHERE i.pk_i_id = NEW.fk_i_item_id) > UNIX_TIMESTAMP() THEN        -- Update winner based on m2_value and bidding price        IF (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            UPDATE oc_t_auction AS a             JOIN oc_t_item AS i ON a.item_id = i.pk_i_id             SET a.winner = 1            WHERE a.item_id = NEW.fk_i_item_id;        END IF;    ELSE        -- If neither condition is met, set the winner column to 0        UPDATE oc_t_auction AS a         JOIN oc_t_item AS i ON a.item_id = i.pk_i_id         SET a.winner = 0        WHERE a.item_id = NEW.fk_i_item_id;    END IF;END;$$DELIMITER ;if else dala venas kala ban. dan error eka enne na eth one karana de venne na------ Post added on [DATETIME="UT"]1690885600[/DATETIME]</blockquote>

Verification: Nawa warak dahaya keeyada? (Namaya wadi kireema dahaya)

Top Bottom