Remove old change_members trigger

[ndwebbie.git] / database / views / current_planet_stats.sql

diff --git a/database/views/current_planet_stats.sql b/database/views/current_planet_stats.sql
index f8ff556a95bd63f612cfa698f0f40e245c98ce88..78ee98f4dd0dad8f41560568c7e7f0e8b957a504 100644 (file)
--- 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;
-