diff options
Diffstat (limited to 'sql/triggers.sql')
-rw-r--r-- | sql/triggers.sql | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/sql/triggers.sql b/sql/triggers.sql index 0cda662f..12579f9d 100644 --- a/sql/triggers.sql +++ b/sql/triggers.sql @@ -232,8 +232,8 @@ CREATE TRIGGER vn_vnsearch_notify AFTER UPDATE ON vn FOR EACH ROW WHEN (OLD.c_se CREATE OR REPLACE FUNCTION notify_pm() RETURNS trigger AS $$ BEGIN - INSERT INTO notifications (ntype, ltype, uid, iid, subid, c_title, c_byuser) - SELECT 'pm', 't', tb.iid, vndbid_num(t.id), NEW.num, t.title, NEW.uid + INSERT INTO notifications (ntype, uid, iid, num, c_title, c_byuser) + SELECT 'pm', tb.iid, t.id, NEW.num, t.title, NEW.uid FROM threads t JOIN threads_boards tb ON tb.tid = t.id WHERE t.id = NEW.tid @@ -244,7 +244,7 @@ BEGIN FROM notifications n WHERE n.uid = tb.iid AND n.ntype = 'pm' - AND n.iid = vndbid_num(t.id) + AND n.iid = t.id AND n.read IS NULL ); RETURN NULL; @@ -260,8 +260,8 @@ CREATE TRIGGER notify_pm AFTER INSERT ON threads_posts FOR EACH ROW EXECUTE PROC CREATE OR REPLACE FUNCTION notify_announce() RETURNS trigger AS $$ BEGIN - INSERT INTO notifications (ntype, ltype, uid, iid, subid, c_title, c_byuser) - SELECT 'announce', 't', u.id, vndbid_num(t.id), 1, t.title, NEW.uid + INSERT INTO notifications (ntype, uid, iid, num, c_title, c_byuser) + SELECT 'announce', u.id, t.id, 1, t.title, NEW.uid FROM threads t JOIN threads_boards tb ON tb.tid = t.id -- get the users who want this announcement |