X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Ffunctions%2Ffind_planet_id.sql;h=5890af945b482ddbc7f0ebff725316166e0953f2;hp=0649fb649eb46302615989c0ead3cd7d22bc7a2d;hb=be7379eb3913b02904971df8a8c29b5e9309ac87;hpb=d8c6f0648fbd22c5c71163d3e712ae16c969e376 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;