From 3caf993af6742740f9c3997c8e072cc681b10118 Mon Sep 17 00:00:00 2001
From: Ugnich Anton
Date: Fri, 4 Apr 2014 14:57:42 +0700
Subject: getBLUsers, getBLTags, setPopular

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

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

diff --git a/src/com/juick/server/TagQueries.java b/src/com/juick/server/TagQueries.java
index 82c0f9ae..87704c62 100644
--- a/src/com/juick/server/TagQueries.java
+++ b/src/com/juick/server/TagQueries.java
@@ -95,4 +95,25 @@ public class TagQueries {
         }
         return tags;
     }
+
+    public static ArrayList<String> getUserBLTags(Connection sql, int uid) {
+        ArrayList<String> tags = new ArrayList<String>();
+
+        PreparedStatement stmt = null;
+        ResultSet rs = null;
+        try {
+            stmt = sql.prepareStatement("SELECT tags.name FROM tags INNER JOIN bl_tags ON (bl_tags.user_id=? AND bl_tags.tag_id=tags.tag_id)");
+            stmt.setInt(1, uid);
+            rs = stmt.executeQuery();
+            rs.beforeFirst();
+            while (rs.next()) {
+                tags.add(rs.getString(1));
+            }
+        } catch (SQLException e) {
+            System.err.println(e);
+        } finally {
+            Utils.finishSQL(rs, stmt);
+        }
+        return tags;
+    }
 }
-- 
cgit v1.2.3