X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Ffunctions%2Ffind_planet_id.sql;h=94d01b90343653e01b4a4b721381de72aaf4215c;hb=75707e9b9cb6a816379ac2a8ac0c215a4bbe2545;hp=0649fb649eb46302615989c0ead3cd7d22bc7a2d;hpb=d8c6f0648fbd22c5c71163d3e712ae16c969e376;p=ndwebbie.git

diff --git a/database/functions/find_planet_id.sql b/database/functions/find_planet_id.sql
index 0649fb6..94d01b9 100644
--- a/database/functions/find_planet_id.sql
+++ b/database/functions/find_planet_id.sql
@@ -1,5 +1,4 @@
-DROP FUNCTIOn IF EXISTS find_planet_id(text,text,race);
-CREATE OR REPLACE FUNCTION find_planet_id(_id text, _ruler text, _planet text, _race race) RETURNS integer
+CREATE OR REPLACE FUNCTION find_planet_id(_id text, _ruler text, _planet text, _race text) RETURNS integer
     AS $_$
 DECLARE
 	p RECORD;
@@ -12,7 +11,7 @@ BEGIN
 			UPDATE planets SET race = _race, planet = _planet, ruler = _ruler WHERE pid = p.pid;
 			UPDATE forum_threads SET subject = escape_html(_ruler) || ' OF ' || escape_html(_planet)
 				WHERE ftid = p.ftid;
-			INSERT INTO forum_posts (ftid, uid, message) VALUES(p.ftid, -2, 'Planet changed data from ('
+			INSERT INTO forum_posts (ftid, uid, message) VALUES(p.ftid, -3, 'Planet changed data from ('
 				|| escape_html(p.ruler) || ', ' || escape_html(p.planet) || ', ' || p.race || ') to ('
 				|| escape_html(_ruler) || ', ' || escape_html(_planet) || ', ' || _race || ').');
 		END IF;