SQLHelpers.getArrayInteger

Users.getUserRead
Users.getUserReaders

1 files changed, 9 insertions, 1 deletions

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;