From a1ecda62eef3b802dbfa044f75ec0050de6ba75e Mon Sep 17 00:00:00 2001
From: Ugnich Anton
Date: Thu, 20 Jun 2013 18:22:12 +0700
Subject: SQLHelpers.getArrayInteger Users.getUserRead Users.getUserReaders

---
 src/com/juick/server/UserQueries.java | 10 +++++++++-
 1 file changed, 9 insertions(+), 1 deletion(-)

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

diff --git a/src/com/juick/server/UserQueries.java b/src/com/juick/server/UserQueries.java
index a9f00f94..652809d6 100644
--- a/src/com/juick/server/UserQueries.java
+++ b/src/com/juick/server/UserQueries.java
@@ -64,7 +64,7 @@ public class UserQueries {
         } finally {
             Utils.finishSQL(null, stmt);
         }
-        
+
         return uid;
     }
 
@@ -358,6 +358,14 @@ public class UserQueries {
         return ret;
     }
 
+    public static ArrayList<Integer> getUserRead(Connection sql, int uid) {
+        return SQLHelpers.getArrayInteger(sql, "SELECT user_id FROM subscr_users WHERE suser_id=?", uid);
+    }
+
+    public static ArrayList<Integer> getUserReaders(Connection sql, int uid) {
+        return SQLHelpers.getArrayInteger(sql, "SELECT suser_id FROM subscr_users WHERE user_id=?", uid);
+    }
+
     public static int getStatsIRead(Connection sql, int uid) {
         int ret = 0;
         PreparedStatement stmt = null;
-- 
cgit v1.2.3