From 3406753be46b637c0afee894cb12ed1bc5de9d29 Mon Sep 17 00:00:00 2001
From: Ugnich Anton
Date: Wed, 23 Apr 2014 21:27:46 +0700
Subject: Recommendations (getJIDSubscribedToUserRecommendations)

---
 src/com/juick/server/MessagesQueries.java | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'src/com/juick/server/MessagesQueries.java')

diff --git a/src/com/juick/server/MessagesQueries.java b/src/com/juick/server/MessagesQueries.java
index 550da56d..d02985ee 100644
--- a/src/com/juick/server/MessagesQueries.java
+++ b/src/com/juick/server/MessagesQueries.java
@@ -138,6 +138,14 @@ public class MessagesQueries {
         return rid;
     }
 
+    public static boolean recommendMessage(Connection sql, int mid, int vuid) {
+        boolean res = SQLHelpers.execute(sql, "INSERT IGNORE INTO favorites(user_id,message_id) VALUES (" + vuid + "," + mid + ")") == 1;
+        if (res) {
+            SQLHelpers.executeInt(sql, "UPDATE messages SET likes=likes+1 WHERE message_id=?", mid);
+        }
+        return res;
+    }
+
     public static boolean canViewThread(Connection sql, int mid, int uid) {
 
         int privacy = 0;
-- 
cgit v1.2.3