X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fviews%2Fcurrent_planet_stats.sql;fp=database%2Fviews%2Fcurrent_planet_stats.sql;h=78ee98f4dd0dad8f41560568c7e7f0e8b957a504;hp=f8ff556a95bd63f612cfa698f0f40e245c98ce88;hb=5464b9f340cc8f8b1e5b37ce244601a24b760677;hpb=c843aa6e80c735c9fde563ecfae5e5233caa72b8

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