summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-11-11 09:53:03 +0100
committerYorhel <git@yorhel.nl>2019-11-11 09:53:03 +0100
commitcd690ed11120d783498cca76cb50c7278a5c7c0f (patch)
tree2f89f4f711250275e18147dad95b0d553dec8126
parenta3318923ab711888df573015e3f6f58a692e67b6 (diff)
ulist: Update lastmod when changing labels or vote
-rw-r--r--lib/VNWeb/User/Lists.pm4
1 files changed, 3 insertions, 1 deletions
diff --git a/lib/VNWeb/User/Lists.pm b/lib/VNWeb/User/Lists.pm
index 97170ca9..99111699 100644
--- a/lib/VNWeb/User/Lists.pm
+++ b/lib/VNWeb/User/Lists.pm
@@ -86,7 +86,8 @@ json_api qr{/u/ulist/setvote.json}, $VNVOTE, sub {
tuwf->dbExeci(
'UPDATE ulist_vns
SET vote =', \$data->{vote},
- ', vote_date = CASE WHEN', \$data->{vote}, '::smallint IS NULL THEN NULL WHEN vote IS NULL THEN NOW() ELSE vote_date END
+ ', vote_date = CASE WHEN', \$data->{vote}, '::smallint IS NULL THEN NULL WHEN vote IS NULL THEN NOW() ELSE vote_date END',
+ ', lastmod = NOW()
WHERE uid =', \$data->{uid}, 'AND vid =', \$data->{vid}
);
elm_Success
@@ -123,6 +124,7 @@ json_api qr{/u/ulist/setlabel.json}, $VNLABELS_IN, sub {
VALUES (', sql_comma(\$data->{uid}, \$data->{vid}, \$data->{label}), ')
ON CONFLICT (uid, vid, lbl) DO NOTHING'
) if $data->{applied};
+ tuwf->dbExeci('UPDATE ulist_vns SET lastmod = NOW() WHERE uid =', \$data->{uid}, 'AND vid =', \$data->{vid});
elm_Success
};