From 5464b9f340cc8f8b1e5b37ce244601a24b760677 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Fri, 13 Jan 2023 08:18:55 +0100 Subject: [PATCH] Remove old change_members trigger --- database/views/current_planet_stats.sql | 20 -------------------- 1 file changed, 20 deletions(-) diff --git a/database/views/current_planet_stats.sql b/database/views/current_planet_stats.sql index f8ff556..78ee98f 100644 --- a/database/views/current_planet_stats.sql +++ b/database/views/current_planet_stats.sql @@ -18,23 +18,3 @@ FROM planets p WHERE tick = ( SELECT max(tick) AS max FROM planet_stats) ) ps LEFT JOIN alliances USING (alliance); - -CREATE OR REPLACE FUNCTION change_member() RETURNS trigger - AS $_X$ -BEGIN - IF TG_OP = 'INSERT' THEN - IF NEW.gid = 2 THEN - UPDATE planets SET alliance = 'NewDawn' WHERE - pid = (SELECT pid FROM users WHERE uid = NEW.uid); - END IF; - ELSIF TG_OP = 'DELETE' THEN - IF OLD.gid = 2 THEN - UPDATE planets SET alliance = NULL WHERE - pid = (SELECT pid FROM users WHERE uid = OLD.uid); - END IF; - END IF; - - return NEW; -END; -$_X$ LANGUAGE plpgsql; - -- 2.39.2