From: Michael Andreen <michael@andreen.dev>
Date: Fri, 13 Jan 2023 07:18:55 +0000 (+0100)
Subject: Remove old change_members trigger
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=5464b9f340cc8f8b1e5b37ce244601a24b760677

Remove old change_members trigger
---

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;
-