setMessagePopular

1 files changed, 18 insertions, 0 deletions

diff --git a/src/com/juick/server/MessagesQueries.java b/src/com/juick/server/MessagesQueries.java
index 3dd8418b..fa84f476 100644
--- a/src/com/juick/server/MessagesQueries.java
+++ b/src/com/juick/server/MessagesQueries.java
@@ -884,4 +884,22 @@ public class MessagesQueries {
 
         return replies;
     }
+
+    public static boolean setMessagePopular(Connection sql, int mid, int popular) {
+        boolean ret = false;
+
+        PreparedStatement stmt = null;
+        try {
+            stmt = sql.prepareStatement("UPDATE messages SET popular=? WHERE message_id=?");
+            stmt.setInt(1, popular);
+            stmt.setInt(2, mid);
+            ret = stmt.executeUpdate() > 0;
+        } catch (SQLException e) {
+            System.err.println(e);
+        } finally {
+            Utils.finishSQL(null, stmt);
+        }
+
+        return ret;
+    }
 }