diff options
| author | Yorhel <git@yorhel.nl> | 2011-02-07 09:29:16 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2011-02-07 09:29:16 +0100 |
| commit | df4277ad295c1127e4b0d71cce49e889fa27dac9 (patch) | |
| tree | d5b23dc8f739731b60f6e7ee7e2b7240cb715d8e | |
| parent | b53d0e8f54ca7e4cc397bb68638a19099f1cb160 (diff) | |
Bugfix: don't generate listdel notify for the user who deleted
| -rw-r--r-- | ChangeLog | 1 | ||||
| -rw-r--r-- | util/sql/func.sql | 3 | ||||
| -rw-r--r-- | util/updates/update_2.18.sql | 3 |
3 files changed, 6 insertions, 1 deletions
@@ -4,6 +4,7 @@ - Added tag visibility options by category on /v+ - Added filter selector to tag pages (excl. tags tab) - Added new VN filters: wish/blacklist, voted, on VN list + - Bugfix: don't generate listdel notify for the user who deleted 2.17 - 2011-02-04 - Allow moderators to overrule VN tag votes diff --git a/util/sql/func.sql b/util/sql/func.sql index 2f87bdb9..d7b5ab2f 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -763,7 +763,8 @@ BEGIN JOIN ( SELECT id, title FROM vn_rev WHERE TG_TABLE_NAME = 'vn' AND vid = NEW.id UNION SELECT id, title FROM releases_rev WHERE TG_TABLE_NAME = 'releases' AND rid = NEW.id - ) x ON c.id = x.id; + ) x ON c.id = x.id + WHERE c.requester <> u.uid; RETURN NULL; END; $$ LANGUAGE plpgsql; diff --git a/util/updates/update_2.18.sql b/util/updates/update_2.18.sql index c4cfe84f..90a5bcd3 100644 --- a/util/updates/update_2.18.sql +++ b/util/updates/update_2.18.sql @@ -3,3 +3,6 @@ CREATE TYPE tag_category AS ENUM('cont', 'ero', 'tech'); ALTER TABLE tags ADD COLUMN cat tag_category NOT NULL DEFAULT 'cont'; +-- load new function(s) +\i util/sql/func.sql + |