diff options
author | Yorhel <git@yorhel.nl> | 2019-11-11 09:53:03 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-11-11 09:53:03 +0100 |
commit | cd690ed11120d783498cca76cb50c7278a5c7c0f (patch) | |
tree | 2f89f4f711250275e18147dad95b0d553dec8126 | |
parent | a3318923ab711888df573015e3f6f58a692e67b6 (diff) |
ulist: Update lastmod when changing labels or vote
-rw-r--r-- | lib/VNWeb/User/Lists.pm | 4 |
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 }; |