X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Ffunctions%2Fusers.sql;h=0743ed3dde2fa034167847ae4d4eb1b99db79685;hb=c843aa6e80c735c9fde563ecfae5e5233caa72b8;hp=2460cc1af3cb41247faeefa21634d07c9c03a179;hpb=76887e53c27118fe04ae8fe75dce610a398b5853;p=ndwebbie.git

diff --git a/database/functions/users.sql b/database/functions/users.sql
index 2460cc1..0743ed3 100644
--- a/database/functions/users.sql
+++ b/database/functions/users.sql
@@ -26,3 +26,13 @@ BEGIN
 	RETURN NEW;
 END;
 $_X$ LANGUAGE plpgsql;
+
+CREATE OR REPLACE FUNCTION update_user_planet_check() RETURNS trigger AS $_X$
+BEGIN
+	IF OLD.pid IS NULL AND NEW.pid IS NOT NULL AND isshuffletick() THEN
+		NEW.pid = NULL;
+	END IF;
+
+	RETURN NEW;
+END;
+$_X$ LANGUAGE plpgsql;