summaryrefslogtreecommitdiff
path: root/sql/triggers.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/triggers.sql')
-rw-r--r--sql/triggers.sql10
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