1 CREATE OR REPLACE FUNCTION updated_claim() RETURNS trigger
11 IF NEW.launched AND NOT OLD.launched THEN
13 SET attack_points = attack_points + 1
16 INSERT INTO forum_posts (ftid,uid,message)
17 VALUES((SELECT ftid FROM users WHERE uid = NEW.uid),NEW.uid
18 ,'Gave attack point for confirmation of attack on target '
19 || NEW.target || ', wave ' || NEW.wave
27 SET attack_points = attack_points - 1
31 UPDATE raid_targets SET modified = NOW() WHERE id = target;
34 $_X$ LANGUAGE plpgsql;