diff options
author | Yorhel <git@yorhel.nl> | 2019-09-17 10:29:26 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-09-17 10:29:39 +0200 |
commit | 3999549a305581966a353e07cae5ea7a9c191d80 (patch) | |
tree | 26a4c451e2fbb2d1c160b9c195e6a147614ee023 /util/sql | |
parent | a91cad2c42aeb49d67edc49674bbbf08e29811d5 (diff) |
Don't send db edit notifications for changes made by Multi
Diffstat (limited to 'util/sql')
-rw-r--r-- | util/sql/func.sql | 1 |
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; |