1 CREATE OR REPLACE FUNCTION update_user_planet() RETURNS trigger AS $_X$
3 IF COALESCE(NEW.pid <> OLD.pid,TRUE) OR NEW.username <> OLD.username THEN
4 UPDATE planets SET nick = NULL WHERE pid = OLD.pid;
5 UPDATE planets SET nick = NEW.username WHERE pid = NEW.pid;
8 IF COALESCE(NEW.pid <> OLD.pid,TRUE)
9 AND (SELECT TRUE FROM groupmembers WHERE gid = 2 AND uid = NEW.uid) THEN
10 UPDATE planets SET alliance = NULL WHERE pid = OLD.pid;
11 UPDATE planets SET alliance = 'NewDawn' WHERE pid = NEW.pid;
15 $_X$ LANGUAGE plpgsql;
17 CREATE OR REPLACE FUNCTION add_user() RETURNS trigger
22 INSERT INTO forum_threads (fbid,subject,uid)
23 VALUES(-1,NEW.uid || ': ' || NEW.username,-3) RETURNING ftid
28 $_X$ LANGUAGE plpgsql;