diff options
author | Yorhel <git@yorhel.nl> | 2011-02-16 16:14:30 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2011-02-16 16:14:30 +0100 |
commit | cd7b3f34173dfeceec03691957c95f4d4ab9cf47 (patch) | |
tree | 819817f5e60ef4c8af7b98aba8264b0954970e8b /util/sql | |
parent | 24680d31a5a3433db5fd0140d9cb80b371659342 (diff) |
chardb: Added character add/edit form + misc. fixes
Diffstat (limited to 'util/sql')
-rw-r--r-- | util/sql/func.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql index 4fc95165..23ae0fb2 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -375,7 +375,7 @@ $$ LANGUAGE plpgsql; -- PLACEHOLDERS, not complete yet -CREATE OR REPLACE FUNCTION edit_char_init(cid integer) RETURNS void AS $$ +CREATE OR REPLACE FUNCTION edit_char_init(hid integer) RETURNS void AS $$ BEGIN BEGIN CREATE TEMPORARY TABLE edit_char (LIKE chars_rev INCLUDING DEFAULTS INCLUDING CONSTRAINTS); @@ -384,13 +384,13 @@ BEGIN EXCEPTION WHEN duplicate_table THEN TRUNCATE edit_char; END; - PERFORM edit_revtable('c', cid); + PERFORM edit_revtable('c', hid); -- new char - IF cid IS NULL THEN + IF hid IS NULL THEN INSERT INTO edit_char DEFAULT VALUES; -- load revision ELSE - INSERT INTO edit_char SELECT name, original, alias, image, "desc" FROM chars_rev WHERE id = cid; + INSERT INTO edit_char SELECT name, original, alias, image, "desc" FROM chars_rev WHERE id = hid; END IF; END; $$ LANGUAGE plpgsql; @@ -663,7 +663,7 @@ $$ LANGUAGE plpgsql; --- update (vn|release|producer).(hidden|locked) on a new revision +-- update (vn|release|producer|char).(hidden|locked) on a new revision -- NOTE: this is a /before/ trigger, it modifies NEW CREATE OR REPLACE FUNCTION update_hidlock() RETURNS trigger AS $$ DECLARE |