From 3999549a305581966a353e07cae5ea7a9c191d80 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Tue, 17 Sep 2019 10:29:26 +0200 Subject: Don't send db edit notifications for changes made by Multi --- util/sql/func.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'util') diff --git a/util/sql/func.sql b/util/sql/func.sql index 8d81c440..792753be 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -682,6 +682,7 @@ CREATE OR REPLACE FUNCTION notify_dbedit(xtype dbentry_type, xedit edit_rettype) ) x(title) ON true WHERE h.type = xtype AND h.itemid = xedit.itemid AND h.requester <> h2.requester -- exclude the user who edited the entry + AND h2.requester <> 1 -- exclude edits by Multi -- exclude users who don't want this notify AND NOT EXISTS(SELECT 1 FROM users_prefs up WHERE uid = h.requester AND key = 'notify_nodbedit'); $$ LANGUAGE sql; -- cgit v1.2.3