From: Michael Andreen <harv@ruin.nu>
Date: Sun, 19 Mar 2017 09:27:34 +0000 (+0100)
Subject: Fix planet log user id
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=be7379eb3913b02904971df8a8c29b5e9309ac87

Fix planet log user id
---

diff --git a/database/functions/find_planet_id.sql b/database/functions/find_planet_id.sql
index 0649fb6..5890af9 100644
--- a/database/functions/find_planet_id.sql
+++ b/database/functions/find_planet_id.sql
@@ -12,7 +12,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;