X-Git-Url: https://git.auder.net/?p=vchess.git;a=blobdiff_plain;f=server%2Fmodels%2FUser.js;h=021cadcb32aebf0a3859d3da209b54c09245d011;hp=9b3049bebd0ab6ac4ff916bbe9b65a58122d28be;hb=d9a7a1e40254bda6e545514596a7363048c084f9;hpb=afd717788f50f92a5df6e5f1004354ff9ab0079d

diff --git a/server/models/User.js b/server/models/User.js
index 9b3049be..021cadcb 100644
--- a/server/models/User.js
+++ b/server/models/User.js
@@ -75,6 +75,17 @@ const UserModel =
     });
   },
 
+  setNewsRead: function(uid)
+  {
+    db.serialize(function() {
+      const query =
+        "UPDATE Users " +
+        "SET newsRead = " + Date.now() + " " +
+        "WHERE id = " + uid;
+      db.run(query);
+    });
+  },
+
   // Set session token only if empty (first login)
   // NOTE: weaker security (but avoid to re-login everywhere after each logout)
   // TODO: option would be to reset all tokens periodically, e.g. every 3 months