summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-09-17 10:29:26 +0200
committerYorhel <git@yorhel.nl>2019-09-17 10:29:39 +0200
commit3999549a305581966a353e07cae5ea7a9c191d80 (patch)
tree26a4c451e2fbb2d1c160b9c195e6a147614ee023 /util
parenta91cad2c42aeb49d67edc49674bbbf08e29811d5 (diff)
Don't send db edit notifications for changes made by Multi
Diffstat (limited to 'util')
-rw-r--r--util/sql/func.sql1
1 files changed, 1 insertions, 0 deletions
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;