1 DROP TRIGGER IF EXISTS update_target ON raid_claims;
2 DROP TRIGGER IF EXISTS unclaim_target ON raid_claims;
4 DROP FUNCTION IF EXISTS updated_target();
5 DROP FUNCTION IF EXISTS unclaim_target();
7 CREATE OR REPLACE FUNCTION updated_claim() RETURNS trigger
17 IF NEW.launched AND NOT OLD.launched THEN
19 SET attack_points = attack_points + 1
22 INSERT INTO forum_posts (ftid,uid,message)
23 VALUES((SELECT ftid FROM users WHERE uid = NEW.uid),NEW.uid
24 ,'Gave attack point for confirmation of attack on target '
25 || NEW.target || ', wave ' || NEW.wave
33 SET attack_points = attack_points - 1
37 UPDATE raid_targets SET modified = NOW() WHERE id = target;
40 $_X$ LANGUAGE plpgsql;
43 CREATE TRIGGER updated_claim
44 AFTER INSERT OR DELETE OR UPDATE ON raid_claims
45 FOR EACH ROW EXECUTE PROCEDURE updated_claim();